Click Next to go to Step 2. A custom group lets you group attribute elements from the same or different attributes to meet your reporting requirements. Paste the CSS for the style and the javascript code into the Code Editor tab. However, it is not expected to see a metric value corresponding to the Custom Group. When creating or editing a custom group in MicroStrategy Developer 9. In MicroStrategy Web, click the metric for which you want to enable a grand total or subtotals. {&GROUPLABEL} Name of the graph. Right-click the custom group, then select Edit. Unique Features. Dataset 2 contains Year and Profit, filtered to return data for only two years (2008 and 2009). Below are the steps to enable/disable the settings of data blending: 1. For Compound Profit to be dynamically aggregated correctly, you change the dynamic aggregation function to Sum. 5. Ritinder Kaur Business Intelligence 1 comment. So distinct counts would not be possible. For information on whether your database supports various date and time functions, see MicroStrategy and Database Support for Functions. These values are set by default when the "Hive 0. The following table summarizes the similarities and differences between consolidations and custom groups. Yes. Note: If a user enters more than 15 digits for a. Other notable enhancements. This is a single-value function. An object is a basic building block in MicroStrategy. A ragged hierarchy is the one in which the parent attribute element of one or more. This approach makes it easier for you to specify a flexible partitioning. A percent-to-total shortcut metric displays the percent in relation to a selected total of each item affected by the metric. This has been tested to work successfully in a 9. microstrategy. Displaying Top 5 Customers, Top 5 Employees, and Top 5 Items on the same report. 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. 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. The essential distinction is that consolidations work with attributes and custom groups use filters. Recommendation. The data for the Lookup_Region table came from a different source system than the data for the Lookup_Call_Ctr and the source systems have different naming conventions. MicroStrategy is a data analytics platform that delivers actionable intelligence to organizations of all sizes. ” icon to expand it: All page-by attributes will. The metric value of the first element (which is already the total of the individual items in the element) is added in the Total Subtotal displayed in the grid report. MicroStrategy - Real Time Consolidations & Custom Groupings - Online Training Video by MicroRooster MicroRooster 6. For example, the report below contains Region, Category, and Profit. custom groups. Custom groups are. 743,656 professionals have used our research since 2012. Define the advance sort on the derived. The maximum file size of dashboard (. Custom Group Editor. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. Consolidations are groupings of attribute elements while custom groups are based on filter criteria. By default, this executable is located in C:Program FilesMicroStrategyIntegrity Manager. User specifies the tables to load into memory; Attributes/Metrics are mapped to these tables. xConsolidations allow users to group attribute elements in new ways without changing the metadata and warehouse definitions. The total is calculated for all the selector items. 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. Click the Options icon . Create or edit reports with authoring functionality. This allows you to group attribute elements on a report in a way that is not defined in your data warehouse. If the document is already open in Design Mode, click the Editable Mode icon . 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. First, create a consolidation that has a few elements but specifically at least one element with more than 2 attribute elements in its consolidation. KB46734: In MicroStrategy Web 9. A custom group element is a logical expression of qualifications. Create a report that uses this. Enable hierarchical display for the custom group. Consolidations allow you to qualify a report on a row-by-row basis. 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. x, select 'Project Documentation' from the Tools menu to. Overall customer rating 9. A custom group is made up of an ordered collection of components called custom group elements. Per-column group Advanced Filter; Thresholds . x, non-aggregatable metrics are used for this kind of calculation. Then, for mobile devices, our Responsive View will take over the layout and place groups vertically on the canvas. 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. a) Attribute form qualification. Run Repository Translation Wizard from the Start Menu -> Programs -> MicroStrategy-> Object Manager. Drag an attribute from the Datasets panel to the Rows area of the Editor panel to add attributes to the rows. Instead of a consolidation, a custom group can be defined. Add a condition to a custom group element. com Twitter: @MicroRoosterFormat: A MicroStrategy Online Training Video blog. Consolidations vs Custom Groups. 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. Uninstall all the MicroStrategy and related products from Control Panel: Any MSTR Hotfixes applied. Web Professional. 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. 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. This is called heterogeneous column naming. 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. Consolidations are groupings of attribute elements while custom groups are based on filter criteria. Add the Age Groups Custom Group and the Profie and Revenue metrics to a report in MicroStrategy 10. Pros. blogspot. There's a reason we're at the top of the list. Create three reports named A (with attribute A), A&B (with attribute A and B),A&C (with attribute A and C) Create a dashboard based on the three reports created in last step. Consolidations are used to group the attributes without disturbing the schema and it can group attributes based on the elements. 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. Content groups can be defined for a custom application to limit the content that can be viewed by end users in the Sidebar menu of all Library clients, including mobile. Click 'OK'. To control the display of which Custom Group elements display sums, right click on the Custom Group element, and select "Show Display Options". Get Started. – Calculations. But then it will add these 2 together for A+B. It enables you to group attribute elements in new ways without altering the metadata and warehouse. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. Source: MicroRooster. Fu nction Types. 3. 1 HF6 environment. Consolidations are used to define the data you want to view in your report. Creating Powerful (and Beautiful) Dossiers. 1. Information about custom groups includes: About Custom Groups: Grouping Attribute Elements with Banding and Filtering Custom Group Effects on SQL Generation. – Filters. Copy cleanup. In MicroStrategy SQL Generation Engine 9. Visit the data visualization and data dashboard galleries for inspiration. The SQL pulls back the appropriate groups, and then performs the consolidation in memory. One element will show the top ten customers and another element will show all customers. When creating a VI Dashboard which contains a grid dataset along with either a consolidation or custom group object, the 'Create Attribute' option does not display for any other normal attribute in the dataset. STEPS TO REPRODUCE: Follow the steps below in order to reproduce this issue using the MicroStrategy Tutorial project: 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. 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. The metric can also show a total by page, show a total for each value of the attribute, or show the grand. The "Custom Group Element Header Display Position" should be selected to reflect where the user would like to display the partial sum. 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. The Subscribe to FTP dialog box opens. Use that metric in a custom group that bands based on metric value and for each metric value. Now your connection f. However, there is no option for the user to enable custom group subtotals at the report. Step 10) Press “Back” for the SAP Standard Toolbar. 16. 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. 3. x with any number of attributes. Submit Search. Three common microstrategy developer soft skills are analytical skills, communication skills and creativity. An online search reveals that MicroStrategy has less market penetration than Tableau. You must have the MicroStrategy Report Services product to view and create documents and RS dashboards. Homogeneous mapping: For consistency, it is a good idea for columns that contain the same data to. simply a grouping of attribute elements is called Consolidation. 1. 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. In free-form layout, we provide an intuitive way to let you visually “group” containers together. For Network: Transport Routes Overview -> Config. Supports custom properties (10. The report displays derived elements defined using. x, select 'Project Documentation' from the Tools menu to start the wizard. Select only Configuration Objects for documentation. The Item_id, Day_id, and Call_Ctr_id columns in the table above represent practical levels at which sales. This is caused by subtotals for the custom group object being disabled at the report level. All right, let’s get started! Performance Indicator We will explore two objects that serve this purpose: Custom Groups and Consolidations. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence; Multi-Cloud; Embedded Analytics. This can be reproduced in Microstrategy Tutorial by following the steps below. How to create a MicroStrategy connection file (. Syntax . See below: Notice in Developer, you can currently right click on this document and select the 'Edit' option. KB46734: In MicroStrategy Web 9. It includes built-in geocoding that auto maps executive locations. Each custom group element is made up of: A header, which contains the name of the custom group element and is displayed as a row in report results. Mastering Business Intelligence with MicroStrategy; Credits. Microstrategy Dossiers With the release of MicroStrategy 10. Note: Since performance of any query depends on factors outside MicroStrategy's control (especially database tuning and indexing), MicroStrategy cannot guarantee that there will be an improvement in performance using this technique. Consolidations are groupings of attribute elements while custom groups are based on filter criteria. In MicroStrategy Web, open the document in Design or Editable Mode. Microstrategy Dossiers With the release of MicroStrategy 10. 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. Click the Options icon . 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. 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. To choose a metric, execute one of the following: In the Metric box, enter in the desired metric name and click OK. Populate and Evaluate: Fill report data required for display. 1, custom group selector does not have the custom group elements, while in 9. Follow the steps below for an example of how to do this. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. MicroStrategy is a proprietary business intelligence suite based on a ROLAP back-end similar to Cognos or Business Objects. Step 3. The different kinds of value prompts are: Date prompt: Users enter a specific date for which to see data. Modified 3 months ago. 1. Microstrategy Dossiers With the release of MicroStrategy 10. Count of Parents in Platform Analytics: There is an OOTB metric called Objects, which calculates the parents of a component object. Change the order that the conditions are evaluated. The abundant design options deliver full control over position, formatting, and interactivity. Invoke the MicroStrategy Integrity Manager executable MIntMgr. 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. Ans: MicroStrategy enables ad hoc analysis through an intuitive interface. This prompt is used in a filter. In general, a user specifies a list of conditions and corresponding return values. A new custom group element is created, with the default name Custom Group Element1. All attribute element data is added together to form the metric values for the new Group derived element. MicroStrategy has partnered with MobileIron to add an extra layer of security to MicroStrategy Mobile applications running on iOS devices. 1. Credits; About the Authors. 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. There are three types of objects: schema objects, application objects, and configuration objects. Let me illustrate. This allows you to group attribute elements on a report in a way that is not defined in your data warehouse. If Custom Group A has six elements, Custom Group B has five elements and Custom Group C has eight elements, the number of SQL passes generated would be 6 x 5 x 8 = 240. 2. Level Metrics. The following options are available: Ø Transaction Mapping options. 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. {&GROUPLABEL} Name of the graph. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. From the perspective of the report design process, a custom group is an object that can be placed on a template. Browse to the folder in which to create the new custom group, then click the Create Custom Group icon. Custom groups are used to apply different filters to different rows. Refresh. From the Tools menu, select Grouping. A custom group is made up of an ordered collection of elements called custom group elements. 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. For more details, see the Custom Groups and Consolidations chapter of the Advanced Reporting Help. For example, the following image shows two facts with an Item/Day/Call Center level. To view custom groups in a hierarchical structure on a report, you must: Expand the item display of at least one custom group element. Below are the new features exclusive to. You'll find everything from waterfall charts to word clouds in our community. The Metric Editor opens in either Function Editor mode or Formula Editor mode, depending on the type of metric you chose to edit. 5K subscribers Subscribe 3. MicroStrategy Advanced Reporting Guide provides comprehensive information on advanced topics for using the MicroStrategy query and reporting products. bandings on Attributes or Metrics to group the. 3. Under 'Level…' choose the attribute. Step 7) In the next screen, Enter Field Status Groups for the Field Status Variant. Select Field Status Group and press Choose Detail button. Type the following for the name: "Total for the #P #0". For example, the separator is a comma (,) in English and a semicolon (;) in German. 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. 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. There are three types of objects: schema objects, application objects, and configuration objects. Ensure that subtotaling is enabled for the consolidation. Ca se functions Microstrategy Case functions return specified data in a SQL query based on the evaluation of user-defined conditions. From the Schedule drop-down list, select a schedule or event on which to deliver the report or document. Group 4: London, Fargo, Memphis and Charleston . The output level of a custom group (in this example, Store) is based on the filtering conditions of the element. 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. Passes that hit the same fact table across different elements of a custom group are merged provided that they satisfy certain conditions. KB42896: How to grant privileges to a user, user group or security role using MicroStrategy Command. Next, browse and choose the required attributes to create the. 3. Remember that P displays the parent attribute and 0 (the number zero, not the letter o) displays all the forms of the parent attribute. SASE and XDR are opportunities for consolidation: 41. for each successive object passed. The elements of a metric level are described below: •. 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. A badge icon appears on the item to indicate that it is certified. Close the Visualization Builder, and then re-open it. x, select 'Project Documentation' from the Tools menu to. Each custom group. To decide for yourself whether you should or should not use custom group, you must first understand the SQL executed by Microstrategy when you create a custom group. You can rename the. Version 2021. Examples of this category are simple mathematical. Custom Groups : Custom groups are set of filters and. Creating consolidations. The Document Properties dialog box opens. Architects can create custom-based transformations to provide details for time periods such as Last Year, Month, Date, and others. Navigate to and select a Transaction Services report, then click OK. com Format: A MicroStrategy Online Training Video blog. 3. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. The major roles and responsibilities depicted on the Microstrategy Developer Resume include the following – developing business solutions,. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Enterprise Analytics Business Intelligence; HyperIntelligence; Cloud; Product Innovation; Education; Consulting HyperIntelligence and its Architecture. Derived elements are available only from MicroStrategy web. Consolidation elements are attribute elements that define the consolidation. This tool is known for its flexibility and speed of data study without losing on. 2. Enter a name for the custom group in the Enter Custom Group Name Here field. A report is a MicroStrategy object that represents a request for a specific set of formatted data from your data source. Enter a new name for the custom group element and press ENTER. Click New Condition, then select the appropriate options to define the filtering condition. Facts and fact tables have an associated level based on the attribute ID columns included in the fact table. Say you have product group A, product group B, product group A+B. Report will display result as below. Add a condition to a custom group element. Remember that P displays the parent attribute and 0 (the number zero, not the letter o) displays all the forms of the parent attribute. Open the document in Design or Editable Mode. Execute the report. How to create a metric that uses different multiplier for different elements of consolidations or custom groups. From the left, click Document. 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. Both consolidations and custom groups provide flexibility in reports, but the objects differ in their structure and use. found that 75% of organizations are pursuing security vendor consolidation in 2022, up from 29% in 2020. Passes that hit the same fact table across different elements of a custom group are merged provided that they satisfy certain conditions. You can use DateDiff to create a metric or attribute form that lists the length of time between two dates. Number of consultants & teachers ___. Derived metric based on attribute values Here is how could create and display data correctly on using below simple steps. 2. For example, the application for the Sales team may be locked to two groups. Custom Group and Consolidation Comparison summarizes the differences between these objects. The. 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. Features: MicroStrategy and Tableau are two unique tools that offer incredible features. The recursive hierarchy table has to be split into several tables, one for each level in the hierarchy. {&GROUPLABEL} Name of the graph item's category. Syntax. The Custom Group Options dialog box opens. Create a consolidation with Region grouping 1-2 different attribute elements. Another possible solution in MicroStrategy would be to create logical tables to create an hierarchy like: Dept -> Old Dept -> Sub-Dept -> Old. In some cases custom group/consolidation on a report may cause metric value not to be shown. Consolidations allow users to group attribute elements in new ways without changing the metadata and warehouse definitions. 9K views 4 years ago MicroStrategy In this video I will discuss. community. A consolidation element expression defines how the attribute elements are calculated. Therefore, by default, custom groups are not sorted on reports and you cannot use the sort accessible from the toolbar or right-click menu option to sort custom groups. Consolidations enable users to create. September 18, 2018. Qualifications are the actual conditions that must be met for data to be included in the custom group element. Click OK. Data can be connected through an API, flat file, or database. I have a bunch of table that looks like this: Fact table 1. this allows users to perform the in-depth analysis of their data and get the valuable results from their data. In MicroStrategy SQL Engine, a VLDB setting "Custom Group Interaction with Report Filter" exists to manage different situations in which a Custom Group interacts with the report filter. When the report is executed and the prompt resolution occurs, the display contains the. 1. Consolidations are static, we can create consolidations on attribute elements. This consolidation will contain four. In the right corner of the dashboard, change the data source to none. 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. 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. This feature is only implemented for element list prompts. 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. (i) the MicroStrategy Components developed and licensed by MicroStrategy Services Corporation (MicroStrategy) of McLean, Virginia to Oracle and imbedded in the MicroStrategy for Oracle Retail Data Warehouse and MicroStrategy for Oracle Retail Planning & Optimization applications. 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 -. You can even import consolidation elements from other consolidations in the project to create consolidation elements. -> Check -> Request Consistency. As you can imagine, the SQL Engine. Consolidation elements are attribute elements that define the consolidation. within a function are separated by commas. DOWNLOAD NOW. The Metric Qualification dialog box opens. Then, for mobile devices, our Responsive View will take over the layout and place groups. 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. For example, we create a group that is “East Zone” and generate a list of regions that are in the east zone. The report data is as displayed below. 1 the sel… Number of Views 776 KB211988: Modifying a Custom Group in Web using the “Save As…” option overwrites the ACL of the Custom Group. 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. Video Tutorials. Finally, row level math can be performed. Consolidations: Grouping Attribute Elements with Arithmetic and Logical Operators. Custom groups enable users to view specific elements based on a metric or specification. STEPS TO. consolidation elements, which can be individually formatted. Consolidation ; Custom group; Fact; Metric; Subtotal; Transformation; For information about consolidations, custom groups, metrics, and subtotals, see the Advanced Reporting Guide. 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. By default, the metrics Compound Profit and Profit Margin do not use a dynamic aggregation function. A report is a MicroStrategy object that represents a request for a specific set of formatted data from your data source. This can be reproduced in Microstrategy Tutorial by following the steps below. Top Tips: Setup and Support for ESRI Map Custom Shapes with 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. For steps to create a custom group in MicroStrategy Developer, see the MicroStrategy. Technically this will result is different queries on the database, due to the fact that each calculation level is different. Experience. Consolidations are used to specify the data that you want to view in your report. 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. The Apply functions are not meant to take. Further, consolidations allow you to place this grouping of attribute elements on a template just like an attribute. 4. This article might want you to upgrade faster to the newest version and enjoy all of the enhancements in creating your stories!. 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. Dataset 1 contains Year and Revenue, with data for three years (2007-2009). Create a report with the custom group "CG1" and the MDX metric "Cost". 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. This prompt is used in a filter. Each element in the custom group can have a different output level. Number of years active 18. Microstrategy Dossiers With the release of MicroStrategy 10. They are made up of custom group. 4. To add a derived element to a document, open the document in Editable Mode. Another possible workaround is to divide the consolidation element expression by the number of attribute elements in that consolidation element (e. 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. Execute one of the following options: To specify default prompt answers, click on 'Add'. The MicroStrategy Tutorial project uses aggregate tables by default. x, select 'Project Documentation' from the Tools menu to start the wizard. Display the hierarchical view in the report (MicroStrategy Developer only) These tasks are completed at different levels and in different MicroStrategy. The Metric Editor opens in either Function Editor mode or Formula Editor mode, depending on the type of metric you chose to edit. Query Stage: Retrieve data from the warehouse. 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 ("). Description: MicroStrategy lets you create consoli. com. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. They can create custom calculations, prompt for inputs, and easily share findings. ) A subtotal lets you see the. Click Add New Element to create a new consolidation element. The Custom Group Editor opens. built from same attributes or from multiple attributes. Enable Subtotals and enable a basic total. Custom groups are used to apply different filters to different rows of a report. Select your custom visualization. Through these interview questions and answers you will learn what is metadata, attributes, mapping, hierarchies, facts, smart metrics, transformations, filters, prompts and more.