The syntax of the ApplySimple expression is as follows: ApplySimple ("expression using #0",ATTRIBUTE_NAME)In some scenarios, it is necessary to use a database passthrough function (ApplySimple, ApplyComparison, ApplyAgg) to achieve specific query syntax that is not natively generated by the MicroStrategy SQL Generation Engine. The fractional part is removed without rounding the number up or down. Using a combination of filters and metric dimensionality, the same results can be achieved. For example: • 1/ Attribute [Net Weight] = 0,5 (type of data is. MicroStrategy - Passthrough Filters - Online Training Video by MicroRooster. You can define joins between columns on the Import from Tables dialog while building a query for importing your data. With a few additional applysimple statements this can also be used to create QTD and MTD. This filter must be applied in the final pass to find the correct store-region relationship, even though the final pass is a normal join instead of a downward join. The index for referencing these objects begins with 0 and increases by. The datatype used to define columns in temporary tables for objects defined with multiple inputs such as an applysimple statement are determined by the datatype of the first object listed in the object definition in MicroStrategy. In MicroStrategy SQL Generation Engine, security filters prevent users from seeing certain data in the database. 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. x. 다음의 예시 화면은 MicroStrategy Tutorial 프로젝트 안에서, 단순히 ORDER_DETAIL 과 ORDER_FACT 테이블을 사용해서 만들어졌습니다. You can use the MicroStrategy CASE function, available in MicroStrategy Developer (Schema ObjectsFunctions and OperatorsFunctionsInternal Functions), to retrieve desired result sets. MicroStrategy will continue to investigate and post updates as soon as they are available. 4. A table containing data that points to another row within the same table is said to have a recursive reference or to conform a recursive hierarchy. The Select Bursting Criteria options are displayed. Use the datetime format defined on warehouse database side in the ApplySimple statement. Create a metric like the example below: e. 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'. x. Filter functions can only be Equal, And, Or and Not" displays on prompt screen when using ApplySimple on a cube report in MicroStrategy 9. Expression: ApplySimple("FORMAT(#0,'yyyy-MM-dd')", [DAY_DATE]) Save the modification and update schema. 1 and 10. In the Create New Form Expression window in the Attribute Editor, select the above table as the source table and use the following ApplySimple statement to define the expression: Applysimple( "#0 '-' #1 '-' #2", ID, Quarter, Year) From the MicroStrategy Developer File menu, point to New > Attribute. This function relies on the Analytical Engine for processing, rather than the database. The syntax in this document can vary depending on the. Example 1 Using an attribute The ApplySimple and ApplyComparison functions are useful in the Advanced Qualification Editor. Microstrategy Dossiers With the release of MicroStrategy 10. , metrics or attributes) containing a particular function or operator (e. Phoenixier. g. The ApplyAgg function itself is a group-value function and accepts facts, attributes, and metrics as input. For information on the syntax used in your specific database, refer to the MicroStrategy Functions Reference. This is a comparison function. In SQL Server, the CAST () function is used to convert data into a different data type and the ApplySimple () function in MicroStrategy can be used to incorporate the CAST () function. This issue applies also to MDX passthrough formulas defined by enclosing the formula in quote marks (without the ApplySimple keyword). Returns a date or timestamp plus an offset (+ or -) n days. There are five predefined Apply functions, each belonging to a different function type - ApplySimple, ApplyAgg, ApplyOLAP, ApplyComparison, ApplyLogical. &[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. comApplySimple functions are used for simple expressions that use arithmetic operators. . The 'Choose a Prompt Style' dialog box opens. Something like: ApplySimple("'Y'", [your metric here]). 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. Refer to MicroStrategy Knowledge Base document KB5700-007-0107 for more. MicroStrategy - Dynamic Attribute with join. The following steps demonstrate how to use the comparison operator prompt in an ApplySimple function with a Case statement. 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. 4. Applysimple in Metric; Conditional metric and report filter interactions; Connection Mappings in Microstrategy;. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . In MicroStrategy Desktop, double-click on the attribute to be modified. Add the metric to a simple report and execute. Select any project that is in the project source that contains the users and groups and click Next. mstrc” file needs to be created for an environment connection prior submission, please follow these steps. nction Types. Recommended VLDB Properties for use of MicroStrategy 9 with Hive 0. xDateDiff (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 dashboard. Syntax. mstrc”. CAUSE: This is expected behavior. But, it will calculate at the lowest Data level if that is your intention. If the cube dimension's key data use the MicroStrategy login directly, the formula can be relatively simple. 4. Set Data Engine Version setting to 12. Here is the workaround to achieve the attribute left outer join on MicroStrategy Web. The syntax always follows the format Applyfunction ("#0. SyntaxCurrentDate. I want to find out the number of Widgets that were faulty, so I created another metric with that. In MicroStrategy, there are two settings that users can access to control Outer Join behavior : Formula Join Type and Metric Join Type . MicroStrategy does not currently support element prompts inside of metric definitions. Concat is often used to combine related values, such as a first and last name. Select only Configuration Objects for documentation. Create a numeric value prompt and name it P1. December 07, 2018. The same logical should apply for other databases, but the syntax will need to be changed. Select the attribute form to be displayed with a link. A user may want to create an attribute with an alternating expression depending on a certain condition, a conditional attribute. Used MicroStrategy functions such as ApplySimple, ApplyComparision in the metric calculations and used in different reports. Users want to create a filter that always filters on this month, i. X to be seen in MicroStrategy Web 9. Examples of this category are simple mathematical. You can use them in many different capacities, which include, creating or modifying both schema and user objects. Most data on a document is from one or more underlying datasets. x. KB419483: How to create a comparison operator prompt and use it in an applysimple function in MicroStrategy Developer Number of Views 1. DATA ANALYSIS 102. KB32365: How to use element list prompts in database passthrough functions In MicroStrategy SQL Generation Engine. 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. In MicroStrategy SQL Generation Engine, when simple Period to Date (PTD) reports are needed, there is no need to create a transformation table. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. 4. 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. KB16057: How to create customized metric expressions for MDX Cube data sources in MicroStrategy Engine. Enter a title and a description for the prompt. RE: DateTime to Month formatConcat (Concatenate) The Concat function combines two or more input strings into one continuous string and returns the result. x. You can use the AppleSimple function to insert database-specific functions and simple operators directly into SQL. g. For this example, assume we have a order_fact table has two dates, order_date and ship_date and an. 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. This true in any case where an explicit datatype is required. Examples of this category are simple mathematical. Involved in Microstrategy Intelligence Server performance monitoring and managing cache expiry times. Settings for Outer Join between metrics in MicroStrategy MicroStrategy adopts multi-pass logic to determine the execution plan for a report. Create a FreeForm SQL Report and add this nested prompt into it. Trending Articles. x-10. 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. Create a Report Services Document 2. 4. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. The current logic I've found is below. Case. The ApplyComparison function is used with comparison operators such as >, Like, and In. You can use the ApplyComparison function to define custom filters. We are active contributors to solutions on the MicroStrategy Community site. This section describes the date and time functions. While MicroStrategy Developer 9. NTTA (North Texas Toll Authority) Nov 2021 - Mar 20231 year 5 months. 1. 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. Example 3: ApplySimple ApplySimple ("Datediff (YY,#0,getdate ())", [BIRTH_DATE]) The attribute form, Age, can be defined by using the single-value function, ApplySimple. Right-click the fact and select Edit. If the cube dimension's key data use the MicroStrategy login directly, the formula can be relatively simple. Navigate to the Layout Tab. Returns the difference in days between two given dates as an integer value. You can use the ApplyAgg function to define simple metrics or facts by using database-specific, group-value 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. The result does not. 4. g. Sum is a group-value function. The steps below use objects from the MicroStrategy Tutorial project as an example. The example below shows the basic structure of an ApplySimple statement to create metrics. The MicroStrategy Tutorial project is used to explain how users can customize numbers from "1,000,000" to a "1. 1M type format. ApplySimple where simple (e. Web/Desktop requires making use of a Live Connect dataset (either Data Import - Pick Tables or from Existing Objects). Microstrategy Dossiers With the release of MicroStrategy 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. if both conditions are met, then Red, else Green. 0 and have to resort use applysimple to take advantage of DB's least function instead. 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. 1. ApplySimple("Datediff(YY,#0,getdate())", [BIRTH_DATE]), in which [BIRTH_DATE] is an attribute. The expression editor in MicroStrategy Developer provides an escape sequence to support double-quote marks in a string. x. If you are looking to learn. 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. , the report always contains a clause such as 'WHERE MONTH_ID = 200107', for the current month. x If a user needs to display blocks of 12 months as years by specifying the end month at run time there is a way of doing it by following the steps below: 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. In MicroStrategy Developer, create a dummy metric with the following definition. ApplySimple may be used in one or both sides of a comparison expression. Click OK in all three dialogs (Login, Connection, and Database Instance). Make two grids with different attributes and metrics in each 3. ApplyComparison: where comparison operators (e. Syntax. . Data files can be published as either an In-Memory Cube or a Live Connect Cube. A system external to Intelligence Server is responsible for determining whether the conditions for triggering an event are met. 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. Trending Articles. RE: YTD. 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. Deploy the ojdbc8. 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. A human reader can see from the ApplySimple SQL string that the revenue value will be returned (meaning that the datatype should be Float). The goal is to create an image link that is used to export the grid, like shown below: Document in Edit Mode Follow the steps below: 1. Step 3) Create a report using the 'Region' attribute and the metric created in Step 2. Create a numeric value prompt and name it P1. x. ApplyComparison The ApplyAgg function is used to define simple metrics or facts by using database-specific, group-value functions. Create a metric with the ApplySimple statement below as its definition and name it "Case Metric": ApplySimple ("CASE WHEN #0 <= 2000 THEN #1. 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. Change the DESC form expression to the following. png"). Users need to change the expression accordingly based on the. x, with the Intelligence Server running on Linux,. Select Filter definition prompt -> Choose from an attribute element list as shown below. ApplySimple where simple (e. 2. 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. To create a MicroStrategy Environment connection file . When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Applysimple in Metric; Conditional metric and report filter interactions; Connection Mappings in Microstrategy;. There are five predefined Apply functions, each belonging to a different function type - ApplySimple, ApplyAgg, ApplyOLAP, ApplyComparison, ApplyLogical. Nick. 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. The following example uses MicroStrategy Tutorial to explain the construction of a Year-To-Date metric. For example, ApplySimple ("#0 * #1", [col1], [col2]) indicates that two items, col1 and col2, referenced as #0. CAUSE: This is currently working as designed. Relate tables store information about the relationship between two attributes when one a parent of the other or vice-versa. For information on the syntax used in your specific database, see MicroStrategy and Database Support for Functions and see the section that corresponds. Problem. 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. Click on 'Finish' and save the prompt. The ApplySimple function is used with simple operators and functions. How to use Guacamole to copy and paste text or files in MicroStrategy on AWS; All new Download site is now available!ApplyAgg. Comparison operator prompts can be used in ApplySimple functions with Case statements using the metric, (@nameofprompt(M1, M2)). How to create fact that does not get rounded up when calculated with MicroStrategy Developer 9. 2. The calculation of the difference is based on the number of day boundaries crossed, not the number of twenty-four hours periods elapsed. Relate tables contain the ID columns of two or more attributes, which will define associations between them. The types of arguments determine how the parameter markers inside the pattern are replaced. Syntax. 1 and 10. 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'. Victoria is experiencing low interest rates too. 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. ApplyRelative: where Online Analytical Processing (OLAP) functions (e. ApplySimple("CONVERT(VARCHAR(23), #0, 121)",[Column1] )symbol. Dynamic Sourcing is the technology that allows ad-hoc report, standard reports and OLAP reports to access shared Intelligent Cubes in an automatic way. Select your custom visualization. arithmetic operators) can be used. It is used to define compound metrics via. From the File menu, click Open. Microstrategy - creating a simple percentage column. Save the prompt as "Call Center Prompt". 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. Apply the filter Year=2002 to your report. This allows you to use MicroStrategy's built-in functions in your qualification. A space where we get together to see curiosities, share experiences and pass tips to be the coolest and most knowledgeable consultants. x. For basic information and examples of the ApplySimple function, see the Functions Reference. 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. using Sum (PaidAmt * Attribute Sales Year) works fine, valid expression, but not really what I want. Ragged Hierarchies in Microstrategy. x does not have the inherent functionality to truncate numbers like this, it is possible to do it using the 'ApplySimple' function. 4. 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. To Define a Join Between the Columns of Two Tables. The MicroStrategy SQL Engine 9. 4. Syntax. The prompt "Choose from all elements of 'Category'" is also placed into the report. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. You can use the AppleSimple function to insert database-specific functions and simple operators directly into SQL. Number of Views 2. 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. To provide a reasonable level of generality, the feature is based on a 'pattern and arguments'. mstrc file from an empty text file. The steps to use the JDBC driver to connect to Oracle are as follows: Download the Oracle JDBC thin driver. The prompt may be used in the ApplySimple function, and will be substituted at runtime. If the first date argument is later than the second date argument, the result is a negative number. The ApplySimple statements given above are ORACLE Specific. To create a column alias for a fact. 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. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Click OK in all three dialogs (Login, Connection, and Database Instance). ApplySimple("#0", MaxProfit). MSTR has evolved. x-10. x or you can always use an applysimple to pass the Oracle functions in natively. 00" format. 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 “#n” code in Apply function syntax serves as placeholders for the MicroStrategy objects being passed to your database. 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. Using the ApplySimple function, you can include prompts in your MDX to provide dynamic analysis on your MDX cube data. [MSTR User]. , ApplySimple or ApplyAgg). . Relationship tables in Microstrategy. . The apply functions act as containers for non-standard SQL expressions being passed to the database. mdb and TUTORIAL_METADATA_7200. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Unable to use columns from different tables in a derived attribute in MicroStrategy Developer 9. This condition may be implemented through an ApplySimple statement such as the following: The user will find that the CASE statement works. MicroStrategy will continue to investigate and post updates as soon as they are available. 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. x using an Oracl… Number of Views 6. Right-click on an existing environment and choose Properties. I have a metric that shows sum (Widgets). If instead a “. Presented by MicroStrategyBlog. ApplySimple. KB4275: How to retrieve attribute form expressions using MicroStrategy Intelligence Server SDK. To create an attribute in MicroStrategy with a fixed NUMBER value, follow the steps below:. ApplySimple ("Case When T1. Case. 4. 4) Next, change the Theme back to None and click Apply. Consult the following MicroStrategy Knowledgebase document for more information on Case() and CaseV(). In most cases, these values are not recognized as MicroStrategy objects. For new columns to be available for attribute and fact creation in MicroStrategy Architect, the table structure must be updated. Examples of this category are simple mathematical. x. 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. KB39990: How to use ApplySimple to create attribute form to support sorting configuration in the attribute editor in MicroStrategy Desktop and Web 9. How to calculate data of time date type (HH:MM:SS) in Microsoft SQL Server using MicroStrategy Developer 9. A dataset is a standard MicroStrategy report. If two users with different security filters run the same report, they may get different results. Concat (Concatenate) The Concat function combines two or more input strings into one continuous string and returns the result. 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. In this brief video tutorial, Doug Terbush from our Customer Education team describes the use of the Case function, along with examples of using this functio. 4. UnderstandingFunctionsinMicroStrategy 5 TheBasicsofMicroStrategyObjects,ObjectDefinitions,andFunctions 6 FunctionSyntaxandFormulaComponents 9You have 2 options. An inner join is created and a line representing the join appears in the Query Builder pane, running. The script inside the " " always depends on the type of database used and can vary from one database. x adn 10. of distributed under each attribute element. Dynamic date qualifications are not supported against MDX cube data sources, but the same results can be achieved by using custom MDX expressions. Returns the current date as provided by the database timer. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. This is the format that will be used to convert string1 to a date. I can't remember if the strings have to be enclosed in single or quote quotes. x pass-through function, in this case the ApplySimple function. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. If all conditions are false, a default value is returned. x, with the Intelligence Server running on Linux, the. Consolidations and custom groups are two special reporting features that enable user to surpass basic reporting functionality. g. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. KB439226: How to create a filtered metric using a case statement in Visual Insight in MicroStrategy Web 10. This function does not take input variables. In MicroStrategy SQL Generation Engine, security filters prevent users from seeing certain data in the database. Create New Metric in a report or VI. Syntax. Number of Views 1. Custom groups; A custom group is a special filter that can be placed on a template and is. Some customers may need to use the Oracle provided JDBC in lieu of MicroStrategy shipped ODBC driver to connect to Oracle database. 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. KB7127: Case and CaseV functions in the MicroStrategy Analytical Engine . Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformKB3905: How to use pass-through expression- ApplySimple in MicroStrategy SQL Generation Engine. "mahendra_patel via microstrategy-l" 07/07/2006 11:19 Favor responder a microstrategy-l@Groups. 7x are listed below. 2. x use the Day attribute to qualify on a particular date. The ApplyAgg function is used with Basic functions such as Sum and Max. Example 1 Using an attribute ApplySimple is a function that allows users to send direct input to the warehouse without any assumption or special handling of what is inside the custom SQL by MicroStrategy. 3 – Enter the desired. Thus directly using NULL in formula will fail. CurrentDate() For information on whether your database supports various date and time functions, see MicroStrategy and Database Support for Functions. The following steps can be used to concatenate two attribute forms. Microstrategy Dossiers With the release of MicroStrategy 10. The function removes the fractional part of a real number so that only the integer part remains. It should work. using Sum (PaidAmt * Attribute Sales Year) works fine, valid expression, but not really what I want. Motivation: Customers can bring in data as a cache so they can save on costs using Snowflake. For Oracle 12. By contrast, IF() allows database side conditional functions to be leveraged without using ApplySimple() or ApplyAgg() functions. , ApplySimple or ApplyAgg). KB419483: How to create a comparison operator prompt and use it in an applysimple function in MicroStrategy Developer. For basic information and examples of the ApplySimple function, see the Functions Reference. Count(ApplySimple("Case when #0 <> 0 then #1 else Null end", Column2, Column1)) {~ } Note: Notice that the ELSE statement is using 0 or Null based on the metric functions, such as Sum or Count. 94K. In Microstrategy I am trying to create a new fact that returns a specific name depending on the type of text contained in the field NAME. To provide a reasonable level of generality, the feature is based on a 'pattern and arguments' scheme. Open up the same document in MicroStrategy Web 10.