Note that for the first row, the data from the previous row is 0 since the analysis is limited to the data retrieved by the report. Open the report in Edit mode. 41. 4. Dossiers can be created by using the new Desktop product or Workstation or simply from the Web interface which replaces Visual Insights. In addition to creating, editing, and consuming content, users can also share personalized content via email, folders, or. Review your choices at the summary screen and click Finish. The examples below use the Lag function. The following example shows the steps to create the report above: Create an attribute mapped to key2 column on Table_2. Bitcoin rose Friday, topping $38,000 to extend a strong year for the cryptocurrency. From: sukumar123 via microstrategy-l [mailto:microstrategy-l@groups. In the Grouping panel, right-click the grouping field to display horizontally, and select Grouping Properties. 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. The difference in using Lead rather than Lag is that the Lead function would display information by going forward in time rather than backward. Since the limit is 0 and ∑ ∞ n = 1 1 n3 / 2 converges, we can conclude that ∑ ∞ n = 1lnn n2 converges. Specify whether to compare all objects or just objects in a specific folder, and what types of objects to compare. Omit until content. Custom Tooltips in Microstrategy developer and Web The following table describes the macros you can use to customize graph tooltips in both MicroStrategy Developer and MicroStrategy Web: Macro Information Displayed {&TOOLTIP} All relevant labels and values associated with a graph item. Follow the steps below for an example of how to do this. Accept the other default values. ) The above example used an Apply function, ApplySimple. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. 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. ApplyComparison is commonly used to create custom filters. Connect to a database instance and drags tables into the canvas. One or more of the following patents may apply to the product sold herein: U. Examples of this category are Between, Like, Greater than(>), Less than (<), ApplyComparison, and so on. Item = 3/4 * 10 = 7. This technical note describes how to use a custom expression to filter on previous months dynamically in MicroStrategy Developer 9. 4. If all conditions are false, a default value is returned. For additional information on Null/Zero functions, refer to the MicroStrategy Functions Reference. Go to the Editors section and select Filter. 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. (If the option for advanced qualification is not visible as one of the filtering options, see KB5188, "'Add an Advanced Qualification' option is not displayed when creating a filter in MicroStrategy Desktop 8. If you have a joint child relationship in your data, it is important for you to define it in MicroStrategy so. ApplyComparison ("#0 between #1 and #2",? Instead, they are intended to enhance the MicroStrategy product by taking advantage of what the RDBMS platforms can offer. 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. 3. ApplyComparison. Use the steps in Custom Expressions along with the custom expression below, to create the filter you need: ApplyComparison ("#0 like '*'", Store@DESC) Each piece of the custom expression is explained below: This article explains how the applycomparison function works in MicroStrategy This video focuses on what types of functions you users can create and how to correctly write them. This prompt is used in a filter. (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. Prompt-in-prompt is a feature in which the answer to one prompt is used to define another prompt. The example below shows the basic structure of an ApplySimple statement to create metrics. Go to Start -> Programs -> MicroStrategy -> Tools, run ScanMD. 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. 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. 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 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. 0. MicroStrategy is a data analytics platform that delivers actionable intelligence to organizations of all sizes. One filter uses the original ID form of the attributeThis article discusses how to use Edit Links to filter a destination Report by an attribute not present on the destination Report in MicroStrategy Desktop 9. x using a filter selector combined with a case statement derived metric and view filter. The Report SQL indicates that the filter has not been applied. Example 1. 1. ) The above example used an Apply function, ApplySimple. 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. Compare all the important BI vendors with our 100% independent Business Intelligence tools comparison. 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)'. Cross-tab stage. x . 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. A user tries to create a custom filter expression in MicroStrategy Desktop 8. Explanation. key1 + '%')",Key2@ID) Published: Apr 12, 2017. In earlier versions of the product metrics with different conditions such as the expression 'ApplyComparison("#0 in (select year_id from lu_year where year_id = 2015)",Year@ID)' could not be combined into a single pass of SQL per the SQL Global Optimization. The “ #n” code in Apply function syntax serves as placeholders for the MicroStrategy objects being passed to your database. , in search results, to enrich docs, and more. {&GROUPLABEL} Name of the graph. Dossiers can be created by using the new Desktop product or Workstation or simply from the Web interface which replaces Visual Insights. 1. This will enable the option to use ApplyComparison’s in Filters. The ApplyAgg function itself is a group-value function and accepts facts, attributes, and metrics as input. Populate and Evaluate: Fill report data required for display. The syntax always follows the format Applyfunction ("#0. 00% Whether there are values or not. ApplyComparison. The Filter Editor is displayed. The ID is distinct. 4. Considerations for the use of star schemas with MicroStrategy SQL Generation. This document provides the steps to accomplish the same. Enterprise Analytics Business Intelligence; HyperIntelligence; Cloud; Product Innovation; Education; ConsultingInvoke the MicroStrategy Integrity Manager executable MIntMgr. The “SQL” portion of your code always come. Takeaways: Power BI vs. 1 comment. If DHTML is disabled, click the Go icon . This article explains an enhancement available starting in 10. For example, while the Lag function can. Stand out in a crowd. exe to this machine. The syntax is: FileLocation is the path to the saved test file. Create a new filter using a custom expression with POST /api/model/filters. The My Preferences dialog box opens. Right-click the dossier you want to certify. There are three types of objects: schema objects, application objects, and configuration objects. In this case, enter 'Date@ID'. 3. 2. ", Arg1, Arg2). Arguments may be substituted into the specified SQL pattern. Microstrategy Dossiers With the release of MicroStrategy 10. x, select 'Project Documentation' from the Tools menu to start the wizard. 4. Click OK. ittoolbox. To Access an Advanced Filter Qualification. Save and assign a name to the file like “My_first_connection_file. Drag an attribute from the Datasets panel to the Columns area of the Editor panel to add attributes to the columns. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. 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. The Grouping panel is displayed. 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. To use previously defined in Db2 function in MicroStrategy, you can use the MicroStrategy built-in Apply (Pass-Through) Functions or use Freeform SQL. The next example uses ApplyComparison. Note: To avoid user permission conflicts, the following steps must be performed with highest privileges. The ApplySimple function is used with simple operators and functions. 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. (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. This can be accomplished by creating a simple batch file, and scheduling that batch file to execute with a third-party tool like Microsoft Task Scheduler. From the Visualizations panel, select Grid . Go to File > New >. The fuel for business dashboards is data, so each one needs to have one or more data sources. But if i answer only one prompt and leave the other one answered,the. Click Nextto pass ScanMD introduction to the next step, which is Step 1of ScanMD. x . 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. For basic information and examples of the ApplySimple function, see the Functions Reference. mstrc, please open something similar to Notepad. In the Navigation pane, click Dossiers. 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. SecurityRegion table defines from which region a user is allowed to view data. Create three filters (F1, F2, F3) using Applycomparison statements. How to use Guacamole to copy and paste text or files in MicroStrategy on AWS; All new Download site is now available! How to increase the Java Heap size in Tomcat Application Server; KB222220: Images are not displayed in Excel documents that are delivered through Distribution Services in MicroStrategy 9. Dossiers can be created by using the new Desktop product or Workstation or simply from the Web interface which replaces Visual Insights. To enable a visualization to filter or highlight the data in another visualization. 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. Now your connection f. 1. 1. 9, there was an active focus on making it easier to build dashboards for the widest audience of end users. 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. 5. Case. Open the dossier you want to modify. ApplySimple – Uses simple arithmetic operators. Query Stage: Retrieve data from the warehouse. In the User Manager, grant the 'User report filter editor' privilege to the user facing this issue. Number of Views 2K. The next example uses ApplyComparison. 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. x. Depending on your MicroStrategy product and licensing. In the MicroStrategy Mobile app, depending on your device, you can navigate to the Shared Reports folder in a variety of ways: When the Mobile user taps the URL on the mobile device, the user may. MicroStrategy helps business people make faster, better business decisions, empowering them with self-service tools to explore data and share insights in minutes. Numeric prompt: Users enter a specific number, up to 15 digits, which is then used as part of a filter, or within a metric, to look for specific numeric data. To Add a Target Visualization to Your Dossier: Open the dossier with the visualization. The index for referencing these objects begins with 0 and increases by. 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. 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. Drag an attribute from the Datasets panel to the Rows area of the Editor panel to add attributes to the rows. 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. 1 and 10. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. Using OLAP Services, create a metric that is the SUM of a fact. Follow the steps below to create a list of all groups and the users in each group: In MicroStrategy Developer 9. x. ,. About Us. 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. This report shows the sum of sales for each month, for the previous row and the % change between them. Choose attribute Call Center and use the Region Filter created in the previous step. This is a. How to define an advanced qualification using a custom expression to filter on months in MicroStrategy Developer 9. This is a single-value function. 1001 to 5000 Employees. To Access an Advanced Filter Qualification. From the Tools menu, select Report Options. We are active contributors to solutions on the MicroStrategy Community site. There are two symbols which can be used interchangeably and are recognized by MicroStrategy as wildcards, * and %. 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. The apply () collection is bundled with r essential package if you install R with Anaconda. 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. In the last field, type the value (s) or click the calendar to select a. x, select 'Project Documentation' from the Tools menu to. MicroStrategy desktop provides some functionality to compare the values of two metrics using the filtering functions. In the MicroStrategy Developer File menu, point to New > Filter. By default, this executable is located in C:Program FilesMicroStrategyIntegrity Manager. Click Qualify. mstrc file created before and click Continue. They act as containers for non-standard SQL expressions that MicroStrategy does not support. Example include ApplySimple, ApplyComparison, etc. Example: Customer City = Call Center Using ApplyComparisonSet the qualification type to 'Custom'. 9 billion. Published on July 2022 | Categories: Documents | Downloads: 1 | Comments: 0 | Views: 62MicroStrategy Tutorial. The following schema shows which setting takes precedence when set at different levels. Clear the Totals check box to remove the standard subtotals. Hi, if this doesn't work fo r any reason, there is a workaround. 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. 4 and later. 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. For example, consider the relationship between three attributes: Promotion, Item, and Quarter. The MicroStrategy SQL Generation Engine uses the COALESCE function to ensure correctness and consistency in full outer join results. Syntax. x. Example: In the database warehouse, there is a table called SecurityRegion, with two columns, Region_ID and User_ID. From the first drop-down menu, select the form you want to filter data based on. Cross-tab: Pivot and display sorting and page-by Each of the engines plays an important part in the report execution process. The ApplyComparison function is used with comparison operators such as >, Like, and In. 0. All the existing visual Insights dashboards will be converted to Dossiers With MicroStrategy 10. Plus, it connects business apps while integrating data. MicroStrategy URL Parameters. ) are used. From the Visualizations panel, select Grid . After installation of this application only thing you have to do is to follow step listed below: Type here text you want to find and press next. 0. Published on December 2016 | Categories: Documents | Downloads: 71 | Comments: 0 | Views: 894Apply Comparison - Techniques - Microstrategy Blog. Set up the Enterprise Manager. For basic information and examples of the ApplySimple function, see the Functions Reference. ')"; [Net Weight. Ap plySimple (microstrategy. In the right corner of the dashboard, change the. Using system prompts, users can use. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. To determine how null and zero metric values are displayed or hidden in a grid report. x-10. Open up those tables in the Table Editor by navigating to the Schema ObjectsTables folder, and double-clicking the tables. MSTR Secure Enterprise. The next example uses ApplyComparison. 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. Select only Configuration Objects for documentation. Choose folders where you want to find the text and press next. 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. Comprehensive analytical capabilities and Automated reporting: MicroStrategy offers wide range of analytical features including data visualizations, advance analytics, data discovery and predictive modeling. Ultimately, it was. Applycomparison advancd filter with a select state. ApplyComparison ("Upper (#0) like. 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 Combination Graph. 1 and 10. 3. mtc is the name of the saved test file. Security filters enable you to control what warehouse data users can see when that data is accessed through MicroStrategy. The ApplyComparison function is used with RDBMS comparison operators such as >, like, and In. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories. Example. Using the ApplySimple function, you can include prompts in your MDX to provide dynamic analysis on your MDX cube data. ApplyComparison is used to define a filter by populating the WHERE clause in the. 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. Follow the steps below: Right-click on the project and select 'Project Configuration. 3. It will not indicate that the check box is enabled, but this step is mandatory. To create a MicroStrategy Environment connection file . Query Stage: Retrieve data from the warehouse. 2. To make Apply functions, to must have the Use FreeForm SQL Publications privilege. There are two symbols which can be used interchangeably and are recognized by MicroStrategy as wildcards, * and %. From the first drop-down menu, select the form you want to filter data based on. There is no functional difference between the two symbols. If required, we can also create a derived metric to make complex comparisons. Returns TRUE if value is not NULL; otherwise returns FALSE. 2. Click Insert Visualization . 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. 4. This custom SQL can be used. A compound key attribute is an attribute whose primary key is made up by the combination of two or more columns. For an introduction to prompts, how prompts save the report designer time, and how prompts work with MicroStrategy security filters, see the. 2. In MicroStrategy Developer, create a new report or select an existing report to use as the data mart table. The ID is distinct. 62K. This article explains how to use the applycomparison function in MicroStrategy INTRODUCTION Pass-through expressions, also called Apply functions, provide access. 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. The ApplyComparison function is used with comparison operators such as >, Like, and In, which accepts facts, attributes, and metrics as input. 3. This is a filter which contains a prompt on an attribute element list. 1) Adding a view filter to the report where Sum Metric != 0 which will bring only non zero values. Restricting access to data: Security filters. ApplyAgg. Why MicroStrategy Why MicroStrategy; Customer Stories ApplyComparison ("ComparisonFunction (#0, #1)", attribute1@ID, attribute2@ID) You can use five pre-defined Apply functions to replace regular, predefined functions of the same type. Project and schema locking prevent multiple users sessions. MicroStrategy can generally generate this type of SQL, but I find using this method usually comes out with more efficient SQL, especially compared to using a Set Qualification Filter. In this case, enter 'Date@ID'. 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. ) The above example used an Apply function, ApplySimple. It allows users to customize data visualizations and build personalized real-time dashboards. You can allow joins across datasets based on unrelated common attributes in a single Dossier or for all of the documents. The Lead function can be used in the same way. Right-click the project for which to activate the advanced qualification option and choose My Preferences. Apply Comparison – Techniques. Select types of files you want to be considered and press next. This feature is only implemented for element list prompts. Define the advance sort on the derived. For information on whether your database supports various date and time functions, see MicroStrategy and Database Support for Functions. In the Grouping panel, right-click the grouping field to display horizontally, and select Grouping Properties. A security filter can be assigned to a user or group to narrow the result set when they execute reports or browse elements. Most data on a document is from one or more underlying datasets. Level: Set grouping to "Beginning Fact" for your date attribute. You must use the ApplyComparison and when you create the filter use Advanced Qualification. ApplySimple ("case when #0 contains 'As Is' then 'As Is' when contains 'New' then 'New' ELSE 'Other' END", [NAME]) case. This document will use the MicroStrategy Tutorial project with a warehouse in SQL Server to demonstrate the concept: Create a numeric value prompt and name it P1. The Filter Editor is displayed. There's a reason we're at the top of the list. For more details, click the link corresponding to each function. In some circumstances, it may be desirable to edit the definition of a security filter on the fly. Save the filter as "Region Filter". Number of Views 3. ProjectListType. Create a new attribute form for the attribute that the qualification will be based on. Therefore, there are two ways around it; you need to create a view that pre-joins the two tables so the two columns are in the same table; or you can use a subquery to bring one column from one table into the other table. The Security Role Editor opens. Number of Views 16. Select only Configuration Objects for documentation. In the Visualization Gallery, click Combo Chart to create a combination graph. ) are used. Using MicroStrategy Object Manager to copy/move objects around is not recommended while other user sessions are making changes using MicroStrategy Agent, as it could lead to metadata inconsistency. (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. KB6178: How to use the pass-through expression ApplyComparison in MicroStrategy SQL Generation Engine. 1. Select. All metric expressions must have an aggregation function. 5. If you are looking to learn. In this case, Promotion has a many-to-many relationship to both Item and Quarter. If I select name1 from the prompt, I do need to show all the occurances of. Follow the steps below to access the Project Comparison Wizard: From the Start menu -> Programs -> MicroStrategy -> Administrator -> Object Manager. To configure:-. 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. MicroStrategy - Metric Comparison. Transformations are schema objects and therefore only a project designer with the Create schema objects privilege can create them. likes. (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. Continue with the previous Steps 2 and 3 above. If an environment does not already exist, an environment will need to be created first. Click Advanced, then New to create a custom subtotal. Execute the report and add a Subtotal (Average). The easiest is probably to create an attribute of only the first character using the substring function. Back to the Report. for each successive object passed. Our Team; Careers: work as a economic news consultant; Our. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. For the Time hierarchy, the offset can. The ApplySimple function is used with simple operators and functions. This is usually ID. 0. Transformations allow you to apply an attribute-element based offset to compare metric data. 3. ApplyComparison(UPPER(#0) like 'Z####%', Country@DESC) The SQL used the. ” icon to expand it: All page-by attributes will. The issues with many-to-many relationships, including loss of analytical capability and multiple counting, also apply to many-to-many joint child relationships. Here is the workaround to achieve the attribute left outer join on MicroStrategy Web. For details, see Comparison Operators. How to write Pass-through filters using ApplySimple, ApplyAgg and ApplyComparison functions. Apply Comparison – Techniques _ Microstrategy Blog. 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. mstrc) Open Workstation. 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. 02K. 1 and 10. Click Insert Visualization to add a new, blank visualization to the dossier. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. 6,154,76 6, 6,173,310, 6,260,050,. Visit the data visualization and data dashboard galleries for inspiration. A MicroStrategy Report Services document displays data coming from multiple reports, with the data laid out and designed in presentation-quality format. From the Tools menu, select Grouping. 3. e. A sales team might use a business dashboard to connect. In order to exclude the values, create another filter expression which will always be TRUE and. 0. 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. 2. Tysons Corner, VA. How to create a dynamic custom group to display a set of date ranges in Microstrategy Developer. The script inside the " " always depends on the type of database used and can. 1Community & Support Search Discussions Open A Case View My CasesKB19301: How to create a filter that prompts on two metrics and uses a comparison operator to compare them in MicroStrategy Developer 9. Populate and Evaluate: Fill report data required for display. To allow sorting on the attribute elements after sorting by the metric total value, users may follow the steps below: Create a level derived metric to calculate on the attribute level at which the subtotal is calculated. Right-click on the project name and select My Preferences.