These groups provide a new view of report data for analysis and formatting purposes. If a user enters more than 15 digits for a. 7x are listed below. )Right-click the custom group, then select Edit. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. Consolidations are groupings of attribute elements while custom groups are based on filter criteria. 1. Case This function evaluates multiple expressions until a condition is determined to be true, then returns a. Custom groups are used to apply different filters to different rows. For detailed steps to define a condition, see Condition Editor. 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. September 22, 2023. MicroStrategy’s OLAP Services is an expansion of MicroStrategy Intelligence Server. Invoke the MicroStrategy Integrity Manager executable MIntMgr. 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. Why MicroStrategy Why MicroStrategy; Customer StoriesThe user privileges that take up a Transaction Services license are denoted by 4 asterisks (****) in the User Editor. blogspot. Below were my list of questions to be aware as an basic MicroStrategy Developer from my personal experience (dusted from my backup to share with you all). The five Apply statements enable you to take advantage of your database's native functionality. Change the formatting of the values to have different colors. Creates a connection object which is used in subsequent requests and manages the user’s connection with the MicroStrategy REST and Intelligence Servers. Consolidations allow you to group attribute elements in new ways without changing the metadata and warehouse. To install this visualization, download the . In addition, this release introduces new features across the analytics, mobility, and security platforms—making it easier for users to build applications faster. The data for the Lookup_Region table came from a different source system than the data for the Lookup_Call_Ctr and the source systems have different naming conventions. community. The settings are numbered 1-5. 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. MSTR Secure Enterprise. Consolidation ; Custom group; Fact; Metric; Subtotal; Transformation; For information about consolidations, custom groups, metrics, and subtotals, see the Advanced Reporting Guide. Follow the steps below to create a list of all groups and the users in each group: In MicroStrategy Developer 9. The total is calculated for all the selector items. 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. 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. KB4377. Add a condition to a custom group element. 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. Relate tables contain the ID columns of two or more attributes, which will define associations between them. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. Select Field Status Group and press Choose Detail button. Click Add New Element to create a new consolidation element. Consolidations are used to group the attributes without disturbing the schema and it can group attributes based on the elements. Create a report with Year, the Region consolidation, and the Profit metric. These auto text codes are automatically replaced by information about the document. Keep Group Structure, which indicates that the custom group is not sorted (the default) Sort on Attribute ID. Consolidations are used to define the data you want to view in your report. 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. To control the display of which Custom Group elements display sums, right click on the Custom Group element, and select "Show Display Options". Considerations for the use of star schemas with MicroStrategy SQL Generation. Whether you're working with dossiers, cards, documents, or managing an entire intelligent enterprise, Workstation empowers you to do everything from one place. Remember that P displays the parent attribute and 0 (the number zero, not the letter o) displays all the forms of the parent attribute. 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). Note: Since performance of any query depends on factors outside MicroStrategy's control (especially database tuning and indexing), MicroStrategy cannot guarantee that there will be an improvement in performance using this technique. Number of years active 18. 2. A recent survey by Gartner, Inc. Create a report with Year, the Region consolidation, and the Profit metric. Number of offices 3. However, you can use the advanced sorting functionality to sort a custom group in either of the following ways: Sort on the IDs of the attributes that compose the custom group. Microstrategy Dossiers With the release of MicroStrategy 10. You can consider custom groups as many different reports "stacked up" together. If the element name is shown, then the sum will be shown. However, it is not expected to see a metric value corresponding to the Custom Group. The recommended VLDB optimizations for Hive 0. Microstrategy - how to create a custom group with boolean band. x, select 'Project Documentation' from the Tools menu to start the wizard. MicroStrategy recommends to have only one child at the lowest level. Subtotals. Extensively worked in creating and integrating MicroStrategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) with the data warehouse. UX. Step 7) In the next screen, Enter Field Status Groups for the Field Status Variant. MicroStrategy is ranked 8th in BI (Business Intelligence) Tools with 12 reviews while Tableau is ranked 2nd in BI (Business Intelligence) Tools with 48 reviews. The “ #n” code in Apply function syntax serves as placeholders for the MicroStrategy objects being passed to your database. Comprehensive analytical capabilities and Automated reporting: MicroStrategy offers wide range of analytical features including data visualizations, advance analytics, data discovery and predictive modeling. comArchitects can now do more with MicroStrategy Workstation. Specify the desired delivery options including recipient address, subscription name. In MicroStrategy Web, click the metric for which you want to enable a grand total or subtotals. Compare all the important BI vendors with our 100% independent Business Intelligence tools comparison. The third most common microstrategy developer skill is templates on 5. They allow you to group attribute elements in new ways without changing the metadata and. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. HRESULT : Aggregation ([out, retval] EnumDSSAEAggregation *pAggregation)Follow the steps below to create a list of all groups and the users in each group: In MicroStrategy Developer 9. The "Grouping" property has six possible. Custom groups enable users to view specific elements based on a metric or specification. 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. Consolidations enable you to group together and to pick specific attribute elements. Right click on the Grid object and select Properties and Formatting to set Photo Uploader as the widget under Widget setting unchecking full screen for android phone as following. Make two grids with different attributes and metrics in each 3. 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. Select any project that is in the project source that contains the users and groups and click Next. 5K subscribers Subscribe 3. For example, the report below contains Region, Category, and Profit. The Report Pre Statement settings insert custom SQL statements at the beginning of the report SQL. simply a grouping of attribute elements is called Consolidation. Custom groups; A custom group is a special filter that can be placed on a template and. Enter a description for the custom group in the Enter Custom Group Description Here field. Execute one of the following options: To specify default prompt answers, click on 'Add'. To Modify Permissions for an Object in MicroStrategy Web. From the left, click Document. The output level of a custom group (in this example, Store) is based on the filtering conditions of the element. It enables you to group attribute elements in new ways without altering the metadata and warehouse. For example, a report. DAY_DESC. First, create a consolidation that has a few elements but specifically at least one element with more than 2 attribute elements in its consolidation. Creating metrics on-the-fly: derived metrics, Defining attribute elements on-the-fly: derived elements, Filtering data on the fly: view filters and metric filters, Importing data as an. September 18, 2018. 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. Navigate to and select a Transaction Services report, then click OK. 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. •. Each element contains a set of filtering or banding qualifications. Enable Subtotals and enable a basic total. Visit the data visualization and data dashboard galleries for inspiration. 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. Mid-America = Central, South. The MicroStrategy Tutorial project uses aggregate tables by default. Now using the mouse place the cursor on text box of 10000 which is next to 'Maximum number of monitoring objects displayed per page. Consolidation elements can also be an expression of attribute elements that make up a consolidation. September 18, 2018. This article will help you learn to use these elements to create more powerful and unique grids. A ragged hierarchy is the one in which the parent attribute element of one or more. Qualifications are the actual conditions that must be met for data to be included in the custom group element. Custom groups are used to apply different filters to different rows of a report. Right-click the Grid/Graph, transaction table, or any of the text fields in the panel stack, then select Configure Transaction. built from same attributes or from multiple attributes. It is used to apply database (row-level) security to a MicroStrategy user. Right-click on the metric header to apply the condition or threshold and select 'Alerts': Specify the conditions to meet for the delivery to be triggered in the filter editor: Expand the Delivery Settings section. In Step 1, choose a Project Source from the drop down list, and enter a Login and a Passwordthat have administrative privileges to the metadata. 5. Especially for you we decided to list and test the most interesting new features that MicroStrategy 2020 brings to dossiers. In MicroStrategy Web, open the document in Design or Editable Mode. This object contains crucial project information that is generated and maintained by managers. Consolidations serve two powerful functions that can greatly enhance your reporting abilities: You can create a. {&GROUPLABEL} Name of the graph. It uses the concept of Inmemory Business Intelligence. 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. ApplySimple() Accepts facts, attributes, and metrics as input. It is derived based on a count against the fact_object_component table. In general, a user specifies a list of conditions and corresponding return values. It is expected to not see individual items under the custom group element as the filter qualification for the custom group excludes all data. MicroStrategy - Real Time Consolidations & Custom Groupings - Online Training Video by MicroRooster MicroRooster 6. xConsolidations allow users to group attribute elements in new ways without changing the metadata and warehouse definitions. 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. 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. Under Elements for this consolidation, right-click and select Add Element. 3. Group 2: Washington, DC, Salt Lake City, Miami and Milwaukee. Select only Configuration Objects for documentation. Qualifications are the actual conditions that must be met for data to be included in the custom group element. Slowly changing dimensions (SCDs) are a common characteristic in many business intelligence environments. If a user enters more than 15 digits for a. it looks like MicroStrategy doesn't support it, please advise. 1. 5-7 Years. x, select 'Project Documentation' from the Tools menu to start the wizard. Get inspiration at the MicroStrategy data visualization gallery. They can be defined from any of the following: Attribute elements from different levels of the same hierarchy, such as Region and Call Center in the Geography. 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. 4. Technically this will result is different queries on the database, due to the fact that each calculation level is different. Here are the series of steps to setup report objects in which metrics and subtotals so only the subtotal field will contain the RunningSum and the regular metric values will be standard sum values. certificateOn the Graph menu, choose Preferences. Consolidations: Virtual attributes. The different kinds of value prompts are: Date prompt: Users enter a specific date for which to see data. objects that you can place on a report template. 4. To apply the same tooltip to every item in the graph, select the Labels and Values category. September 06, 2018. 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. Autostyles based on one document can be applied to another document in order to change its formatting or appearance. For example, you need to analyze data by season (Fall, Winter, and so on) although your project does not contain a Season attribute. To control the display of which Custom Group elements display sums, right click on the Custom Group element, and select "Show Display Options". A consolidation allows you to group together various elements of the Region attribute into various territories and place them on your template. In contrast, consolidations. You'll find everything from waterfall charts to word clouds in our community. When the report is executed and the prompt resolution occurs, the display contains the. The Custom Group Editor opens. This can be reproduced in Microstrategy Tutorial by following the steps below. Custom groups are used to apply different filters to different rows of a report. From the perspective of the report design process, a custom group is an object that can be placed on a template. 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,. Another possible workaround is to divide the consolidation element expression by the number of attribute elements in that consolidation element (e. 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. 2. The custom group elements can be. Become a More Intelligent Enterprise. Define the advance sort on the derived. blogspot. Syntax . 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. Right-click the header of the attribute whose elements you want to use to. A custom group is a special filter that can be placed on a template and is comprised of an ordered collection of elements called custom group elements. microstrategy. Overall customer rating 9. Step 1. The Consolidation Editor contains the following sections: The left pane contains an element list that includes the consolidation element you add. {&GROUPLABEL} Name of the graph. A custom group is made up of an ordered collection of elements called custom group elements. Microstrategy Dossiers With the release of MicroStrategy 10. The report-related objects placed on the template, such as attributes. Normally, users would accomplish this with an attribute by setting it to the level of that attribute, however that may not produce desirable values. A sales team might use a business dashboard to connect. For Network: Transport Routes Overview -> Config. 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. '. Numeric prompt: Users enter a specific number, up to 15 digits, which is then used as part of a filter, or within a metric, to look for specific numeric data. 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. Right-click the custom group, then select Edit. a) Attribute form qualification. They can create custom calculations, prompt for inputs, and easily share findings. This prompt is used in a filter. 11. this allows users to perform the in-depth analysis of their data and get the valuable results from their data. 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. It queries SQL databases. Yes. A custom group is a set of special filters that can be placed on a template. 9K views 4 years ago MicroStrategy In this video I will discuss. Visit the data visualization and data dashboard galleries for inspiration. The. – Calculations. Add the Custom Group to Grouping, as shown below: On Call Center Group, right click and select Sort – Inherit attribute sort. Source: MicroRooster. 4. Step 3. Nature: By nature, both Tableau and MicroStrategy tools are Business Intelligence software designed for visualizing data. This knowledge base article explains an feature enhancement when using Consolidation or custom group. Create a consolidation with Region grouping 1-2 different attribute elements. Consolidations allow you to qualify a report on a row-by-row basis. Both consolidations and custom groups provide flexibility in reports, but the objects differ in their structure and use. Right-click on an existing environment and choose Properties. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . 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. Content Groups are MicroStrategy objects that can be migrated between environments. By default, this executable is located in C:Program FilesMicroStrategyIntegrity Manager. You'll find everything from waterfall charts to word clouds in our community. Case This function evaluates multiple expressions until a condition is determined to be true, then returns a. xmay wish to see data in Region wise. 2. A custom group can group attribute elements in a way that is not defined in the data warehouse. We need to establish a consolidation route for each transport layer. attribute elements. Select your custom visualization. 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. Using custom groups, you can group attribute elements in a way that is not defined in the data warehouse. Follow the steps below. Autostyles can be either saved based on an existing document or they can. 2. . Web Professional. Create a virtual attribute to allow reporting on an attribute that does not exist in the data model. These groups provide a new view of report data for analysis and formatting purposes. The report-related objects placed on the template, such as. x with any number of attributes. A derived element allows us to group on the basis of: – List of elements. When running a report in MicroStrategy Web with a custom group on the template, after enabling subtotals to display for the grid, users will notice that no totals display. It allows users to customize data visualizations and build personalized real-time dashboards. V. Starting in MicroStrategy 2021 Update 1, there is an new out-of-the-box, feature-rich. Step 3. We can define a. 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. | Meet MicroStrategy AI on the road. Ø Local Transaction options. Select 'Add a Metric qualification' and click OK. Through these interview questions and answers you will learn what is metadata, attributes, mapping, hierarchies, facts, smart metrics, transformations, filters, prompts and more. This feature is similar to what we see in. Note that a custom group, 'Age Groups' from the MicroStrategy Tutorial project, is used in the page-by axis. microstrategy. For more details, see the Custom Groups and Consolidations chapter of the Advanced Reporting Help. 1. The partition attribute should allow for near uniform distribution of data across the partitions, so that the workload on each partition is evenly distributed. {&GROUPLABEL} Name of the graph. Use that metric in a custom group that bands based on metric value and for each metric value. MicroStrategy has partnered with MobileIron to add an extra layer of security to MicroStrategy Mobile applications running on iOS devices. In MicroStrategy Web, edit or execute a report. Open the Desktop Window with the Navigation pane in Smart Mode. User specifies the definition of the cube on a Report Template with Attributes, Metrics, and Filter. 9% of resumes. The Compound Grid is a new visualization introduced in the MicroStrategy 2020 release. Architects can create custom-based transformations to provide details for time periods such as Last Year, Month, Date, and others. Starting in MicroStrategy 2021 Update 2, you can create or edit standalone consolidations for a project. In the Calculations - Subtotals window, Select the desired Custom Group and select Yes in the Allow subtotals drop down. 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. 5K subscribers Subscribe 3. To execute more than five statements, insert multiple statements in Report. Create an empty MD shell in Microsoft Access. Moving the CG/Consolidation to the left as a first column may fix the problem. Tableau has unique graphics options to present data in a meaningful manner. Next, browse and choose the required attributes to create the. Populate and Evaluate: Fill report data required for display. Metrics: Component Objects. The object Type is listed as Super Cube: This can also be seen when editing or authoring a dossier. A split hierarchy is one - that at the lowest level - has more than one child. This function evaluates multiple expressions until a condition is determined to be true, then returns a corresponding value. Follow the steps below for an example of how to do this. Zip File Name: Type a name for the zip file in the Zip File Name field. 1) Create Metric 1 which is the sum of the fact that is to be in the columns. In free-form layout, we provide an intuitive way to let you visually “group” containers together. The Subscribe to FTP dialog box opens. You must have the MicroStrategy Report Services product to view and create documents and RS dashboards. KB13530: Feature in MicroStrategy SQL Generation Engine: Set Operator Optimization . 4. Michael Sandberg's Data Visualization BlogMicroStrategy ONE introduces new features that provide better performance and scalability to enhance the overall user experience. Now your connection f. Follow the steps below: Right-click on the project and select 'Project Configuration. A cross join between datasets can result in rows or Group Header/Footer sections that do not have metric data. From the perspective of the report design process, a custom group is an object that can be placed on a template. 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. Your personal view subscription is saved, and you are returned to the report, document, or quick dashboard. For example, ApplySimple ("#0 * #1", [col1], [col2]) indicates that two items, col1 and col2, referenced. This tool is known for its flexibility and speed of data study without losing on. Find an event in a city near you. Viewed 13k times. Click Next to go to Step 2. Consolidation elements can also be an expression of attribute elements that make up a consolidation. Grouping in a metric level determines how the metric aggregates. Click OK. 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). Click the “Burst. There are three types of objects: schema objects, application objects, and configuration objects. Microstrategy Dossiers With the release of MicroStrategy 10. 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 Item_id, Day_id, and Call_Ctr_id columns in the table above represent practical levels at which sales. If an environment does not already exist, an environment will need to be created first. Autotext code/macros in Microstrategy Document/dashboard. – Filters. Change the order that the conditions are evaluated. This article will help. 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. utils. Custom Group Effects on SQL Generation. 2. Development/ Integration system is taken as the source of these consolidation routes. One of the powerful advantages of consolidations is the ability to create virtual attributes, which allow you to group attribute elements in a customized way. {&GROUPLABEL} Name of the graph item's category. x and 10. 3. The Document Properties dialog box opens. Create a Report Services Document 2. In the Order column, select Ascending or Descending. It provides the capability for complex calculations, trend analysis, etc. The following table summarizes the similarities and differences between consolidations and custom groups. The Custom Group Editor enables you to create and modify custom groups. And leverage the Page-By function to focus your analysis on one element. Custom: Define specific minimum and maximum values to use to display the selected metrics. Submit Search. A report is a MicroStrategy object that represents a request for a specific set of formatted data from your data source. This option is only available for alerts sent to email addresses. By the way, there is no. 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. MicroStrategy has partnered with MobileIron to add an extra layer of security to MicroStrategy Mobile applications running on iOS devices. Select the Password protect zip file check box and type a password for the zip file. 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. Consolidation with diff groups of cities as regions. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories. How to create a MicroStrategy connection file (. Once data flows into the interface, the dashboard will come to life. Schema objects include facts, hierarchies, and custom groups; application objects include reports, documents, and metrics; and configuration objects include project sources, database instances. 3 and later) Supports exporting to PDF (10. Place the newly created consolidation in the template. The header is an arbitrary name that you define when you create the element. 35K subscribers 2. Create or edit. ( How?) Double-click in the Custom Group Definition pane. For example, the following image shows two facts with an Item/Day/Call Center level. Split Hierarchy with M-M relationships: Explanation. You can only certify dossiers in the Dossiers area of the Navigation pane. 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. Custom Groups : Custom groups are set of filters and. A badge icon appears on the item to indicate that it is certified. Description: MicroStrategy lets you create consoli. The Grouping panel is displayed. Learn how to switch to a compound grid, add column sets in this new visualization. Consolidation elements are attribute elements that define the consolidation. With an OLAP Services license, user can perform additional OLAP analysis, using the following features: Displaying data on the fly: dynamic aggregation, page. What are custom groups? Custom Group or Consolidation? - MicroStrategy James Oliver 10. Open the document in Design or Editable Mode. In your Datasets panel, hover over the name of your dataset. Ultimately, it was. 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. 5. 1. For example, the before and after SQL that is generated for a. In some cases custom group/consolidation on a report may cause metric value not to be shown. Click New Condition, then select the appropriate options to define the filtering condition. Consolidation ; Custom group; Fact; Metric; Subtotal; Transformation; For information about consolidations, custom groups, metrics, and subtotals, see the Advanced Reporting Guide. To enable totals or subtotals for a metric. Application objects: Application objects include filters, prompt, documents, templates, reports, custom groups, and. Microstrategy Dossiers With the release of MicroStrategy 10. com Twitter: @MicroRoosterFormat: A MicroStrategy Online Training Video blog.