The term ad hoc is Latin for “for this situation. This technical note will discuss the workflow of a Document Execution Request, introduce the Performance Troubleshooting Cycle, and present links to other resources with detailed steps for troubleshooting specific components that may affect performance. Utilizes understanding of dimensional data modeling techniques, data warehousing, design and concepts to produce balanced scorecard design, and design of dashboards and KPI’s (Key Performance Indicators) Build and test production deployment packages and implementation plans for. If the report takes 2 min to. Upgrade to MicroStrategy 2021 Update 2 still notice the performance difference. The summary tabs provide information like Sales, Cost, Profit and Profit Margin, and overview of how all regions are performing along with monthly trend in spark lines. ”. IBM Cognos is ranked 7th in BI (Business Intelligence) Tools with 17 reviews while MicroStrategy is ranked 8th in BI (Business Intelligence) Tools with 12 reviews. Filter PanelMicrostrategy Dossiers With the release of MicroStrategy 10. Highly accomplished and creative Microstrategy Developer with deep experience in all aspects of software development. MB. Full living cycle implementation of. Creating Documents and dashboard using slice n Dice Concepts. They. 10. When we place some. Views 1540. 118 MicroStrategy Education: Dashboards and Data Discovery 10. Enhancing the existing reports with some new metric calculation and attribute changes. Details for MicroStrategy Web and Web Universal follow: MicroStrategy Web (ASP. Giving dashboard, best practice to improve the dashboard performance. 611 Analytics. 0. When designing your projects and data warehouse, follow the MicroStrategy best practices as. Microstrategy Dossiers With the release of MicroStrategy 10. Tableau is a data visualization tool that helps create appealing charts, reports, and dashboards that are easy to share and interactive. 8+ years of Professional experience this includes Design , Development and implementation of MicroStrategy request with proficiency in creating Attribute , Facts , Patterns , Filter , Prompts , Metric , Reports , Documents and Dashboards using MicroStrategy 10. For detailed instructions to print a document, see the MicroStrategy Web Help or the Document and Dashboard Analysis Guide. Microstrategy Web Visual Insights . When we place some common attribute or metric in multiple visualization, it is easy to study the variations among them. The most common microstrategy developer hard skill is dynamic dashboards. This article describes best practices to be taken when using an Oracle database of version 19c in MicroStrategy with DDA mode. Company Size: 250M - 500M USD. Plus, it analyzes and narrates all the underlying data to make. They showcased their physician performance reports, hospitals’ daily indicators reports, and revenue reports at entity and department levels with various KPIs such as revenue driven from corporations, health institutions, banks or government. We recommend upgrading to the latest version of the following applications to get optimized viewing performance and enhanced security: MicroStrategy Workstation; Library Mobile for Android & iOS; MicroStrategy App for macOS & Windows;. Publishing reports and dashboards. The goal is to select which Metric you want to display. 1. Objective : Micro Strategy professional with almost 7+ years of result-driven experience in Data Modeling, Designing, Architecture Data Warehouses and BI applications in diverse industrial sectors like manufacturing, pharmaceutical, banking, retail and insurance. If you click the link for the Narrowcast Services SDK Guide, a File Download dialog box opens. Excellent analytical, inter-personal and communication skills with clear understanding of business process flow. Optimize database performance and utilization based on query types, usage patterns, and application design requirements. Set up the Enterprise Manager. Step 4: Login to your MicroStrategy account and navigate to the project where you want to integrate Google Analytics. First up, Report Services Documents (or just “documents”) continue to remain an essential part of the MicroStrategy portfolio. Hi, The report can be tuned. MicroStrategy 9 Release 3 lets you explore your data in compelling reports and dashboards via iPhone, iPad, BlackBerry, Web, and more. - Full life cycle implementation. The MicroStrategy Intelligence Server 9. Users may design, generate, and alter reports, dashboards, and data models with this tool. 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. Refer to the following MicroStrategy Knowledge Base technical note for related information: KB18975 - New feauture in MicroStrategy Web 9. For tuning details, see the appropriate section in the Installation and Configuration Guide. You'll find user-generated examples showcasing a variety of use cases such as financial or retail sales analysis. Metadata is a relational database that contains information to facilitate the transfer of data between Data warehouse and Microstrategy. Capture8. This technical note is part of How to troubleshoot Dashboard Performance. Views 1543. The stand-alone filter can then be used on many different reports, as well as on metrics and other objects. 9% of resumes. Croatia Office. Dashboards in MicroStrategy Web. The selections a user makes when using selectors with Report Services Documents in MicroStrategy Web 9. 2. Overall environment stability and performance tuning MicroStrategy Web/Mobile Dashboard development MicroStragety Architecture Teradata object creation (Views, procedures, tables) Technical Support to BA, QA and BI Developers BI Administration: Informatica and Teradata alerting and performance management Managing. Our goal was simple — to build the next-generation dashboard editor. Data blending. and select the Project-Name. this allows users to perform the in-depth analysis of their data and get the valuable results from their data. Always consider to collect database statistics as the query execution plan is generated based on that. Microstrategy Dashboard performance improvements steps: Many times, causes of poor performance can be simplified to specific components. Just summarizing the slides I presented at World, touching on ideas and areas of optimization for lightning fast performance of your mobile apps. The Winner: Tableau emerges as the winner for reporting with built-in versioning and subscription-based report delivery. That is accomplished with the connector. 1. First, define one visualization as the source. Required Status to Perform Action. 2. • Involved in understanding and transmitting the business requirements for the project and. However, Intelligent cube publishing performance may be affected with the agent enabled. Data quality. Additionally, when using Teradata as MicroStrategy Metadata, the Teradata ODBC driver options should be set as follows. Grids formatting, contrasts, transparency, global formatting and KPI summaries. Stay up to date on inventory needs and avoid. Please try to see the SQL of the report and the SQL in the database and try. Dashboards provide a distilled view of. Optimize database performance and utilization based on query types, usage patterns, and application design requirements. 4/10/9. First, define one visualization as the source. Ultimately, it. Dossiers automatically adjust to look great on any screen. →The dashboard is displayed very fast. It performs the following critical tasks for the MicroStrategy BI platform: Runs queries, performs calculations, and formats reports. Hee-Wei Tan (Inactive) · May 1, 2017 ·. Add Thread Group. Adding External data from various sources to create dashboard. The bigger the Dashboard size the. From a performance perspective, not only does it help split and divide the data into multiple sets, thereby improving performance, one can also cache the linked dashboard ahead. Interactive dashboards in MicroStrategy. 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. This course. Microstrategy Dashboard performance improvements steps: Many times, causes of poor performance can be simplified to specific components. From the Report Selection panel, go to the File menu > Open. The top reviewer of IBM Cognos writes "Helpful online community. MicroStrategy offers customizable dashboards that enable businesses to visualize and track key performance indicators (KPIs), including profit margins, revenue, and costs. For details on analyzing documents in the different modes, see the MicroStrategy Web Help. The amount of data retrieved and objects being used in a Report Services Dashboard have a direct impact in the size of the final Dashboard. With these statistic logs, administrators can observe the amount of time spent on each step of the process for a certain task in MicroStrategy Web. Kylin4 uses a new spark build engine and parquet as storage, and uses spark as query engine. Documents and dashboards can appear in almost as many ways as you can imagine and are generally formatted to suit your business needs, in a single display of presentation quality. MicroStrategy Certified Professionals: This is a guest blog post co-written by Amit Nayak at Microstrategy. 123. View AllFiles. You'll find user-generated examples showcasing a variety of use cases such as financial or retail sales analysis. A passionate Certified Business Intelligence & Data Analytics Professional with over 15 years of experience with a proven track record in managing Project Life Cycle, Application architecture. 1 million in the first quarter of 2022. For information on connecting to databases, see Connect to Databases. In-store and online. It is possible for the users to use it as a web-based or a desktop tool. This section describes only the most basic guidelines. Log into the three-tier project source and choose the project that was analyzed in stage 2. Microstrategy Developer Resume. Dossier Performance Troubleshooting Guide Since MicroStrategy 10. However, Intelligent cube publishing performance may be affected with the agent enabled. A billing manager can see data in a report called Invoice Statements by Selected Customers, as well as a customer-level transaction detail report. The grouping options for levels include: Standard groups by the attribute level of the target. Set this dummy map as project default drill map in Step 2. MicroStrategy’s business intelligence (BI) and analytics platform helps organizations make educated decisions by providing timely insights that lead them to informed decisions. When you start a project using MicroStrategy with Oracle as warehouse at a very beginning state, please consider below constructions step by step for project. Importing Dashboards; Exporting Dashboards. • Designed and developed multiple Reports/Dashboards in MicroStrategy Web and Developer (Report Services) for senior executives and Board of Directors • User acceptance testing (UAT) for the last stage in development. Scorecards typically follow a specific methodology and focus on key metrics within a business area. Define the System Requirements. He loves to assist team members in architecting new solutions, performance tuning schemas and databases, and providing the best customer experience to end users. Tests were conducted for several concurrent users for two data size sets “1x” and “20x” having 3. CAUSE: This issue is caused by the way the image is referenced when defining the path. 0. On the dataset "Generic Metrics List". - Query plan performance tuning frequently involves altering the query, the database design, or the database configuration to increase query performance. Design and maintain database enterprise assets. Diagnostic Analytics. High Performance Tuning -- A methodical approach to tuning MicroStrategy software for maximum performance, including all components of the BI ecosystem such. For example, the attribute Customer has the forms ID, First Name, Last Name, Address, and Birth Date. In MicroStrategy Desktop, log in to a project. Analyze the low performance query using DBA knowledge, add. The Subtotals dialog box opens. Hema Pratapa (Inactive) · 1월 23, 2020 ·. “ Data without context is meaningless. Client rendering time greatly relies in the amount of XML that needs to be parsed. Select the Members tab. Inserting Panel Stacks ,Layouts ,Selectors and widget in Documents and Dashboard. Dashboards, on the other hand, also provide key metrics but tend to summarize business intelligence information more widely. The PostgreSQL ODBC Driver has the best cube publish performance as it has the highest throughput. Change the data of the report and re-execute it. Dashboard Templates Overview. - Full life cycle implementation encompassing. Step 6: Click on "Web Integration" and paste the Google Analytics tracking code into the. Tuning in MicroStrategy performance can be affect by various VLDB settings to optimize the SQL generation according to the actual target database environment. Each and every layer matters, and one can encounter different. The Performance Analysis dashboard provides information about the past week of report and document requests from various sources, such as Developer, MicroStrategy Web, or Distribution Services. Designing, building, and maintaining data integration processes in test and production environments of ETL processes, and design data models. As shown below, this RS dashboard contains an area graph for daily revenue, a grid report for category analysis, and a bar graph for subcategory revenue. Grouping determines how the metric aggregates. High Performance Tuning -- A methodical approach to tuning MicroStrategy software for maximum performance, including all components of the BI ecosystem such as relational database management systems. •. , UNION, INTERSECT, EXCEPT). The newest feature release of Microstrategy, Microstrategy 10. 2 MicroStrategy 2020 • Up to 3X Performance Improvements OOTB using Derived Table Syntax and Arrow Data Transfers. KB441987. /") fails when exporting to PDF. With market competition being cutthroat, companies. For each source, you can see how many reports/documents used a cache, how many used an Intelligent Cube, and how many used an external data source. Performance monitoring and tuning experience for all MicroStrategy reports and dashboards. IBM Cognos also connects you with the company data you collect on their. Tableau developers create tableau dashboard reports, collaborate with other developers, and attend feedback. MicroStrategy 10. Cube advisor This feature allows you to discover which visualization is consuming most of the time in your dossier to improve performance. A well-drafted Senior Microstrategy Developer. 8 delivers critical visualization and dashboard capabilities across enterprise analytics, enterprise mobility, embedded analytics and new features for MicroStrategy Desktop, MicroStrategy Web, MicroStrategy Mobile. The second question is a little difficult. a) Attribute form qualification. Freedom to Choose. Filters can include date ranges, data sources, geographic regions, departments, or product SKUs. You can modify certain settings in the MicroStrategy Web server machine or application for best performance. Significantly improves user-perceived query performance. png. Platform Analytics is a monitoring tool that captures real-time data from the MicroStrategy platform, and uses this data to enable smarter administration and provide a better experience to your MicroStrategy users. This technical note is part of How to troubleshoot Dashboard Performance document that can be found in KB19625: Dashboard performance troubleshooting in MicroStrategy 9. TM1: Analyze & Share Data (3 day) Learn how to create analyses and enter data in Microsoft Excel and on the Web, create custom views of the data, and build reports and forms in. How to create a Snowflake Usage Dossier. In order to facilitate users to have a more. These are represented in dashboards either as a part of visualizations or tables. For details, see the MicroStrategy Tech Notes. The table below summarizes a few key modules that commonly consume the most amount of time during a dashboard execution: This setting is used to combine multiple subqueries into a single subquery using set operators (e. 0-beta and official version were released. SUMMARY: This technical note is part of How to troubleshoot Dashboard Performance document that can be found KB4100-812-0001You can use the Enterprise Manager reports and dashboards out-of-the-box, or you can modify the reports to return exactly the data you want to analyze for your MicroStrategy environment. One of your most important jobs as a MicroStrategy system administrator is to find the balance that maximizes the use of your system's capacity to provide the best performance possible for the required number of users. The DSN and Login ID are provided based on the server configuration that you did previously. 0. The ODBC connection uses 3. 612 Advanced Big Data Administration 2021. KB442449: Dossier Performance: Connect Live performance considerations. MicroStrategy 2021 can take advantage of Arrow format provided by Snowflake which can help improve the performance for customers. Quickly visualize data with out-of-the-box grids, graphs, charts, and maps. Provide solutions by building tools, reports and. You'll find user-generated examples showcasing a variety of use cases such as financial or retail sales analysis. 0. Develop MicroStrategy dashboards and reports with an emphasis on showcasing the self-service business intelligence capabilities of the MicroStrategy platform Prototype dashboards with panels, selectors and links Design, develop and implement reporting and analysis environment, including template-driven. On the metadata Connection page, enter the database password to access the MicroStrategy metadata. These Dashboards are used by Network Administrators to manage, maintain and optimize their. MicroStrategy is a data analytics platform for conveying business insights with customizable data visualizations and dashboards. Back then, the dossier editor (formerly known as Visual Insight) was a powerful BI tool with limited design functionality. <br>Currently a. - Lead AI initiative for in depth Smart analyticsWorkstation is the only space for analysts and app architects to build and manage content of all types. First up, make sure you consider every layer of the workflow while optimizing for performance. . Dynamic Dashboard, Report development, and Project design: Facts, Attributes, Hierarchies, Aggregation Deliver required documentation for build, and support responsibilities, including. A cloud-native, open architecture platform, it is built on a scalable, future-fit semantic layer designed to inject AI-powered Intelligence Everywhere™. The latest information on the data including the addition of new objects, modifications can automatically be derived from the warehouse directly. The XML generated to transport data and Dashboard formatting information is generated using a tree of nodes, as any other XML file, in order to separate the different sections and pieces of. Creating and modelling advanced MicroStrategy Schema layers, including setting up joins, hierarchies, logical tables etc. To access documentation resources on Windows. 4. 1/9. Acibadem shared details on their MicroStrategy dashboards and HyperIntelligence cards. In addition, it will also be quite useful for those readers who look forward to become a Data Analyst or a Data Scientist. 963. MicroStrategy - Creating Dashboard. Scalability and High Performance with MicroStrategy 10 Enterprise Analytics and Mobility at Scale574. The following diagram depicts the role of the intelligent cube. A dashboard is made up of multiple visualizations. Experience designing complex dashboards that take advantage of all Tableau functions, including data blending, actions, parameters, and more. 262KB. KB31469: Data generation for Dashboard Performance Optimizations in MicroStrategy Web. PRIME stands for Parallel Relational In-Memory Engine, and it engulfs two types of in-memory cubes: OLAP cubes, or the traditional Intelligent Cubes that have existed since 9. Organizing interactivity features on a dashboard. Restart the Intelligent Server. 30% Performance Improvement with Lookup Cube Caching. Microstrategy Dashboard performance improvements steps: Many times, causes of poor performance can be simplified to specific components. Jul 13, 2023. • Performed performance tuning of interfaces in StreamSets Data Collector, Oracle Data Integrator, Informatica, Vertica, and Oracle DB. The tool kit of SAP BusinessObjects includes the tools for reporting and dashboards that business owners can use by consuming the data available in the form. Designing and developing Power BI dashboard and visualization. It gives you exclusive access to MicroStrategy experts on-demand or on-schedule, as well as access to all 56 courses in the MicroStrategy Education Catalog. – Extensive experience developing reports, dashboards, and cubes in MicroStrategy latest versions. We empower you with the skills to get the most out of your analytics investment. 0, was released in July 2020, and then kylin 4. The second most common hard skill for a microstrategy developer is bi appearing on 5. Tuning. 0, while Tableau is rated 8. 9 and 79 million rows in the. Skip to main content LinkedIn. 111 Overview of Enterprise Analytics 2021. Dashboards are a powerful way to communicate data and other information, especially with a user-centered, goal-centric design that follows dashboard design best practices and proper data visualization. AMD Software: Adrenalin Edition features performance tuning presets for the AMD Radeon RX 6800 and RX. Applied Teradata Application Utilities and Teradata SQL . Microstrategy Dashboard performance improvements steps: Many times, causes of poor performance can be simplified to specific components. Full-time, temporary, and part-time jobs. Metadata is a relational database that contains information to facilitate the transfer of data between Data warehouse and Microstrategy. Additionally, when using Teradata as MicroStrategy Metadata, the Teradata ODBC driver options should be set as follows. Confidential Starting in MicroStrategy 2021 Update 1, you can connect to the on-premise database from the MicroStrategy cloud via Gateway Agent. This article describes best practices to be taken when connecting an instance of IBM Db2 in MicroStrategy. Change Journaling is enabled by default since MicroStrategy version 10. . Open the Diagnostics and Performance Logging Tool from the MicroStrategy Intelligence Server machine. Support, design, build and test MicroStrategy projects, reports, and dashboards Plan and execute MicroStrategy upgrades Performance tuning of reports, both new and existing Work closely with DBA’s to conduct any data model, data profiling, or database design & development changes required to support BI projects While the default values should result in the best report performance in most cases, some reports may perform better when certain VLDB Properties are set to non-default values. This article describes best practices to be taken when using a Teradata database in MicroStrategy. Define the statistics and enterprise warehouse database. To define a specific subtotal displays for a report like the one shown above, follow the steps below: Select Subtotals from the Data menu. AMD Software’s One-Click Auto Overclock feature is a simple way to get more performance out of your AMD Ryzen™ 5000 Series Processor and AMD Radeon™ 6000 Series Graphics Card. MicroStrategy ONE is a comprehensive intelligence platform that integrates the power of generative AI with the precision of BI. Data Management. A Report Services document is a set of data and formatting properties that, when executed, can produce an attractive presentation-quality report. 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. In the edit site dialog, check the allow performance recording checkbox and click OK. MicroStrategy 2021. Here’s what we found: The most important types of business intelligence tool features and functionality are: Dashboards. 8+ years of Professional experience which includes Design , Technology and implementation of MicroStrategy applications with competence within creating Attribute , Tatsachen , Template , Filter , Prompts , Metric , Reports , Related and Dashboards using MicroStrategy 10. Their answers provided us with data on the features most desired by those in the market for a business intelligence system. Check the attached . Place Intelligence Server close to the both the data warehouse and the metadata repository. To troubleshoot performance issues, users must identify. Views 1543. Almost 10 years of experience in international BI software vendor. Group Elements. Browse and incorporate these templates into your own data dashboards. Microstrategy web. Professional Summary. To configure:-. 2 by default. Report takes 2 minutes to execute in MSTR, but it took 2 seconds in database 2. December 18, 2008 MicroStrategy, Performance Tuning Tiwari Ashish. g. In the PDF Options dialog box determine the report scaling and orientation, and press Export. Ad hoc query. The idea is to make faster line-of-business decisions with easy access to information, including performance and sales metrics. Our Customers. 2. The DashboardViewer. Dedicate a machine for the metadata repository. 411 Project Architecting 2021. Dedicate a machine for the metadata repository. The default folder is: C:\Program Files (x86)\MicroStrategy\Product Name when installed on a 64-bit Windows environment. Expertise in developing Public obj (metrics, filters, prompts, Custom. txt file. For information on connecting to databases, see Connect to Databases. The major usage of the tool is for analytical purposes (reporting) by interacting with Hadoop, Microsoft SQL Server Tables, and SSAS MDX. IBM Cognos is a BI tool that allows its users to create, manage, and visualize activity dashboards to present, track, and analyze relevant data for the company. MicroStrategy. 117 MicroStrategy Education: Enterprise Mobility 10. Select Export from Home menu, and then click PDF. SQL Server Performance Tuning and Optimization -Languages English. Dynamic Dashboard, Report development, and Project design: Facts, Attributes, Hierarchies, Aggregation Deliver required documentation for build, and support responsibilities, including. Understand your data characters and choose the matched configuration. to improve it by reducing the number of passes created by the report. 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. Microstrategy is actually based on the single meta-data repository. It is Microstrategy Workstation scripts (Python) to get the results from the search object. Apply online instantly. You can follow online guru for important updates. Unified Quoting Updates to better handle characters. Place Intelligence Server close to the both the data warehouse and the metadata repository. The document opens in the default mode selected by the document designer. Learn our Microstrategy Training to master yourself in building reports and dashboards using MicroStrategy from scratch with hands-on training from real-time experts. For this point admins need to try the three options and see which one has better performance. This technical note is part of How to troubleshoot Dashboard Performance document that can be found in KB19625: Dashboard performance troubleshooting. If report taking longer time to run then before checking other things, first check the report SQL and try to run the same in the database . Best Practices Articles (Performance Tuning Based on IBM Db2) This article describes best practices to be taken when connecting an instance of IBM Db2 in MicroStrategy. Click Define New Configuration. Additionally, the custom number formatting and advanced threshold editor allow us to use colors and symbols to create a richer grid presentation. It’s like having an expert speak directly to every user, telling them what the data means and what they should do about it. MicroStrategy Course Overview. To avoid this, MicroStrategy uses intelligent cubes, which is an object sitting in the middle layer between reports and the warehouse. Watch the presentation where you'll discover our top five hacks to optimize your Dossier designs including best practices for data wrangling, dataset management, and content caching. In order to ensure that the XML generated is optimized please review the XML generation optimization techniques KB31469: Data generation for Dashboard Performance Optimizations in MicroStrategy Web 9. Designed services and dashboards in MicroStrategy. Retail is leveling up with omnichannel analytics. In the Source area, select a database instance for the database to access using Freeform SQL. x offers a new addition to the OLAP services features: in-memory Intelligent Cubes. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. This article describes best practices to be taken when using a Teradata database in MicroStrategy. The second question is a little difficult. A MicroStrategy dashboard is an interactive display that you can create to showcase and explore business data. In order to ensure that the XML generated is optimized please review the XML generation optimization techniques KB31469: Data generation for Dashboard Performance Optimizations in MicroStrategy Web 9. Classroom Review questions for Microstrategy Documents & Dashboards + Visual Insights. Documents and dashboards allow you to display your business data in a user. Every step along the way matters. Learn how to create insightful and interactive dashboards using MicroStrategy. The result of this setting is reflected in the GROUP BY clause of the SQL command. Right-click on the right-hand side of Desktop, select New, and then select Report. However, there is no significant improvement against Synapse Analytics. - Platform Migrations - New implementations - Maintenance and management of the MicroStrategy platform: best practices definition, deployments, users and privileges management, security filters and configurations, platform tuning using VLDBs, usage and performance monitoring, version upgrading. For all other outputs, MicroStrategy Office, MicroStrategy Web in DHTML mode and MicroStrategy Web in Flash mode the Intelligence Server generate XML. 4. General hardware recommendations. To start the Report Wizard. Pre-selecting an attribute element in a selector might. I will also demonstrate how to use panel stacks, s. Data Combination Setting MicroStrategy use TLS v1. Browse and incorporate these templates into your own data dashboards. Business Intelligence Reports and dashboards using MicroStrategy Desktop. TM1: Administer the Technical Environment (2 day) Learn how to install and configure Cognos TM1, monitor system performance, and secure Cognos TM1 applications. x. x can either filter or slice the selector`s target:. • Chapter 3, Creating Dashboards and Visualizations describes how to create and format a dashboard, and ad d visual representa tions of the dataThe first step in analyzing the performance of Intelligent Cube Publication is to look at the post-execution SQL view of the initially published Intelligent Cube and understanding the breakdown. Microstrategy Developer. Efficiently manages thousands of end-user requests (jobs.