To extend this flexibility to you, MicroStrategy offers 5 functions which allow you to directly supply the SQL you want for a specific piece of the Query: ApplySimple, ApplyAgg, ApplyComparison, ApplyOLAP and ApplyLogical. 2. From: sukumar123 via microstrategy-l [mailto:microstrategy-l@groups. 4. With an OLAP Services license, user can perform additional OLAP analysis, using the following features: Displaying data on the fly: dynamic aggregation, page. x, select 'Project Documentation' from the Tools menu to start the wizard. These two software solutions offer almost similar features. Now when both the prompts are answered,the above subquery is generated by the Microstrategy . . x . 1. 5. this allows users to perform the in-depth analysis of their data and get the valuable results from their data. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories. ApplyComparison ("Upper (#0) like. I've looked at % column settings in other % metrics in our. A badge icon appears on the item to indicate that it is certified. 3. From the Select a Project drop-down list, select the project for which to assign the security role. Back to the Report. The following examples illustrate the URL parameter reportviewmode and the corresponding view of the report that will display: When reportviewmode is set to 1, the report is displayed in grid mode: When. x. The Filter Options dialog box opens. Drag an attribute from the object browser into the text box next to the qualification type or enter the attribute name and its form according to the following format: attribute_name@form_name. The Report SQL indicates that the filter has not been applied. Using OLAP Services, create a metric that is the SUM of a fact. System Manager workflow can execute on a schedule or after an event has been triggered. The apply () function is the most basic of all collection. This is a single-value function. Using Prompts and ApplySimple Statements. Syntax. The number of partitions should typically be between the minimum and maximum, and closer to half the number of logical cores. 2) Create Metric2 as the RunningSum of Metric1. Choose attribute Call Center and use the Region Filter created in the previous step. Returns TRUE if value is not NULL; otherwise returns FALSE. There's a reason we're at the top of the list. The ApplyAgg function is used to define simple metrics or facts by using database-specific, group-value functions. In order to export a document in excel format using the URL API, the executionMode must be set to 4. 5% of users said that the platform is easy to use, with a user-friendly drag. 3. 4. A bubble chart (aka bubble plot) is an extension of the scatter plot used to look at relationships between three numeric variables. How to create a dynamic custom group to display a set of date ranges in Microstrategy Developer. There's a reason we're at the top of the list. 2. It has a simple menu to import data for analysis and export the result of analysis. 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. Example: Customer City = Call Center Using ApplyComparisonAn object is a basic building block in MicroStrategy. Follow the steps below to access the Project Comparison Wizard: From the Start menu -> Programs -> MicroStrategy -> Administrator -> Object Manager. Select only Configuration Objects for documentation. To determine how MicroStrategy hides null and zero metric values in the grid, on the General tab, select the Hide Null/Zero Toggle Behavior. MicroStrategy strongly advises against using Apply functions when standard MicroStrategy functions can be used to achieve the same goal, because using RDBMS functions effectively bypasses the validations and other benefits of MicroStrategy products. For example: ApplyComparison ("#0>#1", Store@ID, Month@ID) You can use the ApplyComparison function to define custom filters. com] Sent: Friday, July 18, 2008 10:26 AM To: Karan, Divya Subject: RE:[microstrategy-l] How to create a case sensitive value prompted filter in MSTR Posted by sukumar123 on 07/18/2008 11:29:00 AM I am using DB2. Create another dynamic date filter 'OBJ2 - Last Month' Create a Metric 'OBJ3 - Max Day No Filter' that returns the day value in a metric for a given day. This week I bring a very useful functionality in MicroStrategy: Pass-through functionalities, which allow us to add by hand a query (or, rather, part of the query) to give a little more flexibility to the query. MSTR will assign a weight based on the level of the attribute in the hierarchy. General hardware recommendations. For filters, the ApplyComparison and ApplySimple functions are most useful, although you can also use Apply functions to create metrics and prompts. 5. 1 and 10. The example below shows the basic structure of an ApplySimple statement to create metrics. Labels: #Recursive hierarchies microstrategy #Recursive Hierarchy. The overall sort order is evaluated and stored in the attribute definition when the attribute is saved. If all conditions are false, a default value is returned. To create Attribute/Fact definition or simple passthrough expression - use ApplySimple. Creating metrics on-the-fly: derived metrics, Defining attribute elements on-the-fly: derived elements, Filtering data on the fly: view filters and metric filters, Importing data as an. x, select 'Project Documentation' from the Tools menu to. Object prompts can be created using. 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. The examples below use the Lag function. x . A security filter can be assigned to a user or group to narrow the result set when they execute reports or browse elements. Case. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. After that only thing you have to do is to press finish button. From the Tools menu, select Document Properties. The screen shot below shows the F1 filter which returns the dates between the first date prompt minus the number of different days between the two date prompts. Drag and drop the . ApplyComparison is used to define a filter by populating the WHERE clause in the. Plus, it connects business apps while integrating data. Depending on your MicroStrategy product and licensing, this function may not be available. Using the "Month" attribute as an example, follow the steps below to create a dynamic filter in the Microstrategy Tutorial project: Create a filter from Developer and select "Add an advanced qualification", as shown below: Select "Custom expression" under "option" drop-down list, as shown below:Filter Reports using SQL with ApplyComparison and ApplySimple. Select only Configuration Objects for documentation. 4. Click Filter Options. EXAMPLE. The script inside the " " always depends on the type of database used and can. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Choose the Light Theme from the drop down menu and click the Apply button. 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. Create three filters (F1, F2, F3) using Applycomparison statements. Apart from using the VLDB properties to create the left outer join, article describes how to use the Logical View to specify an outer join between two attribute lookup tables when only attributes are on a report. The Grouping panel is displayed. The Intelligence Server won't enforce the "Use Freeform SQL Editor" privilege for the end-users who are using ApplyX functions in these projects, and will enforce the privilege for all other projects. In the User Manager, grant the 'User report filter editor' privilege to the user facing this issue. A dataset is a standard MicroStrategy report. Create a report R1 with Month, Revenue and filter which contains the first 6 months in 2008. Starting in MicroStrategy 10. Use the individual editors inside Developer to create and edit various model objects. Then use this report in a filter along with the advanced qualification which says'ApplyComparison ("#0 in (select distinct fiscal_mo_nbr from days where day_dt=trunc(sysdate-1))", [Fisc Mth Nbr]@ID)'. For example, while the Lag function can. Apply conversely Pass-through functions in Microstrategy. Number of Views 3. Use the limit comparison test to determine whether the series ∑ ∞ n = 1 5n 3n + 2 converges or diverges. Apply functions: These functions provide access to functions and syntactic constructs that are not standard in MicroStrategy but are offered by various relational database. Cross-tab stage. All the existing visual Insights dashboards will be converted to Dossiers. All the existing visual Insights dashboards will be converted to Dossiers With MicroStrategy 10. CONTENTS 1. Some key things to understand when making these formulas. 4 and later. Use the MicroStrategy built-in apply (pass-through) functions; Freeform SQL; Apply (pass-through) functions. All attributes used to group data in the report or document are shown in the Available Attributes list. Prior to MicroStrategy 9. MicroStrategy OLAP Services allows view filters, which are a filter that can be applied by the user dynamically after the report has been executed and displayed. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. For example: ApplyComparison ("#0>#1", Store@ID, Month@ID)You can use the ApplyComparison function to define custom filters. In this article, we raised two workarounds to help. Open the dossier you want to modify. 5. , in search results, to enrich docs, and more. About Us. Below is what I tried but it did not work. Example: Customer City = Call Center Using ApplyComparison You can use the AppleSimple function to insert database-specific functions and simple operators directly into SQL. ApplyComparison is commonly used to create custom filters. id where #1 and #2)", [Date]@Id,? [GTN],? [BTN]) Both the GTN amd BTN are optional prompts. Select. In Step 1, choose a Project Source from the drop down list, and enter a Login and a Passwordthat have administrative privileges to the metadata. x using the ApplyLogic function, as illustrated below. In order to exclude the values, create another filter expression which will always be TRUE and. x SQL Engine is ignoring the conditionality at the report level because a metric in the report also contains a related conditionality which has been set to "remove related report filter elements" or "ignore" the filtering criteria at. The ApplyComparison function is used with RDBMS comparison operators such as >, like, and In. Create a tie-breaker / unique-ranking metric using the [running count] analytical function: Right-click on the RunningCount function name and choose 'parameters': Set the sorting order to be [UNIT PRICE] and [UNIT COST]. MicroStrategy - Metric Comparison. 2. If you want to use a data range in your filter, select Between. Select Show advanced qualification. MSTR has evolved dashboards to the point that. Restricting access to data: Security filters. To use # as a character rather than a placeholder, use four # characters in a row. 4. A icon appears in the upper left corner of the source visualization. ) The above example used an Apply function, ApplySimple. Filter Reports using SQL with ApplyComparison and ApplySimple. The ApplyComparison function is used with comparison operators such as >, Like, and In. Number of Views 16. If excutionMode is not provided in the URL, by default PDF will be used as executionMode. The ApplyComparison function allows users to bypass the MicroStrategy SQL parser and create an expression where comparison operators (e. (The use of brackets around compound object names is standard for many objects in MicroStrategy and is not restricted to custom expressions and Apply functions. Set up the Enterprise Manager. This is a. For more details, click the link corresponding to each function. When used inside a string comparison statement they are a. ApplyComparison With system prompts, it is possible to use database security tables to build MicroStrategy security mechanisms. Filename. But if i answer only one prompt and leave the other one answered,the. Some of the main features offered by MicroStrategy are Advanced Analytics, Data Discovery, Data Visualisation, Embedded BI, and detailed reports and statements. The following example shows the steps to create the report above: Create an attribute mapped to key2 column on Table_2. Example. The multiple columns are joined with other attributes, typically in a many-to-many relationship. Joint child relationships are really another type of many-to-many relationship where one attribute has a many-to-many relationship to two otherwise unrelated attributes. Select Filter definition prompt -> Choose from an attribute element list as shown below. Double click on your Report Filter and you’ll now have the option to add an Advanced Qualification: You can then provide the code for the ApplyComparison. The elements of a metric level are described below: •. MicroStrategy is a strong contender in the enterprise BI market that its customers praise for a multitude of reasons: its robust drag-and-drop reporting tool, strong data visualizations and dashboards and accessibility through web and mobile apps. How to use the pass-through expression ApplyComparison in MicroStrategy SQL Generation Engine. Drive revenue growth with memorable app workflows and AI features that really speak to the user. With advanced qualifications enabled, double-clicking on the last line in the filter editor or report filter panel reveals the radio button to add an advanced qualification to the filter. The examples shown below were created in the MicroStrategy Tutorial project. Open MicroStrategy Developer. Click Save and Update Schema. com) KB6178: How to use the pass-through expression ApplyComparison in MicroStrategy SQL Generation Engine. This function evaluates multiple expressions until a condition is determined to be true, then returns a corresponding value. In the MicroStrategy Developer File menu, point to New > Filter. x-10. ApplySimple ("case when #0 contains 'As Is' then 'As Is' when contains 'New' then 'New' ELSE 'Other' END", [NAME]) case. Open a project source in MicroStrategy Object Manager. To create a compound key, users must create multiple attribute forms, group them together and set the form group as the key for the. This method exists as attribute only outer joins will not be generated on their own by the MicroStrategy SQL engine. It leverages data connectivity, machine learning and mobile access to offer users comprehensive control over their insights. This technical note describes how to use a custom expression to filter on previous months dynamically in MicroStrategy Developer 9. 1 and 10. 0. ApplyComparison. From the Project menu, select Compare Projects. 3. Note: To avoid user permission conflicts, the following steps must be performed with highest privileges. Level: Set grouping to "Beginning Fact" for your date attribute. key1 + '%')",Key2@ID) Published: Apr 12, 2017. ) The above example used an Apply function, ApplySimple. Save the prompt as "Call Center Prompt". x. Dossiers can be created by using the new Desktop product or Workstation or simply from the Web interface which replaces Visual Insights. To support including attribute information in the metric expression, in the Definition area, type Max () to use the Max aggregation function. To make Apply functions, to must have the Use FreeForm SQL Publications privilege. Example include ApplySimple, ApplyComparison, etc. Item = 3/4 * 10 = 7. Example 1 Using an attribute Wildcards are special characters which when used in a string comparison such as "like" change its behavior. 1. This is a comparison function. See the syntax below forward can. How to create a MicroStrategy connection file (. They may be compared in either 2-tier or 3-tier. Right-click the dossier you want to certify. Case can be used for categorizing data based on multiple conditions. Create a new filter in MicroStrategy Developer; Choose the 'Add an advanced qualification' option and click on the 'OK' button. SecurityRegion table defines from which region a user is allowed to view data. If the attriubte name has spaces, use the '' symbols to group the name. Therefore, users must use the ApplyComparison function to ignore the SQL parser as shown below: NOTE: KB5700-007-0107 describes the ApplyComparison function in detail as well as other functions that bypass. The filtering setting for a level metric governs the relationship between the report filter and the calculation of the metric. ApplyComparison("#0 not like '-%'"; [InductLine]@ID). Follow the simple steps below to create a datamart report: 1. --- mahuamitra via microstrategy-l wrote: > > Thanks for the quick reply. To resolve this issue, follow the steps below: Log into the project source as a user with System Administrator privileges. While each Apply function has its own syntax, the Apply functions share several syntactic features: The "#n" code in Apply function syntax serves as placeholders for the MicroStrategy objects being passed to your database. . Query Stage: Retrieve data from the warehouse. Syntax Common to Apply Functions. In MicroStrategy 2021 Update 5, in order to achieve better performance, for selected Gateways, the SQL Engine will push down the case function to calculate in the databases. Click the “Burst. This is a single-value function. Joint child relationships are really another type of many-to-many relationship where one attribute has a many-to-many relationship to two otherwise unrelated attributes. There are two symbols which can be used interchangeably and are recognized by MicroStrategy as wildcards, * and %. Overall, more than 87. Most data on a document is from one or more underlying datasets. Using the ApplySimple function, you can include prompts in your MDX to provide dynamic analysis on your MDX cube data. Help your customers get more out of the app experience with an engaging AI assistant that provides automatic answers or outputs in real time. If you’re a Power BI user, you’ll be pretty much at home with MicroStrategy since both use similar analytics tools and share a common semantic layer. Save the filter as "Region Filter". The report execution is typically a 3 step process process of the below: Query Stage. Subscribe to MicroStrategy. Example: Customer City = Call Center Using ApplyComparison Set the qualification type to 'Custom'. 9, there was an active focus on making it easier to build dashboards for the widest audience of end users. The filter on this will be "where <> '-' " and there is no need to use. Project and schema locking prevent multiple users sessions. If you are editing the Case function, use the values in step 8. Blocklist of project. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Cards can be consumed in a web browser via the MicroStrategy HyperIntelligence Chrome extension and on iOS devices via the MicroStrategy. I've been all over Microstrategy community and have tried possible solutions/formatting etc. 2. Although transformations can be applied to any attribute hierarchy, the Time hierarchy is used most often. There are two symbols which can be used interchangeably and are recognized by MicroStrategy as wildcards, * and %. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. To configure:-. Below tuning suggestion is based on IBM Document on Performance Tuning. Drag an attribute from the Datasets panel to the Rows area of the Editor panel to add attributes to the rows. The ID is distinct. Simple drag-and-drop tools are paired with intuitive visualizations. 2. The user should enter two double-quote marks in succession, as shown. Connect to a database instance and drags tables into the canvas. Explanation. The issues with many-to-many relationships, including loss of analytical capability and multiple counting, also apply to many-to-many joint child relationships. There is no functional difference between the two symbols. Applycomparison advancd filter with a select state. But, DESC has repeating values. x and newer Loading × Sorry to interruptIn 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. Specify whether to compare all objects or just objects in a specific folder, and what types of objects to compare. Depending on your MicroStrategy product and licensing. For instance, it could be possible to pass in parameters to MicroStrategy Web to dynamically effect what a user has access to at that timeWhen exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. HTML Image as a Button That Exports a Grid on a Document to Excel in MicroStrategy 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 MicroStrategy SQL Generation Engine uses the COALESCE function to ensure correctness and consistency in full outer join results. Adding an existing D3 Visualization;. 7K KB6178: How to use the pass-through expression ApplyComparison in MicroStrategy SQL Generation Engine2. 04K. Details of Document Execution Request, introduce the Performance Troubleshooting Cycle, and present links to other resources with detailed steps for troubleshooting specific components that may affect performance. The template looks like the following: In this sample workflow, you want to return the newly created filter and its. Apply the custom expression filter as shown in the image below: ApplyComparison ("exists (select 'a' from Table_1 a2 where #0 like '%' + a2. You can use DateDiff to create a metric or attribute form that lists the length of time between two dates. AMPERE blog on Microstrategy development and issues faced during development, deployment and maintenance. Open a new or existing dossier. Follow the steps below: Right-click on the project and select 'Project Configuration. Example: Customer City = Call Center Using ApplyComparison An object is a basic building block in MicroStrategy. There's a reason we're at the top of the list. Published on December 2016 | Categories: Documents | Downloads: 71 | Comments: 0 | Views: 894Apply Comparison - Techniques - Microstrategy Blog. Unser Team; Careers: work as a business intelligence advisor; ServicesKB14562: How to use a relationship filter to control expensive subqueries in MicroStrategy SQL Generation Engine Number of Views 3. The expression parser fails to validate the expression, with a message under the expression editor reading "Invalid Expression. Cheers. Using the Metric Editor, create a new metric expression. Below are the list of parameters that the URL must. 4. Note: If a user enters more than 15 digits for a. mstrc file created before and click Continue. 0. ApplySimple – Uses simple arithmetic operators. Exercise 4. Logical operators: These operators provide basic comparisons and return TRUE or FALSE values based on the evaluation of the formula. If you are looking to learn. For additional information on Null/Zero functions, refer to the MicroStrategy Functions Reference. For basic information and examples of the ApplySimple function, see the Functions Reference. Comprehensive analytical capabilities and Automated reporting: MicroStrategy offers wide range of analytical features including data visualizations, advance analytics, data discovery and predictive modeling. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. 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. About Us. You would go through the same process as above to get a variance, by creating multiple metrics with the filters needed and then using compound metrics that bring them together. x, select 'Project Documentation' from the Tools menu to start the wizard. From the first drop-down menu, select the form you want to filter data based on. Min (Ttime) {~+, <|Ttime+} < [date filter]; @2; ->. x using the ApplyLogic function, as illustrated below. Limit the number of attribute elements displayed in a prompt in MicroStrategy. ApplySimple – Uses simple arithmetic operators. The Subtotals dialog box opens. Each dot in a bubble chart corresponds with a single data point, and the variables’ values for. Query Stage: Retrieve data from the warehouse. Comparison operator prompts can be used in ApplySimple functions with Case statements using the metric, (@nameofprompt(M1, M2)). 2987. Description. 5% of users said that the platform is easy to use, with a user-friendly drag. Continue creating the metric (for example, adding levels or conditionality) . Create a report with Region attribute. In MicroStrategy Developer, create a new report or select an existing report to use as the data mart table. The Document Properties dialog box opens. The difference in using Lead rather than Lag is that the Lead function would display information by going forward in time rather than backward. Without data, the dashboard will not show the user anything. 3. Select the 'Advanced' tab, as shown below: Change the setting for 'Attribute element browsing' (circled in red above) to the limit that is desired for the project. The next example uses ApplyComparison. From the Tools menu, select View Filter. Back to the Report. Create a metric with the ApplySimple statement below as its definition and name it "Case Metric": Create a filter using the Advanced Qualification: Through the use of the ApplyComparison function, create a custom expression filter to select the desired rows from the desired table. Go to Start -> Programs -> MicroStrategy -> Tools, run ScanMD. mstrc”. for each successive object passed. Tysons Corner, VA. Depending on the type of object you are filtering on, a different set of choices appears. Microstrategy Report Services documents vs Dashboards. 11 where metrics with complex custom SQL logic filters can be combined into a single pass of SQL through global optimization when a feature flag is enabled. mtc is the name of the saved test file. Apply Comparison – Techniques. 11K KB6178: How to use the pass-through expression ApplyComparison in MicroStrategy SQL. Create a file subscription in MicroStrategy Web. x using an Oracl… Number of Views 6. Example. ApplyComparison is a 'pass-through' function that builds a SQL comparison expression based on the input string of database-specific SQL syntax. x and 9. Therefore, users must use the ApplyComparison function to ignore the SQL parser as shown below: NOTE: KB5700-007-0107 describes the ApplyComparison function in detail as well as other functions that bypass the SQL parser in MicroStrategy Desktop. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. ApplyComparison() Accepts facts, attributes, and metrics as input. The index for referencing these objects begins with 0 and increases by. Open the report’s subscriptions in MicroStrategy Web: Scroll down to the Email subscription and click the option to “Add email subscription”: Choose the schedule by clicking the drop-down and selecting the required schedule. The next example uses ApplyComparison. ApplyComparison is used to define a filter by populating the WHERE clause in the SQL passed to your RDBMS, and can take facts, attributes, and metrics as input. By default, 'Custom Expression' is the option selected for a new Advanced Qualification. This article covers how to use passthrough expressions to write custom SQL inside of MicroStrategy. ITtoolbox. Review your choices at the summary screen and click Finish. How to write Pass-through filters using ApplySimple, ApplyAgg and ApplyComparison functions. The next example uses ApplyComparison. Example: Customer City = Call Center Using ApplyComparisonYou can use the AppleSimple function to insert database-specific functions and simple operators directly into SQL. The syntax is: FileLocation is the path to the saved test file. 2. Level metrics allows the users to choose the right combination of level target, filtering, and grouping (referred to as elements) to achieve your desired results. MicroStrategy strongly advises against using Apply functions when standard MicroStrategy functions can be used to achieve the same goal, because using RDBMS functions effectively bypasses the validations and other benefits of MicroStrategy products. Every request to a MicroStrategy Web product corresponds to a. MicroStrategy use TLS v1. ApplySimple ("case when #0 contains 'As Is' then 'As Is' when contains 'New' then 'New' ELSE 'Other' END", [NAME]) case. . 1 In some scenarios, users would like to query the latest N days data that are available the database. No doubt MicroStrategy has powerful filtering capabilities but if you are familiar with SQL, somtimes you might find that you feel a bit constrained in certain situations and thinking you could do things easier with a simple query and there may come a time where you need to filter a report based on the results of a SQL query. Execute the report and add a Subtotal (Average). The ApplyComparison function is used with comparison operators such as >, Like, and In. For example, edit the attributes. From creating basic objects to building complex reports and analyzing data, you have the ability to create custom expressions using a. The functionality of Apply functions is provided by wrapping the expression, as a string, inside a dedicated (Apply) function call. The index. Data DesignIn 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. Arguments may be substituted into the specified SQL pattern. Enable the 'Show Advanced Qualification' box, as shown below. ApplyComparisonStep 3. However, by taking advantage of the ApplySimple expression, the attribute sorting can get applied correctly in Microstrategy Desktop and Web 9. This depends on the function we are using (we explain each one below), but, for example, the ApplyComparison, appears mainly when defining filters, either integrated within a report or an indicator or as a filter object per se. KB6178: How to use the pass-through expression ApplyComparison in MicroStrategy SQL Generation Engine. 1. This document provides the steps to accomplish the same. To display a group horizontally. As you can imagine, the SQL Engine. x-10. MicroStrategy is a strong contender in the enterprise BI market that its customers praise for a multitude of reasons: its robust drag-and-drop reporting tool, strong data visualizations and dashboards and accessibility through web and mobile apps. Click Insert Visualization . The definition of the shortcut filter (East Coast) is displayed. Microstrategy Dossiers With the release of MicroStrategy 10. ) The above example used an Apply function, ApplySimple. If SQL is required for another database platform, users need to contact their database administrator to do so.