Consolidations are groupings of attribute elements while custom groups are based on filter criteria. For tp & TPPARAM: System Overview Screen -> SAP System -> Check -> Transport Tool. This can be reproduced in Microstrategy Tutorial by following the steps below. {&GROUPLABEL} Name of the graph. How to create a MicroStrategy connection file (. They are group-value functions. 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. To Define Custom Group Elements. 2. Content Groups are MicroStrategy objects that can be migrated between environments. MicroStrategy is rated 8. In some cases custom group/consolidation on a report may cause metric value not to be shown. Remember that P displays the parent attribute and 0 (the number zero, not the letter o) displays all the forms of the parent attribute. One common way to do this is to compare the date information you have stored to the current date. To begin, the architecture for dashboard execution is. The tooltip will show the dataset type listed as a Super Cube. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . 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. 5-7 Years. To enable totals or subtotals for a metric. 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. 2. In the Navigation pane, click Dossiers. g. Moving the CG/Consolidation to the left as a first column may fix the problem. Open the document in Design or Editable Mode. The object Type is listed as Super Cube: This can also be seen when editing or authoring a dossier. Examples of this category are simple mathematical. The mobile placement order follows a “Z-path” (left-to-right and top-to-bottom order). The Grouping Properties dialog box opens. Consolidations are groupings of attribute elements while custom groups are based on filter criteria. Consolidations are static, we can create consolidations on attribute elements. microstrategy. MicroStrategy is a data analytics platform that delivers actionable intelligence to organizations of all sizes. For example, the before and after SQL that is generated for a. Grouping specific months into a seasons consolidation. Handling slowly changing dimensions in a data warehouse depending on the user needs. As you can imagine, the SQL Engine. Designed Prompts and Filters to generate reports in grid and graph mode. Microstrategy Dossiers With the release of MicroStrategy 10. When this report is executed, only two custom group elements are displayed even though five elements are defined in the custom group. 1K views 5 years ago MicroStrategy. Consolidations and custom groups can support, because another sql statement may be created and retrieve the correct results from base tables. 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. How to create a metric that uses different multiplier for different elements of consolidations or custom groups. For example you can determine Top 20 customers, report the revenue of all customes with M, and add some regional figures in a single custom group. If the element name is shown, then the sum will be shown. Non-aggregatable metrics are defined using the dimensionality section of the metric editor. x, select 'Project Documentation' from the Tools menu to start the wizard. Derived metric based on attribute values Here is how could create and display data correctly on using below simple steps. for each successive object passed. MicroStrategy recommends to have only one child at the lowest level. The partition attribute should allow for near uniform distribution of data across the partitions, so that the workload on each partition is evenly distributed. By implementing the security policies and configurations provided by MobileIron, administrators can apply enhanced protections to mobile devices in use across the enterprise. West = Northwest, Southwest. Change the formatting of the values to have different colors. Vitaracharts for Microstrategy offers a variety of customizable data marker options for all charts including grids where there is a wide variety of use cases for this feature. 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. By default, this executable is located in C:Program FilesMicroStrategyIntegrity Manager. To modify permissions for a user or group, from the Permission Level drop-down list for that user or group, select the predefined set of permissions, or select Custom to define a custom set of permissions. Consolidations are used to group the attributes without disturbing the schema and it can group attributes based on the elements. The steps below show you how to create a custom group in MicroStrategy Web. x, non-aggregatable metrics are used for this kind of calculation. 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. September 18, 2018. 9% of resumes. In addition, notice that the bars are all separated as a single bar based on their Revenue. x, select 'Project Documentation' from the Tools menu to start the wizard. Click New Custom Group Element. Consolidations: Grouping Attribute Elements with Arithmetic and Logical Operators. Microstrategy Dossiers With the release of MicroStrategy 10. There's a reason we're at the top of the list. objects that you can place on a report template. Step 8) In the next screen, Select the Field Group to maintain the status. The Subscribe to FTP dialog box opens. Users can explore, filter, and visualize data with drag-and-drop functionality. 3. Finally, row level math can be performed. All right, let’s get started! Performance Indicator We will explore two objects that serve this purpose: Custom Groups and Consolidations. Filename. Note that a custom group, 'Age Groups' from the MicroStrategy Tutorial project, is used in the page-by axis. Ritinder Kaur Business Intelligence 1 comment. {&GROUPLABEL} Name of the graph item's category. KB46734: In MicroStrategy Web 9. 3. Populate and Evaluate: Fill report data required for display. Define conditions to use to filter data by selecting an attribute, metric, report, or filter, then specifying the appropriate options. For example, the application for the Sales team may be locked to two groups. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Source: MicroRooster. Next, browse and choose the required attributes to create the. Choose File > New Consolidation. Open up the same document in MicroStrategy Web 10. This feature is similar to what we see in web pages. Third party code/SQL: MicroStrategy Technical Support does not provide customized SQL queries. Right-click the custom group, then select Edit. Relate tables contain the ID columns of two or more attributes, which will define associations between them. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . Autostyles based on one document can be applied to another document in order to change its formatting or appearance. MSTR Secure Enterprise. ApplyAgg. Consolidation with diff groups of cities as regions. 3. These groups provide a new view of report data for analysis and formatting purposes. Unique Features. 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. Step 1. Another possible workaround is to divide the consolidation element expression by the number of attribute elements in that consolidation element (e. microstrategy. 1. There are three types of objects: schema objects, application objects, and configuration objects. To view custom groups in a hierarchical structure on a report, you must: Expand the item display of at least one custom group element. In general, a user specifies a list of conditions and corresponding return values. Result for new metric is blank. A custom group lets you group attribute elements from the same or different attributes to meet your reporting requirements. On the toolbar, click Add Element. It is derived based on a count against the fact_object_component table. 0). Right click and "Run as Administrator" to. Create New Metric in a report or VI. In MicroStrategy Developer, create a new report or select an existing report to use as the data mart table. 1. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. Custom Group Effects on SQL Generation. Starting in MicroStrategy 2021 Update 2, you can create or edit standalone consolidations for a project. For example, you might group the Month elements into December. By the way, there is no. From the Schedule drop-down list, select a schedule or event on which to deliver the report or document. Level metrics allows the users to choose the right combination of level target, filtering, and grouping (referred to as elements) to achieve your desired results. Display the hierarchical view in the report (MicroStrategy Developer only) These tasks are completed at different levels and in different MicroStrategy. 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. STEPS TO REPRODUCE: Create a document in MicroStrategy Developer or Web 10. 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:. Following are the steps to create a custom group. Facts and fact tables have an associated level based on the attribute ID columns included in the fact table. Consolidations are static, we can create consolidations on attribute elements. Description: MicroStrategy lets you create consoli. With pass-through functions, you can create custom expressions to define attributes, metrics and filters. . Individual consolidation elements can be formatted so that they display as formatted on any reports containing them. Visit the data visualization and data dashboard galleries for inspiration. MicroStrategy Interview Questions. These auto text codes are automatically replaced by information about the document. – Filters. Click Advanced, then New to create a custom subtotal. The Custom Group Editor enables you to create and modify custom groups. Subtotals. / 3. simply a grouping of attribute elements is called Consolidation. Consolidations allow users to group attribute elements in new ways without changing the metadata and warehouse definitions. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence; Multi-Cloud; Embedded Analytics. x. From the Elements menu, choose Add Element. x, select 'Project Documentation' from the Tools menu to start the wizard. It includes built-in geocoding that auto maps executive locations. 6 and later) Installation Instructions. MicroStrategy Best Practices Dynamic Custom Group in Dashboards or Dossiers Custom groups enable users to view specific elements based on a metric or specification. These values are set by default when the "Hive 0. After you find the microstrategy. Custom Data Markers allow for the flexibility to add more context to your displayed data and personalize it to the business user. 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. a) Attribute form qualification. In the Microstrategy Developer go to Tools -> Preferences(Not my prefernces :)) Under Developer category -> select Browsing on the browsing tab you see all the options like below: 3. Consolidations are groupings of attribute elements while custom groups are based on filter criteria. The recursive hierarchy table has to be split into several tables, one for each level in the hierarchy. •. Both documents and RS dashboards provide the freedom to design a dashboard pixel-by-pixel in multiple editing and previewing modes. 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. For example, setting Metric Join type to "Outer" at the report level (Metric editor > Tool > Metric Join Type) overwrites the Metric Join Type set at the Database Instance Level: The subject of Outer Joins is a very broad one, however, as a. 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. A custom group is a set of filters that can be placed on a template. 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. Created different types of objects such as attributes, metrics, filters, prompts, Custom Groups and Consolidation. This prompt is used in a filter. Click the Options icon . built from same attributes or from multiple attributes. From the Home menu, point to Subscribe to, and select FTP. x, select 'Project Documentation' from the Tools menu to start the wizard. Type the following for the name: "Total for the #P #0". )Right-click the custom group, then select Edit. Application objects: Application objects include filters, prompt, documents, templates, reports, custom groups, and. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . 4. Consolidations vs. . About the Authors; About the. 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. This tool is known for its flexibility and speed of data study without losing on. The Custom Group Editor appears. Ensure that subtotaling is enabled for the consolidation. 3. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. it looks like MicroStrategy doesn't support it, please advise. In MicroStrategy Web, open the document in Design or Editable Mode. 4. KB4377. Right-click the header of the attribute whose elements you want to use to. Double-click 'Add Qualification'. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. For Network: Transport Routes Overview -> Config. Then, for mobile devices, our Responsive View will take over the layout and place groups vertically on the canvas. To resolve this issue, perform the following steps: Right-click on the Project in MicroStrategy Desktop and go to Project Configuration. A consolidation allows you to group together the elements of the Month of Year attribute into various seasons and place them on the template. A derived element allows us to group on the basis of: – List of elements. Custom Visualizations: Users can create or import custom visuals to make their reports more tailored and effective. The SQL pulls back the appropriate groups, and then performs the consolidation in memory. This object contains crucial project information that is generated and maintained by managers. Through these interview questions and answers you will learn what is metadata, attributes, mapping, hierarchies, facts, smart metrics, transformations, filters, prompts and more. A custom group can group attribute elements in a way that is not defined in the data warehouse. This calculation takes place in an analytical Engine so this helps for better performance when compared to Custom Group. 2) Create Metric2 as the RunningSum of Metric1. For more details, see the Custom Groups and Consolidations chapter of the Advanced Reporting Guide. Qualifications are the actual conditions that must be met for data to be included in the custom group element. The report displays derived elements defined using. Visualize the flow from one set of values to another to gain insight into relative contributions. For example, you need to analyze data by season (Fall, Winter, and so on) although your project does not contain a Season attribute. The Custom Group content should be similar to: 2) Create a RunningSum metric over the regular Revenue metric:1. Consolidation elements are attribute elements that define the consolidation. 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. Step 3. One element will show the top ten customers and another element will show all customers. Create a report that uses this. In the "Metadata Repository" screen, select the "Project Source Name" and check the "Export Translations" option, as shown in the. Experience. 1) Create Metric 1 which is the sum of the fact that is to be in the columns. Create or edit. Display the hierarchical view in the report (MicroStrategy Developer only) These tasks are completed at different levels and in different MicroStrategy. For example, the report below contains Region, Category, and Profit. Custom Group Editor. Create a Report Services Document 2. Split Hierarchy with M-M relationships: Explanation. In the list of categories on the left, click Subtotals. Change the formatting of the values to have different colors. Tile grid map is an abstraction of the map data to solve the issue of difference in sizes causing issues with shading and making it difficult to compare geographic information. About Custom Group Elements. The essential distinction is that consolidations work with attributes and custom groups use filters. xConsolidations allow users to group attribute elements in new ways without changing the metadata and warehouse definitions. In MicroStrategy Workstation, right click on any cube created via Data Import and select Properties. Top Tips: Setup and Support for ESRI Map Custom Shapes with MicroStrategy. Custom groups; A custom group is a special filter that can be placed on a template and. September 18, 2018. . Type the Name of the personal view. 3% of resumes. When the report is executed and the prompt resolution occurs, the display contains the. Create a virtual attribute to allow reporting on an attribute that does not exist in the data model. This has been tested to work successfully in a 9. A ragged hierarchy is the one in which the parent attribute element of one or more. Consolidations are used to group the attributes without disturbing the schema and it can group attributes based on the elements. Each element in the custom group can have a different output level. Same thing for Sub-Dept 201. The Preferences dialog box opens. A custom group is used to group attribute elements and aggregate results in a report. utils. 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. A simple metric sum (Revenue) will go to different aggregate tables depending on the attributes on the template. 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. {&GROUPLABEL} Name of the graph. 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. Depending on the options that you select in the Custom Group Editor, the custom group could appear on the report in MicroStrategy Developer as shown below. The "Grouping" property has six possible. 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). It enables you to group attribute elements in new ways without altering the metadata and warehouse. STEPS TO. Custom Group Effects on SQL Generation. To resolve this issue, perform the following steps: Right-click on the Project in MicroStrategy Desktop and go to Project Configuration. Reports. Schema objects include facts, hierarchies, and custom groups; application objects include reports, documents, and metrics; and configuration objects include project sources, database instances. Updated: November 2023. template, consolidation, and custom group objects in an Enterprise Data Warehouse team environment. Supports custom properties (10. Yes. Dynamic Custom Group in Dashboards or Dossiers. 1 the sel… Number of Views 778 KB211988: Modifying a Custom Group in Web using the “Save As…” option overwrites the ACL of the Custom Group. An object is a basic building block in MicroStrategy. MicroStrategy is the best BI tool used for reporting the data in very good design and graphical way. You'll find everything from waterfall charts to word clouds in our community. The elements of a metric level are described below: •. A badge icon appears on the item to indicate that it is certified. ×Sorry to interrupt. To apply the selections as a slice,. Insert an HTML container (and not an image) and insert the script below. The following is an example of a 'Customer Geography' consolidation: Save the consolidation. Consolidation ; Custom group; Fact; Metric; Subtotal; Transformation; For information about consolidations, custom groups, metrics, and subtotals, see the Advanced Reporting Guide. In the Order column, select Ascending or Descending. Schema objects include facts, hierarchies, and custom groups; application objects include reports, documents, and metrics; and configuration objects include project sources, database instances. Click Advanced, then New to create a custom subtotal. Select any project that is in the project source that contains the users and. Labels: #Creat transaction services photo uploader #transaction. Now to fix this create a new Derived metric on Category attribute first with formula as Max (Category) {~ } and calling Books. Each text string entered in Report Pre Statement 1 through Report Pre Statement 4 is executed separately as a single statement. 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. Cards present predefined KPIs associated with a selected keyword sourced securely from MicroStrategy. Consolidations serve two powerful functions that can greatly enhance your reporting abilities: You can create a. The following table summarizes the similarities and differences between consolidations and custom groups. Consolidations enable users to create. The consolidation calculates at the report dataset level, aggregates that, and then does the consolidationCustom 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. ” icon to expand it: All page-by attributes will. The third most common microstrategy developer skill is templates on 5. Select the 'Advanced' tab, as shown below: Change the setting for 'Attribute element browsing' (circled in red above) to the limit that is desired for the project. Custom Group vs Consolidation; Auto Styles (Report vs Document vs Dossiers) Reports Creation. A sales team might use a business dashboard to connect. Tableau is a data visualization tool that helps create appealing charts, reports, and dashboards that are easy to share and interactive. 7x. x and add a derived attribute, right clicking an. 9K views 4 years ago MicroStrategy In this video I will discuss when you should use a. Target: The target is the attribute level at which the metric calculation groups. Custom groups are more flexible than consolidations because you do not have to know much about your data to create filters for a custom group. Learn more. Prompt-in-prompt is a feature in which the answer to one prompt is used to define another prompt. 4. Depending on your MicroStrategy product and licensing, this function may not be available. For more details, see the Custom Groups and Consolidations chapter of the Advanced Reporting Help. To add a derived element to a document, open the document in Editable Mode. Watch this to learn about creating custom groups, time-based transformations, and shortcuts—all in. Syntax . The “ #n” code in Apply function syntax serves as placeholders for the MicroStrategy objects being passed to your database. 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. If the quarter attribute is removed from the template, all custom group elements are displayed, with empty metric values for the custom group elements that lie outside of the report filter. A custom group is a set of special filters that can be placed on a template. I have a bunch of table that looks like this: Fact table 1. You can even import consolidation elements from other consolidations in the project to create consolidation elements. ,) SQL level tuning (Stats, Indexes, Cross Join Avoid, etc. For detailed steps to define a condition, see Condition Editor. x with any number of attributes. 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. 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. Enter a description for the custom group in the Enter Custom Group Description Here field. To install this visualization, download the . While this feature is similar to using an ApplySimple in a filter, the difference is that you can customize both sides of the condition, whereas with the ApplySimple you can only customize one side to be equal to a single Attribute Form. Click Save to save changes. Mastering Business Intelligence with MicroStrategy; Credits. 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. Viewed 13k times. Example. 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. if both conditions are met, then Red, else Green. Passes that hit the same fact table across different elements of a custom group are merged provided that they satisfy certain conditions. 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. $50,000 per year [includes deployment, hosting, maintenance, and 80 hours of custom course creation]As shown in the table in Custom Group Structure on Reports, you can enable custom group subtotals at the report or custom group level in Developer, as described below: The report level is governed by the Report Data Options, which allow you to disable or enable subtotals for each custom group on a particular report. Your personal view subscription is saved, and you are returned to the report, document, or quick dashboard. These groups provide a new view of report data for analysis and formatting purposes. Qualifications are the actual conditions that must be met for data to be included in the custom group element. Custom Group vs Consolidation; Auto Styles (Report vs Document vs Dossiers) Reports Creation. Click the Options icon . For example, we create a group that is “East Zone” and generate a list of regions that are in the east zone. blogspot. The schema looks like the following diagram. ApplySimple() Accepts facts, attributes, and metrics as input. Follow the steps below. x, select 'Project Documentation' from the Tools menu to. The fuel for business dashboards is data, so each one needs to have one or more data sources. Michael Sandberg's Data Visualization BlogMicroStrategy ONE introduces new features that provide better performance and scalability to enhance the overall user experience. 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. The following window appears on completing the above step. Asked 4 years, 11 months ago. 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. Video Tutorials. Example. There are three types of objects: schema objects, application objects, and configuration objects. Consolidations are used to define the data you want to view in your report. Derived elements are available only from MicroStrategy web. For information on whether your database supports various date and time functions, see MicroStrategy and Database Support for Functions. And leverage the Page-By function to focus your analysis on one element. Both consolidations and custom groups provide flexibility in reports, but the objects differ in their structure and use. Follow the steps below: Right-click on the project and select 'Project Configuration. Group 1: Atlanta, San Diego, Berlin and San Francisco. MicroStrategy - Real Time Consolidations & Custom Groupings - Online Training Video by MicroRooster MicroRooster 6. x, select 'Project Documentation' from the Tools menu to. Slowly changing dimensions (SCDs) are a common characteristic in many business intelligence environments. 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. 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. Case can be used for categorizing data based on multiple conditions. x. The Running Sum is defined as follows: RunningSum<BreakBy= {Subcategory}, SortBy= (Month) > ( [Units Received]) and should be the sum of the Units Received + Running Sum. 3. Step 2. The Metric Editor opens in either Function Editor mode or Formula Editor mode, depending on the type of metric you chose to edit. An attribute form qualification might filter on the form Last Name, the operator Begins With, and the letter H. 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. Follow the steps below to create a list of all groups and the users in each group: In MicroStrategy Developer 9. comArchitects can now do more with MicroStrategy Workstation. Per-column group Advanced Filter; Thresholds . Javadoc API documentation for MicroStrategy 2019. 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. The algorithm that calculates the table sizes performs the following steps: Calculate the number of levels per hierarchy: Hierarchy 1: 3. Custom groups. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. Technically this will result is different queries on the database, due to the fact that each calculation level is different.