All attributes used to group data in the report or document are shown in the Available Attributes list. Follow the simple steps below to create a datamart report: 1 In MicroStrategy Developer, create a new report or select an existing report to use as the data mart table. 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. The next example uses ApplyComparison. The metric calculates only for the elements found in the filter definition. Go to Tools -> My Preferences -> Filters and check the box for Show Advanced Qualifications. By default, this executable is located in C:Program FilesMicroStrategyIntegrity Manager. Back to. A icon appears in the upper left corner of the source visualization. x-10. As a MicroStrategy developer, and a SQL programmer, I pick and choose my battles, and as much as it’s recommended in MicroStrategy to make complex metrics with “Last” or different Level Dimensionality, there’s also situations where you want to make the database do the work…such is the Case with the ApplyComparison filter. For instance, it could be possible to pass in parameters to MicroStrategy Web to dynamically effect what a user has access to at that timeTo burst a file subscription across multiple subfolders. 11K KB6178: How to use the pass-through expression ApplyComparison in MicroStrategy SQL. To create a rolling month transformation filter, which will allow a user to select a month and will then filter values based on the the inputted number of months before it, do the following: 1. Create the statistics database instance. The ApplyComparison function allows users to bypass the MicroStrategy SQL parser and create an expression where comparison operators (e. x . ApplyComparison is used to define a filter by populating the WHERE clause in the. Returns TRUE if the value is NULL; otherwise returns FALSE. 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. Here are the detailed steps on how to install MicroStrategy using the MicroStrategy virtual appliance: Go to the MicroStrategy website and create a MicroStrategy account. There's a reason we're at the top of the list. This article explains how to use the applycomparison function in MicroStrategy INTRODUCTION Pass-through expressions, also called Apply functions, provide access. Click Advanced, then New to create a custom subtotal. Here is the workaround to achieve the attribute left outer join on MicroStrategy Web. all to no avail. Example: Customer City = Call Center Using ApplyComparison You can use the AppleSimple function to insert database-specific functions and simple operators directly into SQL. x using an Oracl… Number of Views 6. Using the Metric Editor, create a new metric expression. I've been all over Microstrategy community and have tried possible solutions/formatting etc. Quick connections to any data source are combined with one-click sharing of any insight. The Document Properties dialog box opens. Select the 'Advanced' tab, as shown. Select any project that is in the project source that contains the users and groups and click Next. Menu. 5% of users said that the platform is easy to use, with a user-friendly drag. The next example uses ApplyComparison. MicroStrategy Web is an interactive, easy to use interface for all Business Intelligence (BI) reporting, analysis, and monitoring. There's a reason we're at the top of the list. Set up the Enterprise Manager. ApplyComparison is a 'pass-through' function that builds a SQL comparison expression based on the input string of database-specific SQL syntax. Query Stage: Retrieve data from the warehouse. 2. ) The above example used an Apply function, ApplySimple. 4 and later. General hardware recommendations. 1. In this example, the filter compares a user-entered date to see if it is between the Order_Date and the Ship_Date. 1. 4. The MicroStrategy ONE platform provides access to AI-powered workflows, unlimited data sources, cloud-native technologies, and unparalleled performance to speed up time from data to action. 5. For example: ApplyComparison ("#0>#1", Store@ID, Month@ID)You can use the ApplyComparison function to define custom filters. It leverages data connectivity, machine learning and mobile access to offer. To resolve this issue, follow the steps below: Log into the project source as a user with System Administrator privileges. Open a project source in MicroStrategy Object Manager. The Lead function can be used in the same way. Sometimes it’s easier to push the functions to the database level. Applycomparison advancd filter with a select state. This is a single-value function. Go to the Editors section and select Filter. The following report sample displays all of the options, including the view filter, in the report details. Click Insert Visualization to add a new, blank visualization to the dossier. Syntax. How to implement attribute form expression using Apply Functions in MicroStrategy Developer Apply functions can be used in the attribute editor to provide access to functionality that is not standard in MicroStrategy, but available from the Relational Database Management System (RDBMS), such as the special functions or syntactic. There are two symbols which can be used interchangeably and are recognized by MicroStrategy as wildcards, * and %. KB47572: How to display dates between a selected date and the first day of the month of the selected date in MicroStrategy. Note: Filters can only be created out of metrics and schema attributes. 4. ApplyComparison is commonly used to create custom filters. Syntax Common to Apply Functions. From the next drop-down menu, select the operator that describes how you want to filter data. In the bottom left corner, click on the button "Generate Connection File". This is a. Limit the number of attribute elements displayed in a prompt in MicroStrategy. This metric divides the sum of VOL fact at report level by [Net Weight] after applying it a character replace at BBDD level with ORACLE's replace function (it. Select only Configuration Objects for documentation. It allows users to customize data visualizations and build personalized real-time dashboards. Syntax. Number of Views 2K. To support including attribute information in the metric expression, in the Definition area, type Max () to use the Max aggregation function. If excutionMode is not provided in the URL, by default PDF will be used as executionMode. For an introduction to prompts, how prompts save the report designer time, and how prompts work with MicroStrategy security filters, see the. In the Grouping panel, right-click the grouping field to display horizontally, and select Grouping Properties. In your Datasets panel, hover over the name of your dataset. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. The filtering setting for a level metric governs the relationship between the report filter and the calculation of the metric. The primary characteristic of star schema is its use of dimension tables rather than single-attribute lookup tables. Create a report with Region attribute. com Para jpviva. To solve this problem, the ApplyComparison. Filename. A sales team might use a business dashboard to connect. 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. Stand out in a crowd. This article describes how to use the applycomparison function to use like with text prompts in MicroStrategy (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. A report requires to show the bottom 10 unit prices per item. For information on whether your database supports various date and time functions, see MicroStrategy and Database Support for Functions. None. 9, there was an active focus on making it easier to build dashboards for the widest audience of end users. In Teradata, the Extract function returns the month, day or year from a date field. In this case, enter 'Date@ID'. A compound key attribute is an attribute whose primary key is made up by the combination of two or more columns. MicroStrategy Developer allows expressions to be created where an element list prompts is one of the arguments to a passthrough function; however. Although transformations can be applied to any attribute hierarchy, the Time hierarchy is used most often. To Display a Filter's Definition. Enterprise Analytics Business Intelligence; HyperIntelligence; Cloud; Product Innovation; Education; ConsultingInvoke the MicroStrategy Integrity Manager executable MIntMgr. 3. 3. Apply functions: These functions provide access to functions and syntactic constructs that are not standard in MicroStrategy but are offered by various relational database. The recursive hierarchy table has to be split into several tables, one for each level in the hierarchy (turning it into a traditional snowflake schema). Acceptlist of project. Actually, it can be used anywhere where. Splitting the fraction: Numerator: Sum (VOL) {~} Denominator: Max ( ApplySimple ("replace (#0, ',', '. Now your connection f. While string functions can be used to create metrics, a more common use case for these functions is in the creation of attribute forms. This is a single-value function. In this article we will discuss the ApplySimple function. ApplyComparison is commonly used to create custom filters. But if i answer only one prompt and leave the other one answered,the. The ID is distinct. Click Filter Options. All the existing visual Insights dashboards will be converted to Dossiers With MicroStrategy 10. This will change the diagrams, depending on the value selected. 6,154,76 6, 6,173,310, 6,260,050,. Using system prompts, users can use. Below are the list of parameters that the URL must. 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. 1 and 10. 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. 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. 4. 2. id where #1 and #2)", [Date]@Id,? [GTN],? [BTN]) Both the GTN amd BTN are optional prompts. Filter Reports using SQL with ApplyComparison and ApplySimple. One common way to do this is to compare the date information you have stored to the current date. 1. A space where we get together to see curiosities, share experiences and pass tips to be the coolest and most knowledgeable consultants. Create an attribute element prompt for Month. Syntax. ) The above example used an Apply function, ApplySimple. In the MicroStrategy Developer File menu, point to New > Filter. To Create a Combination Graph. To begin, the architecture for dashboard execution is. It leverages data connectivity, machine learning and mobile access to offer users comprehensive control over their insights. 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. 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. All the existing visual Insights dashboards will be converted to Dossiers With MicroStrategy 10. for each successive object passed. MSTR Secure Enterprise. A bubble chart (aka bubble plot) is an extension of the scatter plot used to look at relationships between three numeric variables. 1 and 10. 4 and later. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. 0. Blocklist of project. Joao Paulo "mahendra_patel via microstrategy-l" 07/07/2006 11:19 Favor responder a microstrategy-l@Groups. x: Open the Filter Editor to define a new filter. You must use the ApplyComparison and when you create the filter use Advanced Qualification. MicroStrategy strongly advises against using Apply feature at standard MicroStrategy functions can be used to achieve the same goal, because using RDBMS additional effectively bypasses the validations also other benefits about MicroStrategy products. Define the statistics and enterprise warehouse database. Create a new filter using a custom expression with POST /api/model/filters. ApplyComparison. For example, consider the relationship between three attributes: Promotion, Item, and Quarter. About Us. The issue is reproduced in MicroStrategy Tutorial project with the steps below: Create a metric based on the freight fact which is extended to Item attribute with fact extension. The fuel for business dashboards is data, so each one needs to have one or more data sources. The report execution process is a three-step process: 1. Case can be used for categorizing data based on multiple conditions. Click Insert Visualization . Create three reports named A (with attribute A), A&B (with attribute A and B),A&C (with. When evaluating different solutions, potential buyers compare competencies in categories such as evaluation and contracting, integration and deployment, service and support, and specific product capabilities. The difference in using Lead rather than Lag is that the Lead function would display information by going forward in time rather than backward. Retrieve a list of user groups and the associated users in MicroStrategy Developer Follow the steps below to create a list of all groups and the users in each group: In MicroStrategy Developer 9. Brand = 4/4 * 10 = 10 (note that the lowest level attribute always have a weight of 10 ) Similary for a the date hierarchy, the values are calculated as below. 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. Our Team; Careers: work as a economic news consultant; Our. 4. 1 comment. Select Show advanced qualification. Create a new filter in MicroStrategy Developer; Choose the 'Add an advanced qualification' option and click on the 'OK' button. 7K KB6178: How to use the pass-through expression ApplyComparison in MicroStrategy SQL Generation Engine2. If you have a joint child relationship in your data, it is important for you to define it in MicroStrategy so. Starting in MicroStrategy 10. 5. Open “Database instances” in the Categories menu, and click on “SQL Data warehouses”. 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. Intelligence Everywhere. 0, one fifth of the training data was always reserved for validating the model built on the remaining four fifths of the data. It will not indicate that the check box is enabled, but this step is mandatory. When him need to use an Apply function, MicroStrategy encourages him to submit and enhancement request for inclusion of the requests performance in a future product release. If I understand right, create a report using the above SQL to generate a single value (it does). Example include ApplySimple, ApplyComparison, etc. 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's a reason we're at the top of the list. x-10. Using L’Hôpital’s rule, limx → ∞ lnx √x = limx → ∞ 2√x x = limx → ∞ 2 √x = 0. In this quick tip, I show you how to filter MicroStrategy reports using a custom SQL query using ApplyComparision and ApplySimple. Click Nextto pass ScanMD introduction to the next step, which is Step 1of ScanMD. Case. 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. In this example, the filter compares a user-entered date to see if it is between the Order_Date and the Ship_Date. A user tries to create a custom filter expression in MicroStrategy Desktop 8. This article covers how to use passthrough expressions to write custom SQL inside of MicroStrategy. Go to Start -> Programs -> MicroStrategy -> Tools, run ScanMD. After applying the filter, click some of the values of the product category visible in the top bar filter section. Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e. x-10. KB7294: How security filters work in. This article covers how to use passthrough expressions to write custom SQL inside of MicroStrategy. x, select 'Project Documentation' from the Tools menu to start the wizard. The Filter Editor is displayed. For example: ApplyComparison ("#0>#1", Store@ID, Month@ID) You can use the ApplyComparison function to define custom filters. The template looks like the following: In this sample workflow, you want to return the newly created filter and its. If an environment does not already exist, an environment will need to be created first. We’re here to help you align the future of AI/BI technology with your company vision. Cards can be consumed in a web browser via the MicroStrategy HyperIntelligence Chrome extension and on iOS devices via the MicroStrategy. MSTR has evolved dashboards to the point that. ) The above example used an Apply function, ApplySimple. Right-click on the Project name in MicroStrategy Developer 9. 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. 2. ProjectListType. x and 10. Using the ApplySimple function, you can include prompts in your MDX to provide dynamic analysis on your MDX cube data. Level Metrics. The Filter Editor is displayed. The syntax for the If function is IF (Condition, TrueResult, FalseResult) where:The MicroStrategy Desktop environment is very intuitive. Subscribe to MicroStrategy. To create metrics to use additional attribute forms as inputs for predictive metrics. . When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. However, when a LIKE operator is used in the metric definition, the query can be incorrectly generated leading the report to fail. The Intelligence Server will enforce the "User Freeform SQL. There are three types of objects: schema objects, application objects, and configuration objects. For the second filter, create an advanced qualification. ApplyLogic where logical operators (And, Or, etc. The definition of the shortcut filter (East Coast) is displayed. 1. 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. To create a MicroStrategy Environment connection file . Next, navigate to the Theme tab. To provide a reasonable level of generality, the feature is based on a 'pattern and arguments' scheme. x and 9. This is usually ID. Review your choices at the summary screen and click Finish. 4. To apply the selections as a slice,. ApplyComparisonStep 3. Patent Nos. The ApplyComparison function is used with comparison operators such as >, Like, and In, which accepts facts, attributes, and metrics as input. 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. How to create a MicroStrategy connection file (. 4) Next, change the Theme back to None and click Apply. (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. Create a report with Region attribute in the row, and add the above filter. 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. For information on whether your database supports various date and time functions, see MicroStrategy and Database Support for Functions. The Apply functions are not meant to take. 9, there was an active focus on making it easier to build dashboards for the widest audience of end users. CAUSE: One scenario is that the MicroStrategy 10. g. Willingness Team; Careers: work as adenine business intelligence consultantKB17904: How to prompt for a month and show data for the last 12 months using warehouse transformation tables. 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. Open MicroStrategy Developer. In some circumstances, it may be desirable to edit the definition of a security filter on the fly. The overall sort order is evaluated and stored in the attribute definition when the attribute is saved. Example 1 Using an attribute ApplySimple ("Datediff (YY, #0,getdate ())", [BIRTH_DATE]) Example 2 Using an attribute ApplySimple ("Months_between (sysdate,#0)",. If the attriubte name has spaces, use the '' symbols to group the name. Note: To create custom expression qualifications, the advanced qualification option must be enabled in the report designer's preferences in MicroStrategy Desktop 8. 2. Create a report R1 with Month, Revenue and filter which contains the first 6 months in 2008. 2. SecurityRegion table defines from which region a user is allowed to view data. This function evaluates multiple expressions until a condition is determined to be true, then returns a corresponding value. In some cases, it is possible that a single column does not meet these criteria, in which case either the dataset/application is not a good. 4. 4. Follow the steps below: Right-click on the project and select 'Project Configuration. 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. 1. The following report sample displays all of the options, including the view filter, in the report details. From the Project menu, select Compare Projects. Save and assign a name to the file like “My_first_connection_file. Dossiers can be created by using the new Desktop product or Workstation or simply from the Web interface which replaces Visual Insights. Our Team; Careers: work as a company intelligence consultant; ServicesKB20306: How to create dynamic date based on 'Last Month' in MicroStrategy SQL Generation Engine 9. 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,. 2. There are three types of objects: schema objects, application objects, and configuration objects. Use the MicroStrategy built-in apply (pass-through) functions; Freeform SQL; Apply (pass-through) functions. ApplyComparison is used to define a filter by populating the WHERE clause in the. In MicroStrategy Developer, open Architect. Dashboard execution stages can be represented below: MicroStrategy Intelligence Server When an end user makes a Document Execution Request through any client (a web browser via MicroStrategy Web, the MicroStrategy Desktop/Developer client, the MicroStrategy Mobile app, or the MicroStrategy Office client), the request is sent to. 3. Explanation. 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. The following example shows the steps to create the report above: Create an attribute mapped to key2 column on Table_2. ITtoolbox. The “ #n” code in Apply function syntax serves as placeholders for the MicroStrategy objects being passed to your database. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. The menu also provides features to connect to a server if required, view the data sets available, the visualization gallery, and data filtering options, etc. Go to Tools -> My Preferences -> Filters and check the box for Show Advanced Qualifications. Right-click the project for which to activate the advanced qualification option and choose My Preferences. From the Tools menu, select Grouping. Filter Reports using SQL with ApplyComparison and ApplySimple. Example: In the database warehouse, there is a table called SecurityRegion, with two columns, Region_ID and User_ID. The following steps demonstrate how to use the comparison operator prompt in an ApplySimple function with a Case statement. For additional information on Null/Zero functions, refer to the MicroStrategy Functions Reference. 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. 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. 3. 1. The ApplyComparison function is used with comparison operators such as >, Like, and In, which accepts facts, attributes, and metrics as input. Ap plySimple (microstrategy. Users may want to create a metric that displays 'NEW' when the display date is later or equal to the selected date and 'OLD' when the display date is earlier than the selected date in MicroStrategy Developer 9. Click Qualify. With all form sort orders set to none there is no saved sort order, MicroStrategy defaults to sort ascending by ID. Microstrategy Report Services documents vs Dashboards. Competitors: Oracle, SAP, IBM Create Comparison. To determine how MicroStrategy hides null and zero metric values in the grid, on the General tab, select the Hide Null/Zero Toggle Behavior. In MicroStrategy Web, open the document in Design or Editable Mode. Drag an attribute from the Datasets panel to the Rows area of the Editor panel to add attributes to the rows. Save the prompt as "Call Center Prompt". Dossiers can be created by using the new Desktop product or Workstation or simply from the Web interface which replaces Visual Insights. 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. Overall, more than 87. All the existing visual Insights dashboards will be converted to Dossiers With MicroStrategy 10. --- mahuamitra via microstrategy-l wrote: > > Thanks for the quick reply. You can achieve what you want if you build the metric with: A filter to ignore your specified "NULL-Date". Select any project that is in the project source that contains the users and groups and click Next. 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)'. In the following example, we have selected multiple values and you can notice how the pie-chart changes as each of the values are selected. See this difference in Joins Across Datasets and Document/dashboard best practice. 9, there was an active focus on making it easier to build dashboards for the widest audience of end users. e. To resolve this issue, follow the steps below: Log into the project source as a user with System Administrator privileges. . The metric will assign sequential numbers to the rows using the defined order. The following schema shows which setting takes precedence when set at different levels. Continue creating the metric (for example, adding levels or conditionality) . Schema objects include facts, hierarchies, and custom groups; application objects include reports, documents, and metrics; and configuration objects include project sources, database instances. KB35312: Attribute sorting does not get applied correctly on a selector when viewing a Report Services Document in DHTML mode in MicroStrategy Web 9. the Administration menu -> Projects in MicroStrategy Developer as shown. This can be achieved in multiple ways, but this Tech Note will focus on creating a Year to Date metric using a Month or Quarter attribute without using a transformation table. In order to export a document in excel format using the URL API, the executionMode must be set to 4. The functionality of Apply functions is provided by wrapping the expression, as a string, inside a dedicated (Apply) function call. ApplyComparison. ) The above example used an Apply function, ApplySimple. (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. How to Create a Filter within a Report: Embedded Filters. The following procedure describes how to achieve this: Create the highest level filter. The next example uses ApplyComparison. If you want to use a data range in your filter, select Between. x . This is a comparison function. Click Insert Visualization . Number of Views 3. 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. This article covers how to use passthrough expressions to write custom SQL inside of MicroStrategy. The name of the source visualization. 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. The same attribute is modified so the forms are now: Form Name. ')"; [Net Weight. The ApplyAgg function is used to define simple metrics or facts by using database-specific, group-value functions. 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. The Report Options dialog box opens. In the Grouping panel, right-click the grouping field to display horizontally, and select Grouping Properties. The ApplyComparison function is used with comparison operators such as >, Like, and In. One of the MicroStrategy-provided transformations answers our needs for the following example. Cheers. From: danielmager via microstrategy-l To: devildreamss Sent: Wednesday, No vember 1, 2006 1:27:45 PM Subject: Re: [microstrategy-l] Microstrategy lo gged in user on report / parameter. Right-click on the Project name in MicroStrategy Developer 9. x. The Grouping panel is displayed. Instead, you can use an ApplyComparison function in a custom expression qualification filter to search for this symbol. ) The above example used an Apply function, ApplySimple. In this example, the filter compares a user-entered date to see if it is between the Order_Date and the Ship_Date. Prior to MicroStrategy 9. mstrc, please open something similar to Notepad. For examples of Apply. As a MicroStrategy developer, and a SQL.