how to create a vi dashboard in microstrategy. Create or edit. how to create a vi dashboard in microstrategy

 
 Create or edithow to create a vi dashboard in microstrategy  Add a dataset to a VI that contains a metric that is a string (“Metric Number” in this

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. Add the Call Center attribute to the rows, then remove it from the grid, and save the. For steps to create visualizations and analyze data in VI dashboards, see the MicroStrategy Web Help . This article explains how to programmatically set a selector in a dashboard using MicroStrategy SDK 9. 4. 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. The 30+ free BI comparison graphs will give you instantly insight in the pros and cons. In Flash Mode in MicroStrategy Web, the Grid/Graph displays as this type of widget. 5. Polymer lets you connect data sources and explore the data in real-time through interactive dashboards. Cross-tab stage. 2. The purpose of this feature is to allow a user to execute a dashboard and when the dashboard is returned it will have selected specific sheet. After converting a VI Dashboard to a document, the ‘Export to Excel’ option is not available when executing the document: CAUSE The ‘Export to Excel’ option is disabled by default in converted documents. Best practices to design or utilize mobile dashboards in offline mode in MicroStrategy Mobile. 4 and 10. Observe the layout and color as below: 3. ; In Name, enter a name for the calculated member. Telling a Story with MicroStrategy Dossier. xTo create an attribute in MicroStrategy with a fixed NUMBER value, follow the steps below:. To open the demo visualization in MicroStrategy Web, choose: Create > Upload MicroStrategy File > View Dashboard. Fast-forward to the business intelligence dashboards that are available today: dashboard visualization has become an industry standard that is widely adopted by analytics professionals, students, and directors of. Create an Intelligent Cube, with Region, Category, Cost and Profit. Design workflows, create content groups, or customize application components with the no-code framework. Show more. MicroStrategy can connect to any type of data including big data, flat files, social media data and so on. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformNew feature was introduced that allows users to add buttons to dashboards in MicroStrategy Web 9. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . Data Mining. You'll find user-generated examples showcasing a variety of use cases such as financial or retail sales analysis. Browse and incorporate these templates into your own data dashboards. Create three reports named A (with attribute A), A&B (with attribute A and B),A&C (with attribute A and C) Create a dashboard based on the three reports created in last step. To configure the MicroStrategy Mobile Library app, visit the MicroStrategy. 3. Place the newly created consolidation in the template. $13. CAUSE: This is by design for MicroStrategy Developer 10. You can also display Visual Insight (VI) dashboards on an iPad with MicroStrategy Mobile. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. Learn more. 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. A VI dashboard is a customized, interactive display that you can use to explore your business data. A demo that describes how to create and use MicroStrategy Dashboards. The comment feature is just one of the ways you can collaborate with others. Run the following. However the options to link - unlink attributes are available in other dashboards. Limit the Use of Derived Attributes or Metrics. If the New Document dialog box is not. xComing to usage, Tableau offers the visual analysis of data rapidly. Supports aggregation, which is dynamic. In this tutorial I show you how to create a beautiful dashboard that incorporates the ESRI mapping widget. 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. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformThe Import Data button does not work when creating a New Visual Insight Dashboard in MicroStrategy Web 9. • Trained users in creating VI dashboard and MicroStrategy driven data mining capabilities. Use this as a template:Learn more at us on LinkedIn at article addresses the first challenge by providing three professional color combinations for your next MicroStrategy, Tableau or Power BI data visualization project. Supports the creation of derived metrics. Add. mstrc) Open Workstation. Get inspiration at the MicroStrategy data dashboard gallery. 4 Easy to use new editor for MicroStrategy documents and dashboards from VitaraCharts plug-in. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. Create a Report Services Document 2. Tableau Desktop provides a considerable big set of visualizations. 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. Specify the desired delivery options including recipient address, subscription name. Once you upgrade your existing environment to the latest version, all of your VI dashboards will be converted to Dossiers. How to show. Loading. Power BI Pro. Enable the data labels on the graph matrix visualization. Add external dataset from an Excel file 3. Now explore the schema attribute in MicroStrategy's Workstation which allows you to create and edit the attributes such as facts, logical tables, metrics inside your workstation. In the worksheet menu, select Move to. Create a Visual Insight dashboard and add the above cube as the dataset: 3. Drag an attribute from the Datasets panel to the Columns area of the Editor panel to add attributes to the columns. Create another report with Year in the rows, and Revenue in the columns. x, what is the difference between the "Create New Report" option. Create a user (tester) and disable the "web publish Intelligence Cube" privileges under Web Analyst. This will only color every other row of your grid. Export to PDF. 6K views 5 years ago. A new VI dashboard opens, with the Intelligent Cube added to the Dataset Objects pane. 3. The Select Dataset dialog box opens. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformMicroStrategy for Jupyter is an extension for Jupyter Notebook which provides a graphical user interface for mstrio-py methods with the help of which user can perform all of the import and export actions without writing a single line of code manually. 1 some of the Dashboards do not have the option to link or unlink attributes. 6. Create a new Custom Group by right-clicking on the right-pane of MicroStrategy Developer > New > Custom Group or File > New > Custom Group. Description: A demo that describes how to create and use MicroStrategy D. 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. The parent element appears in Parent. Select the Members tab. 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 ’. 7 and below. Connect to MicroStrategy using Power BI Desktop. After Cube 1 created, create a Dashboard. Change the formatting of the percent to total with the appropriate settings (decimal places, negative value formatting, etc). AI Homework Help. Creating Documents and Dashboard. Select the same Excel file as Data Source and choose any Refresh Policy 6. Answer: Go with dossier. Avoid Images on Thresholds. 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. Dashboards executed in Flash mode require Flex Binary for the data and XML generation for the Dashboard definition. 1 – In MicroStrategy Developer, navigate to the folder where you wish to create the attribute, right-click in it and select New > Attribute. 0 - 10. Sample. This KB article applies to:-Dossiers/VI Dashboards. KB219997: The "Send notification to email. Create a dashboard and add the objects as shown below. It also provides steps to create your first dashboard. The course also lets you analyze MicroStrategy data flow. Data Visualization- The tool has great function of creating Dashboards which are specially useful for higher management to review it. CAUSE This is a known issue with MicroStrategy 10. MicroStrategy offers an intuitive way to create and modify business. Create a VI dashboard and use the report created in step 1 as the underlying dataset. All the existing visual Insights dashboards will be converted to. 2987. 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. Followers. Dossiers. The impact is limited to the 'browse all objects' option on dashboard in MicroStrategy Web 10. Right click on top of the regular attribute and the create attribute option won't be. Then click on New Document. The worksheet query is stored in the dashboard and can be modified in that context. With concurrency scaling in place for the report queries, we can see a significant. Create an Intelligent Cube, with Region, Category, Cost and Profit. The simplest way to design nested or cascading selectors is to design the entire dashboard first and leave the creation of the selectors to the very end. 5 for iPad STEPS TO REPRODUCE: On web, create a VI dashboard and choose Vertical Line- Absolute. Observe the layout and color are different as shown below: CAUSE: This is a known issue with MicroStrategy 10. Save and assign a name to the file like “My_first_connection_file. The following steps will add a toolbar item in MicroStrategy Visual Insight Dashboards using the MicroStrategy Web SDK 10. If you want something more advanced, like colors based on values in the cells, you should use thresholds. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. 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. From the left, click Document. It would be impossible for any single person to wade through data line-by-line and see distinct patterns and make. Use the Edit Links function to create a hyperlink to Target Report for each attribute. School NIT Rourkela; Course Title DATA ANALYSIS 102; Uploaded By DeanElectronHummingbird14. Visualization with Multiple Datasets. 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. g. 4 Hotfix 7. Dashboard. x, a workaround is available below: STEPS TO FOLLOW: 1. A developer may need to know the number of datasets within a Visual Insight Dashboard. • Chapter 3, Creating Dashboards and Visualizations describes how to create and format a dashboard, and ad d visual representa tions of the data In MicroStrategy 10. If the qualification prompt is. Each input object on the Transaction Services report needs a separate text field. From the Tools menu, select Document Properties. The steps to create a dashboard in Microstrategy are as follows: Click on Create on the left side of the Microstrategy web application. This Tutorial describes how to set a Dossier/VI Dashboard as the Default Start page in MicroStrategy Web. 1, please check the 9. Right-click the Intelligent Cube, select "Schedule Delivery To" and choose "Refresh Cube". Select Don't warn. A dashboard is made up of multiple visualizations. To successfully link attributes between datasets at the document/dashboard level, a set of rules need to be followed. Create a user (tester) and disable the "web publish Intelligence Cube" privileges under Web Analyst. x. Add a second visualization just so that the graph matrix is pushed into a narrower size. MSTR's Test) - Run the. 6 or above, ensure the steps in KB441194 are also implemented. 4. Customize the format of the imported document; 3. 3. 3. In the right corner of the dashboard, change the data source to none. The demo also covers Dashboard export settings. ETL. 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. The fuel for business dashboards is data, so each one needs to have one or more data sources. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform D3 Visualization is supported starting from MicroStrategy. In MicroStrategy Mobile 9. The example provided in this document is provided “as-is” to the user and assumes that the user: Can program, compile (e. KB248510. In MicroStrategy Mobile 9. Upgrade to this version to take advantage of. 2. 1 or more recent). I will also demonstrate how to use panel stacks,. In MicroStrategy 10, user is able to hide dataset objects in dataset panel in VI dashboard/Dossier by right mouse click on the object and select Hide. 04K subscribers. Adding External data from various sources to. In the Select Dataset dialog box, navigate to the Intelligent Cube that you want to use for the dashboard. Autotext code/macros in Microstrategy Document/dashboard. Our goal was simple — to build the next-generation dashboard editor. However, there is still a way for users to view back-end data in a Visual Insight dashboard. The Security Role Editor opens. This KB article applies to:-Dossiers/VI Dashboards. 4 ToUltimately, it was time to go beyond dashboards, both in concept and in name, and so the've renamed VI dashboards to ‘ dossiers ’. MicroStrategy Workstation Become a More Intelligent Enterprise Whether you're working with dossiers, cards, documents, or managing an entire intelligent enterprise, Workstation empowers you to do everything from one place. 4. It supports interactive dashboard, highly detailed reports, ad-hoc query, automated report dispute, and Microsoft Office integration. MicroStrategy vs Power BI. After applying the filter, click some of the values of the product category visible in the top bar filter section. Inside the panelstack, add a HTML container which has the URL to point to a report/document/VI dashboard within the same project (make sure this target report/document/VI dashboard has a prompt built on top of the attribute used in the selector B) Create a VI dashboard using the Category Sales Report. Follow the steps below to reproduce the issue in MicroStrategy Tutorial project: 1. To create a new data-set, click on Add. 4. Over 12+ years of experience in Data Warehousing & Business Intelligence application development, maintenance and various project implementations11+ years of IT experience with strong expertise in using MicroStrategy tool Suite as Reporting, dashboard and Administration. Direct Cubes over View Reports. Now your connection file is ready to be. Dossiers can be created by using the new Desktop product or. Web Edit Dashboard. Add a dataset to a VI that contains a metric that is a string (“Metric Number” in this. Add metrics: Revenue, Profit and Cost to Vertical Axis. Choose one of the following: Save the metric. Confirm by hitting Republish and then Done 7. These auto text codes are automatically replaced by information about the document. Grouping Multi-select elements and define a group. In this way, your dossier creates & Displays. CAUSE This is a known issue with MicroStrategy 10. 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. You can create two security filters, let call them: MyAttributeEqual1. . We’ve evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . Dossiers can be created by using the new Desktop product or Workstation or simply from the Web interface which replaces Visual Insights. CAUSE. 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. Have strong skills in Microstrategy,Teradata, Oracle, Tableau &. According to the World Economic Forum, the world produces 2. Tableau is a better Power BI alternative. 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. Create a Dashboard 2. Then you have to modify the users to assign the. If you do not use a Consolidation or Custom Group and right click on an attribute, the Create attribute option will be displayed. Ultimately, it was time to go beyond dashboards, both in concept and in name, and so the've renamed VI dashboards to ‘ dossiers ’. After creating custom threshold ranges and colors run the VI Dashboard/ Document. x. 4. admin dashboard color palette analytics color scheme. They have a background in data analysis and possess strong technical. Reports. . Answer: Go with dossier. From the Insert menu, point to Widgets, and then select Microcharts. To define a specific subtotal displays for a report like the one shown above, follow the steps below: Select Subtotals from the Data menu. WORKAROUND STEPS: 1. Get inspiration at the MicroStrategy data dashboard gallery. It shows many attributes grouped into separate visualizations. On the other side, Microstrategy offers easy blending and linking to different data sources. Convert the Visual Insight dashboard to a document. "Create New Report" and "Browse All Objects" only appears if attributes are available in the project schema. x. Logon to MicroStrategy Web using the Administrator user. Use all three prompts above as the report filter. When installing MicroStrategy Intelligence Server Universal in Unix environment, user needs to specify the path for Home, Install and Log directory as below: As default, the Install and Log folders are under Home folder. 6, a new parameter has been introduced in the URL API. To apply the selections as a slice,. Ultimately, it. Create a custom subtotal with desired name in dataset report. All the existing visual Insights dashboards will be converted to Dossiers. This type of business analytics employs techniques such as drill-down, data discovery, data mining, and correlations to uncover the root causes of. 7) Data labels for line chart display overlapped with the line in VI dashboard in MicroStrategy Mobile 9. The template should include the maximum number of attributes and metrics of any report that may use this autostyle. Make sure 'Show Title Bar' is unchecked. The list of supported hardware and Mobile OS versions remains the same as the MicroStrategy Mobile Platform App. Strong semantic layer to define all the business rules and tightly coupled. Microstrategy Dashboard performance improvements steps: Many times, causes of poor performance can be simplified to specific components. 2 and above, this can be integrated into a dashboard for easy navigation and user interaction. For information on connecting to databases, see Connect to Databases. You can use the Custom Visualization API to create tooltip functionality using third-party plotting libraries like D3. 1. MicroStrategy. Source: MicroRooster. 2, the link sent to the user will take the user to a Report Services Document version of the. Diagnostic analytics shifts from the “what” of past and current events to “how” and “why,” focusing on past performance to determine which factors influence trends. The result appears as if we are dealing with one source of data. This metric is used for getting "1" value for all rows. Free essays, homework help, flashcards, research papers, book reports, term papers, history, science, politicsDashboards executed in Flash mode require Flex Binary for the data and XML generation for the Dashboard definition. , in search results, to enrich docs, and more. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. SYMPTOM When the VI Dashboard is executed from Web, there are XML & HTML5 caches created. 2. To learn more about embedding dashboards for. A text editor to create HTML files. Sample code for a simple login page using LoginPage. To define a specific subtotal displays for a report like the one shown above, follow the steps below: Select Subtotals from the Data menu. If the qualification prompt is not answered the legend correctly reflects the threshold ranges and colors remain the same. “When we first started—and. 4. A blank visualization appears in the dossier. Microstrategy. Once you select the data from the source, the data is automatically. Note however, that MicroStrategy Technical Support does not make recommendations related to tuning or performance of individual MicroStrategy Intelligence Server and operating system configurations. MicroStrategy has no obligation to monitor the Communication Services. A mobile dashboard is a data analytics tool used to track important key performance indicators (KPIs) and display them visually on a mobile device. Number of consultants & teachers ___. Format this dashboard yourself with the help of this 2 minutes video and before/after dashboard samples. 11. When users add an attribute with large number of elements into the Filter Pane of Dossier/VI Dashboard and set the selector type to Checkbox, a search box will also be displayed so users can search the elements, which is very convenient. I will also demonstrate how to use panel stacks, s. 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. When you use a worksheet to create a dashboard, the worksheet itself is removed from the Worksheets page. 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. 5. MicroStrategy 10 Dossier (dashboard) enables dynamic links to reports with passing parameters. Some of the main features offered by MicroStrategy are Advanced Analytics, Data Discovery, Data Visualisation, Embedded BI, and detailed reports and statements. MicroStrategy on AWS: Intro to Visual Insight. Login Web with Administrator, Create a VI Dashboard based on this cube. This editor contains the "Condition" field by default, so you are able to select your filter normally from the list. You can determine how the widget is displayed in different MicroStrategy Developer views and MicroStrategy Web modes, as outlined in the steps below. Predictive Analytics. You must disable the Title Bar for this to work. 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. Format this dashboard yourself with the help of this 2 minutes video and before/after dashboard samples. . 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. After selecting the blank dashboard, unlock it from the Options. x. The binary generated for this mode is different from the binary generated for PDF. Dashboards and Widgets Creation Guide Creating Interactive Dashboards for your Data Version: 9. STEPS TO REPRODUCE: 1. MicroStrategy Intelligence Functions:Follow the steps below. Create a report with DAY, GROUP, PLANT, and metrics Sum MTD, and Replace Total. Tableau Explorer. This video tutorial demonstrates how to create an Agile dashboard from a classic report. It is possible to use more than one cube in a single Dashboard. Then user is able to select the object to display. From the left, click Document. Before Customization: After Customization: Launch the Web Customization Editor. `x` ( Lowercase) Deletes the character at the cursor location. Fully customizable with editors in Dossier or Web Report Services Documents (DHTML widgets) for appearance. Intro to VI. More information. Create a Visual Insight dashboard and add the above cube as the dataset: 3. What you need here are the MicroStrategy Security Filters. x. 4. Architect. For example, this might be provided by a customer email attribute form of the Customer attribute. This is fixed in MicroStrategy Mobile 10 application for iPad. Try For Free. Currently, it is not supported to keep the format when refresh RS document or VI dashboard from. How to create a MicroStrategy connection file (. A BI Developer is a professional who designs, develops, and maintains business intelligence solutions. A selector can change panels, another selector, the focus of a Grid/Graph, or dynamic text fields (a text field that is a reference to an object on a report) in a panel stack, as described below. The Document Properties dialog box opens. | Meet MicroStrategy AI on the road. 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. That is accomplished with the connector. x. Form Type. Add Region in Horizontal Axis. As of MicroStrategy 10. Create a document with two selectors A & B (checkbox,listbox,drop-down selector) and a panelstack 2. x, include a customized ESRI map. MicroStrategy for Jupyter is contained within mstrio-py package and is available after. Observe the layout and color are different as shown below: CAUSE: This is a known issue with MicroStrategy 10. Power Bi can be set up for work with a large amount. 11, this visualization is provided out of the box. $40 per userWhy MicroStrategy Why MicroStrategy; Customer Stories; PlatformHere is the workaround to achieve the attribute left outer join on MicroStrategy Web. Description: A demo that describes how to create and use MicroStrategy. Users can take advantage of D3’s features and several of its wrapper libraries for making visualizations on VI Dashboards and Report Service documents . It helps to browse and explore data with flexibility and also measure and observe data effectively. One use case is to determine if a Visual Insight Dashboard is new. Now leverage trusted data to build a Power BI dashboard and even schedule dataset refresh cadence. Create new solutions quickly in Power BI. Vi Editor Commands in Linux for Deleting Characters and Lines: Here is the list of important commands which can be used to delete characters and lines in an opened file. • Chapter 2, Importing Data into MicroStrategy Desktop describes how to import data into MicroStrategy Desktop, for use in creating dashboards. Speedier efficiency than direct warehouse queries. The Export Engine (EE) runs as an independent micro-service to export dossiers to PDF that comes with its own logging and troubleshooting steps. The following steps will add a toolbar item in MicroStrategy Visual Insight Dashboards using the MicroStrategy Web SDK 10. Any comprehensive dashboard worth its salt will allow you to dig deep into certain trends, metrics, or insights with ease. In MicroStrategy 9. import data into MicroStrategy Desktop, for use in creating dashboards. STEPS TO FOLLOW: 1. In Web, click New Dashboard. Use, download or otherwise copy, or provide (whether or not for a fee) to a person or entity any directory of users of the Communication Services or other user or usage information or any portion thereof. • Chapter 3, Creating Dashboards and Visualizations describes how to create and format a dashboard, and ad d visual representa tions of the dataThis issue was fixed in MicroStrategy 10. In the following example, we will create a dashboard showing some common. In MicroStrategy Web 10. This Tutorial describes how to set a Dossier/VI Dashboard as the Default Start page in MicroStrategy Web. 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. "Create New Report" and "Browse All Objects" only appears if attributes are available in the project schema. The conclusion: Power BI wins on broad usage by a non-technical audience. No Filtering – Selectors do not target each other. WORKAROUND. ), and execute Java programs. MicroStrategy Dashboards allow any user to seamlessly transform MicroStrategy reports into interactive dashboards! So you can get Governed, high quality, sec. You are a financial analyst and want to build a grid to analyze each region’s performance across different set of products, like home equity loans and certificates of deposit, all in the same view. MicroStrategy Basic Reporting Guide is a comprehensive manual that teaches you how to create, execute, and analyze reports using MicroStrategy. With Parameterize Query on, the query can be re-used and the data retrieving performance will be increase by 10% for IBM Db2. hex colors for dashboard how to make excel graphs look professional html colors for dashboard kpi template line.