Business intelligence (BI) tools enable analyzing, discovering, and reporting on data to help executives and managers make more informed business decisions. Right click the Revenue metric and go to Number Format, the Automatic option will be chosen by default;. x and edit it within Design. This KB article applies to:-Dossiers/VI Dashboards. Starting in MicroStrategy 9. An object prompt for one or more metrics placed on the columns. This video shows a few tricks and tips to format and enhance your charts in MicorStrategy. Labels or Tags are types of classification components that help to categorize elements. Expert Help. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. SYMPTOM In MicroStrategy 10. Ultimately, it was time to go beyond dashboards, both in concept and in name, and so the've renamed VI dashboards to ‘ dossiers ’. Selector three selects Quarter element. In the following example, we enable concurrency scaling on the Amazon Redshift cluster for the MicroStrategy dashboard queries. Add a graph matrix visualization. If the qualification prompt is. admin dashboard color palette analytics color scheme. 1 or more recent). MicroStrategy Dashboards allow any user to seamlessly transform MicroStrategy reports into interactive dashboards! So you display governed, high quality, secure and contextual data using a state of the art data visualization interface. To define a specific subtotal displays for a report like the one shown above, follow the steps below: Select Subtotals from the Data menu. Note that this visualization might not auto-size when exporting via PDF. Pros and Cons. Add additional column in the same Excel file 4. Design workflows, create content groups, or customize application components with the no-code framework. With concurrency scaling in place for the report queries, we can see a significant. Power BI Pro. Incorrect data is seen in a metric calculation of an aggregate from base derived metric with date attribute filtering in Dossier/VI Dashboard when the attribute join behavior is set to Outer Join To Lookup. Using Excel, there are several different kinds of filters we can create and add to a dashboard. Every request to a MicroStrategy Web product corresponds to a. 1 branch. Create a user (tester) and disable the "web publish Intelligence Cube" privileges under Web Analyst. Create a Visual Insight dashboard and add the above cube as the dataset: 3. This is a javascript. Click on the new frame and select the option to enlarge it to full-screen. The MicroStrategy Library can be accessed via the MicroStrategy Library App available on the Apple Store (for iOS) and Google Play Store (for Android). By linking dossier-style documents and dossiers together, you create the experience of a mobile app. Pages 272 Course Hero uses AI to attempt to automatically extract content from documents to surface to you and others so you can study better, e. With so much data, it’s become increasingly difficult to manage and make sense of it all. Ultimately, it was time to go beyond dashboards, both in concept and in name, and so the've renamed VI dashboards to ‘ dossiers ’. Microstrategy Dossiers With the release of MicroStrategy 10. The list of supported hardware and Mobile OS versions remains the same as the MicroStrategy Mobile Platform App. Navigate to the document in MicroStrategy Developer. ACTION This issue has been addressed with Microstrategy Web 10. A list of security roles in the project source opens in the main Developer pane. Microstrategy Dashboard performance improvements steps: Many times, causes of poor performance can be simplified to specific components. Sample code for a simple login page using LoginPage. Maulik Dhandhukia. In the Dashboard A, create three selectors: Selector one selects Category element. x, include a customized ESRI map. A text editor to create HTML files. Step 3. As known, MicroStrategy Web preferences can be modified to set a Report/RSD as the Default Start page as per: Ideas. You can immediately begin sorting, pivoting, and filtering data. Make sure the "Is hyperlink" property is checked. Upgrade to this version to take advantage of. Fully customizable with editors in Dossier or Web Report Services Documents (DHTML widgets) for appearance. The template should include the maximum number of attributes and metrics of any report that may use this autostyle. Microstrategy Dashboard performance improvements steps: Many times, causes of poor performance can be simplified to specific components. 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. 4 ToUltimately, it was time to go beyond dashboards, both in concept and in name, and so the've renamed VI dashboards to ‘ dossiers ’. The following diagram depicts the role of the intelligent cube. After applying the filter, click some of the values of the product category visible in the top bar filter section. For information on connecting to databases, see Connect to Databases. You must have the MicroStrategy Report Services product to view and create documents and RS. 1 and 10. However, In this instance only two datasets will be utilized, in order to create a separate worksheet for each dataset. You can disable the setting from the menubar: Format → Dossier Formatting → Disable highlight on hover for containers in Presentation mode. Inserting Panel Stacks ,Layouts ,Selectors and widget in Documents and Dashboard. 4. 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. Activities in Phase 2 place importance on agility and rapid business value, which is critical to gaining acceptance for the selection of a new BI tool. Dashboards and Widgets Creation Guide Creating Interactive Dashboards for your Data Version: 9. Creating a custom label on the grid requires a basic understanding of HTML. 1The update cache subscription will not refresh the cache created by VI Dashboard in MicroStrategy 10. Report Services documents are fully supported (for viewing) in mobile; There are some limitations for viewing VI dashboards in mobile. I have made a metric selector to visualize on a board, using an attribute with the name of the metrics and a metric with a 'case', the selector works fine, but the values are unformatted, some idea. Dossiers can be created by using the new Desktop product or Workstation or simply from the Web interface which replaces Visual Insights. Another common situation with Parameterized Query will be combining multiple inserts of data into the database as a single query. CASE 2. js. For example, the CEO of a technology company might want a personalized report or dashboard of focus group data on a new product within 24 hours. Load Chapters on Demand. The same attribute is modified so the forms are now: Form Name. x, text in documents still default to that font. The binary generated for this mode is different from the binary generated for PDF. 4 Hotfix 7. import data into MicroStrategy Desktop, for use in creating dashboards. Also, delivering a mobile dashboard with a minimal set of. This editor contains the "Condition" field by default, so you are able to select your filter normally from the list. Get the basics down. Visual Insights dashboards in Microstrategy 11? Dossiers are essentially the next generation of VI dashboards. One use case is to determine if a Visual Insight Dashboard is new. 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. Tableau Desktop has a provision to connect to any kind of data source and provides numeral native data source connectors. You can use the Custom Visualization API to create tooltip functionality using third-party plotting libraries like D3. 1, please check the 9. MicroStrategy URL Parameters. 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. Right mouse click on the report and choose "Create dashboard". It also combines the agility and productivity of self-service visual data discovery with the security, scalability, and governance features of enterprise-grade business. 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. 9% to $59,675,000, while their short-term investments were reduced 100% in the. Our public API makes it easy for data professionals to automate clear, written explanations of their MicroStrategy visualizations. SYMPTOM When the VI Dashboard is executed from Web, there are XML & HTML5 caches created. A mobile dashboard is a data analytics tool used to track important key performance indicators (KPIs) and display them visually on a mobile device. x ACTION: MicroStrategy will continue to investigate and post. Supports aggregation, which is dynamic. About your question, check page 394, Dashboard Editor: Grid: Format. 1 the ability to link between cubes was introduced, however this only works when linking cubes that are created with. MSTR's Test) - Run the. Report Services documents are fully supported (for viewing) in mobile. Number of Views 509. When it comes to Microstrategy vs PowerBi, here are the main aspects: There is a possibility to use MicroStrategy as a source in Power Bi report, which is a powerful Microstrategy tool. At this point, we have created our two reports for our basic dashboard. The Select Dataset dialog box opens. Convert the Visual Insight dashboard to a document. MicroStrategy Parameterized Query feature for better performance. All articles. MyAttributeEqual2. Using MicroStrategy Tutorial warehouse, create a Data Import cube with following tables and relationships as. You will learn how to use various report components, filters, metrics, and prompts to design effective and interactive reports. 5 for iPad. This is fixed in MicroStrategy Mobile 10 application for iPad. The Security Role Editor opens. To troubleshoot performance issues, users must identify these components, then make the appropriate modifications to the environment and/or to the MicroStrategy dashboard to reduce bottlenecks. x. Before Customization: After Customization: Launch the Web Customization Editor. 4. jsp file that you downloaded or create a JSP file that defines your custom login page. Also provided Before / After versions of these charts in the 2 attached dashboards (using MicroStrategy 10. Metrics in MicroStrategy are the calculations performed on data. 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. 6. Also, users can share data and visuals without obstacles. An Update Cache subscription is not specific to mobile devices and can be used to create caches that are consumed by either MicroStrategy Web or mobile devices. 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. Right-click the Intelligent Cube, select "Schedule Delivery To" and choose "Refresh Cube". Creating your custom visualization typically requires only a few steps:To avoid this, MicroStrategy uses intelligent cubes, which is an object sitting in the middle layer between reports and the warehouse. Polymer lets you connect data sources and explore the data in real-time through interactive dashboards. CAUSE: This is by design for MicroStrategy Developer 10. You can navigate the panel and access the tools and built-in templates with ease, so you can create visualizations and share the insights immediately to others. For example, this might be provided by a customer email attribute form of the Customer attribute. A pie or ring chart requires at least one attribute and one metric. Our goal was simple — to build the next-generation dashboard editor. 1. Create a report with: a. 1. x and MicroStrategy Desktop 9. Answer: Go with dossier. Format this dashboard yourself with the help of this 2 minutes video and before/after dashboard samples. Avoid Duplicated Datasets. These auto text codes are automatically replaced by information about the document. To troubleshoot performance issues, users must. MicroStrategy - Creating Dashboard. Login to MicroStrategy Web ; Create a new VI dashboard and notice that the two properties are missing: CAUSE. 4 Hotfix 8. 4 Hotfix 4, within the “MicroStrategy Tutorial”, create a new VI dashboard. Step 2: Add views to your dashboard by dragging sheets onto the dashboard. Navigate to the Visual Insight page in MicroStrategy Web, for example by creating a new dashboard. This article explains how to programmatically set a selector in a dashboard using MicroStrategy SDK 9. In MicroStrategy Developer, locate the Intelligent Cube that needs to be refreshed. 4 Document Number: 09500940 Third Edition, version 9. ETL. Visit the data visualization and data dashboard galleries for inspiration. This is a first of many Dashboard videos and focuses on creating Dashboard templates that are reusable and can be moved between projects and project sources. Here’s what we found: The most important types of business intelligence tool features and functionality are: Dashboards. Add metrics: Revenue, Profit and Cost to Vertical Axis. CAUSE. This type of business analytics employs techniques such as drill-down, data discovery, data mining, and correlations to uncover the root causes of. However, the one caveat is that data sometimes gets cut-off for the sake of the design of the dashboard. Best practices to design or utilize mobile dashboards in offline mode in MicroStrategy Mobile. A set of data is returned from the. The tool brings together previous Data Studio features with Looker’s new business intelligence. xIn MicroStrategy Web 10. Command. Drag and drop the . ACTION. 2 Click the project to log in to. 3, 10. For this check an attribute search is performed. CAUSE This is a known issue with MicroStrategy 10. This explains why these fonts are not included in MicroStrategy Products. From the Elements menu, choose Add Element. Users can take advantage of D3’s features and several of its wrapper libraries for making visualizations on VI Dashboards and Report Service documents . 3. b. To view the current status of a MicroStrategy Intelligence Server Universal instance in a UNIX/Linux environment, run the command ‘mstrctl -s IntelligenceServer gs’ from the <MicroStrategy HOME>/bin directory using a command prompt / terminal. )Victor Oliveira - Sales EngineerOrganizations struggle with making the lives of business users easier and with less steps on the process of self-service anal. $40 per userWhy MicroStrategy Why MicroStrategy; Customer Stories; PlatformHere is the workaround to achieve the attribute left outer join on MicroStrategy Web. Can be used to create visualizations connected to Excel, CSV, and JSON files. 3. . “Dashboards have been critical in maximizing productivity and maintaining accountability of our teams,” says Frank Olivo of Sagapixel. Create a Visual Insight dashboard in MicroStrategy Web. Create Dashboard A with the above report as the dataset. This article explains how to programmatically set a selector in a dashboard using MicroStrategy SDK 9. Click Advanced, then New to create a custom subtotal. 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. 3. The demo also covers Dashboard export settings. You cannot place the widget in the Detail section of a document. A widget is a Flash-based display of the results of dataset reports, allowing users to visualize data in different ways than traditional reports displayed as Grid/Graphs do. One use case is to determine if a Visual Insight Dashboard is new. Learn how to create a simple Visual Insight Dashboard in MicroStrategy Web. Delete the cube cache from cube monitor. com Format: A MicroStrategy Online Training Video blog. 1 Answer. This article demonstrates how to achieve the same in Report Service Document. Insert as dataset a New report with Category and Item attributes and. A scenario may exist where developers would like to design dashboards for particular end users for use while not actively connected to the Internet. 1. From the left, click Document. Export to PDF. 3. An online search reveals that MicroStrategy has less market penetration than Tableau. None. From the Tools menu, select Document Properties. Configure all prompts to be Dynamically answered. MicroStrategy Analytics cubes performance is best in the industry from performance point of view. Add a second visualization just so that the graph matrix is pushed into a narrower size. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformIntroduction to Dossiers. After selecting the blank dashboard, unlock it from the Options. In MicroStrategy Web, create a grid report containing at least three columns. Different View and Execution Modes. There are various applications of MicroStrategy. 11. Show more. g. Unfortunately, this often results in different copies of. A dossier is an interactive display that you can create to showcase and explore business data. Create a report with: MicroStrategy 9, MicroStrategy Distribution Services, MicroStrategy MultiSource Option, MicroStrategy Command Manager, MicroStrategy Enterprise Manager, MicroStrategy Object Manager, MicroStrategy Reporting Suite, MicroStrategy Power User, MicroStrategy Analyst, MicroStrategy Consumer, Attribute is lost from reports/dashboards that use a cube whose attribute was linked to another attribute in a VI dashboard in MicroStrategy 9. 4. Visit the data visualization and data dashboard galleries for inspiration. Performance Implications of Large and Complex Dossiers. Place the newly created consolidation in the template. Add a dataset to a VI that contains a metric that is a string (“Metric Number” in this. Point to Show Hidden Objects. For steps to create visualizations and analyze data in VI dashboards, see the MicroStrategy Web Help . Then you have to modify the users to assign the. 5 for iPad. This video will go over MicroStrategy Visual Insight: What is Visual Insight (VI), What is a VI dashboard,. They are insightful and interactive consoles that use configurable elements (such as search results, lists, filters, matrixes, gauges, and charts) to drill down into data, analyze, predict trends. x. 5 quintillion bytes of data every day, and 90% of all data has been created in the last two years. MicroStrategy makes it easy for you to generate enterprise reporting, dashboards, scorecards, notifications, etc. Autotext code/macros in Microstrategy Document/dashboard. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. Intro to VI. Save the report as "Target Report". To apply the selections as a slice,. • Chapter 3, Creating Dashboards and Visualizations describes how to create and format a. Some of the main features offered by MicroStrategy are Advanced Analytics, Data Discovery, Data Visualisation, Embedded BI, and detailed reports and statements. KB248510. 4. MicroStrategy vs Power BI. In MicroStrategy Web, edit or execute a report. 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. 160. Report created with Intelligent Cube. MicroStrategy 10 Certification Training. The Document Properties dialog box opens. Create, share, and maintain dashboards and dossiers. 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. Alternatively, instead of creating conditional metrics inside a dashboard, you can create them as standalone objects in the folder structure. Easy to make weekly changes based on stakeholder feedback. This issue has been addressed in MicroStrategy 10. 4. Enter a name for the. This function allows you to. Before Customization: After Customization: Launch the Web Customization Editor. In the Table/Range field, click the icon at the end and and select your whole data. Web Run Dashboard. Make planning, designing, and implementing a solution easy. September 22, 2023. All visualizations will be publicly viewable. 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. Python and R wrappers for the MicroStrategy REST APIs Connecting. Gartner’s Magic Quadrant for BI and Analytics report will help. ANALYST VIDEOS & TUTORIALS. 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. Now your connection file is ready to be. Create a document using these two reports as datasets. Users can choose to build single visualizations, more complex dashboards, or enterprise applications by means of our fully-integrated AI chat technology. MSTR's Test) - Run the newly saved VI and answer. Open the document in Design or Editable Mode. Output Mode. Data can be connected through an API, flat file, or database. Vitaracharts is now FREE for Desktop and Workstation. Note however, that MicroStrategy Technical Support does not make recommendations related to tuning or performance of individual MicroStrategy Intelligence Server and operating system configurations. In the Datasets panel, double-click attributes and metrics to add them to the visualization. Report Services documents are fully supported (for viewing) in mobile; There are some limitations for viewing VI dashboards in mobile. A new VI dashboard opens, with the Intelligent Cube added to the Dataset Objects pane. Learn more. Create a report with DAY, GROUP, PLANT, and metrics Sum MTD, and Replace Total. To learn how to view dashboards, see Power BI dashboards. Add the data to a graphical representation, such as a bar graph or pie chart. A VI dashboard is a customized, interactive display that you can use to explore your business data. Create a Report Services Document 2. MicroStrategy Web opens, displaying the MicroStrategy Tutorial project as well as any other projects you have permissions to access. You can immediately begin sorting, pivoting, and filtering data. A sales team might use a business dashboard to connect data. Seen from an end-user perspective the split between VI and Document becomes confusing and it also demonstrates how MicroStrategy represent a much more closed ecosystem than Tableau because of the. A blank visualization appears in the dossier. Since Call Center has the “Denied All” ACL for the Demo user, only the Region and Units Sold are visible. The columns correspond with each of the three required subscription properties: Physical address. 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. 2. If you are looking for visualizations customized for MicroStrategy 9. AI Homework Help. The overall sort order is evaluated and stored in the attribute definition when the attribute is saved. 2. 4. We create a user group in Amazon Redshift, and all the dashboard queries are allocated to this user group’s queue. In conclusion, these are just a few tips to optimize your dossiers. mstrc) Open Workstation. With the release of MicroStrategy 10. While it comes at a higher cost of approximately $70/month, Tableau offers significant advantages. Number of offices 3. Create or edit. Dossiers automatically adjust to look great on any screen. 13. The "All Objects" option is not available for the following types of reports: Freeform SQL Reports. Knowlegde Base: KB258959: New feature for setting My Page as the default start page in MicroStrategy Web 10. Community & Support Search Discussions Open A Case View My CasesFollow the steps below using the MicroStrategy Tutorial project: 1. 4. Format this dashboard yourself with the help of this 2 minutes video and before/after dashboard samples. As of MicroStrategy 10. 4. 2. Dossiers automatically adjust to look great on any screen. Edit the dashboard created in Step 4. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. Answer: Go with dossier. Examples here will be in Notepad++ but your preferred editor is perfectly fine. Cross-tab Stage: Pivot and display sorting and page-by. To change the order of the transformations, select a transformation and use the directional arrows to re-position it. In MicroStrategy Web 9. 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. 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. In the second phase, self-service BI authors can begin using and evaluating Power BI for their needs, and value can be obtained from Power BI quickly. How? Select Save As from the File menu. For testing, you can use any dashboard published to Tableau Server / Tableau Cloud. “When we first started—and. Ultimately, it was time to go beyond dashboards, both in concept and in name, and so the've renamed VI dashboards to ‘ dossiers ’. This will change the diagrams, depending on the value selected. The conclusion: Power BI wins on broad usage by a non-technical audience. 0 - 10. Make two grids with different attributes and metrics in each 3. In this Custom Group Element, add a set qualification on the metric that will be ranked (in this case. Data Mining. A code fix for this issue is available in MicroStrategy Secure Enterprise 10. Follow the steps below to reproduce the issue in MicroStrategy Tutorial project: 1. 70 (free if you have Office 365) Provides access to individual users and enables them to build their own dashboards and connect to a wide range of data sources. Require users to answer prompts. Double-click the security role you want to assign to the user or group. Select the type of widget from the Widget drop-down list. They are useful in creating custom calculations required by business. Also note that there are some limitations for viewing VI dashboards in mobile. WORKAROUND STEPS: 1. Create a custom subtotal with desired name in dataset report. 4. x. From VI Dashboard editor go to Republish Cube 5. MicroStrategy Web provides a wide range of parameters that can be used in combination to achieve different types of requests. 4. Create or open the document to be used as a template. Output Mode. This explains why these fonts are not included in MicroStrategy Products. 1. You can create two security filters, let call them: MyAttributeEqual1. When you use a worksheet to create a dashboard, the worksheet itself is removed from the Worksheets page. Drag an attribute from the Datasets panel to the Rows area of the Editor panel to add attributes to the rows. Enable the data labels on the graph matrix visualization. Once you have your design requirements, we can begin looking at the different authoring capabilities between a dossier and a document. 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 Basic Reporting Guide is a comprehensive manual that teaches you how to create, execute, and analyze reports using MicroStrategy. The example provided in this document is provided “as-is” to the user and assumes that the user: Can program, compile (e. Creation of a metric involves using the in-built. The Dashboard can be executed successfully. Description: In this MicroStrategy tutorial for beginners video, you will learn MicroStrategy from scratch, starting with a comprehensive introduction, MicroStrategy installation, how to create. Add a personal comment or start a conversation with colleagues about a dashboard, right there on that dashboard. Login Developer with "tester", execute the VI dashboard created in step 1. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. When exporting a VI Dashboard to PDF, the titlebar does not fit the grid size in MicroStrategy Web 10. 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. Browse and incorporate these templates into your own data dashboards. Create a derived metric (“New Metric”) with the following syntax: Sum([Metric String]){~+, [Attribute 2]+} Add that metric in a grid visualization, you will notice the cells are blank: Setting a threshold on a derived metric using the max function. Make sure that the ‘Enable email notification to administrator for failed cache creation’ option is checked, and that an email address has been entered. This is fixed in MicroStrategy Mobile 10 application for iPad. This video shows a few tricks and tips to format and enhance your charts in MicorStrategy Dashboards. These limitation will be removed in a soon to be released. 7: STEPS TO REPRODUCE - Create a dataset with a prompt - Create a new VI and add the prompted dataset - Save the VI with a name that has an apostrophe (ex. The email will contain a URL API link to the dashboard, however, in MicroStrategy Distribution Services 10. 2 and above, this can be integrated into a dashboard for easy navigation and user interaction. 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. SYMPTOM: In MicroStrategy 10. hex colors for dashboard how to make excel graphs look professional html colors for dashboard kpi template line. mstr file. CAUSE This is a known issue with MicroStrategy 10.