Object. Step 2. Add a condition to a custom group element. This is a database instance level VLDB setting. The 'Select Objects' dialog box opens. Subtotals. Step 1. To open a document in Editable Mode, from a folder, right-click the document, point to Run as, and select Editable. 3. This article will help. If you have many reports or tasks that need to be executed on the same time-based schedule, consider creating several similar schedules that trigger 15 minutes apart. A derived element is a grouping of attribute elements on a report. 4. (i) the MicroStrategy Components developed and licensed by MicroStrategy Services Corporation (MicroStrategy) of McLean, Virginia to Oracle and imbedded in the MicroStrategy for Oracle Retail Data Warehouse and MicroStrategy for Oracle Retail Planning & Optimization applications. In the list of categories on the left, click Subtotals. When this custom group is placed on a report with the metric and an answer of '8' for the prompt, the following results are returned:Tile grid map is an abstraction of the map data to solve the issue of difference in sizes causing issues with shading and making it difficult to compare geographic information. microstrategy. Create a report with Year on the rows and Revenue on the columns. Consolidations allow you to qualify a report on a row-by-row basis. An online search reveals that MicroStrategy has less market penetration than Tableau. Starting in MicroStrategy 2021 Update 1, there is an new out-of-the-box, feature-rich. Each element in the custom group can have a different output level. An attribute form qualification might filter on the form Last Name, the operator Begins With, and the letter H. A new custom group element is created, with the default name Custom Group Element1. 1 HF6 environment. To Modify Permissions for an Object in MicroStrategy Web. Click "Add Photo" and select photos to upload. Summer consists of June + July + August, fall consists of September + October + November, and so on. Features: MicroStrategy and Tableau are two unique tools that offer incredible features. When this report is executed, only two custom group elements are displayed even though five elements are defined in the custom group. The Running Sum is defined as follows: RunningSum<BreakBy= {Subcategory}, SortBy= (Month) > ( [Units Received]) and should be the sum of the Units Received + Running Sum. This object is based on another familiar one: the Filter. Hierarchy 2: 4. Ans: MicroStrategy enables ad hoc analysis through an intuitive interface. Custom Group Editor. A custom group is used to group attribute elements and aggregate results in a report. The following is a quick reference table for a MicroStrategy Custom Group: A Custom Group is an Application Object that creates dynamic sets of data in such a way that it gives the ability to create several mini-reports inside a Report. When creating or editing a custom group in MicroStrategy Developer 9. '. The Metric Editor opens in either Function Editor mode or Formula Editor mode, depending on the type of metric you chose to edit. This consolidation will contain four consolidation elements, one for each season. Consolidations enable users to create customized groupings that allow row calculations between elements of a given attribute. Uninstall all the MicroStrategy and related products from Control Panel: Any MSTR Hotfixes applied. Custom groups are. Autostyles based on one document can be applied to another document in order to change its formatting or appearance. mstrc) Open Workstation. The Custom Group Editor opens. comA selector can change panels, 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. Click Save to save changes. 2. 1 comment. For tp & TPPARAM: System Overview Screen -> SAP System -> Check -> Transport Tool. Following are the steps to create a custom group. Your personal view subscription is saved, and you are returned to the report, document, or quick dashboard. Fact table levels: The context of your data. DAY_DESC. 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. In contrast, consolidations. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . We need to establish a consolidation route for each transport layer. To enable totals or subtotals for a metric. They act as containers for non-standard SQL expressions that MicroStrategy does not support. / 3. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Connect to and interact with the MicroStrategy environment. Go to Start -> Programs -> MicroStrategy -> Tools, run ScanMD. Follow the steps below for an example of how to do this. If an environment does not already exist, an environment will need to be created first. A custom group can group attribute elements in a way that is not defined in the data warehouse. To choose a metric, execute one of the following: In the Metric box, enter in the desired metric name and click OK. A Group derived element is a combination of attribute elements into a single derived element. Create a new Metric called '1997 Dollar Sales' using 'Dollar Sales' with Year = 1997 as an embedded filter in the metric, and use the new metric when creating the custom group. Create a report with Year, the Region consolidation, and the Profit metric. Examples of this category are simple mathematical. Why MicroStrategy Why MicroStrategy; Customer StoriesThe user privileges that take up a Transaction Services license are denoted by 4 asterisks (****) in the User Editor. The following table summarizes the similarities and differences between consolidations and custom groups. Ca se functions Microstrategy Case functions return specified data in a SQL query based on the evaluation of user-defined conditions. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . From the left, click Document. The settings are numbered 1-5. x, select 'Project Documentation' from the Tools menu to start the wizard. How to create a MicroStrategy connection file (. Create a report with Attribute "Year", custom group "Category" and Metric Revenue; Click in the Metric Revenue in Report Object and go to Insert Tab;When the custom group element is expanded in the Custom Group Editor, up to three SQL passes must be made for each custom group element. ) A subtotal lets you see the. In MicroStrategy Web, open the document in Design or Editable Mode. The designed behavior is explained using an example consolidation and compound metric based on objects in the MicroStrategy Tutorial project. The second most common hard skill for a microstrategy developer is bi appearing on 5. This prompt is used in a filter. Custom group expressions: A custom group is an object that can be placed on a template and is made up of a collection of elements called custom group elements. Depending on your MicroStrategy product and licensing, this function may not be available. Save the report as “Email Bursting”. Javadoc API documentation for MicroStrategy 2019. The Grouping Properties dialog box opens. The Metric Editor opens in either Function Editor mode or Formula Editor mode, depending on the type of metric you chose to edit. 3. UX Designer, MicroStrategy To enable totals or subtotals for a metric. By implementing the security policies and configurations provided by MobileIron, administrators can apply enhanced protections to mobile devices in use across the enterprise. Visit the data visualization and data dashboard galleries for inspiration. The Apply functions are not meant to take. Content groups can be defined for a custom application to limit the content that can be viewed by end users in the Sidebar menu of all Library clients, including mobile. Source: MicroRooster. Relate tables contain the ID columns of two or more attributes, which will define associations between them. 1. Create a new consolidation with three elements - Winter, Spring and Winter + Spring, as illustrated below: Create a report with the above created consolidation and three metrics -. The. The following is a quick reference table for a MicroStrategy Custom Group: A Custom. Mastering Business Intelligence with MicroStrategy. A custom group can group attribute elements in a way that is not defined in the data warehouse. Create New Metric in a report or VI. Consolidations and custom groups can support, because another sql statement may be created and retrieve the correct results from base tables. A consolidation element expression defines how the attribute elements are calculated. Using the. A recent survey by Gartner, Inc. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . The following window appears on completing the above step. Login to MSTR Developer then go to: User Manager > User Definition > Project Access. About the Authors; About the. As you can imagine, the SQL Engine. You must have the MicroStrategy Report Services product to view and create documents and RS dashboards. This is a single-value function. This allows you to group attribute elements on a report in a way that is not defined in your data warehouse. Go to project configuration by right clicking on specific project (You need admin rights to do this). Below are the steps to enable/disable the settings of data blending: 1. MicroStrategy makes no warranty, express, implied or otherwise, regarding this product, including its performance or reliability. '. Ensure that subtotaling is enabled for the consolidation. attribute elements. The Metric Qualification dialog box opens. Explanation. The grouping options for levels include: Standard, which groups by the attribute level of the target. When you open a web page the extension automatically scans web pages in your browser and underlines keywords that you can hover over to trigger cards. A report is a MicroStrategy object that represents a request for a specific set of formatted data from your data source. Choose File > New Consolidation. x, select 'Project Documentation' from the Tools menu to start the wizard. Then, for mobile devices, our Responsive View will take over the layout and place groups vertically on the canvas. Select only Configuration Objects for documentation. A percent-to-total shortcut metric displays the percent in relation to a selected total of each item affected by the metric. The following auto text codes allow you to add document variable information to your document. To open a document in Editable Mode, from a folder, right-click the document, point to Run as, and select Editable. This can be reproduced in Microstrategy Tutorial by following the steps below. Comprehensive analytical capabilities and Automated reporting: MicroStrategy offers wide range of analytical features including data visualizations, advance analytics, data discovery and predictive modeling. DEFINITION: This custom group is a custom group banding qualification created on the metric, with band size banding type and a step size of '1' (integers). From the Elements menu, choose Add Element. The custom group elements can be. Depending on the options that you select in the Custom Group Editor, the custom group could appear on the report in MicroStrategy Developer as shown below. About Custom Group Elements. Now using the mouse place the cursor on text box of 10000 which is next to 'Maximum number of monitoring objects displayed per page. Select only Configuration Objects for documentation. Refresh. In your Datasets panel, hover over the name of your dataset. For this class,. A custom group is a report object made up of an ordered collection of components called custom group elements, each consisting of a header and one or more qualifications that must be met for data to be included in the. Examples of this category are simple mathematical. Syntax . To control the display of which Custom Group elements display sums, right click on the Custom Group element, and select "Show Display Options". Data can be connected through an API, flat file, or database. Consolidations serve two powerful functions that can greatly enhance your reporting abilities: You can create a. Schema objects include facts, hierarchies, and custom groups; application objects include reports, documents, and metrics; and configuration objects include project sources, database instances. Microstrategy Dossiers With the release of MicroStrategy 10. 2. It is made up of an ordered collection of elements referred as custom group elements. Reports are now available to use and interact with in MicroStrategy Library: View standard reports in MicroStrategy Library to get a simple, grid view of data. Create a consolidation with Region grouping 1-2 different attribute elements. In the bottom left corner, click on the button "Generate Connection File". The Create Personal View dialog box opens. None, which excludes the attribute in the target from the GROUP BY clause in the SQL statement. Count of Parents in Platform Analytics: There is an OOTB metric called Objects, which calculates the parents of a component object. exe to this machine. Case. Qualifications are the actual conditions that must be met for data to be included in the custom group element. In free-form layout, we provide an intuitive way to let you visually “group” containers together. A preview of your changes is appears in the scale below. Consolidation and Custom grouping are special type of grouping filters and they are used when a User wants to see the metric values based on certain groupings. MicroStrategy manages the mapping between the logical table and the physical tables. Also, a percent-to-total derived metric has been added to the report using the Insert > Percent to Total > Over Rows menu option, obtained by right-clicking on the metric whose percentage is desired. . For more details, see the Custom Groups and Consolidations chapter of the Advanced Reporting Help. Version 2021. Group 1: Atlanta, San Diego, Berlin and San Francisco. Extensively worked in creating and integrating MicroStrategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) with the data warehouse. TYPE: Custom Group. In MicroStrategy Web, right-click an object and select Share. Loading. 1. Mastering Business Intelligence with MicroStrategy; Credits. Whether you're working with dossiers, cards, documents, or managing an entire intelligent enterprise, Workstation empowers you to do everything from one place. Add the derived metric to the report and hide it by setting the column width to 0. Learn more. Considerations for the use of star schemas with MicroStrategy SQL Generation. A user may have a report with a custom group/consolidation and attributes and want to return the total within each custom group/consolidation element. All attribute element data is added together to form the metric values for the new Group derived element. Modified 3 months ago. In addition, this release introduces new features across the analytics, mobility, and security platforms—making it easier for users to build applications faster. Same thing for Sub-Dept 201. We will explore two objects that serve this purpose: Custom Groups and Consolidations. 3. Per-column group Advanced Filter; Thresholds . Custom groups allow for unique aggregations of data elements and bands to provide a way for business users to analyze data in groups that do not exist in the original data source. In MicroStrategy Web, open the document in Design or Editable Mode. Double-click 'Add Qualification'. 5. Microstrategy Dossiers With the release of MicroStrategy 10. The best part I liked the most about the tool is we can have a different kind of security which can be implemented like the object kevel security, data level security or. bandings on Attributes or Metrics to group the. To resolve this issue, perform the following steps: Right-click on the Project in MicroStrategy Desktop and go to Project Configuration. Open the report’s subscriptions in MicroStrategy Web: Scroll down to the Email subscription and click the option to “Add email subscription”: Choose the schedule by clicking the drop-down and selecting the required schedule. Custom Visualizations: Users can create or import custom visuals to make their reports more tailored and effective. Subtotals are totals of selected groups of your metric data, totaled at a level you select. Dataset 2 contains Year and Profit, filtered to return data for only two years (2008 and 2009). However, there is no option for the user to enable custom group subtotals at the report. Updated: November 2023. a) Attribute form qualification. Tile grid map is an abstraction of the map data to solve the issue of difference in sizes causing issues with shading and making it difficult to compare geographic information. Each element contains a set of filtering or banding qualifications. MicroStrategy Desktop will then return data ordered by DESC ascending as follows for that report: From Desktop, create a new document and select the report that you just created as dataset. Use consolidation editor: use the Consolidation Editor: USECONSOLIDATIONEDITOR: Use custom group editor: use the Custom Group Editor: USECUSTOMGROUPEDITOR: Use data mart editor: use the Data Mart Editor: USEDATAMARTEDITOR:. I want to create a new Metric, using MicroStrategy Metric Editor, to check two conditions: 1 is progress_days > complete_date 2 is Status column is = In Progress. (For a definition and examples of levels of aggregation, see How data is aggregated on a report: metric level . Add the Age Groups Custom Group and the Profie and Revenue metrics to a report in MicroStrategy 10. A custom group is made up of an ordered collection of components called custom group elements. Definition. ALTER CUSTOMGROUP "My Custom Groups" IN FOLDER "Public ObjectsCustom Groups" NAME "Modified My Custom Groups" DESCRIPTION "Modified Copy of My Custom Groups" FOLDER "Public ObjectsCustom GroupsModified Custom Groups" ENABLEHIERARCHICALDISPLAY FALSE ENABLESUBTOTALDISPLAY TRUE. Watch this on-demand webinar to learn why MicroStrategy Workstation is such a valuable tool and how you can leverage it as a one-stop shop for operating and administering your MicroStrategy ecosystem. MicroStrategy recommends to have only one child at the lowest level. {&GROUPLABEL} Name of the graph. This knowledge base article explains an feature enhancement when using Consolidation or custom group. Both consolidations and custom groups provide flexibility in reports, but the objects differ in their structure and use. The Custom Group Editor appears. MicroStrategy is a data visualization tool. – Calculations. Selectors that contain attribute, custom group, or consolidation elements as selector items can also include an option to display totals. Fine Tuning how to do from BI Developer standpoint; VLDB properties (Changing governor settings, tuning the report sql, table creation type, pre/post sql statements for any stats, etc. Each custom group element is made up of: A header, which contains the name of the custom group element and is displayed as a row in report results. Submit Search. In the Order column, select Ascending or Descending. Create a report with Category, Subcategory and Revenue. Right-click the custom group, then select Edit. 1, custom group selector does not have the custom group elements, while in 9. The algorithm that calculates the table sizes performs the following steps: Calculate the number of levels per hierarchy: Hierarchy 1: 3. If projects are distributed asymmetrically across the cluster, when you assign an event-triggered schedule to a project, make sure you trigger the event on all nodes on which that project is loaded. With an OLAP Services license, user can perform additional OLAP analysis, using the following features: Displaying data on the fly: dynamic aggregation, page. Click on the Advanced tab and then the Configure button under 'Analytical Engine VLDB Properties,' as shown below: Expand the Analytical Engine folder and go to 'Subtotals Over Consolidations Compatibility. Consolidations enable users to create. Filters data related to a business attribute’s form (s), such as ID or description. Custom Tooltips in Microstrategy developer and Web The following table describes the macros you can use to customize graph tooltips in both MicroStrategy Developer and MicroStrategy Web: Macro Information Displayed {&TOOLTIP} All relevant labels and values associated with a graph item. MicroStrategy is the best BI tool used for reporting the data in very good design and graphical way. certificateOn the Graph menu, choose Preferences. To execute more than five statements, insert multiple statements in Report. com. To modify permissions for a user or group, from the Permission Level drop-down list for that user or group, select the predefined set of permissions, or select Custom to define a custom set of permissions. {&GROUPLABEL} Name of the graph item's category. . 5-7 Years. Consolidations are used to specify the data that you want to view in your report. Moving the CG/Consolidation to the left as a first column may fix the problem. Information about custom groups includes: About Custom Groups: Grouping Attribute Elements with Banding and Filtering Custom Group Effects on SQL Generation. 1 and 10. It queries SQL databases. 11. Examples include "Region = Northeast" or "Revenue > $1 million". Follow the steps below to create a list of all groups and the users in each group: In MicroStrategy Developer 9. To Create a Custom Group. So, I've had this problem in my hands for the last couples of days and it drives me crazy. Enable hierarchical display for the custom group. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. The report-related objects placed on the template, such as. . The report execution process is a three-step process: 1. A cross join between datasets can result in rows or Group Header/Footer sections that do not have metric data. Cards present predefined KPIs associated with a selected keyword sourced securely from MicroStrategy. Retrieve a list of user groups and the associated users in MicroStrategy Developer Follow the steps below to create a list of all groups and the users in each group: In MicroStrategy Developer 9. The index for referencing these objects begins with 0 and increases by. The properties needed to define a column of a DB table (Columns) Top level object - represents a Castor installation (Castor Server Config. MicroStrategy is a data analytics platform that delivers actionable intelligence to organizations of all sizes. Open up the same document in MicroStrategy Web 10. Slowly changing dimensions (SCDs) are a common characteristic in many business intelligence environments. 4. An object is a basic building block in MicroStrategy. The report-related objects placed on the template, such as attributes. This can be reproduced in Microstrategy Tutorial by following the steps below. You can use DateDiff to create a metric or attribute form that lists the length of time between two dates. Since the Query Engine uses a smart algorithm to combine consolidation elements and determine the minimal number of SQL passes, only one SQL pass may be needed for all the consolidation elements. The chart below contains a list of all the object types and object descriptions occurring in MicroStrategy metadata: Never used, and all functions should check that zero (0) never pass for a type. In MicroStrategy SQL Engine, a VLDB setting "Custom Group Interaction with Report Filter" exists to manage different situations in which a Custom Group interacts with the report filter. simply a grouping of attribute elements is called Consolidation. Handling slowly changing dimensions in a data warehouse depending on the user needs. community. We can define a. To view custom groups in a hierarchical structure on a report, you must: Expand the item display of at least one custom group element. From the perspective of the report design process, a custom group is an object that can be placed on a template. Derived metric based on attribute values Here is how could create and display data correctly on using below simple steps. Execute the report. It is a worthwhile technique. Create or edit. . The essential distinction is that consolidations work with attributes and custom groups use filters. Both products' features range. Second, create a metric that has the base attribute used in the consolidation as a part of the dimensionality. The elements of a metric level are described below: •. Syntax. This tool is known for its flexibility and speed of data study without losing on. The report displays derived elements defined using. Each custom group. Both consolidations and custom groups provide flexibility in reports, but the objects differ in their structure and use. Each of the individual "mini-reports" that make up the entire custom group report will have at least one, if not more, SQL passes of its own. Change the formatting of the values to have different colors. xConsolidations allow users to group attribute elements in new ways without changing the metadata and warehouse definitions. Populate and Evaluate: Fill report data required for display. The following is a quick reference table for a MicroStrategy Custom Group: A Custom Group is an Application Object that creates dynamic sets of data in such a way that it. If the report definition of a report with multiple custom groups is fairly complex, with many metrics and filtering criteria, the resulting complexity and size of the. To resolve this issue, perform the following steps: Right-click on the Project in MicroStrategy Desktop and go to Project Configuration. For example: OR. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. From the Tools menu, select Document Properties. Click New Custom Group Element. microstrategy. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. Change the order that the conditions are evaluated. All attribute element data is added together to form the metric values for the new Group derived element. It allows users to customize data visualizations and build personalized real-time dashboards. By default, the metrics Compound Profit and Profit Margin do not use a dynamic aggregation function. There are three types of objects: schema objects, application objects, and configuration objects. Connection mapping allows administrators to assign a user or group in the MicroStrategy system to a specific login ID on the data warehouse. Open the Desktop Window with the Navigation pane in Smart Mode. 2. Tableau has unique graphics options to present data in a meaningful manner. Right click and "Run as Administrator" to. The image below shows how the East Coast group derived element is created in the Derived Elements Editor: We provide industry standard online training on MicroStrategy Development , Administration and live project development with hand-holding support of expert t. Microstrategy - how to create a custom group with boolean band. The Report Pre Statement settings insert custom SQL statements at the beginning of the report SQL. And leverage the Page-By function to focus your analysis on one element. A custom group is made up of an ordered collection of elements called custom group elements. Enter a new name for the custom group element and press ENTER. {&GROUPLABEL} Name of the graph. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. Consolidation elements can also be an expression of attribute elements that make up a consolidation. In the Grouping panel, right-click the grouping field to display horizontally, and select Grouping Properties. com, that centralizes your learning content, from custom courses to project overviews and how-to videos, all alongside Education courses and certifications. In its most basic form it consists of two parts: A report template (usually simply called a template), which is the underlying structure of the report. For more details, see the Custom Groups and Consolidations chapter. I have a bunch of table that looks like this: Fact table 1. From the File menu, click Open. 7x are listed below. Learn how to switch to a compound grid, add column sets in this new visualization. The Configure Transactions Editor opens. This feature is similar to what we see in web pages. Ca se functions Microstrategy Case functions return specified data in a SQL query based on the evaluation of user-defined conditions. A ragged hierarchy is the one in which the parent attribute element of one or more. Compare all the important BI vendors with our 100% independent Business Intelligence tools comparison. An object is a basic building block in MicroStrategy. The Custom Group Editor opens. The Custom Group content should be similar to: 2) Create a RunningSum metric over the regular Revenue metric:1. Consolidation with diff groups of cities as regions. For example, the attribute Customer has the forms ID, First Name, Last Name, Address, and Birth Date. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. Dashboard performance troubleshooting in MicroStrategy 10. What are custom groups? Custom Group or Consolidation? - MicroStrategy James Oliver 10. | Meet MicroStrategy AI on the road. Cards present predefined KPIs associated with a selected keyword sourced securely from MicroStrategy. There's a reason we're at the top of the list. A custom group is a set of filters that can be placed on a template. MicroStrategy Best Practices Dynamic Custom Group in Dashboards or Dossiers Custom groups enable users to view specific elements based on a metric or specification. The mobile placement order follows a “Z-path” (left-to-right and top-to-bottom order). 9K views 4 years ago MicroStrategy In this video I will discuss. Normally, users would accomplish this with an attribute by setting it to the level of that attribute, however that may not produce desirable values. Custom Tooltips in Microstrategy developer and Web The following table describes the macros you can use to customize graph tooltips in both MicroStrategy Developer and MicroStrategy Web: Macro Information Displayed {&TOOLTIP} All relevant labels and values associated with a graph item. This approach makes it easier for you to specify a flexible partitioning. By default, this executable is located in C:Program FilesMicroStrategyIntegrity Manager. We will explore two objects that serve this purpose: Custom Groups and Consolidations. To decide for yourself whether you should or should not use custom group, you must first understand the SQL executed by Microstrategy when you create a custom group. When a user has additional attributes in the report objects window, the aggregation causes the consolidation to add up the percentages for the results for each attribute instead of dividing the overall numbers. To apply the selections as a slice,. ,) SQL level tuning (Stats, Indexes, Cross Join Avoid, etc. Article outlines why available cache is not utilised when drilling to an attribute inside of an Intelligent Cube report that contains a consolidation or custom group in MicroStrategy Developer (formerly Developer) and WebOnly 29% of organizations consolidate to reduce spending on licensing. Another possible solution in MicroStrategy would be to create logical tables to create an hierarchy like: Dept -> Old Dept -> Sub-Dept -> Old. Being able to run this calculation would. 5% of organizations plan to have adopted SASE by the end of 2022. For example, you might group the Month elements into December. DOWNLOAD NOW. Dashboard execution stages can be represented below: MicroStrategy Intelligence Server When an end user makes a Document Execution Request through any client (a web browser via MicroStrategy Web, the MicroStrategy Desktop/Developer client, the MicroStrategy Mobile app, or the MicroStrategy Office client), the request is sent to. After you find the microstrategy. In MicroStrategy Developer, create a new report or select an existing report to use as the data mart table. The primary characteristic of star schema is its use of dimension tables rather than single-attribute lookup tables. Experience in creating dashboards using Microstrategy Involved in validating data returned in all reports, provided a detailed analysis of data, and identified data quality issues. What is relevant, rather than the sum, is the last atomic inventory value in a given period of time. The different kinds of value prompts are: Date prompt: Users enter a specific date for which to see data. An object is a basic building block in MicroStrategy. This helps the BI platform to extensively. Select any project that is in the project source that contains the users and groups and click Next. Example.