For example, the attribute Customer has the forms ID, First Name, Last Name, Address, and Birth Date. Consolidations are used to group the attributes without disturbing the schema and it can group attributes based on the elements. To view custom groups in a hierarchical structure on a report, you must: Expand the item display of at least one custom group element. Enable Subtotals and enable a basic total. 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. This calculation takes place in an analytical Engine so this helps for better performance when compared to Custom Group. Schema objects include facts, hierarchies, and custom groups; application objects include reports, documents, and metrics; and configuration objects include project sources, database instances. Under 'Level…' choose the attribute. Execute the report and view the SQL:Retrieve a list of user groups and the associated users in MicroStrategy Developer Follow the steps below to create a list of all groups and the users in each group: In MicroStrategy Developer 9. The Custom Group Options dialog box opens. Study MicroStrategy Advanced Reporting flashcards. A cross join between datasets can result in rows or Group Header/Footer sections that do not have metric data. By implementing the security policies and configurations provided by MobileIron, administrators can apply enhanced protections to mobile devices in use across the enterprise. 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. {&GROUPLABEL} Name of the graph. For detailed steps to define a condition, see Condition Editor. Next, browse and choose the required attributes to create the. A new custom group element is created, with the default name Custom Group Element1. For information on whether your database supports various date and time functions, see MicroStrategy and Database Support for Functions. That is, we will not be able to create these elements using the. 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. This report is made up of custom group elements that consist of a header a. Architects can create custom-based transformations to provide details for time periods such as Last Year, Month, Date, and others. Another possible workaround is to divide the consolidation element expression by the number of attribute elements in that consolidation element (e. Group 3: New Orleans, Seattle, Boston and New York. A custom group is made up of an ordered collection of elements called custom group elements. Schema objects include facts, hierarchies, and custom groups; application objects include reports, documents, and metrics; and configuration objects include project sources, database instances. Watch this to learn about creating custom groups, time-based transformations, and shortcuts—all in. The five Apply statements enable you to take advantage of your database's native functionality. Per Cell: Allow MicroStrategy to display the selected metrics using the axis values best suited to display the metric data. {&GROUPLABEL} Name of the graph item's category. You can consider custom groups as many different reports "stacked up" together. Use that metric in a custom group that bands based on metric value and for each metric value. Note: If a user enters more than 15 digits for a. An object is a basic building block in MicroStrategy. 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. When using a Custom Group or Consolidation as a selector, the option Apply selections as a filter is grayed out under the selector properties in MicroStrategy 9. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. . 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. Click OK. 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. A Group derived element is a combination of attribute elements into a single derived element. 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. If the element name is shown, then the sum will be shown. 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. microstrategy. Viewed 13k times. In order to set up an incremental refresh report, the user should first right click on the Intelligent Cube and select "Define Incremental Refresh Report": This will bring up the Incremental Refresh Options editor: Here, the user can define one of the following Refresh type options: Update: If new data is available, it is fetched and added to. Specify the desired delivery options including recipient address, subscription name. 3. x, select 'Project Documentation' from the Tools menu to start the wizard. Define conditions to use to filter data by selecting an attribute, metric, report, or filter, then specifying the appropriate options. DOWNLOAD NOW. 2. Step 1. The report execution process is a three-step process: 1. Problem. If the report definition of a report with multiple custom groups is fairly complex, with many metrics and filtering criteria, the resulting complexity and size of the. For more details, see the Custom Groups and Consolidations chapter of the Advanced Reporting Guide. Custom Group or Consolidation? - MicroStrategy James Oliver 10. They allow you to group attribute elements in new ways without changing the metadata and. Therefore, by default, custom groups are not sorted on reports and you cannot use the sort accessible from the toolbar or right-click menu option to sort custom groups. 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. The essential distinction is that consolidations work with attributes and custom groups use filters. For steps to create a custom group in MicroStrategy Developer, see the MicroStrategy. 4. In MicroStrategy Web, click the metric for which you want to enable a grand total or subtotals. In free-form layout, we provide an intuitive way to let you visually “group” containers together. All right, let’s get started! Performance Indicator We will explore two objects that serve this purpose: Custom Groups and Consolidations. 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. The properties needed to define a column of a DB table (Columns) Top level object - represents a Castor installation (Castor Server Config. Autostyles based on one document can be applied to another document in order to change its formatting or appearance. 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. Inherit Attribute Sort, which uses the default sort of the attribute form set to display first. 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 schema looks like the following diagram. To add a derived element to a document, open the document in Editable Mode. It uses the concept of Inmemory Business Intelligence. Run Repository Translation Wizard from the Start Menu -> Programs -> MicroStrategy-> Object Manager. Reports. Interact with the engaged MicroStrategy Community to get answers to all your. Consolidations allow you to group attribute elements in new ways without changing the metadata and warehouse. You can use DateDiff to create a metric or attribute form that lists the length of time between two dates. Follow the steps below to create a list of all groups and the users in each group: In MicroStrategy Developer 9. In some cases custom group/consolidation on a report may cause metric value not to be shown. Group Elements. 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. . Under Elements for this consolidation, right-click and select Add Element. This allows you to group attribute elements on a report in a way that is not defined in your data warehouse. Click Next to go to Step 2. Then, for mobile devices, our Responsive View will take over the layout and place groups. From the perspective of the report design process, a custom group is an object that can be placed on a template. And leverage the Page-By function to focus your analysis on one element. It enables you to group attribute elements in new ways without altering the metadata and warehouse. Credits; About the Authors. Derived element groups are defined by a list, filter, or calculation. 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. com, that centralizes your learning content, from custom courses to project overviews and how-to videos, all alongside Education courses and certifications. Updated: November 2023. Enter a description for the custom group in the Enter Custom Group Description Here field. From the Home menu, point to Subscribe to, and select FTP. 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. Custom groups are used to apply different filters to different rows of a report. MicroStrategy’s mobile support ensures flexible, real-time data exploration. Select your custom visualization. Slowly changing dimensions in MSTR. Consolidation elements are attribute elements that define the consolidation. Information about custom groups includes: About Custom Groups: Grouping Attribute Elements with Banding and Filtering Custom Group Effects on SQL Generation. The following procedure describes how to. Recommendation. Source: MicroRooster. Business Consolidation: The consolidation of several business units or several different companies into a larger organization. Since the Query Engine uses a smart algorithm to combine consolidation elements and determine the minimal number of SQL passes, only one SQL pass may be needed for all the consolidation elements. Select 'Add a Metric qualification' and click OK. We will explore two objects that serve this purpose: Custom Groups and Consolidations. Technically this will result is different queries on the database, due to the fact that each calculation level is different. 9K views 4 years ago MicroStrategy In this video I will discuss. 1. Asked 4 years, 11 months ago. mstr) file size (MB) setting. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. Another possible solution in MicroStrategy would be to create logical tables to create an hierarchy like: Dept -> Old Dept -> Sub-Dept -> Old. 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,. A derived element allows us to group on the basis of: – List of elements. Add the Age Groups Custom Group and the Profie and Revenue metrics to a report in MicroStrategy 10. 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. Copy the code for the D3 visualization you are using. Custom Group vs Consolidation; Auto Styles (Report vs Document vs Dossiers) Reports Creation. Save the report as “Email Bursting”. 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). You can rename the. Experience. The numbers above the scale represent the minimum and maximum axis values. Microstrategy Dossiers With the release of MicroStrategy 10. The Grouping panel is displayed. Get inspiration at the MicroStrategy data visualization gallery. 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. 9% of resumes. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. The property is named "document grids from multiple datasets" and defaults to enabled but can be set to disabled. 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. Labels: #Creat transaction services photo uploader #transaction. Custom groups enable users to view specific elements based on a metric or specification. Consolidations vs Custom Groups. The Metric Editor opens in either Function Editor mode or Formula Editor mode, depending on the type of metric you chose to edit. A report is a MicroStrategy object that represents a request for a specific set of formatted data from your data source. When creating or editing a custom group in MicroStrategy Developer 9. An attribute form qualification might filter on the form Last Name, the operator Begins With, and the letter H. 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 ("). objects that you can place on a report template. / 3. The major roles and responsibilities depicted on the Microstrategy Developer Resume include the following – developing business solutions,. KB46734: In MicroStrategy Web 9. Description: A training video demonstrating how to create, use and forma. The Create Personal View dialog box opens. A custom group can group attribute elements in a way that is not defined in the data warehouse. 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. . UX Designer, MicroStrategy To enable totals or subtotals for a metric. 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. 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. To Modify Permissions for an Object in MicroStrategy Web. Consolidations are used to define the data you want to view in your report. 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. Third party code/SQL: MicroStrategy Technical Support does not provide customized SQL queries. Right-click the custom group, then select Edit. This is called heterogeneous column naming. With pass-through functions, you can create custom expressions to define attributes, metrics and filters. A consolidation element expression defines how the attribute elements are calculated. Dashboard performance troubleshooting in MicroStrategy 10. 2. 3. This prompt is used in a filter. The primary characteristic of star schema is its use of dimension tables rather than single-attribute lookup tables. Object. Dynamic Custom Group in Dashboards or Dossiers. blogspot. Group Elements. Your personal view subscription is saved, and you are returned to the report, document, or quick dashboard. It provides the capability for complex calculations, trend analysis, etc. A consolidation allows you to group together various elements of the Region attribute into various territories and place them on your template. 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. From the perspective of the report design process, a custom group is an object that can be placed on a template. Create a consolidation with Region grouping 1-2 different attribute elements. 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. The Document Properties dialog box opens. 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. Grouping specific months into a seasons consolidation. 0, while Tableau is rated 8. The Preferences dialog box opens. 6 and later) Installation Instructions. There are three types of objects: schema objects, application objects, and configuration objects. For more details, see the Custom Groups and Consolidations chapter of the Advanced Reporting Help. Type the following for the name: "Total for the #P #0". The custom group elements can be. certificateOn the Graph menu, choose Preferences. Whether you're working with dossiers, cards, documents, or managing an entire intelligent enterprise, Workstation empowers you to do everything from one place. | Meet MicroStrategy AI on the road. Custom Visualizations: Users can create or import custom visuals to make their reports more tailored and effective. From the Visualizations panel, select Grid . (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. . Qualifications are the actual conditions that must be met for data to be included in the custom group element. Such as Sum Metric = Metric 1 + Metric 2 + Metric 3The "Custom Group Element Header Display Position" should be selected to reflect where the user would like to display the partial sum. Syntax. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . 3. x. Explanation. Michael Sandberg's Data Visualization BlogMicroStrategy ONE introduces new features that provide better performance and scalability to enhance the overall user experience. The following options are available: Ø Transaction Mapping options. The total is calculated for all the selector items. Create or edit reports with authoring functionality. This article might want you to upgrade faster to the newest version and enjoy all of the enhancements in creating your stories!. 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. The different kinds of value prompts are: Date prompt: Users enter a specific date for which to see data. For example, we create a group that is “East Zone” and generate a list of regions that are in the east zone. There are three types of objects: schema objects, application objects, and configuration objects. Filename. Remember that P displays the parent attribute and 0 (the number zero, not the letter o) displays all the forms of the parent attribute. The report-related objects placed on the template, such as attributes. Custom: Define specific minimum and maximum values to use to display the selected metrics. A custom group is a set of filters that can be placed on a template. 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. 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:. Right-click the header of the attribute whose elements you want to use to. Consolidations vs. Consolidation ; Custom group; Fact; Metric; Subtotal; Transformation; For information about consolidations, custom groups, metrics, and subtotals, see the Advanced Reporting Guide. Description: A training video demonstrating how to create, use and forma. simply a grouping of attribute elements is called Consolidation. 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. Create an empty MD shell in Microsoft Access. The following schema shows which setting takes precedence when set at different levels. For example, the following image shows two facts with an Item/Day/Call Center level. Schema objects include facts, hierarchies, and custom groups; application objects include reports, documents, and metrics; and configuration objects include project sources, database instances. – Filters. This article will help. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. Create a report that uses this. Usually, dimensional hierarchies are presented as. Get Started. Navigate to and select a Transaction Services report, then click OK. But it’s nipping at the heels of leading BI. Consolidations are used to group the attributes without disturbing the schema and it can group attributes based on the elements. . MSTR Secure Enterprise. Javadoc API documentation for MicroStrategy 2019. Step 3. microstrategy. The fuel for business dashboards is data, so each one needs to have one or more data sources. 4. You can only certify dossiers in the Dossiers area of the Navigation pane. Cards present predefined KPIs associated with a selected keyword sourced securely from MicroStrategy. Each element in the custom group can have a different output level. Custom Groups : Custom groups are set of filters and. If the Sort By object is a consolidation or metric, the only option is Default. Connect to and interact with the MicroStrategy environment. Derived elements are available only from MicroStrategy web. The object Type is listed as Super Cube: This can also be seen when editing or authoring a dossier. Below are the new features exclusive to. Custom groups are used to apply different filters to different rows of a report. To apply the same tooltip to every item in the graph, select the Labels and Values category. This prompt is used in a filter. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. 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. It includes built-in geocoding that auto maps executive locations. In this example, you need to break down the territories as follows: East = Mid-Atlantic, Northeast, Southeast. )Right-click the custom group, then select Edit. {&GROUPLABEL} Name of the graph. zip file below and deploy it in the environments where you want to use it - MicroStrategy Desktop, Workstation, Web, or Mobile. Add the Custom Group to Grouping, as shown below: On Call Center Group, right click and select Sort – Inherit attribute sort. 2. If an environment does not already exist, an environment will need to be created first. microstrategy. Step 1. In the "Metadata Repository" screen, select the "Project Source Name" and check the "Export Translations" option, as shown in the. Consolidations are groupings of attribute elements while custom groups are based on filter criteria. This consolidation will contain four. x and add a derived attribute, right clicking an. Group 4: London, Fargo, Memphis and Charleston . There are three types of objects: schema objects, application objects, and configuration objects. Starting in MicroStrategy 2021 Update 2, you can create or edit standalone consolidations for a project. Select Data > Report Data Options. utils. 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. 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. 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. Select any project that is in the project source that contains the users and. A Group derived element is a combination of attribute elements into a single derived element. Query Generation. Enable hierarchical display for the custom group. Double-click 'Add Qualification'. The Custom Group Editor opens. Ragged Hierarchies. 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. One element will show the top ten customers and another element will show all customers. Both products' features range. One common way to do this is to compare the date information you have stored to the current date. Refresh. 5-7 Years. xmay wish to see data in Region wise. Step 2. This calculation takes place in an analytical Engine so this helps for better performance when compared to Custom Group. 3% of resumes. The elements of the consolidation appear as rows on your. Type the following for the name: "Total for the #P #0". This object contains crucial project information that is generated and maintained by managers. Syntax . On the toolbar, click Add Element. For example, a Time dimension in a star schema may be supported by a dimension table with the following structure: DAY_ID. IF (Condition, TrueBranch, FalseBranch) In this guide, lists of attributes, metrics, values, parameters, etc. The designed behavior is explained using an example consolidation and compound metric based on objects in the MicroStrategy Tutorial project. 1. You can consider custom groups as many different reports "stacked up" together. In MicroStrategy Web, click the metric for which you want to enable a grand total or subtotals. 7x are listed below. The SQL for a report with a custom group is likely to be very complex. Selectors that contain attribute, custom group, or consolidation elements as selector items can also include an option to display totals. Number of offices 3. com Format: A MicroStrategy Online Training Video blog. Mastering Business Intelligence with MicroStrategy. The different kinds of value prompts are: Date prompt: Users enter a specific date for which to see data. The report should contain the attributes, metrics, and other objects that you want to use as columns in the data mart table and which will populate the data mart table. 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. The goal is to create an image link that is used to export the grid, like shown below: Document in Edit Mode Follow the steps below: 1. Consolidations are used to create virtual attributes to allow reporting on attributes that do not exist in the data model. The following table summarizes the similarities and differences between consolidations and custom groups. 2. Go to Project Configuration > Database Instances > Connection Mapping as seen below: Click on New to create a new Connection Map and fill in the Criteria for the USA users for their connection mapping, as shown below: Note: When creating a new connection map, the users can choose from the following two types of database instances. We can define a. 1. A custom group is used to group attribute elements and aggregate results in a report. Dataset 2 contains Year and Profit, filtered to return data for only two years (2008 and 2009). You'll find everything from waterfall charts to word clouds in our community. Where:The Profit metric is a simple sum of the Profit fact. Click New Condition, then select the appropriate options to define the filtering condition. If the document is already open in Design Mode, click the Editable Mode icon . Derived metric based on attribute values Here is how could create and display data correctly on using below simple steps. The Metric Qualification dialog box opens. Mastering Business Intelligence with MicroStrategy; Credits. 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. 2. In the Order column, select Ascending or Descending. A consolidation element expression defines how the attribute elements are calculated. Application objects: Application objects include filters, prompt, documents, templates, reports, custom groups, and. In your Datasets panel, hover over the name of your dataset. KB4377. Example. Make two grids with different attributes and metrics in each 3. Source: MicroRooster. ). With an OLAP Services license, user can perform additional OLAP analysis, using the following features: Displaying data on the fly: dynamic aggregation, page. Click the Options icon . ×Sorry to interrupt. A derived element allows us to group on the basis of: – List of elements. Copy cleanup. 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. By implementing the security policies and configurations provided by MobileIron, administrators can apply enhanced protections to mobile devices in use across the enterprise. 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. In the right corner of the dashboard, change the data source to none. 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. This object is based on another familiar one: the Filter. Prompt-in-prompt is a feature in which the answer to one prompt is used to define another prompt. Right click and "Run as Administrator" to. within a function are separated by commas. Keep Group Structure, which indicates that the custom group is not sorted (the default) Sort on Attribute ID. Consolidation elements can also be an expression of attribute elements that make up a consolidation. 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. Follow the steps below: Right-click on the project and select 'Project Configuration. ApplySimple() Accepts facts, attributes, and metrics as input. KB13530: Feature in MicroStrategy SQL Generation Engine: Set Operator Optimization . Metrics: Component Objects. Business consolidation is used to improve operational efficiency by. In MicroStrategy Workstation, right click on any cube created via Data Import and select Properties. The. Source: MicroRooster. The recommended VLDB optimizations for Hive 0. Ensure that subtotaling is enabled for the consolidation. Change the formatting of the values to have different colors. Adding consolidations and custom groups . 1K views 5 years ago MicroStrategy. The Custom Group Editor appears. Consolidations enable users to create customized groupings that allow row calculations between elements of a given attribute. The developer would create one or more Filter. (For a definition and examples of levels of aggregation, see How data is aggregated on a report: metric level . Features: MicroStrategy and Tableau are two unique tools that offer incredible features. 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. Description: MicroStrategy lets you create consoli. Consolidations are used to specify the data that you want to view in your report.