2. This has been tested to work successfully in a 9. 3 and later) Supports exporting to PDF (10. In this case, only one form exists for each, as shown below:With MicroStrategy, SQL optimization is performed, by default, across passes corresponding to different elements of a Custom group when possible. {&GROUPLABEL} Name of the graph. Go to project configuration by right clicking on specific project (You need admin rights to do this). MicroStrategy’s OLAP Services is an expansion of MicroStrategy Intelligence Server. Group 3: New Orleans, Seattle, Boston and New York. 3. Both documents and RS dashboards provide the freedom to design a dashboard pixel-by-pixel in multiple editing and previewing modes. 4. Create a report with Year, the Region consolidation, and the Profit metric. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. Following are the steps to create a custom group. So distinct counts would not be possible. Click Save to save changes. 2. In this case, only one form exists for each, as shown below: With MicroStrategy, SQL optimization is performed, by default, across passes corresponding to different elements of a Custom group when possible. Cross-tab: Pivot and display sorting and page-by Each of the engines plays an important part in the report execution process. Enable Subtotals and enable a basic total. Next, browse and choose the required attributes to create the. These groups provide a new view of report data for analysis and formatting purposes. Adding consolidations and custom groups . Disadvantages of Power BI: Limited Data Capacity in Free Version: The Power BI Desktop version has a data capacity restriction, which can limit in-depth data analysis for larger datasets. Below are the steps to enable/disable the settings of data blending: 1. Report will display result as below. DOWNLOAD NOW. Tableau can map latitude and longitude coordinates and link them to spatial data. In the "Metadata Repository" screen, select the "Project Source Name" and check the "Export Translations" option, as shown in the. Here we have compiled a set of MicroStrategy interview questions asked in top organizations around the world. KB16396: A total subtotal incorrectly sums both the elements and individual items in a custom group in MicroStrategy Devel… Number of Views 611 KB4531: How to create a report that displays the top 'n' Item sales (variable) for each Subcategory within a. likes. Microstrategy Dossiers With the release of MicroStrategy 10. Subtotals are totals of selected groups of your metric data, totaled at a level you select. Consolidations are used to group the attributes without disturbing the schema and it can group attributes based on the elements. First, create a consolidation that has a few elements but specifically at least one element with more than 2 attribute elements in its consolidation. Select the environment and project where you want to create your consolidation. {&GROUPLABEL} Name of the graph. For tp & TPPARAM: System Overview Screen -> SAP System -> Check -> Transport Tool. For more details, see the Custom Groups and Consolidations chapter of the Advanced Reporting Help. In the list of categories on the left, click Subtotals. Consolidation ; Custom group; Fact; Metric; Subtotal; Transformation; For information about consolidations, custom groups, metrics, and subtotals, see the Advanced Reporting Guide. ). A consolidation allows you to group together the elements of the Month of Year attribute into various seasons and place them on the template. Consolidations and custom groups can support, because another sql statement may be created and retrieve the correct results from base tables. For detailed steps to define a condition, see Condition Editor. Ritinder Kaur Business Intelligence 1 comment. Consolidations: Grouping Attribute Elements with Arithmetic and Logical Operators. Microstrategy Document Editor Sections Important Notes: The Layout area is in the center of the Document Editor interface and provides the framework for precisely controlling where controls (such as text fields, grid and graph reports, images, and widgets) are displayed when the document is viewed in different display modes, printed,. Third party code/SQL: MicroStrategy Technical Support does not provide customized SQL queries. Your personal view subscription is saved, and you are returned to the report, document, or quick dashboard. Create or edit. The total is calculated for all the selector items. A custom group is made up of an ordered collection of components called custom group elements. A Document Autostyle is a collection of formatting properties saved in a document for various control types (sections, text fields, lines, etc. The recursive hierarchy table has to be split into several tables, one for each level in the hierarchy. Step 10) Press “Back” for the SAP Standard Toolbar. In some cases custom group/consolidation on a report may cause metric value not to be shown. 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. Under 'Level…' choose the attribute. Information about custom groups includes: About Custom Groups: Grouping Attribute Elements with Banding and Filtering Custom Group Effects on SQL Generation Custom Group Structure on Reports Creating a Custom Group Editing and Formatting a Custom Group Consolidations are groupings of attribute elements while custom groups are based on filter criteria. A custom group lets you group attribute elements from the same or different attributes to meet your reporting requirements. Copy cleanup. A custom group can group attribute elements in a way that is not defined in the data warehouse. community. By default, this executable is located in C:Program FilesMicroStrategyIntegrity Manager. The essential distinction is that consolidations work with attributes and custom groups use filters. Use a percent-to-total shortcut metric to show cell-level values as percents of an accumulated row or column total. They act as containers for non-standard SQL expressions that MicroStrategy does not support. The Consolidation Editor contains the following sections: The left pane contains an element list that includes the consolidation element you add. Create a Report Services Document 2. They can create custom calculations, prompt for inputs, and easily share findings. A custom group can group attribute elements in a way that is not defined in the data warehouse. Say you want to create a custom group called "Sales Region" based on the State attribute: Tom sales region - California, Oregon, Nevada; Mary sales region - Atlanta,. Split Hierarchy with M-M relationships: Explanation. – Filters. 3. Custom groups; A custom group is a special filter that can be placed on a template and. 3. The Item_id, Day_id, and Call_Ctr_id columns in the table above represent practical levels at which sales. Javadoc API documentation for MicroStrategy 2019. In this example, you need to break down the territories as follows: East = Mid-Atlantic, Northeast, Southeast. Step 2. We can define a. This feature is similar to what we see in. All right, let’s get started! Performance Indicator We will explore two objects that serve this purpose: Custom Groups and Consolidations. (For a definition and examples of levels of aggregation, see How data is aggregated on a report: metric level . Otherwise, to define tooltips for a single series, select the name of the series. The Condition Editor opens. | Meet MicroStrategy AI on the road. With an OLAP Services license, user can perform additional OLAP analysis, using the following features: Displaying data on the fly: dynamic aggregation, page. We need to establish a consolidation route for each transport layer. Login to MSTR Developer then go to: User Manager > User Definition > Project Access. The partition attribute should allow for near uniform distribution of data across the partitions, so that the workload on each partition is evenly distributed. 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. Visualize the flow from one set of values to another to gain insight into relative contributions. All attribute element data is added together to form the metric values for the new Group derived element. This article will help. For example - We need to see a… Custom number format syntax — If none of the built-in number formats meet your needs, you can create your own custom format in the Number tab of the Format Cells dialog box. The Subscribe to FTP dialog box opens. Select only Configuration Objects for documentation. Creates a connection object which is used in subsequent requests and manages the user’s connection with the MicroStrategy REST and Intelligence Servers. Consolidations are used to create virtual attributes to allow reporting on attributes that do not exist in the data model. x, there is no way to duplicate a custom group element. Each element in the custom group can have a different output level. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Enterprise Analytics Business Intelligence; HyperIntelligence; Cloud; Product Innovation; Education; Consulting HyperIntelligence and its Architecture. A consolidation is a set of attribute elements grouped in a way that they were not originally grouped within the project, so that you can use the consolidation (the newly consolidated elements) just like a regular attribute on a report. Derived element groups are defined by a list, filter, or calculation. Say you have product group A, product group B, product group A+B. This prompt is used in a filter. Enter a name for the custom group in the Enter Custom Group Name Here field. x and 10. 4. Consolidations are groupings of attribute elements while custom groups are based on filter criteria. How MicroStrategy empowers you to design and deploy compelling, responsive Dossiers suited for all audiences and devices in under a day Speakers: Amy Laresch, Product Manager, MicroStrategy; Keng-Fu Chu, Principal UX Designer, MicroStrategy; Jeff Courcelle, VP of UX Design, MicroStrategy; Julia Zhu, Sr. {&GROUPLABEL} Name of the graph. The primary characteristic of star schema is its use of dimension tables rather than single-attribute lookup tables. Labels: #Creat transaction services photo uploader #transaction. A report is a MicroStrategy object that represents a request for a specific set of formatted data from your data source. Consolidation ; Custom group; Fact; Metric; Subtotal; Transformation; For information about consolidations, custom groups, metrics, and subtotals, see the Advanced Reporting Guide. Slowly changing dimensions (SCDs) are a common characteristic in many business intelligence environments. Architects can create custom-based transformations to provide details for time periods such as Last Year, Month, Date, and others. The following is a quick reference table for a MicroStrategy Custom Group: A Custom. 7x" database object is used (set at Configuration Managers > Database Instances > Database Instance > Database connection type) Selected Default VLDB Properties for Hive 0. This is a database instance level VLDB setting. Mid-America = Central, South. A custom group lets you group attribute elements from the same or different attributes to meet your reporting requirements. 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. Right-click on an existing environment and choose Properties. 1. If Custom Group A has six elements, Custom Group B has five elements and Custom Group C has eight elements, the number of SQL passes generated would be 6 x 5 x 8 = 240. Information about custom groups includes: About Custom Groups: Grouping Attribute Elements with Banding and Filtering Custom Group Effects on SQL Generation. Grouping specific months into a seasons consolidation. Create a virtual attribute to allow reporting on an attribute that does not exist in the data model. . Consolidations allow users to group attribute elements in new ways without changing the metadata and warehouse definitions. User specifies the tables to load into memory; Attributes/Metrics are mapped to these tables. Example. Compare all the important BI vendors with our 100% independent Business Intelligence tools comparison. The algorithm that calculates the table sizes performs the following steps: Calculate the number of levels per hierarchy: Hierarchy 1: 3. Custom Group or Consolidation? - MicroStrategy James Oliver 10. Schema objects include facts, hierarchies, and custom groups; application objects include reports, documents, and metrics; and configuration objects include project sources, database instances. This option is available only when the Compress Contents check box is selected. The report displays derived elements defined using. On the toolbar, click Add Element. For example, you need to analyze data by season (Fall, Winter, and so on) although your project does not contain a Season attribute. The following is an example of a 'Customer Geography' consolidation: Save the consolidation. Click the Options icon . Save the report as “Email Bursting”. To Define Custom Group Elements. Features: MicroStrategy and Tableau are two unique tools that offer incredible features. Change the band names to Top Performers, Average Performers, and Under-Performers. To categorize the customer based on the total dollars spent in 1997, add the filter at the custom group level or at the metric level. Following are the steps to create a custom group. 3. Click the Options icon . In your Datasets panel, hover over the name of your dataset. MicroStrategy functions are classified into the following types: Single-value functions (also known as Non-grouping or Scalar functions): These functions operate on each individual component of an input variable or argument, resulting in an output element for each component. It provides the capability for complex calculations, trend analysis, etc. MicroStrategy - Real Time Consolidations & Custom Groupings - Online Training Video by MicroRooster MicroRooster 6. com Format: A MicroStrategy Online Training Video blog. 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. ” icon to expand it: All page-by attributes will. Change the formatting of the values to have different colors. An object is a basic building block in MicroStrategy. Edit the custom group "Top 5 Contributors vs. within a function are separated by commas. The Grouping panel is displayed. mstr) files that can be sent through Distribution Services is defined by the MicroStrategy (. Custom groups are. They are group-value functions. Copy the code for the D3 visualization you are using. 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. Query Stage: Retrieve data from the warehouse. Click 'OK'. A custom group is used to group attribute elements and aggregate results in a report. blogspot. x. In contrast, consolidations. 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. . These groups provide a new view of report data for analysis and formatting purposes. When creating or editing a custom group in MicroStrategy Developer 9. 1 comment. Being able to run this calculation would be useful for. Type the Name of the personal view. com Format: A MicroStrategy Online Training Video blog. The metric can also show a total by page, show a total for each value of the attribute, or show the grand. Both consolidations and custom groups provide flexibility in reports, but the objects differ in their structure and use. A recent survey by Gartner, Inc. Specify the desired delivery options including recipient address, subscription name. . Choose the option, Add an Attribute qualification. {&GROUPLABEL} Name of the graph item's category. There are three types of objects: schema objects, application objects, and configuration objects. The third-party product(s) discussed in this article is manufactured by vendors independent of MicroStrategy. A report is a MicroStrategy object that represents a request for a specific set of formatted data from your data source. Consolidation elements are attribute elements that define the consolidation. Group Elements. MicroStrategy is a data analytics platform that delivers actionable intelligence to organizations of all sizes. Case. MicroStrategy recommends that you use event-triggered schedules in situations where it is important to control which node performs certain tasks. The total is calculated for all the selector items. Explanation. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . Both consolidations and custom groups provide flexibility in reports, but the objects differ in their structure and use. It enables you to group attribute elements in new ways without altering the metadata and warehouse. 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. 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. By the way, there is no. 1, custom group selector does not have the custom group elements, while in 9. Step 3. The maximum file size of dashboard (. Slowly changing dimensions in MSTR. 3. One element will show the top ten customers and another element will show all customers. The Custom Group Editor appears. The purpose of this Tutorial is to create a report which displays the top ten contributors versus all other contributors by use of custom groups in MicroStrategy Web. 16. Without data, the dashboard will not show the user anything. For example, setting Metric Join type to "Outer" at the report level (Metric editor > Tool > Metric Join Type) overwrites the Metric Join Type set at the Database Instance Level: The subject of Outer Joins is a very broad one, however, as a. Step 2. A connection map in MicroStrategy is a link between a MicroStrategy user, a database connection, and a database login. Invoke the MicroStrategy Integrity Manager executable MIntMgr. 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. Custom Groups : Custom groups are set of filters and. A simple metric sum (Revenue) will go to different aggregate tables depending on the attributes on the template. Display the hierarchical view in the report (MicroStrategy Developer only) These tasks are completed at different levels and in different MicroStrategy. Now using the mouse place the cursor on text box of 10000 which is next to 'Maximum number of monitoring objects displayed per page. The SQL will pull back counts for A and B. By implementing the security policies and configurations provided by MobileIron, administrators can apply enhanced protections to mobile devices in use across the enterprise. From the Visualizations panel, select Grid . Drag an attribute from the Datasets panel to the Rows area of the Editor panel to add attributes to the rows. Consolidations are groupings of attribute elements while custom groups are based on filter criteria. It is made up of an ordered collection of elements referred as custom group elements. 2) Create Metric2 as the RunningSum of Metric1. Custom groups are more flexible than consolidations because you do not have to know much about your data to create filters for a custom group. 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. 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. 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. Now your connection f. Remember that P displays the parent attribute and 0 (the number zero, not the letter o) displays all the forms of the parent attribute. This helps the BI platform to extensively. The following schema shows which setting takes precedence when set at different levels. Depending on your MicroStrategy product and licensing, this function may not be available. Open up the same document in MicroStrategy Web 10. Select your custom visualization. a) Attribute form qualification. 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. The consolidation calculates at the report dataset level, aggregates that, and then does the consolidationCustom 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. To choose a metric, execute one of the following: In the Metric box, enter in the desired metric name and click OK. 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. Homogeneous mapping: For consistency, it is a good idea for columns that contain the same data to. 3. Custom groups are used to apply different filters to different rows of a report. Custom group elements can include a logical expression containing any of the following qualification types ("Developer" and "Web" indicate which product the qualification can be created in): Attribute qualification (Developer, Web): Restricts data based on the value of an attribute form; lets you view data only for attribute elements in a list. The. 2. {&GROUPLABEL} Name of the graph item's category. In the Grouping panel, right-click the grouping field to display horizontally, and select Grouping Properties. Hierarchy 2: 4. If the element name is shown, then the sum will be shown. 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. Step 7) In the next screen, Enter Field Status Groups for the Field Status Variant. The attribute level follows a consecutive order from. MicroStrategy functions are classified into the following types: Single-value functions (also known as Non-grouping or Scalar functions): These functions operate on each individual component of an input variable or argument, resulting in an output element for each component. Submit Search. Place the newly created consolidation in the template. Cards present predefined KPIs associated with a selected keyword sourced securely from MicroStrategy. From the left, click Document. All articles. Version 2021. 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. A custom group lets you group attribute elements from the same or different attributes to meet your reporting requirements. 0, while Tableau is rated 8. ) A subtotal lets you see the. That is, we will not be able to create these elements using the. Select only Configuration Objects for documentation. For example, the application for the Sales team may be locked to two groups. The Custom Group Editor opens. 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. Right-click the header of the attribute whose elements you want to use to. x, select 'Project Documentation' from the Tools menu to start the wizard. Use that metric in a custom group that bands based on metric value and for each metric value. Select any project that is in the project source that contains the users and groups and click Next. STEPS TO REPRODUCE: Follow the steps below in order to reproduce this issue using the MicroStrategy Tutorial project: 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. In MicroStrategy Web, right-click an object and select Share. You can consider custom groups as many different reports "stacked up" together. comArchitects can now do more with MicroStrategy Workstation. 6. After you find the microstrategy. The fuel for business dashboards is data, so each one needs to have one or more data sources. Description: A training video demonstrating how to create, use and forma. Summer consists of June + July + August, fall consists of September + October + November, and so on. 3. Dashboard performance troubleshooting in MicroStrategy 10. February 24, 2017 Uncategorized 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. In the right corner of the dashboard, change the data source to none. This type of passthrough can be used to create flexible filters. MicroStrategy AI is here. For example, we create a group that is “East Zone” and generate a list of regions that are in the east zone. 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. Per-column group Advanced Filter; Thresholds . Consolidations are groupings of attribute elements while custom groups are based on filter criteria. 1. This article might want you to upgrade faster to the newest version and enjoy all of the enhancements in creating your stories!. Passes that hit the same fact table across different elements of a custom group are merged provided that they satisfy certain conditions. -> Check -> Request Consistency. This allows you to group attribute elements on a report in a way that is not defined in your data warehouse. . From the list of available objects, select the objects to be used as default values for the prompt and click on '>' to add them to the list of selected objects. The custom group elements can be. Per Cell: Allow MicroStrategy to display the selected metrics using the axis values best suited to display the metric data. Examples include "Region = Northeast" or "Revenue > $1 million". Number of offices 3. You must have the MicroStrategy Report Services product to view and create documents and RS dashboards. STEPS TO. MicroStrategy Interview Questions. Yes. The 30+ free BI comparison graphs will give you instantly insight in the pros and cons. To add a derived element to a document, open the document in Editable Mode. Below are the recommended best practices when scheduling jobs and administrative tasks in MSTR: Executing simultaneous reports can strain system resources. An attribute form qualification might filter on the form Last Name, the operator Begins With, and the letter H. September 22, 2023. Three common microstrategy developer soft skills are analytical skills, communication skills and creativity. . Double-click 'Add Qualification'. The steps below show you how to create a custom group in MicroStrategy Web. KB42896: How to grant privileges to a user, user group or security role using MicroStrategy Command. Ensure that subtotaling is enabled for the consolidation. A physical snapshot of the solution is: Each attribute has a 1-M relationship with its child. MicroStrategy is a data visualization tool. utils. The report data is as displayed below. Especially for you we decided to list and test the most interesting new features that MicroStrategy 2020 brings to dossiers. When creating a VI Dashboard which contains a grid dataset along with either a consolidation or custom group object, the 'Create Attribute' option does not display for any other normal attribute in the dataset. x. 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. 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. mtc is the name of the saved test file. 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. The report-related objects placed on the template, such as attributes. It is expected to not see individual items under the custom group element as the filter qualification for the custom group excludes all data. Reports that contain B or C will ignore filters on the other. These values are set by default when the "Hive 0. Case ( (Category@ID = 1), Revenue, 0) Booksand Name it as Revenue for where 2 is Category ID for "Books" Report will display result. Tableau is a data visualization tool that helps create appealing charts, reports, and dashboards that are easy to share and interactive. Create New Metric in a report or VI. found that 75% of organizations are pursuing security vendor consolidation in 2022, up from 29% in 2020. STEPS TO REPRODUCE: Create a document in MicroStrategy Developer or Web 10. Whether you're working with dossiers, cards, documents, or managing an entire intelligent enterprise, Workstation empowers you to do everything from one place. A new custom group element is created, with the default name Custom Group Element1. 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. 1. Add a condition to a custom group element. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. Run the document on iPad, as shown below: 12. Consolidations vs Custom Groups. Visit the data visualization and data dashboard galleries for inspiration. A cross join between datasets can result in rows or Group Header/Footer sections that do not have metric data. If the Sort By object is a consolidation or metric, the only option is Default. Group 4: London, Fargo, Memphis and Charleston . Group Elements. Instead of a consolidation, a custom group can be defined. While this feature is similar to using an ApplySimple in a filter, the difference is that you can customize both sides of the condition, whereas with the ApplySimple you can only customize one side to be equal to a single Attribute Form. The schema looks like the following diagram. Add this custom group into a report and select 'Yes' for the Allow Subtotals column under the Report Data Options function. The report is showing the correct results: Next, I created a Custom Group as follows: Now, add this custom group to the report and remove the Subcategory. KB43303: After a consolidation is added to the sort-by in the runningsum parameters, the consolidation disappears after clicking OK and going back into the runningsum parameters in MicroStrategy 9. Uninstall all the MicroStrategy and related products from Control Panel: Any MSTR Hotfixes applied. 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. Browse to the folder in which to create the new custom group, then click the Create Custom Group icon. Nature: By nature, both Tableau and MicroStrategy tools are Business Intelligence software designed for visualizing data. x, select 'Project Documentation' from the Tools menu to. In free-form layout, we provide an intuitive way to let you visually “group” containers together. Users can explore, filter, and visualize data with drag-and-drop functionality. For example, the before and after SQL that is generated for a. But it’s nipping at the heels of leading BI. A custom group is a set of special filters that can be placed on a template. Normally, users would accomplish this with an attribute by setting it to the level of that attribute, however that may not produce desirable values.