x Number of Views 1. Add a dataset to a VI that contains a metric that is a string (“Metric Number” in this. To learn how to view dashboards, see Power BI dashboards. 8 by showing "no data" when user switches to the affected sheet and the dashboard CSI (Query Details of the visualization) would also show reference to the missing object. KB4377. This is a list of the available auto text macros that the Report Services Document engine recognizes. MicroStrategy is one of the leading business intelligence software that allows users to get some deep insights into the data trend by offering a plethora of analytical capabilities. These limitation will be removed in a soon to be released. Then you have to modify the users to assign the. 3. . Output Mode. Deploy your MicroStrategy Library application. 4 Easy to use new editor for MicroStrategy documents and dashboards from VitaraCharts plug-in. Visit the data visualization and data dashboard galleries for inspiration. But we can also add more than one data source to the same report. 4. “When we first started—and. Create a Visual Insight (VI) dashboard and insert as dataset a New Report with one attribute and one metric; at least one of the attribute elements should have value 0 for the metric chosen. 4 Hotfix 8. 13. 6. 2 and above, this can be integrated into a dashboard for easy navigation and user interaction. Right-click the Intelligent Cube, select "Schedule Delivery To" and choose "Refresh Cube". MicroStrategy Web opens, displaying the MicroStrategy Tutorial project as well as any other projects you have permissions to access. Excel: This allows the user to export the document to Microsoft Excel in . • Chapter 2, Importing Data into MicroStrategy Desktop describes how to import data into MicroStrategy Desktop, for use in creating dashboards. Web Run Dashboard. However, the one caveat is that data sometimes gets cut-off for the sake of the design of the dashboard. Login Developer with "tester", execute the VI dashboard created in step 1. The following auto text codes allow you to add document variable information to your document. 4, when creating a new derived attribute within a VI Dashboard, there is no option to define translation. This explains why these fonts are not included in MicroStrategy Products. None. Sample code for a simple login page using LoginPage. The following steps will create a set of 3 nested selectors. Several workarounds for this issue have been provided below for use in current releases. For example, this might be provided by a customer email attribute form of the Customer attribute. Collaboration in BI platforms can be important when creating new reports or dashboards. Diagnostic Analytics. Different View and Execution Modes. MicroStrategy Analytics delivers reports and dashboards, and enables users to conduct ad hoc analysis and share insights anywhere, anytime, via mobile devices or the Web. Right click the Revenue metric and go to Number Format, the Automatic option will be chosen by default;. Select 'Link to an existing Report or Report Services Document' option, as shown below: Select the desired Dashboard document and make sure to select Flash (html) as the document format type, as shown. This video shows a few tricks and tips to format and enhance your charts in MicorStrategy Dashboards. It offers an intuitive way to create and modify BI. g. mstrc) Open Workstation. Right click on the padlock symbol, click on Properties and Formatting. Logon to MicroStrategy Web using the Administrator user. 3. To configure the MicroStrategy Mobile Library app, visit the MicroStrategy. MyAttributeEqual2. They are the derived columns which show results such as sum or average of some numeric values of a column in source data. They are useful in creating custom calculations required by business. From the categories on the left, select Other > MicroStrategy for Power BI. You can immediately begin sorting, pivoting, and filtering data. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. Choose Pie > Pie Chart or Ring Chart . Create a new derived metric in a VI Dashboard with the formula below: Sum(IF((Year@ID=2014),Cost,0)){} 2. BI vendor MicroStrategy said today that its Desktop software is now free, adding to the affordable self-service BI landscape that includes Tableau Public, Microsoft Power BI and others. Do one of the following: To apply the selections as a filter, select the Apply selections as a filter for all new targets check box. The data mart table will be stored in this space. Insert an HTML container (and not an image) and insert the script below. Total value is shown sum of revenue, not the last value of fact table result. 1The update cache subscription will not refresh the cache created by VI Dashboard in MicroStrategy 10. URL API parameter to run a VI dashboard with a specified sheet selected Starting in 10. Save and assign a name to the file like “My_first_connection_file. Then click on get started to open dossier. How to rename "Total" in VI dashboard in MicroStrategy Web 10. Output Mode. Since Call Center has the “Denied All” ACL for the Demo user, only the Region and Units Sold are visible. Open a dossier. Ultimately, it was time to go beyond dashboards, both in concept and in name, and so the've renamed VI dashboards to ‘ dossiers ’. This Tutorial describes how to set a Dossier/VI Dashboard as the Default Start page in MicroStrategy Web. More, on Medium. This article demonstrates how to achieve the same in Report Service Document. STEP 1: Enable the MCE trace. When you re-prompt a VI dashboard that has apostrophe in it's name it fails to execute with a completely blank screen in MicroStrategy Web 10. 4. This KB article does NOT apply to:-Report/Document exporting To make those fonts available for Report/Document exporting in MicroStsrategy 10. This article explains how to programmatically set a selector in a dashboard using MicroStrategy SDK 9. Create a dashboard as follows: Panel 47 will be configured as the information window. Customize the format of the imported document; 3. Delete Unused Objects. 11, this visualization is provided out of the box. Right click on top of the regular attribute and the create attribute option won't be. Description: A demo that describes how to create and use MicroStrategy. When exporting a VI Dashboard to PDF, the titlebar does not fit the grid size in MicroStrategy Web 10. If you are looking for visualizations customized for MicroStrategy 9. Click Insert Visualization . 2. The following MicroStrategy SDK sample code demonstrates a zoom-able Heatmap by integrating a D3 Visualization in a Visual Insight Dashboard in MicroStrategy Web. 1. Note: Using the above URL will initially create the VI dashboard using the flash-based interface, as shown below: However, save the dashboard, close it, and rerun it from the folder browsing page and It will open up in HTML 5, as shown below: The MicroStrategy Internal Reference Number for the issue discussed in this technical note is DE24152. Step 3. 4 Hotfix 7. Navigate to the Visual Insight page in MicroStrategy Web, for example by creating a new dashboard. When we place some common attribute or metric in multiple visualization, it is easy to study the variations among them. This explains why these fonts are not included in MicroStrategy Products. 5 as shown below: STEPS TO REPRODUCE: Follow the steps below to reproduce the issue in MicroStrategy Tutorial project: Create a VI Dashboard. Select the Members tab. To open the demo visualization in MicroStrategy Web, choose: Create > Upload MicroStrategy File > View Dashboard. Save the document in the Object TemplatesDocuments folder. For custom visualizations to work in mobile, you need to also include the MobileBase plugin provided by microstrategy in the mobile plugins directory. 34K. Push-Down Derived Attributes for Live Connection Cubes. To create a document template. The list of supported hardware and Mobile OS versions remains the same as the MicroStrategy Mobile Platform App. Back then, the dossier editor (formerly known as Visual Insight) was a powerful BI tool with limited design functionality. Then click on New Document. A mobile dashboard is a data analytics tool used to track important key performance indicators (KPIs) and display them visually on a mobile device. javac, jikes, etc. Once you select the data from the source, the data is automatically. Study Resources. Create a semantic model from the dataflow to allow a user to utilize the data to create reports. The "All Objects" option is not available for the following types of reports: Freeform SQL Reports. This article describes how to create a metric with an attribute as a filter using a Case statement in a Visual Insight dashboard in MicroStrategy Web. MicroStrategy on AWS: Intro to Visual Insight. 4 - 10. 1, a user creates a Visual Insight dashboard and wants to remove “Convert to document” option in order to prevent other users from a conversion by mistake. They use data analytics platforms, reporting tools, and visualization techniques to turn raw data into meaningful insights that help organizations make informed decisions. Now your connection file is ready to be. Use Case 4. This video will go over MicroStrategy Visual Insight: What is Visual Insight (VI), What is a VI dashboard, Characteristics of a VI dashboard, Creating a VI dashboard, VI dashboard Panes, VI capabilities. Currently, it is not supported to keep the format when refresh RS document or VI dashboard from. In the worksheet menu, select Move to. Double-click the security role you want to assign to the user or group. The same attribute is modified so the forms are now: Form Name. Turn on Dossier Cache. Filters within the filter panel can be expanded, collapsed and re-arranged. This article describes an issue where subtotals for calculated group elements display double dashes (--) in VI Dashboards in MicroStrategy 10. On the VI dashboard toolbar click the Add Dataset drop down list and click from DATA ANALYSIS 102 at NIT RourkelaUse a report with a metric qualification prompt as a dataset a VI Dashboard/ Document with a heat map visualization. Microstrategy Dossiers With the release of MicroStrategy 10. Follow the steps below using the MicroStrategy Tutorial project: 1. . Add Region in Horizontal Axis. Compatible with all supported versions of MicroStrategy Desktop, Web, Library and Mobile. MicroStrategy can connect to any type of data including big data, flat files, social media data and so on. x. The following solution allows users to create a report giving them data for the current month and pevious months without creating transformations. Do one of the following: To apply the selections as a filter, select the Apply selections as a filter for all new targets check box. The drag-and-drop modules make building reports impressively interactive and engaging. We’ve evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . To apply the selections as a slice,. After creating custom threshold ranges and colors run the VI Dashboard/ Document. Follow the simple steps below to create a datamart report: 1. Security Filters are pretty much similar to normal filters, so you can play with them and figure out the best condition you want to use. Follow the steps below to display row numbers in one column on the report in MicroStrategy Developer 9. Follow the steps below to reproduce the issue in MicroStrategy Tutorial project: 1. Make two grids with different attributes and metrics in each 3. Add the Category attribute and the Revenue metric in a grid visualization. Creating a custom label on the grid requires a basic understanding of HTML. SYMPTOM When the VI Dashboard is executed from Web, there are XML & HTML5 caches created. How to easily create dossiers/ portfolios with MicroStrategy through a modern and intuitive drag-and-drop-interfaceIn this tutorial I show you how to create a beautiful dashboard that incorporates the ESRI mapping widget. The tool brings together previous Data Studio features with Looker’s new business intelligence. After Cube 1 created, create a Dashboard. To use the report as a data mart report, from the Data menu, select Configure Data Mart. The template should include the maximum number of attributes and metrics of any report that may use this autostyle. Create a new Custom Group by right-clicking on the right-pane of MicroStrategy Developer > New > Custom Group or File > New > Custom Group. “Dashboards have been critical in maximizing productivity and maintaining accountability of our teams,” says Frank Olivo of Sagapixel. Login Web with Administrator, Create a VI Dashboard based on this cube. 1. In this tutorial I show you how to create a beautiful dashboard that incorporates the ESRI mapping widget. Embed CRM Analytics dashboards in every Salesforce experience. Populate & Evaluate Stage. I will also demonstrate how to use panel stacks, s. SYMPTOM: Reports and Dashboards no longer display one of the two attributes that have been linked together in a VI Dashboard from cubes that are used as datasets. MicroStrategy Analytics cubes performance is best in the industry from performance point of view. Views 1538. Right mouse click on the report and choose "Create dashboard" 3. 6, a new parameter has been introduced in the URL API. KB248510. 4. Vitaracharts is now FREE for Desktop and Workstation. I will also demonstrate how to use panel stacks,. Before Customization: After Customization: Launch the Web Customization Editor. The columns correspond with each of the three required subscription properties: Physical address. 4. From VI Dashboard editor go to Republish Cube 5. And leverage the Page-By function to focus your analysis on one element. Users can also choose to display each filter in a different style as shown below, Users can select how each filter selector can target other filter selectors in the filter panel using the following three modes. 4. Emphasis on VISUALIZATIONS. 5. ANALYST VIDEOS & TUTORIALS. By linking dossier-style documents and dossiers together, you create the experience of a mobile app. Change visualization to Line chart. This editor contains the "Condition" field by default, so you are able to select your filter normally from the list. To take advantage of this feature, the user can either specify a key, which can be obtained via code or in the html; or they can specify the sheet based on the index. You can hold each employee to a specific KPI(s). Consume from Power BI Desktop To consume a dataflow, open Power BI Desktop and select Power BI dataflows in the Get Data dropdown. Easy to use new editor for MicroStrategy documents and dashboards from VitaraCharts plug-in. 2 – In the Form Expression window, select a Source table, in this case I am using the calendar dimension (LU_DAY). Users that are required to solely consume Visual Insight Dashboards without the possibility make changes or review dataset objects and filters, administrators may control functionality available to a given user or group through privileges: In order to prevent users from seeing the above panels, remove the Web Analyst privilege "Web Edit. What are the 3 key characteristics of VI Dashboards (Emphases)? Emphasis on SPEED. Create a report with: a. Labels or Tags are types of classification components that help to categorize elements. Open the document in Design or Editable Mode. xTo create an attribute in MicroStrategy with a fixed NUMBER value, follow the steps below:. x Number of Views 400 KB300312: When trying to use the ‘Use 1000 Separator (,)’ for fixed format in a VI dashboard for a metric; the setting wil… Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Introduction to Dossiers. In the Run Modes area, select the format (s) in which the document can be exported: •. MicroStrategy 10 Dossier (dashboard) enables dynamic links to reports with passing parameters. Assuming that a new Dashboard will contain 0 datasets, developers can insert logic to enable panels such as the "Add Existing Dataset" panel when a Dashboard has 0 datasets. x, derived attribute returns only filtered row from one of the blended dataset, or in some cases returns NULL rows when it's defined with two linked attributes which exists in multiple datasets in the dossier/VI dashboard with different filtering conditions. Observe the layout and color are different as shown below: CAUSE: This is a known issue with MicroStrategy 10. The steps to create a dashboard in Microstrategy are as follows: Click on Create on the left side of the Microstrategy web application. This article discusses how the two solutions fare in. Analyze Your Data. 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. Users can choose to build single visualizations, more complex dashboards, or enterprise applications by means of our fully-integrated AI chat technology. Query Stage: Retrieve data from the warehouse. In conclusion, these are just a few tips to optimize your dossiers. MicroStrategy URL Parameters. Dashboard. $40 per userWhy MicroStrategy Why MicroStrategy; Customer Stories; PlatformHere is the workaround to achieve the attribute left outer join on MicroStrategy Web. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformThe Import Data button does not work when creating a New Visual Insight Dashboard in MicroStrategy Web 9. . As known, MicroStrategy Web preferences can be. Another common situation with Parameterized Query will be combining multiple inserts of data into the database as a single query. The text fields can contain data, or can be filled in from the input object. The fuel for business dashboards is data, so each one needs to have one or more data sources. x ACTION: MicroStrategy will continue to investigate and post. A developer may need to know the number of datasets within a Visual Insight Dashboard. See more ideas about dashboards, dashboard design, dashboard. Business intelligence (BI) tools enable analyzing, discovering, and reporting on data to help executives and managers make more informed business decisions. A MicroStrategy user ID to be linked to the address. The following steps outline how to accomplish this: 1. Simple and minimal dashboard designs minimize clutter, enabling users to easily see and access dashboard elements. Create new solutions quickly in Power BI. One use case is to determine if a Visual Insight Dashboard is new. Create a Visual Insight dashboard in MicroStrategy Web. Web Edit Dashboard. Overall customer rating 9. The following diagram depicts the role of the intelligent cube. 3, 10. Report Services documents are fully supported (for viewing) in mobile. Telling a Story with MicroStrategy Dossier. Sorted by: 1. Speedier efficiency than direct warehouse queries. Interact in the Power BI service Collaborate with colleagues. This type of business analytics employs techniques such as drill-down, data discovery, data mining, and correlations to uncover the root causes of. A BI Developer is a professional who designs, develops, and maintains business intelligence solutions. Strong semantic layer to define all the business rules and tightly coupled. (Re-naming it Top Item Sales per Subcategory and Category). Compare all the important BI vendors with our 100% independent Business Intelligence tools comparison. x, no data is returned on the grid when a geo-attribute is directly added to a Dashboard via Web using the 'browse all objects' option. But cube 2 is not listed in the file system. For this check an attribute search is performed. Load Chapters on Demand. Select the same Excel file as Data Source and choose any Refresh Policy 6. This is a javascript. Skip the email. x. x: Create a metric called A with expression "Min(1){~}" as shown below. Create a panel stack. The report execution is typically a 3 step process process of the below: Query Stage. Add a graph matrix visualization. CAUSE: This is a known issue in MicroStrategy Web 10. . Users can take advantage of D3’s features and several of its wrapper libraries for making visualizations on VI Dashboards and Report Service documents . javac, jikes, etc. To add another Intelligent Cube to the dashboard's datasets, in the toolbar, click Add Dataset . The conclusion: Power BI wins on broad usage by a non-technical audience. Learn how to create a simple Visual Insight Dashboard in MicroStrategy Web. It shows many attributes grouped into separate visualizations. CAUSE: This is by design for MicroStrategy Developer 10. Description: A demo that describes how to create and use MicroStrategy D. It is an irreversible alteration to the existing VI dashboard once a document is saved thus it could mean that the Visual Insight dashboard has to be re-built a. This is a known issue in MicroStrategy Web. 11. x, include a customized ESRI map. Also note that there are some limitations for viewing VI dashboards in mobile. You will learn how to use various report components, filters, metrics, and prompts to design effective and interactive reports. MicroStrategy - Creating Dashboard. Right-click on the metric header to apply the condition or threshold and select 'Alerts': Specify the conditions to meet for the delivery to be triggered in the filter editor: Expand the Delivery Settings section. You can add visual representations of the data (that is, called visualizations) to the dossier to make your data easier to interpret, perform manipulations on the data to customize which information to display, and organize data into multiple chapters and pages to provide a. You can click the tab of a visualization to display it. 4. In Web Preferences under 'Default start page,' choose the report that was just executed as shown in the image below: Click 'Apply,' and this report will now. It also provides steps to create your first dashboard. Data labels for line chart display overlapped with the line in VI dashboard in MicroStrategy Mobile 9. How? Select Save As from the File menu. Watch the MicroStrategy team review how to build dossiers with governed data and security filters, ensuring end users get the interactive insights that they need. Modify the existing Custom Group Element. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Create a dashboard VI on MicroStrategy web 10. 5 for iPad STEPS TO REPRODUCE: On web, create a VI dashboard and choose Vertical Line- Absolute. The impact is limited to the 'browse all objects' option on dashboard in MicroStrategy Web 10. Ideally you can design an attribute/metric label in any style; in this example we are making a basic capsule style label. Click on the new frame and select the option to enlarge it to full-screen. 4. Example: It should be like 2nd dossier should be selected as Year=2017 and Month=Feb (as we have selected the same in Dossier 1) but we should also get the other elements in. STEPS TO FOLLOW: Create a new dashboard or document. A blank visualization appears in the dossier. Users that are required to solely consume Visual Insight Dashboards without the possibility make changes or review dataset objects and filters, administrators may control functionality available to a given user or group through privileges: In order to prevent users from seeing the above panels, remove the Web Analyst privilege "Web Edit Dashboard": To set a particular report to be the default start page in MicroStrategy Web, complete the following steps: Execute the report to be set as the default start page in MicroStrategy Web. Continue with the previous Steps 2 and 3 above. 5 quintillion bytes of data every day, and 90% of all data has been created in the last two years. Their answers provided us with data on the features most desired by those in the market for a business intelligence system. Create a user (tester) and disable the "web publish Intelligence Cube" privileges under Web Analyst. • Integrated MicroStrategy web application into Salesforce portal. MicroStrategy - Creating a Dashboard. Compatible with all supported versions of MicroStrategy Desktop, Web, Library and Mobile. In MicroStrategy 9. Our goal was simple — to build the next-generation dashboard editor. MicroStrategy Analytics delivers reports and dashboards, and enables users to conduct ad hoc analysis and share insights anywhere, anytime, via mobile devices or the Web. 1; Knowledge Base: KB322942: How to Create a Link to the Default MicroStrategy Web Home Page When a Different Default Start. Create the report with 3 attributes and 1 metric. If the qualification prompt is not answered the legend correctly reflects the threshold ranges and colors remain the same. x-10. Platform: Edureka Description: After completing the training, you will be able to create the solution for data visualization issues of any size on any platform and create, execute, monitor and schedule BI reports and dashboard processes. 0 - 10. To Create a Pie or Ring Chart. 1; Knowledge Base: KB322942: How to Create a Link to the Default MicroStrategy Web Home Page When a Different Default Start Page Is Configured in Web Preferences in MicroStrategy Web 9. Leveraging trusted data from MicroStrategy, watch as he shows how to build a Power BI dashboard and set up the data so that it refreshes daily. Creation of a metric involves using the in-built. It shows many attributes grouped into separate visualizations. 1. The Export Engine (EE) runs as an independent micro-service to export dossiers to PDF that comes with its own logging and troubleshooting steps. • Providing guidance to other. You can immediately begin sorting, pivoting, and filtering data. Use the Edit Links function to create a hyperlink to Target Report for each attribute. The next step is to create filters. Users ranked Qlik Sense® #1 in Performance Satisfaction, Dashboards, and Project Length in its peer groups. Get Started: Create a Basic HTML file. Continue creating the metric (for example, adding levels or conditionality) . Microstrategy provides an equal number of visualizations as Tableau Desktop and also provides the same features like it. Create a Visual Insight dashboard and add the above cube as the dataset: 3. This is a known issue in MicroStrategy Web. In Web, click New Dashboard. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. 1. import data into MicroStrategy Desktop, for use in creating dashboards. 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. MicroStrategy (Nasdaq: MSTR) is the largest independent publicly-traded business intelligence company, with the leading enterprise analytics platform. Flip through the panels in a panel stack. Using the export to excel option from the grid header outputs an Excel file with the full-screen content of the dashboard even though the desired content was only a grid from the dashboard . The Grouping Properties dialog box opens. 4. 2. 0 - 10. Gartner’s Magic Quadrant for BI and Analytics report will help. Now leverage trusted data to build a Power BI dashboard and even schedule dataset refresh cadence. This is a javascript. Tableau Desktop has a provision to connect to any kind of data source and provides numeral native data source connectors. Direct Cubes over View Reports. xIn MicroStrategy Web 10. Upgrade to this version to take. In MicroStrategy Mobile 9. Microstrategy Dossiers With the release of MicroStrategy 10. MicroStrategy also has an intuitive dashboard and tools within the panel. Microstrategy Web Advanced . 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. The following is an example of a 'Customer Geography' consolidation: Save the consolidation. It is based on a single data repository strategy, whereas Cognos has two metadata repository and database-based. Modules are organized around the business intelligence concepts, tools, and applications, and the use of data warehouse for business reporting and online analytical processing, for creating visualizations and dashboards, and for business performance management and descriptive analytics. 5. How to create a MicroStrategy connection file (. ), and execute Java programs. All articles. Create a report with one attribute and one metric. The binary generated for this mode is different from the binary generated for PDF. CASE 2. The Dashboard can be executed successfully. The 30+ free BI comparison graphs will give you instantly insight in the pros and cons. Open the Diagnostics and Performance Logging Tool from the MicroStrategy Intelligence Server machine. 0 or above, to pick up the fix, enable project level setting "Data Engine Version" to 11. x? QUESTION: In the MicroStrategy Enterprise Manager project, there is a report called "Reports Run by Date,". MicroStrategy URL Parameters. Create a compound metric called B with expression "RunningSum(A)" as shown below. Get inspiration at the MicroStrategy data dashboard gallery. . The next two steps are easy to follow: On the desktop page for large screen devices, add a basic Embed widget by dragging and dropping it into the main workspace. SYMPTOM: In MicroStrategy 10. Dossiers have additionally functionality and enhancements (collaboration, responsive design, enhanced user. 3. This KB article does NOT apply to:-Report/Document exporting To make those fonts available for Report/Document exporting in MicroStsrategy 10. How to show hidden objects? In the Datasets panel, click the arrow icon in the top right. Description: A short demo describing how panels, l. x. Upgrade to this version to take advantage of. com Format: A MicroStrategy Online Training Video blog. A pop-up box will appear. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. MicroStrategy - Creating Metrics. Selector two selects Region element. Note that for custom visualizations to work in mobile, you need to also include the MobileBase plugin provided by MicroStrategy in the mobile plugins directory. Bulk Insert. 3. 2. Timestamps:. So far we saw reporting with one source of data as the source. mstrc”. Without data, the dashboard will not show the user anything. and. Clear the Totals check box to remove the standard subtotals. The MicroStrategy Library can be accessed via the MicroStrategy Library App available on the Apple Store (for iOS) and Google Play Store (for Android). x, a workaround is available below: STEPS TO FOLLOW: 1. Starting in MicroStrategy 9.