microstrategy custom group vs consolidation. To apply the same tooltip to every item in the graph, select the Labels and Values category. microstrategy custom group vs consolidation

 
 To apply the same tooltip to every item in the graph, select the Labels and Values categorymicrostrategy custom group vs consolidation 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

Each element contains a set of filtering or banding qualifications. A derived element is a grouping of attribute elements on a report. 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 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. A custom group is made up of an ordered collection of elements called custom group elements. Create a report with Year on the rows and Revenue on the columns. As you can imagine, the SQL Engine. Custom groups are used to apply different filters to different rows. Explanation. The essential distinction is that consolidations work with attributes and custom groups use filters. 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. 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. Open the Workstation window. 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. 3. You'll find everything from waterfall charts to word clouds in our community. The following schema shows which setting takes precedence when set at different levels. It is a worthwhile technique. x, select 'Project Documentation' from the Tools menu to start the wizard. Description: A training video demonstrating how to create, use and forma. Consolidations are used to create virtual attributes to allow reporting on attributes that do not exist in the data model. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. After you find the microstrategy. Step 3. September 18, 2018. Selectors that contain attribute, custom group, or consolidation elements as selector items can also include an option to display totals. Being able to run this calculation would be useful for. Example. com Twitter: @MicroRoosterFormat: A MicroStrategy Online Training Video blog. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. Description: A training video demonstrating how to create, use and forma. 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. What is relevant, rather than the sum, is the last atomic inventory value in a given period of time. In addition, notice that the bars are all separated as a single bar based on their Revenue. MSTR Secure Enterprise. 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. Through these interview questions and answers you will learn what is metadata, attributes, mapping, hierarchies, facts, smart metrics, transformations, filters, prompts and more. Tableau has unique graphics options to present data in a meaningful manner. community. The Document Properties dialog box opens. The header is an arbitrary name that you define when you create the element. When this report is executed, only two custom group elements are displayed even though five elements are defined in the custom group. Derived element groups are defined by a list, filter, or calculation. MicroStrategy is a data visualization tool. Consolidations allow you to qualify a report on a row-by-row basis. com Format: A MicroStrategy Online Training Video blog. Follow the steps below to create a list of all groups and the users in each group: In MicroStrategy Developer 9. A custom group is a set of filters that can be placed on a template. A split hierarchy is one - that at the lowest level - has more than one child. 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. 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. 4. g. The attribute level follows a consecutive order from. 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. 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. 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. Custom Group and Consolidation Comparison summarizes the differences between these objects. A connection map in MicroStrategy is a link between a MicroStrategy user, a database connection, and a database login. For example, a document contains two datasets. found that 75% of organizations are pursuing security vendor consolidation in 2022, up from 29% in 2020. To Create a Custom Group. Create a report with Year, the Region consolidation, and the Profit metric. Consolidations enable users to create. The elements of a metric level are described below: •. Metrics: Component Objects. 16. Choose the option, Add an Attribute qualification. Description: MicroStrategy lets you create consoli. Consolidations enable users to create customized groupings that allow row calculations between elements of a given attribute. Microstrategy Dossiers With the release of MicroStrategy 10. Create a consolidation with Region grouping 1-2 different attribute elements. When creating or editing a custom group in MicroStrategy Developer 9. Another possible workaround is to divide the consolidation element expression by the number of attribute elements in that consolidation element (e. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. Create a consolidation with Region grouping 1-2 different attribute elements. Consolidation ; Custom group; Fact; Metric; Subtotal; Transformation; For information about consolidations, custom groups, metrics, and subtotals, see the Advanced Reporting Guide. Case This function evaluates multiple expressions until a condition is determined to be true, then returns a. KB16396: A total subtotal incorrectly sums both the elements and individual items in a custom group in MicroStrategy Devel… Number of Views 611 KB4531: How to create a report that displays the top 'n' Item sales (variable) for each Subcategory within a. To view custom groups in a hierarchical structure on a report, you must: Expand the item display of at least one custom group element. Count of Parents in Platform Analytics: There is an OOTB metric called Objects, which calculates the parents of a component object. Below are the new features exclusive to. Login to MSTR Developer then go to: User Manager > User Definition > Project Access. 3. 1) Create Metric 1 which is the sum of the fact that is to be in the columns. Sankey Diagram. A consolidation element expression defines how the attribute elements are calculated. Custom groups are. 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. Both consolidations and custom groups provide flexibility in reports, but the objects differ in their structure and use. Slowly changing dimensions in MSTR. . x, select 'Project Documentation' from the Tools menu to start the wizard. custom groups. Click Next to go to Step 2. A report is a MicroStrategy object that represents a request for a specific set of formatted data from your data source. com. Dataset 1 contains Year and Revenue, with data for three years (2007-2009). In free-form layout, we provide an intuitive way to let you visually “group” containers together. This feature is only implemented for element list prompts. 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. Autostyles based on one document can be applied to another document in order to change its formatting or appearance. 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. Users can explore, filter, and visualize data with drag-and-drop functionality. If you have many reports or tasks that need to be executed on the same time-based schedule, consider creating several similar schedules that trigger 15 minutes apart. From the File menu, click Open. Click OK. Note: If a user enters more than 15 digits for a. Consolidation elements can also be an expression of attribute elements that make up a consolidation. Inherit Attribute Sort, which uses the default sort of the attribute form set to display first. Next, browse and choose the required attributes to create the. There are several ways to do this but I guess the easiest one will be creating a Metric which is the sum of all the metrics to be used in the report. Go to Start -> Programs -> MicroStrategy -> Tools, run ScanMD. Open the custom group editor and drag an object from the object browser to create a custom group. Creating Powerful (and Beautiful) Dossiers. x and 10. 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. Grouping attribute elements: Consolidations, custom groups, and derived elements 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. All articles. 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). {&GROUPLABEL} Name of the graph. The following is a quick reference table for a MicroStrategy Custom Group: A Custom. . Autotext code/macros in Microstrategy Document/dashboard. Copy cleanup. Michael Sandberg's Data Visualization BlogMicroStrategy ONE introduces new features that provide better performance and scalability to enhance the overall user experience. The grouping options for levels include: Standard, which groups by the attribute level of the target. The fuel for business dashboards is data, so each one needs to have one or more data sources. Below are the recommended best practices when scheduling jobs and administrative tasks in MSTR: Executing simultaneous reports can strain system resources. microstrategy. Enable hierarchical display for the custom group. It includes built-in geocoding that auto maps executive locations. Type the following for the name: "Total for the #P #0". 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. 1. We will explore two objects that serve this purpose: Custom Groups and Consolidations. Change the formatting of the values to have different colors. For example: OR. A consolidation element expression defines how the attribute elements are calculated. A percent-to-total shortcut metric displays the percent in relation to a selected total of each item affected by the metric. A Document Autostyle is a collection of formatting properties saved in a document for various control types (sections, text fields, lines, etc. Consolidations are groupings of attribute elements while custom groups are based on filter criteria. To control the display of which Custom Group elements display sums, right click on the Custom Group element, and select "Show Display Options". Syntax. A blank visualization appears in the dossier. Business consolidation is used to improve operational efficiency by. Custom groups enable users to view specific elements based on a metric or specification. In MicroStrategy Web, click the metric for which you want to enable a grand total or subtotals. Ensure that subtotaling is enabled for the consolidation. By the way, there is no. 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. The total is calculated for all the selector items. The report-related objects placed on the template, such as attributes. 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. Schema objects include facts, hierarchies, and custom groups; application objects include reports, documents, and metrics; and configuration objects include project sources, database instances. This approach makes it easier for you to specify a flexible partitioning. A Group derived element is a combination of attribute elements into a single derived element. Specify the desired delivery options including recipient address, subscription name. Follow the steps below: Right-click on the project and select 'Project Configuration. 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). Define conditions to use to filter data by selecting an attribute, metric, report, or filter, then specifying the appropriate options. x, there is no way to duplicate a custom group element. A badge icon appears on the item to indicate that it is certified. Type the following for the name: "Total for the #P #0". 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. Enter a name for the custom group in the Enter Custom Group Name Here field. 3. How to create a consolidation in MicroStrategy. From the perspective of the report design process, a custom group is an object that can be placed on a template. 4. A derived element allows us to group on the basis of: – List of elements. 2) Create Metric2 as the RunningSum of Metric1. Select only Configuration Objects for documentation. – Calculations. Right-click the custom group, then select Edit. MicroStrategy Desktop will then return data ordered by DESC ascending as follows for that report: From Desktop, create a new document and select the report that you just created as dataset. Filename. They are made up of custom group. Relate tables are often used to create relationships between attributes. community. Qualifications are the actual conditions that must be met for data to be included in the custom group element. Find an event in a city near you. In this example, you need to break down the territories as follows: East = Mid-Atlantic, Northeast, Southeast. Microstrategy Dossiers With the release of MicroStrategy 10. This object contains crucial project information that is generated and maintained by managers. The designed behavior is explained using an example consolidation and compound metric based on objects in the MicroStrategy Tutorial project. Same thing for Sub-Dept 201. Creates a connection object which is used in subsequent requests and manages the user’s connection with the MicroStrategy REST and Intelligence Servers. The index for referencing these objects begins with 0 and increases by. Invoke the MicroStrategy Integrity Manager executable MIntMgr. How to create a MicroStrategy connection file (. The output level of a custom group (in this example, Store) is based on the filtering conditions of the element. 1 comment. Consolidations: Grouping Attribute Elements with Arithmetic and Logical Operators. exe using the command line. The algorithm that calculates the table sizes performs the following steps: Calculate the number of levels per hierarchy: Hierarchy 1: 3. 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. Here we have compiled a set of MicroStrategy interview questions asked in top organizations around the world. If the element name is shown, then the sum will be shown. From the perspective of the report design process, a custom group is an object that can be placed on a template. I. Being able to run this calculation would. '. You can even import consolidation elements from other consolidations in the project to create consolidation elements. The Configure Transactions Editor opens. Created different types of objects such as attributes, metrics, filters, prompts, Custom Groups and Consolidation. simply a grouping of attribute elements is called Consolidation. Schema objects include facts, hierarchies, and custom groups; application objects include reports, documents, and metrics; and configuration objects include project sources, database instances. 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. 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:. That is, the metric calculates at the level of the target, if possible. 7x. certificateOn the Graph menu, choose Preferences. Custom groups are used to apply different filters to different rows of a report. See below: Notice in Developer, you can currently right click on this document and select the 'Edit' option. 1. Target: The target is the attribute level at which the metric calculation groups. Right-click on an existing environment and choose Properties. 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 hierarchy. 1. Depending on your MicroStrategy product and licensing, this function may not be available. 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. The Grouping panel is displayed. Select any project that is in the project source that contains the users and. Consolidations allow users to group attribute elements in new ways without changing the metadata and warehouse definitions. Custom Visualizations: Users can create or import custom visuals to make their reports more tailored and effective. Become a More Intelligent Enterprise. Information about custom groups includes: About Custom Groups: Grouping Attribute Elements with Banding and Filtering Custom Group Effects on SQL Generation Custom Group Structure on Reports Creating a Custom Group Editing and Formatting a Custom Group Consolidations are groupings of attribute elements while custom groups are based on filter criteria. Type the Name of the personal view. Create a report with Attribute "Year", custom group "Category" and Metric Revenue; Click in the Metric Revenue in Report Object and go to Insert Tab;When the custom group element is expanded in the Custom Group Editor, up to three SQL passes must be made for each custom group element. You can only certify dossiers in the Dossiers area of the Navigation pane. If a user enters more than 15 digits for a. Next, browse and choose the required attributes to create the. From the Visualizations panel, select Grid . Query Stage: Retrieve data from the warehouse. bandings on Attributes or Metrics to group the. Close the Visualization Builder, and then re-open it. Calculate each attribute individual weight according to the level in the hierarchy (level in hierarchy/number of levels in hierarchy * 10). An object is a basic building block in MicroStrategy. Custom: Define specific minimum and maximum values to use to display the selected metrics. This tool is known for its flexibility and speed of data study without losing on. com, that centralizes your learning content, from custom courses to project overviews and how-to videos, all alongside Education courses and certifications. 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. 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. The Item_id, Day_id, and Call_Ctr_id columns in the table above represent practical levels at which sales. 3. Features: MicroStrategy and Tableau are two unique tools that offer incredible features. Consolidations enable you to group together and to pick specific attribute elements. Data can be connected through an API, flat file, or database. MicroStrategy’s OLAP Services is an expansion of MicroStrategy Intelligence Server. . For example, the before and after SQL that is generated for a. In MicroStrategy SQL Generation Engine 9. The Grouping Properties dialog box opens. Retrieve a list of user groups and the associated users in MicroStrategy Developer Follow the steps below to create a list of all groups and the users in each group: In MicroStrategy Developer 9. In the "Metadata Repository" screen, select the "Project Source Name" and check the "Export Translations" option, as shown in the. The different kinds of value prompts are: Date prompt: Users enter a specific date for which to see data. Experience in creating dashboards using Microstrategy Involved in validating data returned in all reports, provided a detailed analysis of data, and identified data quality issues. In MicroStrategy Web, open the document in Design or Editable Mode. For more details, see the Custom Groups and Consolidations chapter of the Advanced Reporting Help. The Grouping panel is displayed. A cross join between datasets can result in rows or Group Header/Footer sections that do not have metric data. On the toolbar, click Add Element. Recommendation. Labels: #Creat transaction services photo uploader #transaction. To add a derived element to a document, open the document in Editable Mode. The Metric Qualification dialog box opens. Both tools allow you to plot interactive charts, graphs, and dashboards for comprehensive analysis. Make two grids with different attributes and metrics in each 3. xmay wish to see data in Region wise. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. Click the Options icon . A consolidation allows you to group together the elements of the Month of Year attribute into various seasons and place them on the template. However, it is not expected to see a metric value corresponding to the Custom Group. But it’s nipping at the heels of leading BI. In the MicroStrategy Mobile app, depending on your device, you can navigate to the Shared Reports folder in a variety of ways: When the Mobile user taps the URL on the mobile device, the user may be prompted to provide a user name and password to log in to MicroStrategy Mobile Server using this authentication mode. MicroStrategy Best Practices Dynamic Custom Group in Dashboards or Dossiers Custom groups enable users to view specific elements based on a metric or specification. com A 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. All attribute element data is added together to form the metric values for the new Group derived element. MicroStrategy AI is here. For example, we create a group that is “East Zone” and generate a list of regions that are in the east zone. Click the Options icon . STEPS TO. Choose the option, Add an Attribute qualification. x, select 'Project Documentation' from the Tools menu to. Group 1: Atlanta, San Diego, Berlin and San Francisco. x, select 'Project Documentation' from the Tools menu to start the wizard. 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. 1K views 5 years ago MicroStrategy. This option is available only when the Compress Contents check box is selected. utils. A derived element allows us to group on the basis of: – List of elements. Add a condition to a custom group element. Submit Search. 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. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . 11. Right-click the custom group, then select Edit. That is, we will not be able to create these elements using the. Step 3. Custom Data Markers allow for the flexibility to add more context to your displayed data and personalize it to the business user. Group 4: London, Fargo, Memphis and Charleston . To Modify Permissions for an Object in MicroStrategy Web. A custom group lets you group attribute elements from the same or different attributes to meet your reporting requirements. 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. A ragged hierarchy is the one in which the parent attribute element of one or more. Technically this will result is different queries on the database, due to the fact that each calculation level is different. Depending on your MicroStrategy product and licensing, this function may not be available. 6. 9K views 4 years ago MicroStrategy In this video I will discuss. 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. Information about custom groups includes: About Custom Groups: Grouping Attribute Elements with Banding and Filtering Custom Group Effects on SQL Generation. 3% of resumes. new_description is the new. The recommended VLDB optimizations for Hive 0. All attribute element data is added together to form the metric values for the new Group derived element. However, there is no option for the user to enable custom group subtotals at the report. 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. 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 a report with Category, Subcategory and Revenue. You'll find everything from waterfall charts to word clouds in our community. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformCommunity & Support Search Discussions Open A Case View My CasesHyperIntelligence and its Architecture. 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,. Skip to content. Browse to the folder in which to create the new custom group, then click the Create Custom Group icon. Relationship tables in Microstrategy. There are three types of objects: schema objects, application objects, and configuration objects. Microstrategy Dossiers With the release of MicroStrategy 10. Cross-tab: Pivot and display sorting and page-by Each of the engines plays an important part in the report execution process. 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. {&GROUPLABEL} Name of the graph item's category. x, select 'Project Documentation' from the Tools menu to start the wizard. Otherwise, to define tooltips for a single series, select the name of the series. Visit the data visualization and data dashboard galleries for inspiration. KB46734: In MicroStrategy Web 9. Define the advance sort on the derived. Now to fix this create a new Derived metric on Category attribute first with formula as Max (Category) {~ } and calling Books. From the list of available objects, select the objects to be used as default values for the prompt and click on '>' to add them to the list of selected objects. Derived elements are available only from MicroStrategy web. 1. 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. Display the hierarchical view in the report (MicroStrategy Developer only) These tasks are completed at different levels and in different MicroStrategy. The Preferences dialog box opens. Per-column group Advanced Filter; Thresholds . Click the name of a custom group element and type a new name in the field. The Custom Group Editor opens. 5K subscribers Subscribe 3. Definition. Consolidations serve two powerful functions that can greatly enhance your reporting abilities: You can create a virtual attribute, which is a new grouping of attribute elements, and use it on reports. Tableau can map latitude and longitude coordinates and link them to spatial data. Step 1. You can use DateDiff to create a metric or attribute form that lists the length of time between two dates. Starting in MicroStrategy 2021 Update 1, there is an new out-of-the-box, feature-rich. From the left, click Document. Number of offices 3. The report data is as displayed below. We can define a. 35K subscribers 2. Compare all the important BI vendors with our 100% independent Business Intelligence tools comparison. Overall customer rating 9. Run Repository Translation Wizard from the Start Menu -> Programs -> MicroStrategy-> Object Manager. 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. Updated: November 2023. In free-form layout, we provide an intuitive way to let you visually “group” containers together. The mobile placement order follows a “Z-path” (left-to-right and top-to-bottom order). ApplySimple() Accepts facts, attributes, and metrics as input. Both consolidations and custom groups provide flexibility in reports, but the objects differ in their structure and use. Enter a description for the custom group in the Enter Custom Group Description Here field.