Although transformations can be applied to any attribute hierarchy, the Time hierarchy is used most often. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. For examples of joining datasets, see Defining a dataset as primary or secondary and Joining multiple datasets: Examples. Graph: Displays the data visually like a standard MicroStrategy graph report. 2 - Closes all optional prompts with an empty answer. In the filter editor, select 'Add an attribute qualification' as shown below. Define the advance sort on the derived. You can display data in a grid layout. See the previous images above to see how the row headers should now appear. Enable the Source Visualization to Update the Target Visualization. Portion displayed only (only the displayed page if multiple pages). Klicken Sie im Editorbereich auf Spaltensatz hinzufügen um einen weiteren Spaltensatz zu erstellen. The Grid/Graph, which looks like a standard grid container, is displayed. 9, we’ve taken a leap forward in our dashboarding capabilities. Natural Language Query (NLQ) allows end users to build dossiers and get insights just by typing questions. ApplyOLAP is used to define compound metrics. Click "Add Photo" and select photos to upload. Select Custom as the Category and create the format using the number format symbols listed in the table below. Steps to Reproduce on. Region is used as a selector, targeting the Grid/Graph on the right, which is displayed as a graph. If you have many reports or tasks that need to be executed on the same time-based schedule, consider creating several similar schedules that trigger 15 minutes apart. This article describes how to display username on the report grid with MicroStrategy Developer 9. V. This means you can have multiple. x, users may notice that the row headers are not merged, like shown below:Design compound visualizations or add rich text boxes and images. Start Power BI Desktop. 4 and later. A visualization is a visual representation of the data in a dossier, such as a grid, line chart, or heat map. The spreadsheet retains the formatting of the report as displayed in MicroStrategy Web, such as colors, fonts, and structure. Copy individual cells from grid visualizations to the clipboard. In MicroStrategy 2020, the Export to PDF window in a dossier allows for more customization and provides new default settings. Cross-tab Stage: Pivot and display sorting and page-by. Relate tables contain the ID columns of two or more attributes, which will define associations between them. The Compound Grid is a new visualization introduced in the MicroStrategy 2020 release. But, this can also be done with this. x and 10. Even after following the steps in KB37102: The color of a series in a graph changes depending on the information that is displayed by the graph in MicroStrategy 9. Click Insert Visualization . x, follow the steps below:. 6. Remember that P displays the parent attribute and 0 (the number zero, not the letter o) displays all the forms of the parent attribute. In MicroStrategy Web, click the metric for which you want to enable a grand total or subtotals. 1925 views | September 04, 2020 02:01. But, this can also be done with this. Relationship Tables. Go to Web Preferences and select Project Default -> Grid Display. A sample URL that answers an element prompt when the attribute has a compound ID is shown below. Populate & Evaluate Stage: Fill report data for display. Export a dossier when viewed in presentation mode. Notice that some metrics from the right grid are missing. Ein zusammengesetztes Raster erfordert mindestens ein Attribut und eine Metrik. 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. From the Tools menu, select Grouping. 1925 views | September 04, 2020 02:01. To enable this row display, change the Join type to “Join 92” and disable “null check” for metric in report VLDB properties. Click Insert Visualization . A simple metric sum (Revenue) will go to different aggregate tables depending on the attributes on the template. A sample URL that answers an element prompt when the attribute has a compound ID is shown below. You can also apply a set of color and shading schemes to all the objects on a graph report. From the Visualizations panel, select Grid . Using this grid, you can have multiple unrelated attributes and metrics in different sets of columns that are stitched together. How to Share a Dossier. This is easily done using the &hiddensections URL parameter that can be obtained from the folder browsing. A hierarchical attribute represents an entire hierarchy and its levels (for example, Time includes levels of Year, Quarter, Month, and Day). ”. Why MicroStrategy Why MicroStrategy Why MicroStrategy Customer Stories What's New Platform Platform Products AI / BI Platform. In the Gallery, click Compound Grid . In this example, the Year attribute is used. Choose Grid > Compound Grid . Compound grid export via Office add-in. Shapes and Data Labels. Use the Visualization Gallery to perform the following tasks: Select a visualization's type. This visualization allows you to create a grid that analyzes different aspects of data across a common dimensions or. Eg, total (profit/units Sold). Especially for you we decided to list and test the most interesting new features that MicroStrategy 2020 brings to dossiers. Compound grid export via Office add-in Hi there @Cheng Guo (Inactive) (Microstrategy, Inc. 9, we’ve taken a leap forward in our dashboarding capabilities. 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. 4. And leverage the Page-By function to focus your analysis on one element. x, follow the steps below:. To uniquely identify a distribution center, one must know two details about the distribution center: the ID. Each custom group element can be labeled with a header and includes. Generally, you build a compound attribute when your logical data model reflects that a compound key relationship is present. September 18, 2018. Foreign Keys Panel. Introduction to Grids. Using the Connector. Update the data on an Intelligent Cube without having to republish the entire cube in MicroStrategy MicroStrategy has introduced a feature known as, Incremental Refresh Options, which allow Intelligent Cubes to be updated based on one or more attributes, by setting up incremental refresh settings to update the Intelligent Cube with. 2. In its most basic form it consists of two parts: A report template (usually simply called a template), which is the underlying structure of the report. このチュートリアルでは、複合グリッドへの切り替え方法、複合グリッド内の列セットの追加方法、およびこの新しいビジュアリゼーション タイプを活用する簡単な使用例について、順を追って説明します。. mstrc, please open something similar to Notepad. Microstrategy Dossiers With the release of MicroStrategy 10. The data from the datasets is used to populate the report. So the row for Music will not display in the grid. Microstrategy URL API hide sections. Click Advanced, then New to create a custom subtotal. To set this option on the user level: Click on the User Preferences within Web Preferences, and then Grid display. In the new fix, Data Engine fixes the problem of not using the Metric Guide in the component metrics of Compound Metrics. Prompt-in-prompt is a feature in which the answer to one prompt is used to define another prompt. A compound grid requires at least one attribute and one metric. The Shapes and Data Labels options are available to format the graph items, such as graph markers and data labels, in. The name of the source visualization. A normal attribute represents a single hierarchy level (for example, Month). To reference an image using relative path, the following. Super Cubes in MicroStrategy 2019 Beginning in MicroStrategy 11. Set Data Engine Version setting to 11 or. #identify a record uniquely #Microstrategy Compound Key attribute; #ignore Report filters for a metric;. Update the data on an Intelligent Cube without having to republish the entire cube in MicroStrategy. J2EE environment:Year-To-Date Transformation Example. Enhanced formatting options for the Compound Grid visualization, including the ability to resize columns, duplicate, move-to, and copy-to actions. In the compound key, calling centers are identified by both Call_Ctr_id and Region_id. Explanation. A Grid/Graph acts as a standard MicroStrategy report. From the Visualizations panel, select Grid . The option to Delete unused managed objects allows a MSTR Admin to force a search and delete of those managed objects which no longer are in use by the project (no longer have dependants). MicroStrategy Web provides a wide range of parameters that can be used in combination to achieve different types of requests. To reproduce in MicroStrategy Tutorial: Create a simple report with one attribute and one metric. MicroStrategy has introduced a feature known as, Incremental Refresh Options, which allow Intelligent Cubes to be updated based on one or more attributes, by setting up incremental refresh settings to update the Intelligent Cube with. 1) Create Metric 1 which is the sum of the fact that is to be in the columns. 4. This URL executes a report with one prompt. [ONAME:Compound Grid]: This is the name of the object. Compound grids offer enormous flexibility and a lot of room for creativity. In the Datasets panel, double-click attributes and metrics to add them to the visualization. The Compound Grid is a new visualization introduced in the MicroStrategy 2020 release. Notice that a joint child relationship can be one-to-many or many-to-many. In MicroStrategy Web, click the metric for which you want to enable a grand total or subtotals. the Administration menu -> Projects in MicroStrategy Developer as shown. Choose Grid > Compound Grid . Creating a 'Compound Grid' 4100 views | September 04, 2020 02:40. Grouping. To change how it is displayed, do one of the following: To display it as a grid (a standard MicroStrategy grid report with rows and columns of attributes and metrics), in the Property List: Appearance section, select Grid from the View mode drop-down. September 18, 2018. 1 and 10. This feature is only implemented for element list prompts. In the "Metadata Repository" screen, select the "Project Source Name" and check the "Export Translations" option, as shown in the. Click Switch to Function Editor. is not running the latest Microstrategy for office so I'd like to ask if this issue is A)known. View data in simple grid format and leverage page-by options. Microstrategy Dossiers With the release of MicroStrategy 10. From the Home menu, point to Export. A recursive hierarchy or recursive dimension, usually consists of elements that point to other elements pertaining to the same attribute with a parent-child relationship. This technical note outlines how consolidations work with compound metrics in MicroStrategy Developer. This metric should be used on compound grid (rather than standard one). For steps and information on how the datasets are joined, see the. Drag an attribute or metric from the Datasets panel to the Columns Set area in the Editor Panel. This case is also explained with an example based on the MicroStrategy Tutorial project. This condition may be implemented through an ApplySimple statement such as the following: The user will find that the CASE statement. Connecting Tableau to TDV Using ODBC. The contents of the grid report are displayed, separated by commas. Case This function evaluates multiple expressions until a condition is determined to be true, then returns 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. If projects are distributed asymmetrically across the cluster, when you assign an event-triggered schedule to a project, make sure you trigger the event on all nodes on which that project is loaded. The graph shows revenue by category and region. Filter data in a second visualization by selecting attribute elements or metric values in. MicroStrategy AI is here. Add subtotals to the grid. Incluso, si. Do not forget to enable Subtotal (F11). Consider the following MicroStrategy Tutorial project. Follow the steps below. This implies that more than one ID column is needed to uniquely identify the elements of that attribute. It supports interactive dashboard, highly detailed reports, ad-hoc query, automated report dispute, and Microsoft Office integration. In the Editor panel, click Add Column Set to create another column set. 4. View the orange Certified ribbon on the dossier. (Highly recommend for understanding your exported data). Update the data on an Intelligent Cube without having to republish the entire cube in MicroStrategy MicroStrategy has introduced a feature known as, Incremental Refresh Options, which allow Intelligent Cubes to be updated based on one or more attributes, by setting up incremental refresh settings to update the Intelligent Cube with. xls format. Upgrade to MicroStrategy 11. To select how the Grid/Graph is displayed, use the View mode property. In the Datasets panel, double-click attributes and metrics to add them to the visualization. View the visualization's name and data requirements. As far as I tested, qualifying on multiple IDs of the same attribute is not possible in MicroStrategy, not even in version 9. The Compound Grid is a new visualization introduced in the MicroStrategy 2020 release. Click the vertical eclipse icon (More) on the top right of the visualization. See related articleThis video shows how to certify a dossier. Insert an HTML container (and not an image) and insert the script below. In Workstation 2020 you can only use attributes in rows. Learn how to switch to a compound grid, add column sets in this new visualization. In the top toolbar, click Insert Visualization . You treat one attribute as a child of the other and have a compound key for the lower level attribute. Make two grids with different attributes and metrics in each 3. 678 views 2 years ago MicroStrategy 2020. The Metric Editor opens in either Function Editor mode or Formula Editor mode, depending on the type of metric you chose to edit. From the Tools menu, select Report Options . When you upgrade your MicroStrategy software version, you may not want any changes in your data or in the look and feel of your application objects. Another important observation is not to forget to enable "Smart Metric”. 5. Export server-level settings and import them for use with another server. We recommend the latest version. To support best dashboard execution and concurrency performance, MicroStrategy has chosen to limit the number of logical CPUs engaged for any single grid evaluation to 4. Drag an attribute from the Datasets panel to the Rows area of the Editor panel. To accomplish this using the MicroStrategy Tutorial project in MicroStrategy Developer 9. Click here to view help for the latest version of this product or search MicroStrategy Community. Hover over the visualization to use as the source and click More in the top right and choose Select Target. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. Export Page. You can also apply a set of color and shading schemes to all the objects on a graph report. In Comments, enter @. This article might want you to upgrade faster to the newest version and enjoy all of the enhancements in creating your stories!. Make two grids with different attributes and metrics in each 3. Visualize Data Trends: Create intuitive visualizations to present data after it is parsed, structured and analyzed. To Create a Graph that Displays Markers in a Grid Layout. Measure: SLA Status = ISBLANK(SELECTEDVALUE('Alerts'[handledAt])) the results before adding data from dimension: everything works fine until I add data from dimension. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in one grid. How to Share a Dossier. Learn to share exact chapter level filter state of the dossier by embedding a filter in the comments. Create a Report Services Document 2. This means that two calling centers from different regions can share the same Call_Ctr_id. Open the dossier you want to modify. Notice that a joint child relationship can be one-to-many or many-to-many. This document provides the steps to accomplish the same. The spreadsheet retains the formatting of the report as displayed in MicroStrategy Web, such as colors, fonts, and structure. Compound metrics are the ones that are derived by some specific expression involving the different simple metrics. 6. Here the many-to-many relationship is converted into a compound attribute relationship. For example, given a report with Revenue and Cost, the custom subtotal will return total Profit, as shown below:A compound key attribute is an attribute that has two or more IDs. MSTR Secure Enterprise. Select only Configuration Objects for documentation. Limit the number of attribute elements displayed in a prompt in MicroStrategy. In the Gallery, click Compound Grid . Compensating Transactions. Row headers should appear at the top of the dossier instead of the middle, as it is set in the properties. Excel: This allows the user to export the document to Microsoft Excel in . You cannot place the widget in the Detail section of a document. Double-click the Column Set name to rename the set. The goal is to create an image link that is used to export the grid, like shown below: Document in Edit Mode Follow the steps below: 1. But this behavior can be changed by using the 'From Clause Order' VLDB property under the 'Joins' folder. Microstrategy Report Services documents vs Dashboards A MicroStrategy Report Services document reading data coming from manifold reports, equal the data laid out additionally designed in presentation-quality format. Users sometimes encounter the "Report returned no data" message when executing a report and are unable to display the report result as an empty grid instead. Custom grids allow you to utilize dynamic text fields in order to create grids that provide mo. Type the following for the name: "Total for the #P #0". 364 subscribers. 4 and later. Then it creates a third metric, a compound metric. This may make related application objects (reports, filters. Columns Panel. Open a dossier. A compound grid is a visualization that allows you to build complex grids that analyze different aspects of data across a common dimension. Drag an attribute from the Datasets panel to the Rows area of the Editor panel to add attributes to the rows. In the list of categories on the left, click Subtotals. Color from the Advanced Color Picker will. x, users can define a custom subtotal for a metric that returns a value that a compound level metric would return. MicroStrategy provides two types of attributes: normal attributes and hierarchical attributes. New workaround Attribute left outer join effect in MicroStrategy Web. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . Open a new or existing dossier. This means that every metric is evaluated in separate SQL passes. Community & Support Search Discussions Open A Case View My CasesExample 1: Compound key with Effective Date and End Date. The goal is to create an image link that is used to export the grid, like shown below: Document in Edit Mode Follow the steps below: 1. Right click on the Grid object and select Properties and Formatting to set Photo Uploader as the widget under Widget setting unchecking full screen for android phone as following. 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. Connecting MicroStrategy to TDV Using ODBC. Metric Qualification (MQ) Tables. MicroStrategy 2021 is the world’s first and only platform for HyperIntelligence™, federated analytics, and transformational mobility. The report-related objects placed on the template. The same metric exists multiple times on the grid. In MicroStrategy Analytics Enterprise Web 10 onewards, users can now simultaneously import two or more tables from one or more supported data sources, this feature is called Multi-Table Data Import (MTDI) which has been renamed as Super Cubes in MSTR 2019. In a document, you can display a report by adding a Grid/Graph to the document. Microstrategy Dossiers With the release of MicroStrategy 10. A compound key attribute is an attribute whose primary key is made up by the combination of two or more columns. [データセット] パネルで、アトリビュートとメトリックをダブルクリックし、ビジュアリゼーションに追加し. We recommend the latest version. A blank visualization appears in the dossier. If the. Select the Repeat attribute column checkbox to display the attribute. MicroStrategy is an enterprise BI application software. Create a compound metric "Count Employee" as "Count Employee temp" + "Zero" with the definition: ( + Zero) Under the "Subtotals/Aggregation" tab, enable the setting "Allow Smart Metric", at the bottom of the pane: Use the compound metric "Count Employee" on. Insert an HTML container (and not an image) and insert the script below. Finally, just create the report with the attribute (Category) and the third metric. E2open - MicroStrategy Training. Make two grids with different attributes and metrics in each 3. However, o n iPad with MicroStrategy Mobile 9. 1929 views | September 04, 2020 02:01. Create a Report Services Document 2. Create a filter with an element list or qualification prompt on an attribute. To enable totals or subtotals for a metric. Choose Grid > Compound Grid . x. If you have a joint child relationship in your data, it is important for you to define it in MicroStrategy so. 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. My org. J2EE environment:Year-To-Date Transformation Example. xls format. Creating Network Visualizations. Note the picture with the definition. This technical note outlines how consolidations work with compound metrics in MicroStrategy Developer. 1 - Answers all required prompts and optional prompts with default answers. Using Compound Grids. Create a new consolidation with three elements - Winter, Spring and Winter + Spring, as illustrated. In MicroStrategy Web 2019 and above, when running a dossier with row headers centered in the middle (vertically) of the grid, row headers do not appear correctly as you scroll down. Non-aggregatable metrics are defined using the dimensionality section of the metric editor. Locate the Request Geospatial key button above the products session and click on Mapbox Key : Each key is DSI specific. 3. replace (truncates and replaces the data) This Knowledge Base article introduces "mstrio," Python and R packages which provide an interface for the MicroStrategy REST APIs. Assuming CP1252As far as I tested, qualifying on multiple IDs of the same attribute is not possible in MicroStrategy, not even in version 9. Ø Local Transaction options. After the document is exported, the content of the document is displayed using the default settings in Microsoft Excel. Profit is not displayed on the Grid/Graph, nor is it in the data source for the Grid/Graph. New workaround Attribute left outer join effect in MicroStrategy Web Left outer join for attribute is unavailable in Developer by changing the VLDB settings in for the attribute and grid. A physical snapshot of the solution is: Each attribute has a 1-M relationship with its child. Although Item Sold is not on the template, since the temporary table containing data for Item Sold is outer-joined to calculate the compound metric, Unit Sales, Year 2001 appears in the final grid view. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. 4. Make two grids with different attributes and metrics in each 3. Update the data on an Intelligent Cube without having to republish the entire cube in MicroStrategy MicroStrategy has introduced a feature known as, Incremental Refresh Options, which allow Intelligent Cubes to be updated based on one or more attributes, by setting up incremental refresh settings to update the Intelligent Cube with. To use Natural Language Query, go to the Dossier Authoring interface (Web, Workstation, or Desktop), and click on the insight icon located at the top right corner: . 4. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in one grid. [データセット] パネルで、アトリビュートとメトリックをダブルクリックし、ビジュアリゼーションに追加し. This means that every calling center has its own unique ID. Subscribe. Made up of two or more grids of any type (column, modular, symmetrical, and asymmetrical) on one page, they can occupy separate areas or overlap. Step 1: Figure out how many electrons the molecule must have, based on the number of valence electrons in each atom. Creating a Compound Grid Visualization. Right-click the Grid/Graph, transaction table, or any of the text fields in the panel stack, then select Configure Transaction. Select the entire visualization or just the area you want to format. A connection map in MicroStrategy is a link between a MicroStrategy user, a database connection, and a database login. Microstrategy Dossiers With the release of MicroStrategy 10. Select the 'Advanced' tab, as shown. Creating a grid report. A Compound Grid stitches multiple simple Grid visualizations together to provide a more holistic grid view with richer data insights. Save the dashboard. Relate tables store information about the relationship between two attributes when one a parent of the other or vice-versa. This metric definition is shown below:MicroStrategy recommends using the latest Data Engine Version. ドシエを開きます。. When there are multiple datasets in a document, the grouping and sorting dataset is the one that is bolded in the Dataset. If you have a joint child relationship in your data, it is important for you to define it in MicroStrategy so. In MicroStrategy Web, click the metric for which you want to enable a grand total or subtotals. x-10. The different kinds of value prompts are: Date prompt: Users enter a specific date for which to see data. A report is a MicroStrategy object that represents a request for a specific set of formatted data from your data source. 1, the value range of the metric slider changes accordingly. Especially for you we decided to list and test the most interesting new features that MicroStrategy 2020 brings to dossiers. Click Advanced, then New to create a custom subtotal. Creating Geospatial Service Maps. Each custom format can have up to four. Open the Get Data menu and select the MicroStrategy Dataset connector under the Other category. This design may look strange, but in most cases there are. It is now possible to format column groups differently, freely alternate the placement of metrics and attributes in the column headers for each group of columns, or choose which columns of the Grid should show the subtotal value or all values. x and 10. With a few lines of code, data scientists can extract data from cubes and reports and publish entirely new datasets for consumption by other analysts. x-10. Every request to a MicroStrategy Web product corresponds to a specific event or action, which is. Compound Grid visualizations. E2open - MicroStrategy Training. 3. You can use MicroStrategy Web to create a Grid/Graph that contains objects from. Click the location on your document in which to place the widget. How to Share a Dossier. intelligence platform that adds in-memory delivery applications. The report should contain the attributes, metrics, and other objects that you want to use as columns in the data mart table and which will populate the data mart table. x allows users and administrators to decide if the attribute titles are displayed using the attribute name or the attribute form name: The setting to control the appearance of the attribute title is located under Preferences - Grid Display: Show Attribute Form Names. In our. Format Panel for Grid Visualizations. Note the next figure. In the top toolbar, click Insert Visualization . We're sorry. A compound grid is a visualization that allows you to build complex grids that analyze different aspects of data across a common dimension. Ultimately, it was. Microstrategy Dossiers With the release of MicroStrategy 10. 02K subscribers 26 7. 0 or above. Do not forget to enable Subtotal (F11). To accomplish this using the MicroStrategy Tutorial project in MicroStrategy Developer 9. 364 subscribers. With an OLAP Services license, user can perform additional OLAP analysis, using the following features: Displaying data on the fly: dynamic aggregation, page. Add, rearrange, or remove data from a visualization in a dossier. Microstrategy Dossiers With the release of MicroStrategy 10. The Grouping panel is displayed. Join data visualization specialist Len OToole of InfoCepts for this interactive. Introduced in MicroStrategy 2020, the Compound Grid is especially useful for financial analysis. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . A compound grid is a visualization that allows you to build complex grids that analyze different aspects of data across a common dimension. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in. The goal is to create an image link that is used to export the grid, like shown below: Document in Edit Mode Follow the steps below: 1. A Grid/Graph can be directly associated with one dataset report. MicroStrategy Library provides MicroStrategy reporting and analysis capabilities across all of your client interfaces. Right-click on the dossier once again. But, this can also be done with this. The following steps demonstrate how to do that in MicroStrategy Tutorial project: Import data into project and create dashboard. Microstrategy Dossiers With the release of MicroStrategy 10. Unfortunately I have a limitation/bug to report and ask about. This may make related application objects (reports, filters and. MicroStrategy Desktop's basic set of 40 colors matches the Excel colors. Steps to Reproduce on a Compound Grid. First, do "Change Visualization" on your grid and set it to "Compound Grid". The goal is to create an image link that is used to export the grid, like shown below: Document in Edit Mode Follow the steps below: 1. With MicroStrategy 2020 Patch Installer, our customers get centralized solution for applying critical fixes to any version of the. To use Natural Language Query, go to the Dossier Authoring interface (Web, Workstation, or Desktop), and click on the insight icon located at the top right corner: . Ca se functions Microstrategy Case functions return specified data in a SQL query based on the evaluation of user-defined conditions. This document provides the steps to accomplish the same.