4. A dataset is a standard MicroStrategy report. I can't remember if the strings have to be enclosed in single or quote quotes. For example, ApplySimple ("#0 * #1", [col1], [col2]) indicates that two items, col1 and col2, referenced as #0. Download and extract Snowflake ODBC driver from Snowflake console. Data files can be published as either an In-Memory Cube or a Live Connect Cube. All articles. 4. , Tuesday should. 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. Examples of this category are simple mathematical. 4. ')"; [Net Weight. Here MaxProfit is the max value of Profit metric across all items; Copy & paste metric “Profit” to generate metric “Profit1”;How to create a simple Transformation in MicroStrategy. The calculation of the difference is based on the number of day boundaries crossed, not the number of twenty-four hours periods elapsed. I have a metric that shows sum (Widgets). "mahendra_patel via microstrategy-l" 07/07/2006 11:19 Favor responder a microstrategy-l@Groups. The function removes the fractional part of a real number so that only the integer part remains. &[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. Also, I have to move null handling to RDBMS via the function- NVL (Oracle), IsNull (SQL Server), and Coalesce (DB2) because conditions and calcs done in the database don't benefit from MSTR's. 1 and 10. 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. 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. 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. For basic information and examples of the ApplySimple function, see the Functions Reference. The Attribute Editor opens three dialog boxes, if the cascading dialog box option is enabled in the Developer Preference (as it is by default). 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. DateDiff (Day@ID, CurrentDate (), "d") For each element of the Day attribute, the metric displays the number of days between that date and the current date when running the report or dossier. From the Database connection type drop-down, choose Snowflake. The MicroStrategy Analytical Engine does not calculate date and time functions. The MicroStrategy Advanced Reporting Help provides comprehensive information on advanced topics for using the MicroStrategy query and reporting products. 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. SYMPTOM: In MicroStrategy 9. 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. You can define joins between columns on the Import from Tables dialog while building a query for importing your data. 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. 4. Select any project that is in the project source that contains the users and groups and click Next. How to set the maximum date from a warehouse table to be the maximum answer displayed when executing a prompted report in MicroStrategy. . ApplyComparison where. KB35312: Attribute sorting does not get applied correctly on a selector when viewing a Report Services Document in DHTML mode in MicroStrategy Web 9. nction Types. The following example is created within the MicroStrategy Tutorial project, specifically using the ORDER_DETAIL and ORDER_FACT tables. Keep the form expression unchanged. x adn 10. MicroStrategy Apply Functions provide access to functions or syntactic constructs that are not standard in MicroStrategy but are provided by various Relational Database Management System (RDBMS) platforms. In MicroStrategy, there are two settings that users can access to control Outer Join behavior : Formula Join Type and Metric Join Type . While MicroStrategy Developer 9. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. . Create a file subscription in MicroStrategy Web. 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. 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. Open your Snowflake console ( account. The syntax always follows the format Applyfunction ("#0. You can use the ApplyAgg function to define simple metrics or facts by using database-specific, group-value functions. x using an Oracl… Number of Views 6. You can choose one or more data files from Hadoop HDFS and load them into MicroStrategy Intelligence Server. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. KB16057: How to create customized metric expressions for MDX Cube data sources in MicroStrategy Engine. . This custom SQL can be used in the fact, attribute form expression, filter and metric editors. that is used to table that contains column MyDate and force. ApplySimple This is the most common function, as you can use it in an Attribute definition. Always be aware of the latest driver version. Forum: Search: FAQs: Links: MVPs: Menu. Select only Configuration Objects for documentation. But since the length of the month ranges between 28-31 days it. Using these functions, SQLs generated by MicroStrategy will call UDF just like any other function provided by Teradata. 1 and 10. 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. 2. In MicroStrategy Web create a new Visual Insight dashboard with the Year attribute, Region attribute and the Revenue metric. To achieve this, the users can make use of an Apply Simple statement through a new attribute form in the attribute form expression editor. 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. RE: YTD. The MicroStrategy SQL Engine 9. But, DESC has repeating values. 4. Microstrategy Dossiers With the release of MicroStrategy 10. The same logical should apply for other databases, but the syntax will need to be changed. The example below shows the basic structure of an ApplySimple statement to create metrics. 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. EXAMPLES: Using the Populate method: Set objMDFilter = mobjObjSource. 4. ApplySimple("CONVERT(VARCHAR(23), #0, 121)",[Column1] )symbol. Thus directly using NULL in formula will fail. 94K. 1 and 10. With a few additional applysimple statements this can also be used to create QTD and MTD. This document describes the second approach. Ragged Hierarchies in Microstrategy. STEPS TO REPRODUCE: 1 - In the MicroStrategy Tutorial project create a new attribute form in the Category attribute with the following expression:For example, in the MicroStrategy Tutorial project, for the 'Month' attribute, instead of seeing the description as 'September 2007, users might prefer to see 'Sep'. ApplyComparison: where comparison operators (e. This function evaluates multiple expressions until a condition is determined to be true, then returns a corresponding value. The syntax in this document can vary depending on the. 4. How to define an attribute form as an HTML tag in MicroStrategy Developer 9. If the first date argument is later than the second date argument, the result is a negative number. 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. From the MicroStrategy Developer File menu, point to New > Attribute. 1 and 10. Update the data on an Intelligent Cube without having to republish the entire cube in MicroStrategy. The “#n” code in Apply function syntax serves as placeholders for the MicroStrategy objects being passed to your database. 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. x. How to use Guacamole to copy and paste text or files in MicroStrategy on AWS; All new Download site is now available!ApplyAgg. 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. 2. MicroStrategy Office、MicroStrategy Report Services、MicroStrategy Web MMT、MicroStrategy Web Services、Pixel Perfect、 Pixel-Perfect、MicroStrategy Mobile、MicroStrategy Integrity Manager、および MicroStrategy Data Mining Services はすべて、 MicroStrategy Incorporated の登録商標または商標です。In the context of MicroStrategy functions, this book discusses derived expressions. After migrating to MicroStrategy 9. if both conditions are met, then Red, else Green. ITtoolbox. Users want to create a filter that always filters on this month, i. , ApplySimple or ApplyAgg). Teradata supports user-defined functions (UDFs), which allow you to extend the SQL language by writing your own functions or installing UDF packages from third-parties. x. com) In the popup that opens, select ODBC. Applysimple in Metric; Conditional metric and report filter interactions; Connection Mappings in Microstrategy;. MicroStrategy will continue to investigate and post updates as soon as they are available. Deploy the ojdbc8. 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. Select the attribute form to be displayed with a link. 4. Create a Report Services Document 2. i need to. MicroStrategy recommends to have only one child at the lowest level. The database instance is created and can. Personally, I would use ApplySimple and let the database handle the work. 4. For. Environment: Microstrategy. 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. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. x. Create a Report Services Document 2. Fu nction Types. ApplySimple("CASE WHEN #0=1 THEN #1 ELSE NULL END", , ). 2. Outer Joins come into play when MicroStrategy Engine merges the results from all SQL passes into one report. , the report always contains a clause such as 'WHERE MONTH_ID = 200107', for the current month. ApplySimple: where simple operators (e. CREATE SECURITY FILTER "SecFilter3" DESCRIPTION "region@id=1" IN PROJECT "MicroStrategy Tutorial" EXPRESSION "Region@ID=?Contributors"; will receive the following error: CAUSE: This is a known limitation in MicroStrategy Command Manager 9. 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 shown in the screenshot. microstrategy. ) can be used. Recommended VLDB Properties for use of MicroStrategy 9 with Hive 0. MicroStrategy’s strongest feature is it’s SQL Engine. x: Open the Filter Editor to define a new filter. A human reader can see from the ApplySimple SQL string that the revenue value will be returned (meaning that the datatype should be Float). MicroStrategy will continue to investigate and post updates as soon as they are available. x. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Sum . CAUSE: This is currently working as designed. Use of M03 in Microsoft SQL Server 2000 would result in DATEADD (DD, (1 - DAY (GetDate ())), GetDate ()). x using an Oracl… Number of Views 6. The Dynamic Dates in MicroStrategy SQL Generation Engine 9. The following example is created within the MicroStrategy Tutorial project, specifically using the ORDER_DETAIL and ORDER_FACT tables. However, by taking advantage of the ApplySimple expression, the attribute sorting can get applied correctly in Microstrategy Desktop and Web 9. December 07, 2018. MicroStrategy parser doesnt recognize NULL as a key word for null value. By contrast, IF() allows database side conditional functions to be leveraged without using ApplySimple() or ApplyAgg() functions. 0 and have to resort use applysimple to take advantage of DB's least function instead. 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. To create a MicroStrategy Environment connection file . Some customers may need to use the Oracle provided JDBC in lieu of MicroStrategy shipped ODBC driver to connect to Oracle database. g. Syntax. Starting in MicroStrategy 2020 Update 2, the Snowflake ODBC driver is shipped to simplify the connectivity workflow. Case. 4. MSTR has evolved. Drag the column from the first table onto the column from the second table. 0 workflow with Okta can be seen here. Upgrade to MicroStrategy m2020 or later release. Step 2) Create a metric using the following syntax, Sum(ApplySimple("#0", <Attribute Name>, 1)){~}. The MicroStrategy SQL Engine will join database tables together based on the lowest level attributes that MicroStrategy Architect assigns to each table. Applysimple in Metric; Conditional metric and report filter interactions; Connection Mappings in Microstrategy;. g. 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. double quotes around it, substitute the column names with #0 . KB36904: ApplySimple statement is trying to calculate in the Analytical Engine in MicroStrategy Developer 10. MSTR has evolved dashboards to the point that they. For information on the syntax used in your specific database, see MicroStrategy and Database Support for Functions and see the section that corresponds. 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. Create a metric with M03 = MonthStartDate (CurrentDate). In this quick tip, I show you how to filter MicroStrategy reports using a custom SQL query using ApplyComparision and ApplySimple. MicroStrategy - Passthrough Filters - Online Training Video by MicroRooster. Microstrategy Dossiers With the release of MicroStrategy 10. The following example uses MicroStrategy Tutorial to explain the construction of a Year-To-Date metric. How to create fact that does not get rounded up when calculated with MicroStrategy Developer 9. The ApplyComparison function is used with comparison operators such as >, Like, and In. 98K. Change the DESC form expression to the following. Returns the current date as provided by the database timer. Our solutions work to guide towards best practices and provide guidance to the user community. Use ApplySimple in the form expression and change the date format to yyyy-mm-dd. Click New. This section describes the date and time functions. 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. Add the derived metric to the report and hide it by setting the column width to 0. In the Database Connections dialog, enter a database connection name. Phoenixier. MSTR has evolved. Create a new Intelligent Cube C01 using Existing objects: Catalog, Customer City, Customer Gender 3. A system external to Intelligence Server is responsible for determining whether the conditions for triggering an event are met. This article explains how to model recursive hierarchies in MicroStrategy. You can use the AppleSimple function to insert database-specific functions and simple operators directly into SQL. To create an attribute in MicroStrategy with a fixed NUMBER value, follow the steps below:. This function does not take input variables. 08K. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. From MicroStrategy 9. This issue can be solved in two steps using a MicroStrategy 10. jar file to i-server machine. HTCMS (Programmer) (OP) 19 Feb 04 20:41. In MicroStrategy, there is currently no formatting options available to display datetime format forms with millisecond values. Applysimple in Metric; Conditional metric and report filter interactions; Connection Mappings in Microstrategy;. If you love a cozy, comedic mystery, you'll love this 'whodunit' adventure. to MicroStrategy Experts. In MicroStrategy Desktop, double-click on the attribute to be modified. Now your connection f. Loading × Sorry to interruptKB42225: How to create a distinct count subtotal from base report in MicroStrategy Web Number of Views 6. 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. For information on the syntax used in your specific database, refer to the MicroStrategy Functions Reference. In this table, the PARENT_ID column logically points to another row in the same table (ID column). 4. KB36904: ApplySimple statement is trying to calculate in the Analytical Engine in MicroStrategy Developer 10. &[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. Click OK in all three dialogs (Login, Connection, and Database Instance). 4. The script inside the " " always depends on the type of database used and can vary from one database. Comparison operator prompts can be used in ApplySimple functions with Case statements using the metric, (@nameofprompt(M1, M2)). The script inside the " " always depends on the type of database used and. arithmetic operators) can be used. 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. Choose attribute Call Center and use the Region Filter created in the previous step. Depending on your MicroStrategy product and licensing. snowflakecomputing. Microstrategy Dossiers With the release of MicroStrategy 10. Create a new derived attribute by. 4. , metrics or attributes) containing a particular function or operator (e. name = "HFilter" Dim objSearch As. This is a group-value function. This technical article outlines the steps to create rolling time attributes in MicroStrategy Developer 9. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. MicroStrategy Web supports basic HTML tags on warehouse elements, including the tag for HTML hyperlinks. 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. Within a project, a security filter may be specified for any user. Microstrategy Training Centers in Victoria, BC – List of Microstrategy certification training, classes, Institutes in Victoria, Know more about Microstrategy fees. Consult the following MicroStrategy Knowledgebase document for more information on Case() and CaseV(). Insert an HTML container (and not an image) and insert the script below. It should work. 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. Examples of this category are simple mathematical. 4. KB20306: How to create dynamic date based on 'Last Month' in MicroStrategy SQL Generation Engine 9. 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 MicroStrategy Developer, log in to the project source that contains the fact to create a new column alias for. x adn 10. Examples of this category are simple mathematical. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformKB3905: How to use pass-through expression- ApplySimple in MicroStrategy SQL Generation Engine. In MicroStrategy SQL Generation Engine, when simple Period to Date (PTD) reports are needed, there is no need to create a transformation table. x and 10. ApplyComparison The ApplyAgg function is used to define simple metrics or facts by using database-specific, group-value functions. The Apply function types are listed below, along with examples of the MicroStrategy functions that they can replace: ApplySimple: Simple single-value functions, including arithmetic operators such as + and -, date and string manipulation functions, and so on; ApplyAgg: Group-value (otherwise known as aggregate) functions such as Sum and Max Apply functions provide access to functionality that is not standard in MicroStrategy, but is available in the relational database. In MicroStrategy 2021, MicroStrategy ships Snowflake JDBC out of the box. Note: The form expression in the above sample is for Access database only. Syntax. x and add a derived attribute, right clicking an. 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. Number of Views 49. ApplySimple: Simple single-value functions, including arithmetic operators such as + and -, date and string manipulation functions, and so on ApplyAgg: Group-value (otherwise. Expression: ApplySimple("FORMAT(#0,'yyyy-MM-dd')", [DAY_DATE]) Save the modification and update schema. 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. ApplySimple ("cast (#1 as varchar (3)) + ': "" ' + #0 + ' "" ' ", , ) The purpose of this expression (for SQL Server) is to display items with both the ID and description in the same string, quoting the description: When SQL is generated, wherever two double-quotes appear in. Click OK in all three dialogs (Login, Connection, and Database Instance). To create an attribute in MicroStrategy with a fixed NUMBER value, follow the steps below:. 2. 62K. Open the project in which a new column is added. Derived metric based on attribute values Here is how could create and display data correctly on using below simple steps. You can use the AppleSimple function to insert database-specific functions and simple operators directly into SQL. Select the DSN. 2. Concat (Concatenate) The Concat function combines two or more input strings into one continuous string and returns the result. Fu. If two users with different security filters run the same report, they may get different results. g. Number of Views 1. 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. A split hierarchy is one - that at the lowest level - has more than one child. Unfortunately this is a "decode within a decode" and isn't. Create three reports named A (with attribute A), A&B (with attribute A and B),A&C (with attribute A and C) Create a dashboard based on the three reports created in last step. 4. KB484697: How to use the ApplyX function without the "Use FreeForm SQL Report" privilege. Microstrategy Dossiers With the release of MicroStrategy 10. My current metric definition is: ApplySimple("TO_DOUBLE(. MicroStrategy Apply functions provide access to functions or syntactic constructs that are not standard in MicroStrategy but are provided by various Relational Database Management System (RDBMS) platforms. SyntaxCurrentDate. Consolidations allow users to group attribute elements in new ways without changing the metadata and warehouse definitions. 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. The following steps can be used to concatenate two attribute forms. Syntax. Dynamic date qualifications are not supported against MDX cube data sources, but the same results can be achieved by using custom MDX expressions. arithmetic operators) are used. 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. 1 and 10. Visit the data visualization and data dashboard galleries for inspiration. Open up the same document in MicroStrategy Web 10. 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. Presented by MicroStrategyBlog. 2 Can anyone tell me how to create a Filter using Applysimple in Microstrategy 7. ApplySimple ("Case When T1. The syntax always follows the format Applyfunction ("#0. For example, a prompt can be created to provide the list of dates between a date selected in a date prompt and next 30 days. Example 1 Using an attribute The ApplySimple and ApplyComparison functions are useful in the Advanced Qualification Editor. My gloal is to cast a fact column to double value. The following steps demonstrate how to use the comparison operator prompt in an ApplySimple function with a Case statement. 3. The project level setting Data Engine Version can only be enabled through Workstation. Specify the desired delivery options including recipient address, subscription name. ApplySimple("SUBSTR(#0,1,3)", ) Apply. Number of Views 2. These functions are not supported by the Analytical Engine, so they must be calculated by the database. So far we have only found ways to change the. When using the DateDiff function in MicroStrategy Web, you will need to replace the Day@ID attribute in the function definition. Concat is often used to combine related values, such as a first and last name. Creating a . For example, concatenating the two strings "Micro" and "Strategy" would result in the single string "MicroStrategy". This is true whether the null checking is written into the metric formula using the MicroStrategy function NullToZero(My_Fact), or using a database pass-through function such as ApplySimple("NVL(#0, 0)", My_Fact) for Oracle. Using a combination of filters and metric dimensionality, the same results can be achieved. Close the Visualization Builder, and then re-open it. This custom SQL can be used in the fact, attribute form expression, filter and metric editors. to_char (case when Date_DESC is null then to_date (`31-DEC. 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. The ApplyAgg function is used with Basic functions such as Sum and Max. Examples of this category are simple mathematical. 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. For example, ApplySimple("#0 * #1",[col1],[col2]). You can use them in many different capacities, which include, creating or modifying both schema and user objects. How to write Pass-through filters using ApplySimple, ApplyAgg and ApplyComparison functions. Click New. x or you can always use an applysimple to pass the Oracle functions in natively. The fractional part is removed without rounding the number up or down. . NOTE: For additional information regarding pass-through expression ApplySimple and Attribute form data type, refer to the MicroStrategy technical notes: KB3905: How to use pass-through expression- ApplySimple in MicroStrategy SQL Generation EngineThis article covers how to use passthrough expressions to write custom SQL inside of MicroStrategy. Explanation. Trending Articles. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. ApplySimple may be used in one or both sides of a comparison expression. Examples of this category are simple mathematical. If I select name1 from the prompt, I do need to show all the occurances of. A user may want to create an attribute with an alternating expression depending on a certain condition, a conditional attribute. ApplySimple where simple (e. This is a comparison function. Applysimple in Metric; Conditional metric and report filter interactions; Connection Mappings in Microstrategy;. ApplySimple("Case When #0 ='abc' Then #1 Case #2='xyz' Then #3 End",Attribute_A@ID,[Metric 1],Attribute_B@ID ,[Metric 2]). We are active contributors to solutions on the MicroStrategy Community site. 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. Example 1 Using. 0. The Attribute Editor opens three dialog boxes, if the cascading dialog box option is enabled in the Developer Preference (as it is by default). For example, the following will illustrate how to create a metric with a constant element inside the Applysimple statement:Comparison operator prompts can be used in ApplySimple functions with Case statements using the metric, (@nameofprompt(M1, M2)). 1 million 1.