Click the Options icon . The report execution process is a three-step process: 1. x. Handling slowly changing dimensions in a data warehouse depending on the user needs. Consolidations are used to create virtual attributes to allow reporting on attributes that do not exist in the data model. The Condition Editor opens. For example, a report. The following auto text codes allow you to add document variable information to your document. In addition, this release introduces new features across the analytics, mobility, and security platforms—making it easier for users to build applications faster. You can only certify dossiers in the Dossiers area of the Navigation pane. Now using the mouse place the cursor on text box of 10000 which is next to 'Maximum number of monitoring objects displayed per page. 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. Ca se functions Microstrategy Case functions return specified data in a SQL query based on the evaluation of user-defined conditions. -> Check -> Request Consistency. The header is an arbitrary name that you define when you create the element. 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. These auto text codes are automatically replaced by information about the document. 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. In some cases custom group/consolidation on a report may cause metric value not to be shown. Consolidations and custom groups can support, because another sql statement may be created and retrieve the correct results from base tables. To open a document in Editable Mode, from a folder, right-click the document, point to Run as, and select Editable. Consolidations allow you to qualify a report on a row-by-row basis. From the perspective of the report design process, a custom group is an object that can be placed on a template. Click Nextto pass ScanMD introduction to the next step, which is Step 1of ScanMD. Say you have product group A, product group B, product group A+B. West = Northwest, Southwest. cache; com. Application objects: Application objects include filters, prompt, documents, templates, reports, custom groups, and. In MicroStrategy Web, click the metric for which you want to enable a grand total or subtotals. x with any number of attributes. . That is, we will not be able to create these elements using the. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. consolidation elements, which can be individually formatted. this allows users to perform the in-depth analysis of their data and get the valuable results from their data. After you find the microstrategy. 0). What are custom groups? Custom Group or Consolidation? - MicroStrategy James Oliver 10. Passes that hit the same fact table across different elements of a custom group are merged provided that they satisfy certain conditions. 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. For example, ApplySimple ("#0 * #1", [col1], [col2]) indicates that two items, col1 and col2, referenced. Follow the steps below. In contrast, consolidations. Run the document on iPad, as shown below: 12. There's a reason we're at the top of the list. 1031 views | July 14, 2020 56:15. This is a single-value function. The Apply functions are not meant to take. 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. To allow sorting on the attribute elements after sorting by the metric total value, users may follow the steps below: Create a level derived metric to calculate on the attribute level at which the subtotal is calculated. Right-click the dossier you want to certify. 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. Create a Report Services Document 2. com, that centralizes your learning content, from custom courses to project overviews and how-to videos, all alongside Education courses and certifications. 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. Display the hierarchical view in the report (MicroStrategy Developer only) These tasks are completed at different levels and in different MicroStrategy. Compare all the important BI vendors with our 100% independent Business Intelligence tools comparison. Michael Sandberg's Data Visualization BlogMicroStrategy ONE introduces new features that provide better performance and scalability to enhance the overall user experience. For example, we create a group that is “East Zone” and generate a list of regions that are in the east zone. We will explore two objects that serve this purpose: Custom Groups and Consolidations. mstrc) Open Workstation. Description: MicroStrategy lets you create consoli. Do one of the following: To apply the selections as a filter, select the Apply selections as a filter for all new targets check box. To add a derived element to a document, open the document in Editable Mode. This option is available only when the Compress Contents check box is selected. com Format: A MicroStrategy Online Training Video blog. A consolidation allows you to group together the elements of the Month of Year attribute into various seasons and place them on the template. ApplySimple() Accepts facts, attributes, and metrics as input. Now to fix this create a new Derived metric on Category attribute first with formula as Max (Category) {~ } and calling Books. 2. Designed Prompts and Filters to generate reports in grid and graph mode. 3. A custom group is a set of filters that can be placed on a template. The property is named "document grids from multiple datasets" and defaults to enabled but can be set to disabled. This report is made up of custom group elements that consist of a header a. Change the order that the conditions are evaluated. Information about custom groups includes: About Custom Groups: Grouping Attribute Elements with Banding and Filtering Custom Group Effects on SQL Generation. In the list of categories on the left, click Subtotals. For example, you may want to see all the customers in a retail store that bring in over $1,000k in revenue per month, or a teach may want to only view data on students who scored over 2000 on their SATs. To apply the selections as a slice,. 3. The trouble of modifying custom SQL for every object which uses an Apply function when customers switch to different RDBMS and the SQL pattern changes for functions. In the Microstrategy Developer go to Tools -> Preferences(Not my prefernces :)) Under Developer category -> select Browsing on the browsing tab you see all the options like below: 3. This has been tested to work successfully in a 9. microstrategy. It is expected to not see individual items under the custom group element as the filter qualification for the custom group excludes all data. The SQL for a report with a custom group is likely to be very complex. For example, you may want to see all the customers in a retail store that bring in over. 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. User specifies the tables to load into memory; Attributes/Metrics are mapped to these tables. In the Order column, select Ascending or Descending. Fu nction Types. Add a condition to a custom group element. Consolidations allow users to group attribute elements in new ways without changing the metadata and warehouse definitions. Zip File Name: Type a name for the zip file in the Zip File Name field. Group Elements. Below are the new features exclusive to. Syntax. 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. Microstrategy Dossiers With the release of MicroStrategy 10. A physical snapshot of the solution is: Each attribute has a 1-M relationship with its child. Another possible solution in MicroStrategy would be to create logical tables to create an hierarchy like: Dept -> Old Dept -> Sub-Dept -> Old. 2. 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. The different kinds of value prompts are: Date prompt: Users enter a specific date for which to see data. The partition attribute should allow for near uniform distribution of data across the partitions, so that the workload on each partition is evenly distributed. microstrategy. The Grouping panel is displayed. The custom group elements can be. x, select 'Project Documentation' from the Tools menu to. Pros. The object Type is listed as Super Cube: This can also be seen when editing or authoring a dossier. This is called heterogeneous column naming. Pass-through expressions, also called Apply functions, allow use of special functions or syntactic constructs beyond what MicroStrategy can create on its own, but can be obtained through the relational database. comArchitects can now do more with MicroStrategy Workstation. Add the Custom Group to Grouping, as shown below: On Call Center Group, right click and select Sort – Inherit attribute sort. Labels: #Creat transaction services photo uploader #transaction. MicroStrategy Advanced Reporting Guide provides comprehensive information on advanced topics for using the MicroStrategy query and reporting products. Browse to the folder in which to create the new custom group, then click the Create Custom Group icon. MicroStrategy is rated 8. x and 10. In the "Metadata Repository" screen, select the "Project Source Name" and check the "Export Translations" option, as shown in the. Under Elements for this consolidation, right-click and select Add Element. 3. In the Calculations - Subtotals window, Select the desired Custom Group and select Yes in the Allow subtotals drop down. ,) SQL level tuning (Stats, Indexes, Cross Join Avoid, etc. The following is an example of a 'Customer Geography' consolidation: Save the consolidation. 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. There are three types of objects: schema objects, application objects, and configuration objects. Click the “Burst. 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:. You can even import consolidation elements from other consolidations in the project to create consolidation elements. Grouping specific months into a seasons consolidation. The different kinds of value prompts are: Date prompt: Users enter a specific date for which to see data. ( How?) Double-click in the Custom Group Definition pane. 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. Consolidation elements are attribute elements that define the consolidation. Normally, users would accomplish this with an attribute by setting it to the level of that attribute, however that may not produce desirable values. The abundant design options deliver full control over position, formatting, and interactivity. Examples include "Region = Northeast" or "Revenue > $1 million". objects that you can place on a report template. This feature is similar to what we see in. To open a document in Editable Mode, from a folder, right-click the document, point to Run as, and select Editable. Level metrics allows the users to choose the right combination of level target, filtering, and grouping (referred to as elements) to achieve your desired results. The report-related objects placed on the template, such as. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. 3. The mobile placement order follows a “Z-path” (left-to-right and top-to-bottom order). Custom Group Editor. Instead of a consolidation, a custom group can be defined. This feature is only implemented for element list prompts. This allows you to group attribute elements on a report in a way that is not defined in your data warehouse. 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. use functions that are not standard in MicroStrategy but are available in various RDBMS platforms. You'll find everything from waterfall charts to word clouds in our community. 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. Modified 3 months ago. 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. Each element in the custom group can have a different output level. It is used to apply database (row-level) security to a MicroStrategy user. Interact with the engaged MicroStrategy Community to get answers to all your. – Filters. The Document Properties dialog box opens. Definition. Type the Name of the personal view. -10 belong to the aggregate function family whose function type is called DssFunctionSQLTypeAggregation in MicroStrategy. Source: MicroRooster. Define the advance sort on the derived. 1, custom group selector does not have the custom group elements, while in 9. 1. if both conditions are met, then Red, else Green. Schema objects include facts, hierarchies, and custom groups; application objects include reports, documents, and metrics; and configuration objects include project sources, database instances. Step 3. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Watch this to learn about creating custom groups, time-based transformations, and shortcuts—all in. Custom groups. II. 2. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. UX Designer, MicroStrategy To enable totals or subtotals for a metric. For example, the attribute Customer has the forms ID, First Name, Last Name, Address, and Birth Date. Features: MicroStrategy and Tableau are two unique tools that offer incredible features. 4. 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. By the way, there is no. Consolidations enable users to create customized. Now Edit the "Revenue for Books metric and Replace Category@ID with this new Books metric formula would looks like this Case ( (Books = 1), Revenue, 0. Paste the CSS for the style and the javascript code into the Code Editor tab. Inherit Attribute Sort, which uses the default sort of the attribute form set to display first. See below: Notice in Developer, you can currently right click on this document and select the 'Edit' option. Microstrategy Dossiers With the release of MicroStrategy 10. 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. Cards present predefined KPIs associated with a selected keyword sourced securely from MicroStrategy. (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. 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. About Custom Group Elements. Notice that the bars are described by the labels on the X Axis, which break down as follows: Central (Region attribute), Jan 2010 (Month attribute), and either Lethal Weapon 4 or Zorro (custom group elements based on Item attribute). Open the Desktop Window with the Navigation pane in Smart Mode. Each element contains a set of filtering or banding qualifications. Click the Options icon . Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. Right-click the header of the attribute whose elements you want to use to. Through these interview questions and answers you will learn what is metadata, attributes, mapping, hierarchies, facts, smart metrics, transformations, filters, prompts and more. 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. x, select 'Project Documentation' from the Tools menu to start the wizard. From the Elements menu, choose Add Element. By default, this executable is located in C:Program FilesMicroStrategyIntegrity Manager. Both consolidations and custom groups provide flexibility in reports, but the objects differ in their structure and use. To install this visualization, download the . The Custom Group Editor opens. Ensure that subtotaling is enabled for the consolidation. From the Visualizations panel, select Grid . For example, you might group the Month elements into December. x and add a derived attribute, right clicking an. MSTR Secure Enterprise. 0, while Tableau is rated 8. simply a grouping of attribute elements is called Consolidation. Click New Custom Group Element. 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. A consolidation allows you to group together various elements of the Region attribute into various territories and place them on your template. Schema objects include facts, hierarchies, and custom groups; application objects include reports, documents, and metrics; and configuration objects include project sources, database instances. MicroStrategy recommends that you use event-triggered schedules in situations where it is important to control which node performs certain tasks. Result for new metric is blank. Depending on your MicroStrategy product and licensing, this function may not be available. Step 1. The settings are numbered 1-5. A derived element is a grouping of attribute elements on a report. STEPS TO. MicroStrategy has partnered with MobileIron to add an extra layer of security to MicroStrategy Mobile applications running on iOS devices. 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. KB13530: Feature in MicroStrategy SQL Generation Engine: Set Operator Optimization . ). The total is calculated for all the selector items. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. 5K subscribers Subscribe 3. 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. location_path is the folder where the consolidation resides, of type string, between double quotes ("). Select the Password protect zip file check box and type a password for the zip file. There are three types of objects: schema objects, application objects, and configuration objects. 2) Create Metric2 as the RunningSum of Metric1. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . Double-click 'Add Qualification'. All right, let’s get started! Performance Indicator We will explore two objects that serve this purpose: Custom Groups and Consolidations. Metadata partition mapping is the mapping of partitions where the mapping of partitions is performed and maintained in the project metadata by the application, in this case, MicroStrategy. Both products' features range. Source: MicroRooster. 5% of organizations plan to have adopted SASE by the end of 2022. attribute elements. Each element contains a set of filtering or banding qualifications. ApplySimple() Accepts facts, attributes, and metrics as input. Use that metric in a custom group that bands based on metric value and for each metric value. Being able to run this calculation would. Enable Subtotals and enable a basic total. That is, the metric calculates at the level of the target, if possible. Details of 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. exe using the command line. Enable Subtotals and enable a basic total. A percent-to-total shortcut metric displays the percent in relation to a selected total of each item affected by the metric. To support best dashboard execution and concurrency performance, MicroStrategy has chosen to limit the number of logical CPUs engaged for any single grid evaluation to 4. Number of consultants & teachers ___. 3. For Network: Transport Routes Overview -> Config. 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. Custom groups are used to apply different filters to different rows of a report. – Filters. Number of offices 3. blogspot. 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. Custom groups; A custom group is a special filter that can be placed on a template and. V. Invoke the MicroStrategy Integrity Manager executable MIntMgr. Place the newly created consolidation in the template. A recent survey by Gartner, Inc. The “ #n” code in Apply function syntax serves as placeholders for the MicroStrategy objects being passed to your database. Qualifications are the actual conditions that must be met for data to be included in the custom group element. The report-related objects placed on the template, such as attributes. found that 75% of organizations are pursuing security vendor consolidation in 2022, up from 29% in 2020. In the list of categories on the left, click Subtotals. Vitaracharts for Microstrategy offers a variety of customizable data marker options for all charts including grids where there is a wide variety of use cases for this feature. Following are the steps to create a custom group. 4. In MicroStrategy Developer, create a new report or select an existing report to use as the data mart table. If a user enters more than 15 digits for a. 1. Same thing for Sub-Dept 201. Then, for mobile devices, our Responsive View will take over the layout and place groups vertically on the canvas. In MicroStrategy Web, click the metric for which you want to enable a grand total or subtotals. Syntax . By implementing the security policies and configurations provided by MobileIron, administrators can apply enhanced protections to mobile devices in use across the enterprise. So, I've had this problem in my hands for the last couples of days and it drives me crazy. 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. blogspot. Relate tables are often used to create relationships between attributes. From the Schedule drop-down list, select a schedule or event on which to deliver the report or document. 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. Consolidations are used to create virtual attributes to allow reporting on attributes that do not exist in the data model. Open the document in Design or Editable Mode. Display the hierarchical view in the report (MicroStrategy Developer only) These tasks are completed at different levels and in different MicroStrategy. 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. Choose the option, Add an Attribute qualification. So distinct counts would not be possible. Open up the same document in MicroStrategy Web 10. Consolidations vs Custom Groups. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. An object is a basic building block in MicroStrategy. Your separator may vary depending on your number and date format locale. x, select 'Project Documentation' from the Tools menu to. There are three types of objects: schema objects, application objects, and configuration objects. Next, browse and choose the required attributes to create the. The following procedure describes how to. Intelligence Server generates the SQL to execute against the data source (can use Multi-Source)where: customgroup_name is the name of the custom group, of type string, between double quotes ("). The following window appears on completing the above step. Get inspiration at the MicroStrategy data visualization gallery. Login to MSTR Developer then go to: User Manager > User Definition > Project Access. One common way to do this is to compare the date information you have stored to the current date. Description: A training video demonstrating how to create, use and forma. The designed behavior is explained using an example consolidation and compound metric based on objects in the MicroStrategy Tutorial project. MicroStrategy is a data visualization tool. 1 HF6 environment. Passes that hit the same fact table across different elements of a custom group are merged provided that they satisfy certain conditions. 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. This can be reproduced in Microstrategy Tutorial by following the steps below. Custom Data Markers allow for the flexibility to add more context to your displayed data and personalize it to the business user. Step 8) In the next screen, Select the Field Group to maintain the status. Create a virtual attribute to allow reporting on an attribute that does not exist in the data model. Create a report with the custom group "CG1" and the MDX metric "Cost". Right-click the Grid/Graph, transaction table, or any of the text fields in the panel stack, then select Configure Transaction. They can create custom calculations, prompt for inputs, and easily share findings. First, create a consolidation that has a few elements but specifically at least one element with more than 2 attribute elements in its consolidation. This consolidation will contain four. In the bottom left corner, click on the button "Generate Connection File". Group 4: London, Fargo, Memphis and Charleston . 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. SASE and XDR are opportunities for consolidation: 41. For this class,. The. In the Report Data Options Window, Select Calculations > Subtotals. 1. The primary characteristic of star schema is its use of dimension tables rather than single-attribute lookup tables. Tableau has unique graphics options to present data in a meaningful manner. This knowledge base article explains an feature enhancement when using Consolidation or custom group. Per-column group Advanced Filter; Thresholds . Ca se functions Microstrategy Case functions return specified data in a SQL query based on the evaluation of user-defined conditions. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence; Multi-Cloud; Embedded Analytics. They allow you to group attribute elements in new ways without changing the metadata and. Custom Group and Consolidation Comparison summarizes the differences between these objects. STEPS TO REPRODUCE: Create a document in MicroStrategy Developer or Web 10. This allows you to group attribute elements on a report in a way that is not defined in your data warehouse. The second most common hard skill for a microstrategy developer is bi appearing on 5. This article will help. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. Follow the steps below in order to reproduce this scenario using MicroStrategy Tutorial: 1) Create a consolidation using the Call Center attribute elements: Group 1: Atlanta, San Diego, Berlin and San Francisco Group 2: Washington, DC, Salt Lake City, Miami and Milwaukee Group 3: New Orleans, Seattle, Boston and New YorkOn the MicroStrategy side you could create a Custom Group with an element for each Dept, except for Dept 2, Dept 1 and Dept 2 will be part of the same group. For more details, see the Custom Groups and Consolidations chapter. A custom group is a set of special filters that can be placed on a template. Create a consolidation with Region grouping 1-2 different attribute elements. CSS ErrorAnswer You can always convert a consolidation to a custom group, but you can only convert a custom group to a consolidation when the custom group filters are from the same table or very similar tables. Copy the code for the D3 visualization you are using. In free-form layout, we provide an intuitive way to let you visually “group” containers together. 1. I. The maximum file size of dashboard (. Visit the data visualization and data dashboard galleries for inspiration. This helps the BI platform to extensively. Under 'Level…' choose the attribute. VLDB Category. In MicroStrategy Web, edit or execute a report. {&GROUPLABEL} Name of the graph. In the Navigation pane, click Dossiers. A derived element allows us to group on the basis of: – List of elements. a) Attribute form qualification. They are group-value functions. In free-form layout, we provide an intuitive way to let you visually “group” containers together. Group 3: New Orleans, Seattle, Boston and New York. 4. MicroStrategy recommends to have only one child at the lowest level. And leverage the Page-By function to focus your analysis on one element. . 2.