Below are the steps to enable/disable the settings of data blending: 1. The different kinds of value prompts are: Date prompt: Users enter a specific date for which to see data. blogspot. x and 10. 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. Tableau is a data visualization tool that helps create appealing charts, reports, and dashboards that are easy to share and interactive. Now using the mouse place the cursor on text box of 10000 which is next to 'Maximum number of monitoring objects displayed per page. The property is named "document grids from multiple datasets" and defaults to enabled but can be set to disabled. For Network: Transport Routes Overview -> Config. From the Schedule drop-down list, select a schedule or event on which to deliver the report or document. If all conditions are false, a default value is returned. The partition attribute should allow for near uniform distribution of data across the partitions, so that the workload on each partition is evenly distributed. They act as containers for non-standard SQL expressions that MicroStrategy does not support. 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. Selectors that contain attribute, custom group, or consolidation elements as selector items can also include an option to display totals. x. Make two grids with different attributes and metrics in each 3. Browse to the folder in which to create the new custom group, then click the Create Custom Group icon. You can create new schedules in the MicroStrategy Developer Schedule Manager. This prompt is used in a filter. Derived element groups are defined by a list, filter, or calculation. Slowly changing dimensions in MSTR. In the Grouping panel, right-click the grouping field to display horizontally, and select Grouping Properties. Right-click the custom group, then select Edit. blogspot. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. All articles. That is, the metric calculates at the level of the target, if possible. From the Tools menu, select Grouping. The second most common hard skill for a microstrategy developer is bi appearing on 5. To access the setting, in MicroStrategy Developer right-click on the project and select Project Configuration…Then, In the Project Configuration dialog box, choose Project Definition >. Normally, users would accomplish this with an attribute by setting it to the level of that attribute, however that may not produce desirable values. 5K subscribers Subscribe 3. Reports are now available to use and interact with in MicroStrategy Library: View standard reports in MicroStrategy Library to get a simple, grid view of data. This article will help you learn to use these elements to create more powerful and unique grids. It leverages data connectivity, machine learning and mobile access to offer users comprehensive control over their insights. Creating Powerful (and Beautiful) Dossiers. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformCommunity & Support Search Discussions Open A Case View My CasesHyperIntelligence and its Architecture. This consolidation will contain four. 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. Selectors that contain attribute, custom group, or consolidation elements as selector items can also include an option to display totals. ×Sorry to interrupt. {&GROUPLABEL} Name of the graph. Content Groups are MicroStrategy objects that can be migrated between environments. Each element contains a set of filtering or banding qualifications. The settings are numbered 1-5. MicroStrategy is a data visualization tool. In MicroStrategy Web, right-click an object and select Share. Each of the individual "mini-reports" that make up the entire custom group report will have at least one, if not more, SQL passes of its own. Right-click the header of the attribute whose elements you want to use to. This allows you to group attribute elements on a report in a way that is not defined in your data warehouse. Javadoc API documentation for MicroStrategy 2019. Group Elements. Source: MicroRooster. 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. Number of offices 3. Mid-America = Central, South. This is a list of the available auto text macros that the Report Services Document engine recognizes. Custom Group vs Consolidation; Auto Styles (Report vs Document vs Dossiers) Reports Creation. . 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. Qualifications are the actual conditions that must be met for data to be included in the custom group element. Microstrategy Dossiers With the release of MicroStrategy 10. Then, for mobile devices, our Responsive View will take over the layout and place groups. community. Get Started. Syntax. Create a new consolidation with three elements - Winter, Spring and Winter + Spring, as illustrated below: Create a report with the above created consolidation and three metrics -. Consolidations are used to group the attributes without disturbing the schema and it can group attributes based on the elements. One element will show the top ten customers and another element will show all customers. blogspot. Property indicates whether the aggregation over the consolidation is allowed for the consolidation on the template unit Property indicates whether the aggregation over the consolidation is allowed for the consolidation on the template unit. 3. The following schema shows which setting takes precedence when set at different levels. The attribute level follows a consecutive order from. Display the hierarchical view in the report (MicroStrategy Developer only) These tasks are completed at different levels and in different MicroStrategy. Microstrategy removing rows with Zero metric values If there are more than one metric and want to remove the rows with Zero metric values. STEPS TO. The "Custom Group Element Header Display Position" should be selected to reflect where the user would like to display the partial sum. The Metric Qualification dialog box opens. See below: Notice in Developer, you can currently right click on this document and select the 'Edit' option. Become a More Intelligent Enterprise. To open a document in Editable Mode, from a folder, right-click the document, point to Run as, and select Editable. Refresh. MicroStrategy is a data analytics platform that delivers actionable intelligence to organizations of all sizes. In MicroStrategy Workstation, right click on any cube created via Data Import and select Properties. exe using the command line. Interact with the engaged MicroStrategy Community to get answers to all your. Create a Report Services Document 2. You'll find everything from waterfall charts to word clouds in our community. Dataset 1 contains Year and Revenue, with data for three years (2007-2009). Then, for mobile devices, our Responsive View will take over the layout and place groups vertically on the canvas. This report is made up of custom group elements that consist of a header a. 1 and 10. Consolidations are static, we can create consolidations on attribute elements. Updated: November 2023. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . microstrategy. In MicroStrategy SQL Generation Engine 9. Select only Configuration Objects for documentation. Object. Query Stage: Retrieve data from the warehouse. First, create a consolidation that has a few elements but specifically at least one element with more than 2 attribute elements in its consolidation. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. If the Sort By object is a consolidation or metric, the only option is Default. For example, ApplySimple ("#0 * #1", [col1], [col2]) indicates that two items, col1 and col2, referenced. I. Source: MicroRooster. 3% of resumes. 4. An object is a basic building block in MicroStrategy. 3. 3. Configuration objects: Configuration objects enable us to connect with warehouse databases using MicroStrategy architecture. 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. Facts and fact tables have an associated level based on the attribute ID columns included in the fact table. The report-related objects placed on the template, such as attributes. This can be reproduced in Microstrategy Tutorial by following the steps below. 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. {&GROUPLABEL} Name of the graph item's category. In the "Metadata Repository" screen, select the "Project Source Name" and check the "Export Translations" option, as shown in the. The SQL pulls back the appropriate groups, and then performs the consolidation in memory. Insert an HTML container (and not an image) and insert the script below. None, which excludes the attribute in the target from the GROUP BY clause in the SQL statement. The recommended VLDB optimizations for Hive 0. 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. . Consolidations serve two powerful functions that can greatly enhance your reporting abilities: You can create a. Examples of this category are simple mathematical. Custom Group Effects on SQL Generation. x, select 'Project Documentation' from the Tools menu to start the wizard. Creates a connection object which is used in subsequent requests and manages the user’s connection with the MicroStrategy REST and Intelligence Servers. These values are set by default when the "Hive 0. The recursive hierarchy table has to be split into several tables, one for each level in the hierarchy. So distinct counts would not be possible. The different kinds of value prompts are: Date prompt: Users enter a specific date for which to see data. Result for new metric is blank. For more details, see the Custom Groups and Consolidations chapter of the Advanced Reporting Guide. All right, let’s get started! Performance Indicator We will explore two objects that serve this purpose: Custom Groups and Consolidations. Under Elements for this consolidation, right-click and select Add Element. Video Tutorials. Select any project that is in the project source that contains the users and. February 24, 2017 Uncategorized Consolidation and Custom grouping are special type of grouping filters and they are used when a User wants to see the metric values based on. MicroStrategy is the best BI tool used for reporting the data in very good design and graphical way. The following window appears on completing the above step. The SQL for a report with a custom group is likely to be very complex. A cross join between datasets can result in rows or Group Header/Footer sections that do not have metric data. 4. Number of consultants & teachers ___. This 'Top 10 Customers vs All' custom group will have two elements. Change the order that the conditions are evaluated. Normally, users would accomplish this with an attribute by setting it to the level of that attribute, however that may not produce desirable values. {&GROUPLABEL} Name of the graph. Create a new custom subtotal, as shown below: This will generate a report with the sum of all the 'End on hand' across subcategory, as shown below: To hide the auxiliary metric, in the grid options menu from the Columns and Rows tab, change the selection to fixed, as shown below:MicroStrategy Features . This is a single-value function. Study MicroStrategy Advanced Reporting flashcards. Click Next to go to Step 2. Consolidations Homepage Consolidations, custom groups, derived elements, derived attributes and attribute groups are different methods in MicroStrategy to allow. We need to establish a consolidation route for each transport layer. Consolidations enable you to group together and to pick specific attribute elements. In the list of categories on the left, click Subtotals. Here we have compiled a set of MicroStrategy interview questions asked in top organizations around the world. Click OK. microstrategy. 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. 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 properties needed to define a column of a DB table (Columns) Top level object - represents a Castor installation (Castor Server Config. Derived element groups are defined by a list, filter, or calculation. Enable hierarchical display for the custom group. Consolidations are static, we can create consolidations on attribute elements. 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. The Condition Editor opens. This article might want you to upgrade faster to the newest version and enjoy all of the enhancements in creating your stories!. The tooltip will show the dataset type listed as a Super Cube. The Preferences dialog box opens. microstrategy. {&GROUPLABEL} Name of the graph item's category. Consolidations enable users to create customized. 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. 7x" database object is used (set at Configuration Managers > Database Instances > Database Instance > Database connection type) Selected Default VLDB Properties for Hive 0. How to create a metric that uses different multiplier for different elements of consolidations or custom groups. The. A recent survey by Gartner, Inc. The Report Pre Statement settings insert custom SQL statements at the beginning of the report SQL. Consolidation ; Custom group; Fact; Metric; Subtotal; Transformation; For information about consolidations, custom groups, metrics, and subtotals, see the Advanced Reporting Guide. Non-aggregatable metrics are defined using the dimensionality section of the metric editor. Architects can create custom-based transformations to provide details for time periods such as Last Year, Month, Date, and others. 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. Custom groups are used to apply different filters to different rows of a report. But then it will add these 2 together for A+B. By the way, there is no. The MicroStrategy Tutorial project uses aggregate tables by default. Let me illustrate. A custom group is made up of an ordered collection of elements called custom group elements. The SQL will pull back counts for A and B. The SQL for a report with a custom group is likely to be very complex. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . Custom Visualizations: Users can create or import custom visuals to make their reports more tailored and effective. 1. Click the Options icon . ) A subtotal lets you see the. Watch this to learn about creating custom groups, time-based transformations, and shortcuts—all in. We can define a. Second, create a metric that has the base attribute used in the consolidation as a part of the dimensionality. First, create a consolidation that has a few elements but specifically at least one element with more than 2 attribute elements in its consolidation. Follow the steps below: Right-click on the project and select 'Project Configuration. Consolidation with diff groups of cities as regions. 2. Click the arrow to the left of a custom group element to expand it. new_description is the new. Other notable enhancements. They are made up of custom group. V. 11. The 'Select Objects' dialog box opens. However, it is not expected to see a metric value corresponding to the Custom Group. Ragged Hierarchies. 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 enables you to group attribute elements in new ways without altering the metadata and warehouse. Copy the code for the D3 visualization you are using. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. Autostyles can be either saved based on an existing document or they can. From the Elements menu, choose Add Element. A preview of your changes is appears in the scale below. MicroStrategy’s mobile support ensures flexible, real-time data exploration. MicroStrategy has partnered with MobileIron to add an extra layer of security to MicroStrategy Mobile applications running on iOS devices. Custom Group vs Consolidation; Auto Styles (Report vs Document vs Dossiers) Reports Creation. Derived elements are available only from MicroStrategy web. Create an empty MD shell in Microsoft Access. MicroStrategy recommends to have only one child at the lowest level. 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. utils. 1031 views | July 14, 2020 56:15. 9K views 4 years ago MicroStrategy In this video I will discuss when you should use a. 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. Custom Groups : Custom groups are set of filters and. 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. 3. 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. 4. The Subscribe to FTP dialog box opens. Now your connection f. Example. community. Sankey diagrams visually emphasize the major transfers or flows within a system, helping users locate dominant contributions to an overall flow. In MicroStrategy Web, click the metric for which you want to enable a grand total or subtotals. 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. Step 3. The numbers above the scale represent the minimum and maximum axis values. Supports custom properties (10. The Metric Editor opens in either Function Editor mode or Formula Editor mode, depending on the type of metric you chose to edit. For Compound Profit to be dynamically aggregated correctly, you change the dynamic aggregation function to Sum. Information about custom groups includes: About Custom Groups: Grouping Attribute Elements with Banding and Filtering Custom Group Effects on SQL Generation. MicroStrategy Dossier makes it easy to build insightful and engaging dashboards—and with the free-form canvas, the latest 2020 platform release has introduced new game-changing, design-focused. 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. Pros. Visit the data visualization and data dashboard galleries for inspiration. For example, a Time dimension in a star schema may be supported by a dimension table with the following structure: DAY_ID. 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. The essential distinction is that consolidations work with attributes and custom groups use filters. Below are the new features exclusive to. Visualize the flow from one set of values to another to gain insight into relative contributions. zip file below and deploy it in the environments where you want to use it - MicroStrategy Desktop, Workstation, Web, or Mobile. There's a reason we're at the top of the list. Explanation. 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. Both tools allow you to plot interactive charts, graphs, and dashboards for comprehensive analysis. 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. Open up the same document in MicroStrategy Web 10. Click on the Advanced tab and then the Configure button under 'Analytical Engine VLDB Properties,' as shown below: Expand the Analytical Engine folder and go to 'Subtotals Over Consolidations Compatibility. To apply the selections as a slice,. For more details, see the Custom Groups and Consolidations chapter. 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. . Target: The target is the attribute level at which the metric calculation groups. An object is a basic building block in MicroStrategy. 9% of resumes. MicroStrategy Interview Questions. 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,. Case This function evaluates multiple expressions until a condition is determined to be true, then returns a. The Custom Group Editor opens. The designed behavior is explained using an example consolidation and compound metric based on objects in the MicroStrategy Tutorial project. From the File menu, click Open. Login to MSTR Developer then go to: User Manager > User Definition > Project Access. Consolidations are groupings of attribute elements while custom groups are based on filter criteria. Open the custom group editor and drag an object from the object browser to create a custom group. With an OLAP Services license, user can perform additional OLAP analysis, using the following features: Displaying data on the fly: dynamic aggregation, page. To apply the same tooltip to every item in the graph, select the Labels and Values category. STEPS TO REPRODUCE: Create a document in MicroStrategy Developer or Web 10. 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. 2. A sample report is: Attributes: Metadata, Project, Object, Object Type, Component Object Type. For example, the report below contains Region, Category, and Profit. Consolidations enable users to create customized groupings that allow row calculations between elements of a given attribute. Create a report that uses this. Click Insert Visualization . 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 ("). A custom group lets you group attribute elements from the same or different attributes to meet your reporting requirements. x, select 'Project Documentation' from the Tools menu to. If a user enters more than 15 digits for a. The Custom Group Editor enables you to create and modify custom groups. MicroStrategy is rated 8. Ritinder Kaur Business Intelligence 1 comment. Credits; About the Authors. Click OK. Each text string entered in Report Pre Statement 1 through Report Pre Statement 4 is executed separately as a single statement. A derived element allows us to group on the basis of: – List of elements. This approach makes it easier for you to specify a flexible partitioning. Ensure that subtotaling is enabled for the consolidation. Expand the Series category. Choose the option, Add an Attribute qualification. 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. The third most common microstrategy developer skill is templates on 5. Consolidation elements are attribute elements that define the consolidation. When this report is executed, only two custom group elements are displayed even though five elements are defined in the custom group. When you open a web page the extension automatically scans web pages in your browser and underlines keywords that you can hover over to trigger cards. it looks like MicroStrategy doesn't support it, please advise. This object contains crucial project information that is generated and maintained by managers. 3. 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. Passes that hit the same fact table across different elements of a custom group are merged provided that they satisfy certain conditions. Step 8) In the next screen, Select the Field Group to maintain the status. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence; Multi-Cloud; Embedded Analytics. Create a consolidation with Region grouping 1-2 different attribute elements. Considerations for the use of star schemas with MicroStrategy SQL Generation. A derived element is a grouping of attribute elements on a report. Source: MicroRooster. Both consolidations and custom groups provide flexibility in reports, but the objects differ in their structure and use. Custom: Define specific minimum and maximum values to use to display the selected metrics. Step 3. Per-column group Advanced Filter; Thresholds . Step 10) Press “Back” for the SAP Standard Toolbar. Step 9) In the next screen, Maintain the Field status of the Group Fields. com Twitter: @MicroRoosterFormat: A MicroStrategy Online Training Video blog. To control the display of which Custom Group elements display sums, right click on the Custom Group element, and select "Show Display Options". 1, custom group selector does not have the custom group elements, while in 9. Select Data > Report Data Options. bandings on Attributes or Metrics to group the. Consolidations: Virtual attributes. To Modify Permissions for an Object in MicroStrategy Web. This knowledge base article explains an feature enhancement when using Consolidation or custom group. MicroStrategy manages the mapping between the logical table and the physical tables. Problem. Subtotals are totals of selected groups of your metric data, totaled at a level you select. Without data, the dashboard will not show the user anything. mstr) files that can be sent through Distribution Services is defined by the MicroStrategy (. Click Advanced, then New to create a custom subtotal. Third party code/SQL: MicroStrategy Technical Support does not provide customized SQL queries. Select any project that is in the project source that contains the users and groups and click Next. 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,. 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. The index for referencing these objects begins with 0 and increases by. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. KB46734: In MicroStrategy Web 9. 1. Normally, users would accomplish this with an attribute by setting it to the level of that attribute, however that may not produce desirable values. Filters data related to a business attribute’s form (s), such as ID or description. Split Hierarchy with M-M relationships: Explanation. Use that metric in a custom group that bands based on metric value and for each metric value. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. ). Ensure that subtotaling is enabled for the consolidation. 5K subscribers Subscribe 3. Prompt-in-prompt is a feature in which the answer to one prompt is used to define another prompt. Execute the report. As you can imagine, the SQL Engine. Step 7) In the next screen, Enter Field Status Groups for the Field Status Variant. Case ( (Category@ID = 1), Revenue, 0) Booksand Name it as Revenue for where 2 is Category ID for "Books" Report will display result. A custom group is a report object made up of an ordered collection of components called custom group elements, each consisting of a header and one or more qualifications that must be met for data to be included in the. Say you have product group A, product group B, product group A+B. 4. Filename. DOWNLOAD NOW. On the toolbar, click Add Element. 2) Create Metric2 as the RunningSum of Metric1. It is used to apply database (row-level) security to a MicroStrategy user. exe to this machine. For this class,. 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. {&GROUPLABEL} Name of the graph. 1. It is made up of an ordered collection of elements referred as custom group elements. Michael Sandberg's Data Visualization BlogMicroStrategy ONE introduces new features that provide better performance and scalability to enhance the overall user experience. Add the Custom Group to Grouping, as shown below: On Call Center Group, right click and select Sort – Inherit attribute sort. Starting in MicroStrategy 2021 Update 1, there is an new out-of-the-box, feature-rich. Click 'OK'. Group 3: New Orleans, Seattle, Boston and New York. Right-click the custom group, then select Edit.