MicroStrategy - Dynamic Attribute with join. Impact: Capability. mstrc, please open a Notepad or Notepad++. The MicroStrategy SQL Engine 9. For basic information and examples of the ApplySimple function, see the Functions Reference. This custom SQL can be used in the fact, attribute form expression, filter and metric editors. To create a MicroStrategy Environment connection file . KB485687: The bulk insert is not working which caused performance issue when running multi-source reports. Upgrade to MicroStrategy m2020 or later release. . x. ITtoolbox. 2. MSTr allows to dynamically specify the File Location and Backup File Location in a file device using macros. ApplyOLAP is the MicroStrategy Apply function tool used for OLAP functionality when you wish to use the native capabilities of your RDBMS. Apply the filter Year=2002 to your report. 2. For new columns to be available for attribute and fact creation in MicroStrategy Architect, the table structure must be updated. MicroStrategy - Passthrough Filters - Online Training Video by MicroRooster. x. ApplySimple("CASE WHEN #0=1 THEN #1 ELSE NULL END", , ). g. Data files can be published as either an In-Memory Cube or a Live Connect Cube. 11K KB3905: How to use pass-through expression- ApplySimple in MicroStrategy SQL Generation Engine ApplyComparison. Microstrategy Caches Improving Response Time: Caching A cache is a result set that is stored on a system to improve response time in future requests. It will not indicate that the check box is enabled, but this step is mandatory. nction Types. . 2. Download and extract Snowflake ODBC driver from Snowflake console. MicroStrategy parser doesnt recognize NULL as a key word for null value. Dynamic Sourcing is the technology that allows ad-hoc report, standard reports and OLAP reports to access shared Intelligent Cubes in an automatic way. 4. 4. Environment: Microstrategy. Viewed 13k times. x. The ApplySimple function is used with simple operators and functions. The following example will walk through how to setup an attribute form that converts a default datetime value in Microsoft SQL Server 2000 into a NULL value. Trending Articles. An example of this behavior is as follows: Concat (Concatenate) The Concat function combines two or more input strings into one continuous string and returns the result. Select the DSN. 0 database: Create a date value prompt named "End Date" Create a metric "metric1" with the following definition: ApplySimple("Extract(EPOCH FROM DATE #0)", ?) Create a metric "metric2" with the following definition: Min()Fu nction Types. This feature is similar to what we see in. The three dialog boxes are New Attribute, Create New Attribute Form, and Create New Attribute Form Expression. This article explains how to model recursive hierarchies in MicroStrategy. Count(ApplySimple("Case when #0 <> 0 then #1 else Null end", Column2, Column1)) {~ } Note: Notice that the ELSE statement is using 0 or Null based on the metric functions, such as Sum or Count. ", Arg1, Arg2). 3. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. In short, some attribute elements don't have a relationship with their parent/child attribute. 1 and 10. Consult the following MicroStrategy Knowledgebase document for more information on Case() and CaseV(). 98K. 2 for a '(VARCHAR2 (4 BYTE)' column. Select the attribute form to be displayed with a link. You can use CASE, which will apply the changes in the analytical engine or you can use ApplySimple to pass your Case statement down to the database. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformEvents and Event-Triggered Schedules. For more details on enabling the setting, see Change Data Engine Version. Select only Configuration Objects for documentation. RE: DateTime to Month formatConcat (Concatenate) The Concat function combines two or more input strings into one continuous string and returns the result. Click New. For more information on creating an applysimple, refer to MicroStrategy Knowledge Base document, KB5700-007-0113 - How to implement attribute form expression using Apply Functions in MicroStrategy Desktop. The ApplySimple and ApplyComparison functions are useful in the Advanced Qualification Editor. In SQL Server, the CAST () function is used to convert data into a different data type and the ApplySimple () function in MicroStrategy can be used to incorporate the CAST () function. x. For instance, if the datetime format is defined as yyyy-mm-dd on warehouse database side, the form expression needs to be modified as follows:Instead of using the MicroStrategy Week() function, database-based functions can be directly used through an ApplySimple() statement. thread395-610882. Concat is often used to combine related values, such as a first and last name. 4. 4. In the Subscription Editor, click Burst…. In ApplyComparison, the custom SQL syntax enclosed in quotation marks represents the entire condition; thus there is no need to compare the result of ApplyComparison to anything. How to use Guacamole to copy and paste text or files in MicroStrategy on AWS; All new Download site is now available!ApplyAgg. Some customers may need to use the Oracle provided JDBC in lieu of MicroStrategy shipped ODBC driver to connect to Oracle database. x and an Oracle Warehouse using the ApplySimple function. KB20306: How to create dynamic date based on 'Last Month' in MicroStrategy SQL Generation Engine 9. Try to create the metric this way: Sum (PaidAmt * Attribute Sales Year). A space where we get together to see curiosities, share experiences and pass tips to be the coolest and most knowledgeable consultants. As a workaround users can use ApplySimple function as below: ApplySimple(“Case when #0>0 then #1 else NULL end”, [BACK_END_DENIAL_COUNT],[TEST_ID]) Also, you can use "NulltoZero" function as. Select any project that is in the project source that contains the users and groups and click Next. Personalizing file locations. Something like: ApplySimple("'Y'", [your metric here]). SYMPTOM: In MicroStrategy 9. A user may want to create an attribute with an alternating expression depending on a certain condition, a conditional attribute. Relate tables store information about the relationship between two attributes when one a parent of the other or vice-versa. Thanks a lot for the 101 Microstrategy Question…. MicroStrategy functions are classified into the following types: Single-value functions (also known as Non-grouping or Scalar functions): These functions operate on each individual component of an input variable or argument, resulting in an output element for each component. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a red "X" as shown below: However, the images in the report display properly when the report is. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a. Max (1) The metric definition is shown in the image below: Create a second metric with an apply simple statement and using the dummy metric on its definition, as shown below. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. These functions are not supported by the Analytical Engine, so they must be calculated by the database. Change the DESC form expression to the following. For. In the sample cube here, the native IDs from the cube does contain the login: [MSTR User]. Recommendation. In MicroStrategy Web create a new Visual Insight dashboard with the Year attribute, Region attribute and the Revenue metric. The syntax used in ApplySimple is incorrect for SQL Server 2012 database. Generally, when null checking is used in metrics, the null checking is performed as part of the initial metric calculation. 4. , metrics or attributes) containing a particular function or operator (e. arithmetic operators) can be used. 1. Microstrategy - creating a simple percentage column. There's a reason we're at the top of the list. x. This technical note provides an example of how to calculate the number of days between the current date and a date attribute. x fails to generate SQL for a metric based on a fact defined with an ApplySimple statement SYMPTOM: SQL for a metric based on a fact defined with an ApplySimple statement is missing in the report SQL at run time in MicroStrategy 9. How to calculate data of time date type (HH:MM:SS) in Microsoft SQL Server using MicroStrategy Developer 9. This can be accomplished using a combination of ApplySimple() and ApplyAgg() functions at the Fact and Metric definitions, respectively. Users may want to create a report with a metric that has the current date of execution as a column on a report in MicroStrategy Developer 9. ApplySimple("#0", MaxProfit). x, with the Intelligence Server running on Linux,. My gloal is to cast a fact column to double value. Ragged Hierarchies in Microstrategy. Victoria is experiencing low interest rates too. For example, using the MicroStrategy Tutorial project, users may want to calculate the number of. Most data on a document is from one or more underlying datasets. Enter a title and a description for the prompt. Applysimple in Metric; Conditional metric and report filter interactions; Connection Mappings in Microstrategy;. Select any project that is in the project source that contains the users and groups and click Next. x, a passthrough function, such as ApplySimple, cannot be used on a prompt in a report based off of an Intelligent Cube. x. microstrategy. KB17619: How to create a conditional attribute in MicroStrategy Desktop 8. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. Use ApplySimple in MicroStrategy. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a. The MicroStrategy SQL Engine will join database tables together based on the lowest level attributes that MicroStrategy Architect assigns to each table. How to define an attribute form as an HTML tag in MicroStrategy Developer 9. Returns the sum of all numbers in a list of values. KB9585: How to create a Year to Day expression using an Applysimple function in MicroStrategy Developer How to create a Year to Day expression using an Applysimple function in MicroStrategy Developer In certain circumstances it is desirable for business purposes to compare data for one year ago on a day of the week basis (i. The new functions in Microstrategy are pretty smart and convert the generic function to the database specific function when it queries the database. This is a single-value function. Now your connection f. Using these functions, SQLs generated by MicroStrategy will call UDF just like any other function provided by Db2. MicroStrategy - Passthrough Filters - Online Training Video by MicroRooster. This filter must be applied in the final pass to find the correct store-region relationship, even though the final pass is a normal join instead of a downward join. I originally cut and pasted the syntax from SQL+ into the attribute statement and tweaked it. microstrategy. User may have the requirement to limit the date range selection within a specified period based on a single date prompt. If all conditions are false, a default value is returned. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. In MicroStrategy Developer, create a dummy metric with the following definition. The database instance is created. The current year can be returned by putting: Year (CurrentDate ()) for your comparison. Returns the difference in days between two given dates as an integer value. The steps below demonstrate how to create a filter that qualifies on months prior to the current month using a custom expression in an advanced qualification in MicroStrategy Developer 9. This function evaluates multiple expressions until a condition is determined to be true, then returns a corresponding value. However, by taking advantage of the ApplySimple expression, the attribute sorting can get applied correctly in Microstrategy Desktop and Web 9. The ApplySimple function is used with simple operators and functions. Insert an HTML container (and not an image) and insert the script below. Date and Time functions provide date and time information, such as current date, the day of week of a particular date, and so on. In the Database Logins dialog, enter your login credentials. MicroStrategy functions are classified into the following types: Single-value functions (also known as Non-grouping or Scalar functions): These functions operate on each individual component of an input variable or argument, resulting in an output element for each component. There are five predefined Apply functions, each belonging to a different function type - ApplySimple, ApplyAgg, ApplyOLAP, ApplyComparison, ApplyLogical. KB419483: How to create a comparison operator prompt and use it in an applysimple function in MicroStrategy Developer Number of Views 1. In this brief video tutorial, Doug Terbush from our Customer Education team describes the use of the Case function, along with examples of using this functio. ApplySimple("CONVERT(VARCHAR(23), #0, 121)",[Column1] )symbol. The ApplyComparison function is used with comparison operators such as >, Like, and In. g. If an environment does not already exist, an environment will need to be created first. This function relies on the Analytical Engine for processing, rather than the database. When using the DateDiff function in MicroStrategy Web, you will need to replace the Day@ID attribute in the function definition. The ID is distinct. Create 2 derived attributes DA2 and DA3, both using DA1 as a child component. Visit the data visualization and data dashboard galleries for inspiration. Microstrategy Training Centers in Victoria, BC – List of Microstrategy certification training, classes, Institutes in Victoria, Know more about Microstrategy fees. x and add a derived attribute, right clicking an. Examples of this category are simple mathematical. I just verified taking the SQL generated by MSTR back into SQL+ -- the SQL+ results work as they should; however, the report results are different. Case. Case can be used for categorizing data based on multiple conditions. By default usually MicroStrategy treats all column names as upper case only, however in DB2 (and potentially other databases) mixed case columns are possible in a case sensitive database collation. Date and Time functions provide date and time information, such as current date, the day of week of a particular date, and so on. Returns the current date as provided by the database timer. x. Microstrategy Dossiers With the release of MicroStrategy 10. Use the datetime format defined on warehouse database side in the ApplySimple statement. In the Database Connections dialog, enter a database connection name. 1M type format. ApplySimple( "convert. You can use the AppleSimple function to insert database-specific functions and simple operators directly into SQL. The month names do not originally reside in the warehouse tables and the user does not want to manually input the values into the warehouse. MSTR has evolved. KB7127: Case and CaseV functions in the MicroStrategy Analytical Engine . The result does not. There's a reason we're at the top of the list. In MicroStrategy Web, it is possible to use an image as a button to export a grid on a document to Excel in MicroStrategy version 10. Copy the code for the D3 visualization you are using. Since the Engine does not know what operations are there, it cannot determine the inverse formula on which the optimization depends. Create a Report Services Document 2. The following example will walk through how to setup an attribute form that converts a default datetime value in Microsoft SQL Server 2000 into a NULL value. x and 10. The MicroStrategy Analytical Engine does not calculate date and time functions. Creating a . x or you can always use an applysimple to pass the Oracle functions in natively. In SQL Server, it would be as follows: Applysimple ("#0 + char (13) + #1 + char (13) + #2 + char (13) + #3" STREET, CITY, STATE, ZIP) where (13) is the ascii code for. Examples of this category are simple mathematical. Select Filter definition prompt -> Choose from an attribute element list as shown below. MicroStrategy with Google Big Query. To allow sorting on the attribute elements after sorting by the metric total value, users may follow the steps below: Create a level derived metric to calculate on the attribute level at which the subtotal is calculated. MSTR has evolved. g. Within a project, a security filter may be specified for any user. Trending Articles. ApplyRelative where OLAP (ranking, etc. 1 and 10. Involved in Microstrategy Intelligence Server performance monitoring and managing cache expiry times. When you open a web page the extension automatically scans web pages in your browser and underlines keywords that you can hover over to trigger cards. Create the first derived attribute DA1, which is going to be used as the child attribute: 3. Choose the Light Theme from the drop down menu and click the Apply button. 4. A split hierarchy is one - that at the lowest level - has more than one child. Applysimple in Metric; Conditional metric and report filter interactions; Connection Mappings in Microstrategy;. To create an attribute form that allows the attribute to display a name in the format of 'Last_Name, First_Name' in MicroStrategy 10. In a cube containing data from the MicroStrategy Tutorial project, the following metric ranks over the lowest level attribute in the Product hierarchy used on the report. The MicroStrategy Advanced Reporting Help provides comprehensive information on advanced topics for using the MicroStrategy query and reporting products. this column in ApplySimple statement. But, DESC has repeating values. For information on the syntax used in your specific database, refer to the MicroStrategy Functions Reference. Syntax. Microstrategy Dossiers With the release of MicroStrategy 10. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. 1 and 10. In the Create New Form Expression window in the Attribute Editor, select the above table as the source table and use the following ApplySimple statement to define the expression: Applysimple( "#0 '-' #1 '-' #2", ID, Quarter, Year) From the MicroStrategy Developer File menu, point to New > Attribute. The script inside the " " always depends on the type of database used and can vary from one database. The Attribute Editor opens three dialog boxes, if the cascading dialog box option is enabled in the Developer Preference (as it is by default). Follow the next steps to create this type of metric. Unfortunately this is a "decode within a decode" and isn't. mstrc” file needs to be created for an environment connection prior submission, please follow these steps. Outer Joins come into play when MicroStrategy Engine merges the results from all SQL passes into one report. With a few additional applysimple statements this can also be used to create QTD and MTD. Reports that contain B or C will ignore filters on the other. 1 – In MicroStrategy Developer, navigate to the folder where you wish to create the attribute, right-click in it and select New > Attribute. Then I ask how to compared two metric based on ApplySimple in Report limit. To provide a reasonable level of generality, the feature is based on a 'pattern and arguments'. Change the DESC form expression to the following. For reference, refer to the Snowflake release notes. 21K. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. These values are set by default when the "Hive 0. The syntax of the ApplySimple expression is as follows: ApplySimple ("expression using #0",ATTRIBUTE_NAME)In some scenarios, it is necessary to use a database passthrough function (ApplySimple, ApplyComparison, ApplyAgg) to achieve specific query syntax that is not natively generated by the MicroStrategy SQL Generation Engine. 00" format. format_mask is optional. Click on 'Finish' and save the prompt. Whenever users submit an element browse request or a report. Let me know if you need additional information. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. A suspicious death, an upscale spiritual retreat, and a quartet of suspects with a motive for murder. nction Types. Applysimple in Metric; Conditional metric and report filter interactions; Connection Mappings in Microstrategy;. This function evaluates multiple expressions until a condition is determined to be true, then returns a corresponding value. "mahendra_patel via microstrategy-l" 07/07/2006 11:19 Favor responder a microstrategy-l@Groups. ) can be used. Subscribed reports or documents for each. Concat is often used to combine related values, such as a first and last name. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. Microstrategy Caches Improving Response Time: Caching A cache is a result set that is stored on a system to improve response time in future requests. Make two grids with different attributes and metrics in each 3. {Select a Month} and ApplySimple("DateAdd('m',-11,#0)",{Select a Month})) Relate by System Default. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a red "X" as shown below: However, the images in the report display properly when the report is. Thus, if a Dynamic Date is created based on today's date, in order to get 'Last Month' a specific number of days can be subtracted from the date. Note: The form expression in the above sample is for Access database only. Keep the form expression unchanged. Depending on your MicroStrategy product and licensing. If the metric formula includes other operations outside of the ApplySimple function, these operations could be evaluated by the Analytical Engine and the smart metric option would be expected to apply in that case. xThe goal is to create an image link that is used to export the grid, like shown below: Document in Edit Mode Follow the steps below: 1. A metric to show the per-year average of quarterly totals must first aggregate the basic fact data at the level of quarter, then calculate the average at year level over that intermediate result. Within a project, a security filter may be specified for any user. Download the following driver to the server hosting your Intelligence Server: TGZ for Linux. This section describes the date and time functions. 1 and 10. A user may want to create an attribute with an alternating expression depending on a certain condition, a conditional attribute. Field Name is called 'Group' There are certain 'Group' names that I want to put in a certain category using the CASE. if both conditions are met, then Red, else Green. g. CAUSE: This is expected behavior. Specify the desired delivery options including recipient address, subscription name. Since there are 7 days in each week and 52 weeks in each year, this calculation will always match each day of the week to the. 4 and later. Applysimple in Metric; Conditional metric and report filter interactions; Connection Mappings in Microstrategy;. Save the filter as "Region Filter". In this table, the PARENT_ID column logically points to another row in the same table (ID column). If you love a cozy, comedic mystery, you'll love this 'whodunit' adventure. MicroStrategy functions are classified into the following types: Single-value functions (also known as Non-grouping or Scalar functions): These functions operate on each individual component of an input variable or argument, resulting in an output element for each component. Number of Views 1. It should work. ApplySimple: where simple operators (e. Open up the same document in MicroStrategy Web 10. Instead, they are intended to enhance the MicroStrategy product by taking advantage of what the RDBMS platforms can offer. 2 – In the Form Expression window, select a Source table, in this case I am using the calendar dimension (LU_DAY) as the Source table. This means that an attribute. The three dialog boxes are New Attribute, Create New Attribute Form, and Create New Attribute Form Expression. The example given below relates to an Oracle data warehouse, but many other RDBMSs support similar functionality. It is possible to prompt the user for the concluding element by using ApplySimple:Returns the date of the first day of the month in which date or timestamp occurs. Fu. The following steps demonstrate how to use the comparison operator prompt in an ApplySimple function with a Case statement. Refer to MicroStrategy Knowledge Base document KB5700-007-0107 for more. Thus directly using NULL in formula will fail. The syntax always follows the format Applyfunction ("#0. In a cube containing data from the MicroStrategy Tutorial project, the following metric ranks over the lowest level attribute in the Product hierarchy used on the report. After migrating to MicroStrategy 9. Relate tables contain the ID columns of two or more attributes, which will define associations between them. Syntax. 1 and 10. Sum is a group-value function. com Para jpviva. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . The ability to define object relationships and then allow MicroStrategy to generate all of the appropriate SQL as you manipulate and drill is the core of the product. Click New. 4. To create a prompt that places the maximum date value from a warehouse table as the. For instance, if the datetime format is defined as yyyy-mm-dd on warehouse database side, the form expression needs to be modified as follows: Transformation expressions using ApplySimple cannot be optimized because MicroStrategy does not parse or analyze the operations performed in the pass-through SQL string in any way. There are five predefined Apply functions, each belonging to a different function type - ApplySimple, ApplyAgg, ApplyOLAP, ApplyComparison, ApplyLogical. Could you please update the list…. KB4275: How to retrieve attribute form expressions using MicroStrategy Intelligence Server SDK. For information on the syntax used in your specific database, refer to the MicroStrategy Functions Reference. x and 10. I can't remember if the strings have to be enclosed in single or quote quotes. x pass-through function, in this case the ApplySimple function. Dashboard execution stages can be represented below: MicroStrategy Intelligence Server When an end user makes a Document Execution Request through any client (a web browser via MicroStrategy Web, the MicroStrategy Desktop/Developer client, the MicroStrategy Mobile app, or the MicroStrategy Office client), the request is sent to. The current logic I've found is below. comApplySimple functions are used for simple expressions that use arithmetic operators. Metric Join Type: VLDB Setting at Database Instance Level Report. [MSTR User]. Create a numeric value prompt and name it P1. 44K KB440320: How to create multiple metric comparison conditions to filter a report which allows to prompt for one value inpu…Custom formatting metric values of 1,100,000 into a 1. 4. Perform the following steps to update the table structure. An inner join is created and a line representing the join appears in the Query Builder pane, running. Example 1 Using an attribute ApplySimple is a function that allows users to send direct input to the warehouse without any assumption or special handling of what is inside the custom SQL by MicroStrategy. Microstrategy Dossiers With the release of MicroStrategy 10. Create New Metric in a report or VI. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a red "X" as shown below: However, the images in the report display properly when the report is. This custom SQL can be used in the fact, attribute form expression, filter and metric editors. MicroStrategy Web provides a wide range of parameters that can be used in combination to achieve different types of requests. KB3905: How to use pass-through expression- ApplySimple in MicroStrategy SQL Generation Engine. The MicroStrategy Tutorial project is used to explain how users can customize numbers from "1,000,000" to a "1. When using a warehouse that has a table storing month values only as a number, users wish to also display the corresponding month names in MicroStrategy Developer 10. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. By contrast, IF() allows database side conditional functions to be leveraged without using ApplySimple() or ApplyAgg() functions. Contact MicroStrategy Technical Support for an update on the status of this request. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. Click OK in all three dialogs (Login, Connection, and Database Instance). Single-family homes make up a large proportion of the market, but Greater Victoria also has a number of high-end luxury properties. ApplyAgg: where aggregate functions (e. UnderstandingFunctionsinMicroStrategy 5 TheBasicsofMicroStrategyObjects,ObjectDefinitions,andFunctions 6 FunctionSyntaxandFormulaComponents 9You have 2 options. The steps below use objects from the MicroStrategy Tutorial project as an example. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a red "X" as shown below: However, the images in the report display properly when the report is. 1 and 10. These functions are supported by the Analytical Engine. This is a single-value function. Presented during MicroStrategy World 2021, hear best practices and tools and tips for connecting to Snowflake. ApplySimple("Case When #0 ='abc' Then #1 Case #2='xyz' Then #3 End",Attribute_A@ID,[Metric 1],Attribute_B@ID ,[Metric 2]). DaysBetween. We are active contributors to solutions on the MicroStrategy Community site. Right-click on the metric header to apply the condition or threshold and select 'Alerts': Specify the conditions to meet for the delivery to be triggered in the filter editor: Expand the Delivery Settings section. 1 and 10. name = "HFilter" Dim objSearch As. ApplySimple ("case when #0 contains 'As Is' then 'As Is' when contains 'New' then 'New' ELSE 'Other' END", [NAME]) case. Thanks. Case can be used for categorizing data based on multiple conditions. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a red "X" as shown below: However, the images in the report display properly when the report is. Syntax ApplySimple () Accepts facts, attributes, and metrics as input. Syntax. From the Database connection type drop-down, choose Snowflake. You can define joins between columns on the Import from Tables dialog while building a query for importing your data. 3 environment, we have a star schema that has multiple date dimensions. An example of this behavior is as follows:Try using some of the date functions that are now available in 8. For example, ApplySimple("#0 * #1",[col1],[col2]). x, with the Intelligence Server running on Linux,. jar.