In addition, MicroStrategy also allows a business user to design custom ANSI SQL queries with a live connection to leverage any database push-down optimization such as query. 0 and have to resort use applysimple to take advantage of DB's least function instead. MicroStrategy - Passthrough Filters - Online Training Video by MicroRooster. x. 4. Example 3: ApplySimple ApplySimple ("Datediff (YY,#0,getdate ())", [BIRTH_DATE]) The attribute form, Age, can be defined by using the single-value function, ApplySimple. KB35312: Attribute sorting does not get applied correctly on a selector when viewing a Report Services Document in DHTML mode in MicroStrategy Web 9. 4. e. 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. microstrategy. The ApplyAgg function is used with Basic functions such as Sum and Max. g. How to use Guacamole to copy and paste text or files in MicroStrategy on AWS; All new Download site is now available!ApplyAgg. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Our solutions work to guide towards best practices and provide guidance to the user community. Thus directly using NULL in formula will fail. x using an Oracl… Number of Views 6. Concat is often used to combine related values, such as a first and last name. 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. ApplyOLAP is the MicroStrategy Apply function tool used for OLAP functionality when you wish to use the native capabilities of your RDBMS. The syntax in this document can vary depending on the. KB32365: How to use element list prompts in database passthrough functions In MicroStrategy SQL Generation Engine. This technical article outlines the steps to create rolling time attributes in MicroStrategy Developer 9. 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. Use ApplySimple in MicroStrategy. Comparison operator prompts can be used in ApplySimple functions with Case statements using the metric, (@nameofprompt(M1, M2)). For more details on enabling the setting, see Change Data Engine Version. For example, if you specify the File Location as. CONTENTS 1. Custom groups; A custom group is a special filter that can be placed on a template and is. Number of Views 49. The prompt may be used in the ApplySimple function, and will be substituted at runtime. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. MSTR has evolved. In the Database Connections dialog, enter a database connection name. Microstrategy Dossiers With the release of MicroStrategy 10. 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. In other words, ApplySimple("(#0 - #1) / 7", ?, ?) will fail as shown in the example below. Using Prompts and ApplySimple Statements. mstrc) Open Workstation. 2 A. Could you please update the list…. 1 million 1. 7x. Concat is often used to combine related values, such as a first and last name. So far we have only found ways to change the. Click New. 2. 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. Sum . Choose attribute Call Center and use the Region Filter created in the previous step. It should work. 4. Number of Views 49. The fractional part is removed without rounding the number up or down. This is a comparison function. 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. 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. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Create a Report Services Document 2. 4. . 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. Create a metric using either definition: ApplySimple("Sum(#0)", ?Year) Or ApplySimple("Sum(#E0)", ?Year) 3. Examples of this category are simple mathematical. ApplySimple( "convert. Click OK in all three dialogs (Login, Connection, and Database Instance). The recommended VLDB optimizations for Hive 0. 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. AddDays. g. Syntax. 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. This section describes the date and time functions. To ensure this prompt requires an answer, select the 'Prompt answer is required' check box. In the Database Logins dialog, enter your login credentials. ACTION: Contact MicroStrategy Technical support for an update of this. For. 3K. g. KB439226: How to create a filtered metric using a case statement in Visual Insight in MicroStrategy Web 10. The steps below use objects from the MicroStrategy Tutorial project as an example. Follow the next steps to create this type of metric. The “ #n” code in Apply function syntax serves as placeholders for the MicroStrategy objects being passed to your database. Open up the same document in MicroStrategy Web 10. The Attribute Editor opens three dialog boxes, if the cascading dialog box option is enabled in the Developer Preference (as it is by default). 4. ApplySimple ("Case When T1. Join. From the Database connection type drop-down, choose Snowflake. 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. region. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. 3. Explanation. CurrentDate() For information on whether your database supports various date and time functions, see MicroStrategy and Database Support for Functions. 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. Sum, Max, etc) can be used. 1 and 10. 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. Trending Articles. 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. Using a combination of filters and metric dimensionality, the same results can be achieved. Fu nction Types. Number of Views 3. You might have to "trick" it by embedding applysimple inside your case statement to make it accept your "Y" and "N". 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. it looks like MicroStrategy doesn't support it, please advise. Refer to MicroStrategy Knowledge Base document KB5700-007-0107 for more. For more details on how to use ApplySimple() statements, refer to the following MicroStrategy Knowledge Base technical note:When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Consolidations enable users to create customized groupings that allow row calculations between elements of a given attribute. Step 3) Create a report using the 'Region' attribute and the metric created in Step 2. Fu nction Types. This article describes a behavior observed when adding a new attribute form expression with Workstation, if the ApplySimple function is used. 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. KB20306: How to create dynamic date based on 'Last Month' in MicroStrategy SQL Generation Engine 9. Personally, I would use ApplySimple and let the database handle the work. Contact MicroStrategy Technical Support for an update on the status of this request. By design, however, MicroStrategy SQL Generation Engine 8. From MicroStrategy 9. This issue applies also to MDX passthrough formulas defined by enclosing the formula in quote marks (without the ApplySimple keyword). For basic information and examples of the ApplySimple function, see the Functions Reference. Create 2 derived attributes DA2 and DA3, both using DA1 as a child component. Using these functions, MicroStrategy generated SQL. 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. 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. , ApplySimple or ApplyAgg). There's a reason we're at the top of the list. But, it will calculate at the lowest Data level if that is your intention. Generally, when null checking is used in metrics, the null checking is performed as part of the initial metric calculation. 4. MicroStrategy Web supports basic HTML tags on warehouse elements, including the tag for HTML hyperlinks. x. x use the Day attribute to qualify on a particular date. For example, concatenating the two strings "Micro" and "Strategy" would result in the single string "MicroStrategy". MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . Depending on your MicroStrategy product and licensing. The user should enter two double-quote marks in succession, as shown. Concat("Images/demo/s", [BARANG_ID_INT], ". 4. x does not have the inherent functionality to truncate numbers like this, it is possible to do it using the 'ApplySimple' function. Create a new Intelligent Cube C01 using Existing objects: Catalog, Customer City, Customer Gender 3. This is a single-value function. This is a group-value function. You could use applysimple on the attribute definition to display 'NULL; Example:This article describes features that are not supported when using Dynamic Sourcing. 1. In this table, the PARENT_ID column logically points to another row in the same table (ID column). Some customers may need to use the Oracle provided JDBC in lieu of MicroStrategy shipped ODBC driver to connect to Oracle database. 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 Engine This article covers how to use passthrough expressions to write custom SQL inside of MicroStrategy. 35K. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. The Dynamic Dates in MicroStrategy SQL Generation Engine 9. 2 for a '(VARCHAR2 (4 BYTE)' column. This condition may be implemented through an ApplySimple statement such as the following: The user will find that the CASE. All articles. For Oracle 12. Returns a date or timestamp plus an offset (+ or -) n days. Microstrategy Report Services documents vs Dashboards. MSTR has evolved. In a MicroStrategy environment with IBM DB2 as the Warehouse Database, a date attribute is created and defined using an ApplySimple statement containing the function 'CHAR' having 'LOCAL' as argument (which is a DB2 native syntaxWe use MicroStrategy Tutorial objects in the following steps. . x. ITtoolbox. 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. Microstrategy Dossiers With the release of MicroStrategy 10. 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. ApplySimple: where simple operators (e. Case. this column in ApplySimple statement. Step 4) When users execute the report, they will notice that the 'ApplySimple' is ignore resulting in just the Metric Alias. My current metric definition is: ApplySimple("TO_DOUBLE(. [MSTR User]. Syntax. This article covers how to use passthrough expressions to write custom SQL inside of MicroStrategy. 1 and 10. Create a report with the custom group and. 2. Trending Articles. mstrc file from an empty text file. You can use them in many different capacities, which include, creating or modifying both schema and user objects. Recommendation. How to create a MicroStrategy connection file (. When using the DateDiff function in MicroStrategy Web, you will need to replace the Day@ID attribute in the function definition. With consolidations, user can group attribute elements to define "virtual" attributes that enable. If an attribute is the lowest level attribute in a hierarchy, then the MicroStrategy SQL Engine will place a key beside this attribute in its logical table view. 1. Users may need to list all objects (e. When a user types in keywords to tries to find element names in an element prompt, the search returns all objects containing the keywords in MicroStrategy Developer 9. 4. Please follow this product guide toKB6669: How to create dynamic date filters on time attributes other than Date using custom SQL transformations in MicroStrategy SQL Generation Engine . ApplySimple may be used in one or both sides of a comparison expression. Let me know if you need additional information. nction Types. 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. microstrategy. 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. ApplyRelative where OLAP (ranking, etc. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. RE: YTD. The “#n” code in Apply function syntax serves as placeholders for the MicroStrategy objects being passed to your database. 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. 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. 1 and 10. But, it will calculate at the lowest Data level if that is your intention. KB4275: How to retrieve attribute form expressions using MicroStrategy Intelligence Server SDK. mstrc” file needs to be created for an environment connection prior submission, please follow these steps. Then I ask how to compared two metric based on ApplySimple in Report limit. If users attempt to apply a prompt. Split Hierarchy with M-M relationships: Explanation. . The current logic I've found is below. Details: With the Data Import functionality, MicroStrategy imports data from Snowflake into our fast in-memory cubes and can constantly send queries to the data in the memory saving on compute costs. g. 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. 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. 0. MicroStrategy, Inc. 1 and 10. 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. 4. Using Prompts and ApplySimple Statements. Create a report with Category, Subcategory and Revenue. MicroStrategy supports any UDF defined on Teradata through the use of pass-through functions, such as ApplySimple. Add the derived metric to the report and hide it by setting the column width to 0. • Involved in understanding and transmitting the business requirements for the project and. How to embed horizontal bar graphs into a column of a grid in Report Service Document in MicroStrategy Developer 9. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. mstrc”. x, the hyperlinks base on attribute form with Applysimple no longer work in the exported MHT file. Select a prompt style and click on 'OK'. The index for referencing these objects begins with 0 and increases by for each successive object passed. 1K. Maybe the Names (DESC) can be repeated but the ID should be distinct. The syntax always follows the format Applyfunction ("#0. KB39990: How to use ApplySimple to create attribute form to support sorting configuration in the attribute editor in MicroStrategy Desktop and Web 9. 4. 1. Pass-through expressions, also called Apply functions, provide access to special functions or syntactic constructs that are not standard in MicroStrategy, but can be obtained. Impact: Capability. The function removes the fractional part of a real number so that only the integer part remains. 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. ApplySimple("#0", MaxProfit). com Para jpviva. Derived metric based on attribute values Here is how could create and display data correctly on using below simple steps. 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. Microstrategy Dossiers With the release of MicroStrategy 10. 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. 2. Close the Visualization Builder, and then re-open it. For example, ApplySimple("#0 * #1",[col1],[col2])indicates that two items, col1 and col2, referenced as. MicroStrategy parser doesnt recognize NULL as a key word for null value. 1. Web/Desktop requires making use of a Live Connect dataset (either Data Import - Pick Tables or from Existing Objects). x. The apply functions act as containers for non-standard SQL expressions being passed to the database. Motivation: Customers can bring in data as a cache so they can save on costs using Snowflake. Microstrategy Training Centers in Victoria, BC – List of Microstrategy certification training, classes, Institutes in Victoria, Know more about Microstrategy fees. 98K. If you are looking to learn. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. to_char (case when Date_DESC is null then to_date (`31-DEC. For reference, refer to the Snowflake release notes. How to calculate data of time date type (HH:MM:SS) in Microsoft SQL Server using MicroStrategy Developer 9. Hi all, I was wondering if anyone knew of a way to change the display value of a NULL attribute (usually comes up blank) to display something like "UNKNOWN" or "NULL". Data files can be published as either an In-Memory Cube or a Live Connect Cube. 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. This is the format that will be used to convert string1 to a date. This function evaluates multiple expressions until a condition is determined to be true, then returns a corresponding value. In the example above, the ApplySimple statement for the attribute ID form should contain placeholders for column name as follows: ApplySimple("substring(#0, 1, 10)",) After changing the ApplySimple syntax for the attribute form CustCol 3, when the report SQL is viewed, the report will group by the attribute form CustCol 3 as shown below:Qualify on the attribute form that you want to compare (presumably the Year ID), and then in the Operator section, change the dropdown from its default 'Value' to 'Custom'. See below: Notice in Developer, you can currently right click on this document and select the 'Edit' option. 0. KB20306: How to create dynamic date based on 'Last Month' in MicroStrategy SQL Generation Engine 9. The ApplyAgg function itself is a group-value function and accepts facts, attributes, and metrics as input. 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. Syntax ApplySimple () Accepts facts, attributes, and metrics as input. g. x. 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. ApplySimple("CASE WHEN #0=1 THEN #1 ELSE NULL END", , ). format_mask is optional. Follow the steps below to create a list of all groups and the users in each group: In MicroStrategy Developer 9. Select only Configuration Objects for documentation. When using the DateDiff function in MicroStrategy Web, you will need to replace the Day@ID attribute in the function definition. . 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. 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. Number of Views 1. Follow the steps below. KB17619: How to create a conditional attribute in MicroStrategy Desktop 8. How to write Pass-through filters using ApplySimple, ApplyAgg and ApplyComparison functions. 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. Case can be used for categorizing data based on multiple conditions. x, open the Attribute Editor for the desired attribute and create a new form with the following syntax in the Form Expression section: ApplySimple ("#0 ',' #1", ,) NOTE: The ' ' in the above syntax is the Oracle. x that require single quotes in the definition. using Sum (PaidAmt * Attribute Sales Year) works fine, valid expression, but not really what I want. , Rank, etc. 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. 2. In the bottom left corner, click on the button "Generate Connection File". 11K KB3905: How to use pass-through expression- ApplySimple in MicroStrategy SQL Generation EngineApplyComparison. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. 4. In MicroStrategy 2021, MicroStrategy ships Snowflake JDBC out of the box. 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. A user may want to create an attribute with an alternating expression depending on a certain condition, a conditional attribute. Case can be used for categorizing data based on multiple conditions. Applysimple in Metric; Conditional metric and report filter interactions; Connection Mappings in Microstrategy;. Dynamic Sourcing is the technology that allows ad-hoc report, standard reports and OLAP reports to access shared Intelligent Cubes in an automatic way. 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. Instead, they are intended to enhance the MicroStrategy product by taking advantage of what the RDBMS platforms can offer. If a message is displayed asking if you want to use read only mode or edit mode, select Edit and click OK to open the Fact Editor in edit mode so that. This function does not take input variables. 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. ApplySimple("SUBSTR(#0,1,3)", ) Apply. The same logical should apply for other databases, but the syntax will need to be changed. snowflakecomputing. 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. The Attribute Editor opens three dialog boxes, if the cascading dialog box option is enabled in the Developer Preference (as it is by default). arithmetic operators) are used. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. MicroStrategy does not currently support element prompts inside of metric definitions. The MicroStrategy Advanced Reporting Help provides comprehensive information on advanced topics for using the MicroStrategy query and reporting products. Create a file subscription in MicroStrategy Web. x use the Day attribute to qualify on a particular date. 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 new attribute by navigating to File > New > Attribute. You can use the ApplyComparison function to define custom filters. 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. This is a single-value function. . 62K. 4. How to create fact that does not get rounded up when calculated with MicroStrategy Developer 9. STEPS TO REPRODUCE: Create a document in MicroStrategy Developer or Web 10. Number of Views 48. Instead, they are intended to enhance the MicroStrategy product by taking advantage of what the RDBMS platforms can offer. In this article we will discuss the ApplySimple function. 4. 1 and 10. Use the datetime format defined on warehouse database side in the ApplySimple statement. 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. 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. &[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. Insert an HTML container (and not an image) and insert the script below. 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. MSTR has evolved. x does not parse the contents of the SQL string and it cannot anticipate differences in database implementations of standard (or. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. 7x" database object is used (set at Configuration Managers > Database Instances > Database Instance > Database connection type) Selected Default. ApplySimple("Case when #0=1907 then 'Daily' else 'Weekly' END", ) After updating schema, the report works fine as shown below: Published: Jun 6, 2017; Last. In MicroStrategy Developer, create a dummy metric with the following definition.