applysimple in microstrategy. To create an attribute in MicroStrategy with a fixed NUMBER value, follow the steps below:. applysimple in microstrategy

 
 To create an attribute in MicroStrategy with a fixed NUMBER value, follow the steps below:applysimple in microstrategy 7x" database object is used (set at Configuration Managers > Database Instances > Database Instance > Database connection type) Selected Default

jar. Select a prompt style and click on 'OK'. x-10. , >, =, Like, In, etc) can be used. The CASE function permits multiple comparisons. Consolidations and custom groups are two special reporting features that enable user to surpass basic reporting functionality. Personally, I would use ApplySimple and let the database handle the work. Number of Views 4. Starting in MicroStrategy 2020 Update 2, the Snowflake ODBC driver is shipped to simplify the connectivity workflow. 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. 1 and 10. ApplySimple( "convert. for each successive object passed. Microstrategy Dossiers With the release of MicroStrategy 10. ACTION: Use Concat function instead. x pass-through function, in this case the ApplySimple function. There's a reason we're at the top of the list. The expression editor in MicroStrategy Developer provides an escape sequence to support double-quote marks in a string. Could you please update the list…. 4. Relate tables contain the ID columns of two or more attributes, which will define associations between them. The index for referencing these objects begins with 0 and increases by for each successive object passed. ApplySimple: 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. ITtoolbox. using Sum (PaidAmt * Attribute Sales Year) works fine, valid expression, but not really what I want. In MicroStrategy SQL Generation Engine, security filters prevent users from seeing certain data in the database. MicroStrategy supports any UDF defined on Teradata through the use of pass-through functions, such as ApplySimple. CAUSE: This is currently working as designed. In this article we will discuss the ApplySimple function. HyperIntelligence and its Architecture. This means that every metric is evaluated in separate SQL passes. 4. MicroStrategy will continue to investigate and post updates as soon as they are available. Contact MicroStrategy Technical Support for an update on the status of this request. MicroStrategy - Passthrough Filters - Online Training Video by MicroRooster. The following steps can be used to concatenate two attribute forms. This function does not take input variables. The “ #n” code in Apply function syntax serves as placeholders for the MicroStrategy objects being passed to your database. Close the Visualization Builder, and then re-open it. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. This article covers how to use passthrough expressions to write custom SQL inside of MicroStrategy. ApplySimple("SUBSTR(#0,1,3)", ) Apply. 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. 1 million 1. The ApplySimple statements given above are ORACLE Specific. Article outlines why the 'Allow Smart Metric' setting does not persist in OLAP Cube compound metrics using ApplySimple in MicroStrategy DesktopReplace is a metric, fact, column, or string representing the text strings that are used to replace any instances of the string from Find that are included in the strings returned by Argument. Join. Microstrategy Dossiers With the release of MicroStrategy 10. The MicroStrategy Case statement should work fine. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . g. 2. Open the project in which a new column is added. This function is commonly used in metrics and subtotals. 00" format. Perform the following steps to update the table structure. In the right corner of the dashboard, change the. Create a Report Services Document 2. This means that an attribute. MicroStrategy has introduced a feature known as, Incremental Refresh Options, which allow Intelligent Cubes to be updated based on one or more attributes, by setting up incremental refresh settings to update the Intelligent Cube with. Depending on your MicroStrategy product and licensing. Comparison operator prompts can be used in ApplySimple functions with Case statements using the metric, (@nameofprompt(M1, M2)). . 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. #n, (3) place "ApplySimple (" (without the quotes) in front and (4) a comma plus. Create a metric with the ApplySimple statement below as its definition and name it "Case Metric": ApplySimple ("CASE WHEN #0 <= 2000 THEN #1 WHEN #0 >= 2001 THEN #2 END", ? [P1], Revenue, Profit) Note: This example will prompt users for a value. 4. Case. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. 35K. x. Web/Desktop requires making use of a Live Connect dataset (either Data Import - Pick Tables or from Existing Objects). 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. microstrategy. These values are set by default when the "Hive 0. Fu. 4. Case can be used for categorizing data based on multiple conditions. MicroStrategy parser doesnt recognize NULL as a key word for null value. Below is a screenshot of the results received with the above ApplySimple metric: Create a new metric and use an ApplySimple statement in the metric definition that will bring back the current. Thanks a lot for the 101 Microstrategy Question…. x and 10. KB39990: How to use ApplySimple to create attribute form to support sorting configuration in the attribute editor in MicroStrategy Desktop and Web 9. Applysimple in Metric; Conditional metric and report filter interactions; Connection Mappings in Microstrategy;. This is a comparison function. Select any project that is in the project source that contains the users and groups and click Next. MicroStrategy parser doesnt recognize NULL as a key word for null value. You can use the ApplyComparison function to define custom filters. Personalizing file locations. 2 for a '(VARCHAR2 (4 BYTE)' column. 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. Using these functions, SQLs generated by MicroStrategy will call UDF just like any other function provided by Db2. ; Distinct is a TRUE/FALSE parameter that allows you to. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformMicroStrategy Hadoop Gateway operation modes MicroStrategy Hadoop Gateway is a native connector which was built based on Spark 1. You can use the MicroStrategy CASE function, available in MicroStrategy Developer (\\Schema Objects\Functions and Operators\Functions\Internal Functions), to retrieve desired result sets. The new functions in Microstrategy are pretty smart and convert the generic function to the database specific function when it queries the database. 0. Refer to MicroStrategy Knowledge Base document KB5700-007-0107 for more. In Microstrategy Developer, create a new attribute by navigating to File > New > Attribute. Microstrategy Dossiers With the release of MicroStrategy 10. 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 'Choose a Prompt Style' dialog box opens. Create a Fact using two expressions with ApplySimple() definitions as follows:KB14356: When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrate… Number of Views 1. Concat is often used to combine related values, such as a first and last name. The following steps will reproduce the issue in MicroStrategy Tutorial running against a Vertica 4. The syntax in this document can vary depending on the. Something like: ApplySimple("'Y'", [your metric here]). MSTR has evolved. 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. In MicroStrategy Web create a new Visual Insight dashboard with the Year attribute, Region attribute and the Revenue metric. If your database does not include SQL syntax support for a date and time function, the function cannot be. DaysBetween. Another way to accomplish this using ApplySimple instead of ApplyComparison would be to drag the Hour attribute to. Problem. Applysimple in Metric; Conditional metric and report filter interactions; Connection Mappings in Microstrategy;. User may have the requirement to limit the date range selection within a specified period based on a single date prompt. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. to_char (case when Date_DESC is null then to_date (`31-DEC. Create a metric with the ApplySimple statement below as its definition and name it "Case Metric": ApplySimple ("CASE WHEN #0 <= 2000 THEN #1. The example given below relates to an Oracle data warehouse, but many other RDBMSs support similar functionality. x-10. 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. ApplyRelative: where Online Analytical Processing (OLAP) functions (e. Whatever the final sql is (1) take the final sql, (2) Wrap. You can use the AppleSimple function to insert database-specific functions and simple operators directly into SQL. x. ApplySimple may be used in one or both sides of a comparison expression. In the Database Connections dialog, enter a database connection name. Our solutions work to guide towards best practices and provide guidance to the user community. Navigate to the Layout Tab. If the precision is needed to be displayed on a report, a workaround is possible by casting the DATETIME data type to a VARCHAR data type. 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 report always contains a clause such as 'WHERE MONTH_ID = 200107', for the current month. 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. SyntaxCurrentDate. December 07, 2018. Microstrategy Dossiers With the release of MicroStrategy 10. DATA ANALYSIS 102. x mixed case columns names for a DB2 database by default have SQL generated with quote characters enclosing the name . It should work. Always be aware of the latest driver version. com Para jpviva. Syntax. 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. 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. Click on 'Modify' to determine how the prompt will appear in MicroStrategy Web. In most cases, these values are not recognized as MicroStrategy objects. Presented by MicroStrategyBlog. ", Arg1, Arg2). To create a MicroStrategy Environment connection file . 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. Community & Support Search Discussions Open A Case View My CasesTo create the MDSecurity filter, users can either populate the new MDSecurity filter with the definition of an existing filter or define the BottomLevel, TopLevel and Expression properties. MicroStrategy, Inc. Returns a date or timestamp plus an offset (+ or -) n days. In the sample cube here, the native IDs from the cube does contain the login: [MSTR User]. This technical article outlines the steps to create rolling time attributes in MicroStrategy Developer 9. arithmetic operators) are used. &[cbecker] The ApplySimple string can build this ID by using a placeholder where the user login should appear:This article covers how to use passthrough expressions to write custom SQL inside of MicroStrategy. The MicroStrategy Case statement should work fine. KB36904: ApplySimple statement is trying to calculate in the Analytical Engine in MicroStrategy Developer 10. ApplySimple where simple (e. The ApplyComparison function is used with comparison operators such as >, Like, and In. solutions Forum; YTD transformation. Thanks. This can be accomplished using a combination of ApplySimple() and ApplyAgg() functions at the Fact and Metric definitions, respectively. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. ) functions are used. For example, ApplySimple("#0 * #1",[col1],[col2]). 4. The “#n” code in Apply function syntax serves as placeholders for the MicroStrategy objects being passed to your database. To create a column alias for a fact. 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:To burst a file subscription across multiple subfolders. Within a project, a security filter may be specified for any user. The steps below give a detailed explanation on how to create a report that contains a metric based on another metric that will return a static string of data from the warehouse. Microstrategy Report Services documents vs Dashboards. Microstrategy Dashboard performance improvements steps: Many times, causes of poor performance can be simplified to specific components. MyDate =. 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. The three dialog boxes are New Attribute, Create New Attribute Form, and Create New Attribute Form Expression. mdb) and C:Program Files (x86)MicroStrategyTutorial. Users may need to list all objects (e. For more details on enabling the setting, see Change Data Engine Version. This issue can be solved in two steps using a MicroStrategy 10. Contact MicroStrategy Technical Support for an update on the status of this request. When adding a prompted metric using an ApplySimple() function that includes a Max, the prompt name will not be displayed for prompt ordering on a MicroStrategy Report Services Document as shown in the image below: The metric in the report contains a formula similar to the following examplemstrgrl (TechnicalUser) (OP) 2 Dec 03 15:36. g. Follow the steps below. ApplySimple may be used in one or both sides of a comparison expression. Download the following driver to the server hosting your Intelligence Server: TGZ for Linux. The following steps demonstrate how to use the comparison operator prompt. I want to create a new Metric, using MicroStrategy Metric Editor, to check two conditions: 1 is progress_days > complete_date 2 is Status column is = In Progress. This is a single-value function. x. Thus directly using NULL in formula will fail. Involved in Microstrategy Intelligence Server performance monitoring and managing cache expiry times. view, MicroStrategy Logical View) - or not use an attribute form and use a metric instead (that's in relation to the varchar2 data type you mentioned below, since by default, MicroStrategy will pick the column datatype you are using in the applysimple) Now, if what you are saying that you need to apply that functionI tested using internal least function on metics in 7. ApplySimple: where simple operators (e. You can use the AppleSimple function to insert database-specific functions and simple operators directly into SQL. It is used to define compound metrics via. This custom SQL can be used in the fact, attribute form expression, filter and metric editors. Users may wish to use ORACLE's DECODE function instead of the more generic CASE statement incorporation with the 'ApplySimple' function during the report design for MicroStrategy 9. This function relies on the Analytical Engine for processing, rather than the database. Click New. Applysimple in Metric; Conditional metric and report filter interactions; Connection Mappings in Microstrategy;. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Once the administrator sets it up, the end user has to just log in with their Okta or Azure AD email credentials to start using MicroStrategy with Snowflake. The syntax for that is ApplySimple(“<Insert database SQL>”, [Column #0]) ToDateTime (Convert String or Number to a Date or Timestamp) The ToDateTime function converts a string of characters or a number into a date or timestam p. Create a Fact using two expressions with ApplySimple() definitions as follows:KB14356: When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrate… Number of Views 1. of distributed under each attribute element. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Here is the workaround to achieve the attribute left outer join on MicroStrategy Web. The MicroStrategy SQL Engine 9. In certain reports, users may notice that subtotals defined across level are not broken by attribute element in a grid report in MicroStrategy Developer 9. In other words, ApplySimple("(#0 - #1) / 7", ?, ?) will fail as shown in the example below. KB36904: ApplySimple statement is trying to calculate in the Analytical Engine in MicroStrategy Developer 10. In this table, the PARENT_ID column logically points to another row in the same table (ID column). . For information on the syntax used in your specific database, refer to the MicroStrategy Functions Reference. Generally, when null checking is used in metrics, the null checking is performed as part of the initial metric calculation. Syntax. NOTE: An enhancement request has been made to allow users to create a graph for rolling 12 months comparing current and prior year metrics without having to modify attributes by implementing ApplySimple statements. An example of such a need occurs when a modification had been made to the Relational Database Management System (RDBMS) so that the ApplySimple syntax should be changed to reflect the new. Step 4) When users execute the report, they will notice that the 'ApplySimple' is ignore resulting in just the Metric Alias. arithmetic operators) can be used. MSTr allows to dynamically specify the File Location and Backup File Location in a file device using macros. These functions can be used in a MicroStrategy expression as follows, take ApplySimple function for example, create a metric using expression below (Average and Avg are existing metrics): ApplySimple ("case when #0 >. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. g. The user should enter two double-quote marks in succession, as shown. Forum: Search: FAQs: Links: MVPs: Menu. Create a new Intelligent Cube C01 using Existing objects: Catalog, Customer City, Customer Gender 3. Unfortunately this is a "decode within a decode" and isn't. KB439226: How to create a filtered metric using a case statement in Visual Insight in MicroStrategy Web 10. 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. The MicroStrategy Analytical Engine does not calculate date and time functions. Keep the form expression unchanged. Concat is often used to combine related values, such as a first and last name. This section describes the date and time functions. 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. If the cube dimension's key data use the MicroStrategy login directly, the formula can be relatively simple. The database instance is created. 18K KB8426: How to create a metric with an ApplySimple statement which will choose different metrics for calculation based on. The ApplySimple statements given above are ORACLE Specific. You can use them in many different capacities, which include, creating or modifying both schema and user objects. 4. Case can be used for categorizing data based on multiple conditions. The prompt may be used in the ApplySimple function, and will be substituted at runtime. This is a single-value function. How to use Guacamole to copy and paste text or files in MicroStrategy on AWS; All new Download site is now available!Applysimple in Metric; Conditional metric and report filter interactions; Connection Mappings in Microstrategy;. Presented during MicroStrategy World 2021, hear best practices and tools and tips for connecting to Snowflake. I can't remember if the strings have to be enclosed in single or quote quotes. The 'Group By ID Attribute' VLDB property is not applied in a MicroStrategy Desktop 8. Microstrategy Dossiers With the release of MicroStrategy 10. Thus directly using NULL in formula will fail. Number of Views 49. Syntax ApplySimple () Accepts facts, attributes, and metrics as input. ) can be used. An example of this behavior is as follows:Try using some of the date functions that are now available in 8. For example, using the MicroStrategy Tutorial project, users may want to calculate the number of. ApplyComparison where. Users want to create a filter that always filters on this month, i. ApplySimple("Datediff(YY,#0,getdate())", [BIRTH_DATE]), in which [BIRTH_DATE] is an attribute. The example below shows the basic structure of an ApplySimple statement to create metrics. Dynamic Sourcing is the technology that allows ad-hoc report, standard reports and OLAP reports to access shared Intelligent Cubes in an automatic way. 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. Microstrategy Dashboard performance improvements steps: Many times, causes of poor performance can be simplified to specific components. How to create a MicroStrategy connection file (. ApplySimple: where simple operators (e. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. Creating a . 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. The prompt "Choose from all elements of 'Category'" is also placed into the report. However, MicroStrategy does have a method for providing database specific SQL to be passed directly to the database; this is accomplished with the ApplySimple statement. 2. percentage. Fu nction Types. This custom SQL can be used in the fact, attribute form expression, filter and metric editors. 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. ApplySimple ("Case When T1. Syntax. MicroStrategy will continue to investigate and post updates as soon as they are available. Using these functions, MicroStrategy generated SQL. Select the DSN. Create a metric with M03 = MonthStartDate (CurrentDate). Examples of this category are simple mathematical. If all conditions are false, a default value is returned. Microstrategy Dossiers With the release of MicroStrategy 10. By contrast, IF() allows database side conditional functions to be leveraged without using ApplySimple() or ApplyAgg() functions. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. Create New Metric in a report or VI. 1 – In MicroStrategy Developer, navigate to the folder where you wish to create the attribute, right-click in it and select New > Attribute. If the first date argument is later than the second date argument, the result is a negative number. A user may want to create an attribute with an alternating expression depending on a certain condition, a conditional attribute. Explanation. Save and assign a name to the file like “My_first_connection_file. x, with the Intelligence Server running on Linux, the. The following steps will reproduce the issue in MicroStrategy Tutorial running against a Vertica 4. In the Database Logins dialog, enter your login credentials. Splitting the fraction: Numerator: Sum (VOL) {~} Denominator: Max ( ApplySimple ("replace (#0, ',', '. This function evaluates multiple expressions until a condition is determined to be true, then returns a corresponding value. However, the user would like to search for the exact phrase. These triggers do not need to be defined in advance. This custom SQL can be used in the fact, attribute form expression, filter and metric editors. 4. 21K. to MicroStrategy Experts. Right-click the fact and select Edit. Follow the steps below to create a list of all groups and the users in each group: In MicroStrategy Developer 9. An inner join is created and a line representing the join appears in the Query Builder pane, running. In the bottom left corner, click on the button "Generate Connection File". snowflakecomputing. This is a group-value function. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. 3. For example: • 1/ Attribute [Net Weight] = 0,5 (type of data is. The calculation of the difference is based on the number of day boundaries crossed, not the number of twenty-four hours periods elapsed. x, a passthrough function, such as ApplySimple, cannot be used on a prompt in a report based off of an Intelligent Cube. MicroStrategy Technical Support does not provide customized MDX queries. ApplySimple("Case When #0 ='abc' Then #1 Case #2='xyz' Then #3 End",Attribute_A@ID,[Metric 1],Attribute_B@ID ,[Metric 2]). . the columns separated by commas at the end with an ending close Paren. 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. Fu nction Types. The ApplySimple and ApplyComparison functions are useful in the Advanced Qualification Editor. 6. Insert an HTML container (and not an image) and insert the script below. x use the Day attribute to qualify on a particular date. This function evaluates multiple expressions until a condition is determined to be true, then returns a corresponding value. But, DESC has repeating values. ApplySimple ("case when #0 contains 'As Is' then 'As Is' when contains 'New' then 'New' ELSE 'Other' END", [NAME]) case. Number of Views 2. Environment: Microstrategy. MicroStrategy - Dynamic Attribute with join. Motivation: Customers can bring in data as a cache so they can save on costs using Snowflake. 4) Next, change the Theme back to None and click Apply. But since the length of the month ranges between 28-31 days it. From MicroStrategy 9. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. mstrc”. MicroStrategy with Google Big Query. YTD transformation. This section describes the date and time functions. Select your custom visualization. The following example is created within the MicroStrategy Tutorial project, specifically using the ORDER_DETAIL and ORDER_FACT tables. 18K KB8426: How to create a metric with an ApplySimple statement which will choose different metrics for calculation based on. This is a single-value function. 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. Data files can be published as either an In-Memory Cube or a Live Connect Cube. For new columns to be available for attribute and fact creation in MicroStrategy Architect, the table structure must be updated. The Attribute Editor opens three dialog boxes, if the cascading dialog box option is enabled in the Developer Preference (as it is by default). This condition may be implemented through an ApplySimple statement such as the following: The user will find that the CASE. 1. KB3905: How to use pass-through expression- ApplySimple in MicroStrategy SQL Generation Engine. Some customers may need to use the Oracle provided JDBC in lieu of MicroStrategy shipped ODBC driver to connect to Oracle database. , Tuesday should. Details: MicroStrategy supports both Azure AD and Okta Authentication with Snowflake. Deploy the ojdbc8. Now, if I create an attribute on the DESC itself, I do get a unique list of values to be shown in the prompt , but, the report results get messed up. Settings for Outer Join between metrics in MicroStrategy MicroStrategy adopts multi-pass logic to determine the execution plan for a report. Select the DSN. The Microstrategy installation will create 3 Microsite Access databases in your local directory (C:Program Files (x86)MicroStrategyTutorial ReportingTUTORIAL_DATA_7200. Below is what I tried but it did not work. ApplySimple("Datediff(YY,#0,getdate())", [BIRTH_DATE]) The attribute form, Age, can be defined by using the single-value function, ApplySimple. You could use applysimple on the attribute definition to display 'NULL; Example:This article describes features that are not supported when using Dynamic Sourcing. This document describes the second approach. For more information on using these functions in the MicroStrategy's architecture, refer to the MicroStrategy Product documentation and the following Microstrategy Knowledge Base document: TN3905 (TN5200-7X0-0019): How to use pass-through expression- ApplySimple in MicroStrategy SQL Generation Engine 8. MSTR has evolved. As shown below, for a specific report, the 'Group By ID Attribute' VLDB property is set to 'Group by column' instead of 'Group by expression' to avoid using an ApplySimple. In threshold, use the condition as "Region_Test where DESC Exactly EMPTY", then threshold will be applied to those elements whose DESC is a space.