In MicroStrategy Developer, create a dummy metric with the following definition. This is a single-value function. mstrc) Open Workstation. Sum <Distinct, FactID, UseLookupForAttributes>(Argument)Where: Argument is an attribute, fact, or metric representing a list of numbers. 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. mstrc”. Use ApplySimple in MicroStrategy. 00" format. A user may want to create an attribute with an alternating expression depending on a certain condition, a conditional attribute. x-10. This issue applies also to MDX passthrough formulas defined by enclosing the formula in quote marks (without the ApplySimple keyword). name = "HFilter" Dim objSearch As. Personally, I would use ApplySimple and let the database handle the work. cc Assunto [microstrategy-l] ApplySimple function in MSTR 7. 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. Syntax ApplySimple () Accepts facts, attributes, and metrics as input. The Attribute Editor opens three dialog boxes, if the cascading dialog box option is enabled in the Developer Preference (as it is by default). The steps below use objects from the MicroStrategy Tutorial project as an example. This function evaluates multiple expressions until a condition is determined to be true, then returns a corresponding value. Microstrategy Dossiers With the release of MicroStrategy 10. 1M type format. MicroStrategy does not currently support element prompts inside of metric definitions. A suspicious death, an upscale spiritual retreat, and a quartet of suspects with a motive for murder. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a. Using the ApplySimple function, you can include prompts in your MDX to provide dynamic analysis on your MDX cube data. Create the first derived attribute DA1, which is going to be used as the child attribute: 3. Fu nction Types. It is suggested to use quotes to get exact phrase when there is a space between. g. Syntax. , metrics or attributes) containing a particular function or operator (e. 4. The prompt "Choose from all elements of 'Category'" is also placed into the report. 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. Applysimple in Metric; Conditional metric and report filter interactions; Connection Mappings in Microstrategy;. x. 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. By contrast, IF() allows database side conditional functions to be leveraged without using ApplySimple() or ApplyAgg() functions. ApplySimple (“Case when [Field Header Name]='CONDITION1’ then 'condition1 example' end”,String1) What I've found online is a little misleading and wondering if anyone can assist. 18K KB8426: How to create a metric with an ApplySimple statement which will choose different metrics for calculation based on. I originally cut and pasted the syntax from SQL+ into the attribute statement and tweaked it. Sum is a group-value function. 1K. This is the format that will be used to convert string1 to a date. Drag the column from the first table onto the column from the second table. In ApplyComparison, the custom SQL syntax enclosed in quotation marks represents the entire condition; thus there is no need to compare the result of ApplyComparison to anything. Subscriptions and tasks that are based on event-triggered schedules execute when a MicroStrategy event is triggered. It should work. 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. 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. 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. Relate tables store information about the relationship between two attributes when one a parent of the other or vice-versa. From the Database connection type drop-down, choose Snowflake. , ApplySimple or ApplyAgg). This article explains how to model recursive hierarchies in MicroStrategy. Microstrategy Dossiers With the release of MicroStrategy 10. this column in ApplySimple statement. The index for referencing these objects begins with 0 and increases by. 1 and 10. 1 and 10. BC OnLine Partnership Office E161, 4000 Seymour Place PO Box 9412, Stn Prov Govt Victoria, BC V8W 9V1A simple application of this technique is to use a constant value prompt in your project as a multiplier of metric data: ApplySimple (" ( [Measures]. [Total Sales] / #0)" ,?valueprompt). This means that an attribute. MSTR has evolved. 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". Here is the workaround to achieve the attribute left outer join on MicroStrategy Web. snowflakecomputing. 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. In Microstrategy Developer, create a new attribute by navigating to File > New > Attribute. KB3905: How to use pass-through expression- ApplySimple in MicroStrategy SQL Generation Engine. 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. 이 작업은 ApplySimple() 와 ApplyAgg() 함수를 팩트와 메트릭 정의에 활요함으로서 이루어질 수 있습니다. mstrc, please open a Notepad or Notepad++. For example, concatenating the two strings "Micro" and "Strategy" would result in the single string "MicroStrategy". 4. ; Distinct is a TRUE/FALSE parameter that allows you to. ApplySimple. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . Number of Views 49. Examples of this category are simple mathematical. This issue can be solved in two steps using a MicroStrategy 10. 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. Microstrategy Dossiers With the release of MicroStrategy 10. Select your custom visualization. KB419483: How to create a comparison operator prompt and use it in an applysimple function in MicroStrategy Developer. Navigate to the Layout Tab. 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. Details: MicroStrategy supports both Azure AD and Okta Authentication with Snowflake. The steps to use the JDBC driver to connect to Oracle are as follows: Download the Oracle JDBC thin driver. 4. double quotes around it, substitute the column names with #0 . This article covers how to use passthrough expressions to write custom SQL inside of MicroStrategy. These functions are not supported by the Analytical Engine, so they must be calculated by the database. Dynamic Sourcing is the technology that allows ad-hoc report, standard reports and OLAP reports to access shared Intelligent Cubes in an automatic way. &[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. By contrast, IF() allows database side conditional functions to be leveraged without using ApplySimple() or ApplyAgg() functions. x that require single quotes in the definition. Using this function and given the format in which the column is stored in the MicroStrategy Tutorial (Vmall) warehouse (integer, YYYYMM), the formula will extract the year from the date prompt, multiply it by 100 and add the day number to it, giving it the desired format. Below is a screenshot of the results received with the above ApplySimple metric: Create a new metric and use an ApplySimple statement in the metric definition that will bring back the current. arithmetic operators) can be used. It is used to define compound metrics via. Used MicroStrategy functions such as ApplySimple, ApplyComparision in the metric calculations and used in different reports. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Refer to MicroStrategy Knowledge Base document KB5700-007-0107 for more. 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. x. In other words, ApplySimple("(#0 - #1) / 7", ?, ?) will fail as shown in the example below. 6. How to use Guacamole to copy and paste text or files in MicroStrategy on AWS; All new Download site is now available!ApplyAgg. The 'Choose a Prompt Style' dialog box opens. The ApplySimple function is used with simple operators and functions. Create a new Intelligent Cube C01 using Existing objects: Catalog, Customer City, Customer Gender 3. MyDate,sysdate,#0,#1)",Fact1,Fact2) OR. If all conditions are false, a default value is returned. This means that every metric is evaluated in separate SQL passes. Select the DSN. 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. Below is what I tried but it did not work. 11K KB3905: How to use pass-through expression- ApplySimple in MicroStrategy SQL Generation Engine ApplyComparison. But since the length of the month ranges between 28-31 days it. ')"; [Net Weight. Try to create the metric this way: Sum (PaidAmt * Attribute Sales Year). I have a problem and can't understand how create metrics. From the Database connection type drop-down, choose Snowflake. 1 million 1. While MicroStrategy Developer 9. KB7127: Case and CaseV functions in the MicroStrategy Analytical Engine . 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. 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. 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. UnderstandingFunctionsinMicroStrategy 5 TheBasicsofMicroStrategyObjects,ObjectDefinitions,andFunctions 6 FunctionSyntaxandFormulaComponents 9You have 2 options. The types of arguments determine how the parameter markers inside the pattern are replaced. Now, if I create an attribute on the DESC itself, I do get a unique list of values to be shown in the prompt , but, the report results get messed up. How to create a MicroStrategy connection file (. Microstrategy Dossiers With the release of MicroStrategy 10. For information on the syntax used in your specific database, refer to the MicroStrategy Functions Reference. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Comparison operator prompts can be used in ApplySimple functions with Case statements using the metric, (@nameofprompt(M1, M2)). Explanation. , ApplySimple or ApplyAgg). Applysimple in Metric; Conditional metric and report filter interactions; Connection Mappings in Microstrategy;. Follow the steps below to create a list of all groups and the users in each group: In MicroStrategy Developer 9. Example 3: ApplySimple ApplySimple ("Datediff (YY,#0,getdate ())", [BIRTH_DATE]) The attribute form, Age, can be defined by using the single-value function, ApplySimple. 1. This function relies on the Analytical Engine for processing, rather than the database. ApplyRelative: where. In MicroStrategy, there is currently no formatting options available to display datetime format forms with millisecond values. : ApplySimple ("Decode (T1. x and 10. If the first date argument is later than the second date argument, the result is a negative number. This allows you to use MicroStrategy's built-in functions in your qualification. Loading × Sorry to interruptKB42225: How to create a distinct count subtotal from base report in MicroStrategy Web Number of Views 6. Select only Configuration Objects for documentation. The following grid shows the metrics mapped to the time date type column are calculated in the derived metric and subtotal. 1. Then I ask how to compared two metric based on ApplySimple in Report limit. Examples of this category are simple mathematical. Applysimple in Metric; Conditional metric and report filter interactions; Connection Mappings in Microstrategy;. Specify the desired delivery options including recipient address, subscription name. 2 Can anyone tell me how to create a Filter using Applysimple in Microstrategy 7. In short, some attribute elements don't have a relationship with their parent/child attribute. Returns the difference in days between two given dates as an integer value. Applysimple in Metric; Conditional metric and report filter interactions; Connection Mappings in Microstrategy;. You can use the AppleSimple function to insert database-specific functions and simple operators directly into SQL. 2. Phoenixier. But, it will calculate at the lowest Data level if that is your intention. x. December 07, 2018. You can use the MicroStrategy CASE function, available in MicroStrategy Developer (Schema ObjectsFunctions and OperatorsFunctionsInternal Functions), to retrieve desired result sets. In MicroStrategy, there are two settings that users can access to control Outer Join behavior : Formula Join Type and Metric Join Type . Number of Views 49. To create a MicroStrategy Environment connection file . The ApplySimple function is used with simple operators and functions. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. RE: DateTime to Month formatConcat (Concatenate) The Concat function combines two or more input strings into one continuous string and returns the result. x use the Day attribute to qualify on a particular date. This technical article outlines the steps to create rolling time attributes in MicroStrategy Developer 9. Open up the same document in MicroStrategy Web 10. 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. The prompt may be used in the ApplySimple function, and will be substituted at runtime. MicroStrategy, Inc. The result does not. 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. ApplySimple("CASE WHEN #0=1 THEN #1 ELSE NULL END", , ). MyDate =. This is a comparison function. x, with the Intelligence Server running on Linux, the image in the exported PDF. 4. Trending Articles. A derived expression can only use single-value functions, and arguments that are used in the expression are columns. Select any project that is in the project source that contains the users and groups and click Next. 3. However, the ApplySimple statement is running a database-specific function(s), and with this example, changing the data type from Datetime to Char. ApplySimple("CONVERT(VARCHAR(23), #0, 121)",[Column1] )symbol. 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. Subscribed reports or documents for each. 2 release, the driver file is called odbc8. 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. The recommended VLDB optimizations for Hive 0. HTCMS (Programmer) (OP) 19 Feb 04 20:41. However, by taking advantage of the ApplySimple expression, the attribute sorting can get applied correctly in Microstrategy Desktop and Web 9. Syntax ApplySimple () Accepts facts, attributes, and metrics as input. using Sum (PaidAmt * Attribute Sales Year) works fine, valid expression, but not really what I want. This article describes a behavior observed when adding a new attribute form expression with Workstation, if the ApplySimple function is used. KB419483: How to create a comparison operator prompt and use it in an applysimple function in MicroStrategy Developer Number of Views 1. ApplyComparison The ApplyAgg function is used to define simple metrics or facts by using database-specific, group-value functions. I can't remember if the strings have to be enclosed in single or quote quotes. 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. Select any project that is in the project source that contains the users and groups and click Next. This can be accomplished using a combination of ApplySimple() and ApplyAgg() functions at the Fact and Metric definitions, respectively. Change the DESC form expression to the following. 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. MicroStrategy Technical Support does not provide customized MDX queries. In this table, the PARENT_ID column logically points to another row in the same table (ID column). If two users with different security filters run the same report, they may get different results. Users want to create a filter that always filters on this month, i. i'm trying to use the ApplySimple function in order to define a Metric in MicroStratey. . Our solutions work to guide towards best practices and provide guidance to the user community. CAUSE: This is currently working as designed. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. x and higher. MicroStrategy recommends to have only one child at the lowest level. MSTR has evolved. 4. Users need to change the expression accordingly based on the. . The following example is created within the MicroStrategy Tutorial project, specifically using the ORDER_DETAIL and ORDER_FACT tables. 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. Splitting the fraction: Numerator: Sum (VOL) {~} Denominator: Max ( ApplySimple ("replace (#0, ',', '. For example: • 1/ Attribute [Net Weight] = 0,5 (type of data is. Consolidations allow users to group attribute elements in new ways without changing the metadata and warehouse definitions. 1 and 10. Concat is often used to combine related values, such as a first and last name. if both conditions are met, then Red, else Green. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a. . 1. Returns the current date as provided by the database timer. ", Arg1, Arg2). e. Add the metric to a simple report and execute. When using the DateDiff function in MicroStrategy Web, you will need to replace the Day@ID attribute in the function definition. Maybe the Names (DESC) can be repeated but the ID should be distinct. Microstrategy Dossiers With the release of MicroStrategy 10. Insert an HTML container (and not an image) and insert the script below. Number of Views 48. x . solutions Forum; YTD transformation. 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. 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. x report for a specific attribute using an ApplySimple statement as one of its forms. MicroStrategy Web provides a wide range of parameters that can be used in combination to achieve different types of requests. The syntax used in ApplySimple is incorrect for SQL Server 2012 database. 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. MSTR has evolved. CONTENTS 1. Create a numeric value prompt and name it P1. Use the datetime format defined on warehouse database side in the ApplySimple statement. 1 and 10. 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. Microstrategy Dossiers With the release of MicroStrategy 10. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. In the sample cube here, the native IDs from the cube does contain the login: [MSTR User]. Microstrategy Dossiers With the release of MicroStrategy 10. 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. Using the ApplySimple function, you can include prompts in your MDX to provide dynamic analysis on your MDX cube data. . UnderstandingFunctionsinMicroStrategy 5 TheBasicsofMicroStrategyObjects,ObjectDefinitions,andFunctions 6 FunctionSyntaxandFormulaComponents 9 You have 2 options. 35K. How to embed horizontal bar graphs into a column of a grid in Report Service Document in MicroStrategy Developer 9. g. The three dialog boxes are New Attribute, Create New Attribute Form, and Create New Attribute Form Expression. 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. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformEvents and Event-Triggered Schedules. Thanks. x-10. 4. Whatever the final sql is (1) take the final sql, (2) Wrap. Syntax. xApplySimple("year(date(#0) - 2 MONTHS)*100+month(date(#0) - 2 MONTHS)",CustomAttriubte@ID). This condition may be implemented through an ApplySimple statement such as the following: The user will find that the CASE. Example 1 Using an attribute The ApplySimple and ApplyComparison functions are useful in the Advanced Qualification Editor. The “ #n” code in Apply function syntax serves as placeholders for the MicroStrategy objects being passed to your database. Use the datetime format defined on warehouse database side in the ApplySimple statement. to MicroStrategy Experts. 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. 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. ApplySimple("Datediff(YY,#0,getdate())", [BIRTH_DATE]) The attribute form, Age, can be defined by using the single-value function, ApplySimple. The ApplyComparison function is used with comparison operators such as >, Like, and In. 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. Microstrategy Dashboard performance improvements steps: Many times, causes of poor performance can be simplified to specific components. Ragged Hierarchies in Microstrategy. In MicroStrategy SQL Generation Engine, it is not possible to use element list prompts in database passthrough functions, using the default syntax, such as ApplySimple, ApplyComparison and ApplyAgg. format_mask is optional. When using the DateDiff function in MicroStrategy Web, you will need to replace the Day@ID attribute in the function definition. ApplySimple (" 'Text goes. In MicroStrategy Web, edit or execute a report. The script inside the " " always depends on the type of database used and can vary from one database. x-10. For this example, assume we have a order_fact table has two dates, order_date and ship_date and an. I can't remember if the strings have to be enclosed in single or quote quotes. Contact MicroStrategy Technical Support for an update on the status of this request. 4. Nick. KB20306: How to create dynamic date based on 'Last Month' in MicroStrategy SQL Generation Engine 9. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. The MicroStrategy SQL Engine will join database tables together based on the lowest level attributes that MicroStrategy Architect assigns to each table. The expression editor in MicroStrategy Developer provides an escape sequence to support double-quote marks in a string. Phoenixier. The prompt "Choose from all elements of 'Category'" is also placed into the report. g. Using these functions, SQLs generated by MicroStrategy will call UDF just like any other function provided by Teradata. For basic information and examples of the ApplySimple function, see the Functions Reference. Relate tables are often used to create relationships between attributes. The Microstrategy installation will create 3 Microsite Access databases in your local directory (C:Program Files (x86)MicroStrategyTutorial ReportingTUTORIAL_DATA_7200. RE: YTD. for each successive object passed. x with any number of attributes. Microstrategy Dossiers With the release of MicroStrategy 10. Used Enterprise manager to create reports on the project usage and report usages. This technical article outlines the steps to create rolling time attributes in MicroStrategy Developer 9. 2 – In the Form Expression window, select a Source table, in this case I am using the calendar dimension (LU_DAY). Case. In the right corner of the dashboard, change the. 4. x-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. 21K. g. Recommended VLDB Properties for use of MicroStrategy 9 with Hive 0. 4. Concat is often used to combine related values, such as a first and last name. MicroStrategy is a commercial off-the-shelve tool that automates the generation of Snowflake SQL queries through a semantic layer in datasets design. There's a reason we're at the top of the list. A space where we get together to see curiosities, share experiences and pass tips to be the coolest and most knowledgeable consultants. The Dynamic Dates in MicroStrategy SQL Generation Engine 9. Trending Articles. For information on the syntax used in your specific database, refer to the MicroStrategy Functions Reference. Create a report with the custom group and. MicroStrategy parser doesnt recognize NULL as a key word for null value. A system external to Intelligence Server is responsible for determining whether the conditions for triggering an event are met. 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. x. Whenever users submit an element browse request or a report. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. These values are set by default when the "Hive 0. Look the SQL code generated for the report, take the alias. The ability to define object relationships and then allow MicroStrategy to generate all of the appropriate SQL as you manipulate and drill is the core of the product. To create a column alias for a fact. Sum, Max, etc) can be used. ) are used. Case can be used for categorizing data based on multiple conditions. com Para jpviva. By default, all of the columns used in an expression must originate from the same table. 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. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformKB3905: How to use pass-through expression- ApplySimple in MicroStrategy SQL Generation Engine.