Whether you're working with dossiers, cards, documents, or managing an entire intelligent enterprise, Workstation empowers you to do everything from one place. Enable Subtotals and enable a basic total. this allows users to perform the in-depth analysis of their data and get the valuable results from their data. Dynamic Custom Group in Dashboards or Dossiers. For example, the before and after SQL that is generated for a. Browse to the folder in which to create the new custom group, then click the Create Custom Group icon. Grouping attribute elements: Consolidations, custom groups, and derived elements When using a Custom Group or Consolidation as a selector, the option Apply selections as a filter is grayed out under the selector properties in MicroStrategy 9. In the right corner of the dashboard, change the data source to none. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . Select 'Add a Metric qualification' and click OK. Select the environment and project where you want to create your consolidation. For example: OR. What is relevant, rather than the sum, is the last atomic inventory value in a given period of time. 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. 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. Step 1. Click the Options icon . The different kinds of value prompts are: Date prompt: Users enter a specific date for which to see data. To open a document in Editable Mode, from a folder, right-click the document, point to Run as, and select Editable. Three common microstrategy developer soft skills are analytical skills, communication skills and creativity. This feature is similar to what we see in web pages. From the left, click Document. For example, you may want to see all the customers in a retail store that bring in over $1,000k in revenue per month, or a teach may want to only view data on students who scored over 2000 on their SATs. 4. 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. Count of Parents in Platform Analytics: There is an OOTB metric called Objects, which calculates the parents of a component object. To control the display of which Custom Group elements display sums, right click on the Custom Group element, and select "Show Display Options". By implementing the security policies and configurations provided by MobileIron, administrators can apply enhanced protections to mobile devices in use across the enterprise. Group 3: New Orleans, Seattle, Boston and New York. As you can imagine, the SQL Engine. 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. Then, for mobile devices, our Responsive View will take over the layout and place groups. Both tools allow you to plot interactive charts, graphs, and dashboards for comprehensive analysis. Starting in MicroStrategy 2021 Update 2, you can create or edit standalone consolidations for a project. All attribute element data is added together to form the metric values for the new Group derived element. This option is available only when the Compress Contents check box is selected. Below are the new features exclusive to. Interact with the engaged MicroStrategy Community to get answers to all your. Business Consolidation: The consolidation of several business units or several different companies into a larger organization. MSTR Health Center (if it's not uninstalled) MSTR Office (if installed) DHTML Editing Component (if installed) Restart the machine. CSS ErrorAnswer You can always convert a consolidation to a custom group, but you can only convert a custom group to a consolidation when the custom group filters are from the same table or very similar tables. A custom group lets you group attribute elements from the same or different attributes to meet your reporting requirements. A sales team might use a business dashboard to connect. Custom group expressions: A custom group is an object that can be placed on a template and is made up of a collection of elements called custom group elements. 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. Where:The Profit metric is a simple sum of the Profit fact. However, it is not expected to see a metric value corresponding to the Custom Group. 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. When using a Custom Group or Consolidation as a selector, the option Apply selections as a filter is grayed out under the selector properties in MicroStrategy 9. Your personal view subscription is saved, and you are returned to the report, document, or quick dashboard. 4. 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. 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 ("). The following is a quick reference table for a MicroStrategy Custom Group: A Custom. Let me illustrate. Enable hierarchical display for the custom group. Consolidations are used to group the attributes without disturbing the schema and it can group attributes based on the elements. Microstrategy Dossiers With the release of MicroStrategy 10. 9K views 4 years ago MicroStrategy In this video I will discuss. A custom group lets you group attribute elements from the same or different attributes to meet your reporting requirements. Create a report with Year on the rows and Revenue on the columns. 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. An online search reveals that MicroStrategy has less market penetration than Tableau. Consolidations allow you to qualify a report on a row-by-row basis. Change the band names to Top Performers, Average Performers, and Under-Performers. {&GROUPLABEL} Name of the graph. x. x, select 'Project Documentation' from the Tools menu to start the wizard. By default, the metrics Compound Profit and Profit Margin do not use a dynamic aggregation function. Mastering Business Intelligence with MicroStrategy; Credits. You can consider custom groups as many different reports "stacked up" together. Description: A training video demonstrating how to create, use and forma. You'll find everything from waterfall charts to word clouds in our community. Consolidations are groupings of attribute elements while custom groups are based on filter criteria. These auto text codes are automatically replaced by information about the document. You can even import consolidation elements from other consolidations in the project to create consolidation elements. Selectors that contain attribute, custom group, or consolidation elements as selector items can also include an option to display totals. 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. Metrics: Component Objects. Click Advanced, then New to create a custom subtotal. 4. 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. Click "Add Photo" and select photos to upload. Query Stage: Retrieve data from the warehouse. In the list of categories on the left, click Subtotals. Get inspiration at the MicroStrategy data visualization gallery. 1, custom group selector does not have the custom group elements, while in 9. For more details, see the Custom Groups and Consolidations chapter of the Advanced Reporting Help. A custom group lets you group attribute elements from the same or different attributes to meet your reporting requirements. Problem. Number of offices 3. To execute more than five statements, insert multiple statements in Report. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. An object is a basic building block in MicroStrategy. The Item_id, Day_id, and Call_Ctr_id columns in the table above represent practical levels at which sales. 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. The best part I liked the most about the tool is we can have a different kind of security which can be implemented like the object kevel security, data level security or. It is expected to not see individual items under the custom group element as the filter qualification for the custom group excludes all data. A blank visualization appears in the dossier. 7x. Examples of this category are simple mathematical. x. For example - We need to see a… Custom number format syntax — If none of the built-in number formats meet your needs, you can create your own custom format in the Number tab of the Format Cells dialog box. MicroStrategy Advanced Reporting Guide provides comprehensive information on advanced topics for using the MicroStrategy query and reporting products. A connection map in MicroStrategy is a link between a MicroStrategy user, a database connection, and a database login. Right-click the custom group, then select Edit. Consolidations enable users to create customized. Dataset 2 contains Year and Profit, filtered to return data for only two years (2008 and 2009). Syntax . Custom Group or Consolidation? - MicroStrategy James Oliver 10. 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. To enable totals or subtotals for a metric. 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. A recent survey by Gartner, Inc. One common way to do this is to compare the date information you have stored to the current date. Custom groups are. 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,. This feature is similar to what we see in. Article outlines why available cache is not utilised when drilling to an attribute inside of an Intelligent Cube report that contains a consolidation or custom group in MicroStrategy Developer (formerly Developer) and WebOnly 29% of organizations consolidate to reduce spending on licensing. A custom group is made up of an ordered collection of components called custom group elements. When the report is executed and the prompt resolution occurs, the display contains the. Skip to content. Slowly changing dimensions in MSTR. September 06, 2018. To Create a Custom Group. There's a reason we're at the top of the list. In free-form layout, we provide an intuitive way to let you visually “group” containers together. In addition, notice that the bars are all separated as a single bar based on their Revenue. 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. When a user has additional attributes in the report objects window, the aggregation causes the consolidation to add up the percentages for the results for each attribute instead of dividing the overall numbers. 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. Visualize the flow from one set of values to another to gain insight into relative contributions. (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. 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. exe using the command line. Notice that the bars are described by the labels on the X Axis, which break down as follows: Central (Region attribute), Jan 2010 (Month attribute), and either Lethal Weapon 4 or Zorro (custom group elements based on Item attribute). 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. Ensure that subtotaling is enabled for the consolidation. utils. certificateOn the Graph menu, choose Preferences. It allows users to customize data visualizations and build personalized real-time dashboards. Group 2: Washington, DC, Salt Lake City, Miami and Milwaukee. 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. Consolidations allow you to group attribute elements in new ways without changing the metadata and warehouse. The total is calculated for all the selector items. 5-7 Years. In this example, you need to break down the territories as follows: East = Mid-Atlantic, Northeast, Southeast. Right-click the header of the attribute whose elements you want to use to. Derived metric based on attribute values Here is how could create and display data correctly on using below simple steps. •. Save the report as “Email Bursting”. attribute elements. The following is an example of a 'Customer Geography' consolidation: Save the consolidation. )Right-click the custom group, then select Edit. Step 10) Press “Back” for the SAP Standard Toolbar. For Compound Profit to be dynamically aggregated correctly, you change the dynamic aggregation function to Sum. Consolidations vs. Select only Configuration Objects for documentation. use functions that are not standard in MicroStrategy but are available in various RDBMS platforms. | Meet MicroStrategy AI on the road. This type of passthrough can be used to create flexible filters. Define conditions to use to filter data by selecting an attribute, metric, report, or filter, then specifying the appropriate options. You must have the MicroStrategy Report Services product to view and create documents and RS dashboards. 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. Consolidation elements are attribute elements that define the consolidation. The Condition Editor opens. Step 2. Subtotals are totals of selected groups of your metric data, totaled at a level you select. Designed Prompts and Filters to generate reports in grid and graph mode. Through these interview questions and answers you will learn what is metadata, attributes, mapping, hierarchies, facts, smart metrics, transformations, filters, prompts and more. They act as containers for non-standard SQL expressions that MicroStrategy does not support. 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. If a user enters more than 15 digits for a. II. In your Datasets panel, hover over the name of your dataset. With pass-through functions, you can create custom expressions to define attributes, metrics and filters. Prompt-in-prompt is a feature in which the answer to one prompt is used to define another prompt. To Modify Permissions for an Object in MicroStrategy Web. Yes. 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. For detailed steps to define a condition, see Condition Editor. Each element contains a set of filtering or banding qualifications. {&GROUPLABEL} Name of the graph. 5K subscribers Subscribe 3. One element will show the top ten customers and another element will show all customers. x, select 'Project Documentation' from the Tools menu to start the wizard. For example, a Time dimension in a star schema may be supported by a dimension table with the following structure: DAY_ID. Moving the CG/Consolidation to the left as a first column may fix the problem. The steps below show you how to create a custom group in MicroStrategy Web. MicroStrategy functions are classified into the following types: Single-value functions (also known as Non-grouping or Scalar functions): These functions operate on each individual component of an input variable or argument, resulting in an output element for each component. 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. KB16396: A total subtotal incorrectly sums both the elements and individual items in a custom group in MicroStrategy Devel… Number of Views 611 KB4531: How to create a report that displays the top 'n' Item sales (variable) for each Subcategory within a. 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. The following table summarizes the similarities and differences between consolidations and custom groups. Normally, users would accomplish this with an attribute by setting it to the level of that attribute, however that may not produce desirable values. 1. 2. But it’s nipping at the heels of leading BI. Insert an HTML container (and not an image) and insert the script below. MicroStrategy is a data visualization tool. Instead of a consolidation, a custom group can be defined. 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. mstrc) Open Workstation. A Group derived element is a combination of attribute elements into a single derived element. In some cases custom group/consolidation on a report may cause metric value not to be shown. 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. Derived elements are available only from MicroStrategy web. Click Save to save changes. 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. A message is displayed at the top of the report, document, or quick dashboard, confirming that the personal view is saved. Select only Configuration Objects for documentation. 6 and later) Installation Instructions. For example, the separator is a comma (,) in English and a semicolon (;) in German. x with any number of attributes. Metadata partition mapping is the mapping of partitions where the mapping of partitions is performed and maintained in the project metadata by the application, in this case, MicroStrategy. The developer would create one or more Filter. . To resolve this issue, perform the following steps: Right-click on the Project in MicroStrategy Desktop and go to Project Configuration. These values are set by default when the "Hive 0. com Twitter: @MicroRoosterFormat: A MicroStrategy Online Training Video blog. Custom: Define specific minimum and maximum values to use to display the selected metrics. The following table summarizes the similarities and differences between consolidations and custom groups. The primary characteristic of star schema is its use of dimension tables rather than single-attribute lookup tables. Next, browse and choose the required attributes to create the. 1 comment. Type the Name of the personal view. Example. This article will help. In the Report Data Options Window, Select Calculations > Subtotals. Ritinder Kaur Business Intelligence 1 comment. Create a report with Category, Subcategory and Revenue. Comprehensive analytical capabilities and Automated reporting: MicroStrategy offers wide range of analytical features including data visualizations, advance analytics, data discovery and predictive modeling. template, consolidation, and custom group objects in an Enterprise Data Warehouse team environment. 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. utils. For example - We need to see a…Custom number format syntax — If none of the built-in number formats meet your needs, you can create your own custom format in the Number tab of the Format Cells dialog box. UX. Enter a new name for the custom group element and press ENTER. 5% of organizations plan to have adopted SASE by the end of 2022. Click New Condition, then select the appropriate options to define the filtering condition. Nature: By nature, both Tableau and MicroStrategy tools are Business Intelligence software designed for visualizing data. Microstrategy Dossiers With the release of MicroStrategy 10. Fu nction Types. Browse to the folder in which to create the new custom group, then click the Create Custom Group icon. TYPE: Custom Group. Users can explore, filter, and visualize data with drag-and-drop functionality. Autostyles based on one document can be applied to another document in order to change its formatting or appearance. Custom group elements can include a logical expression containing any of the following qualification types ("Developer" and "Web" indicate which product the qualification can be created in): Attribute qualification (Developer, Web): Restricts data based on the value of an attribute form; lets you view data only for attribute elements in a list. Description: MicroStrategy lets you create consoli. x. It is a worthwhile technique. Study MicroStrategy Advanced Reporting flashcards. Specify the desired delivery options including recipient address, subscription name. For example, you need to analyze data by season (Fall, Winter, and so on) although your project does not contain a Season attribute. There are three types of objects: schema objects, application objects, and configuration objects. Derived elements are available only from MicroStrategy web. . A consolidation allows you to group together various elements of the Region attribute into various territories and place them on your template. Right-click the Grid/Graph, transaction table, or any of the text fields in the panel stack, then select Configure Transaction. KB4377. 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. Subtotals. Without data, the dashboard will not show the user anything. Michael Sandberg's Data Visualization BlogMicroStrategy ONE introduces new features that provide better performance and scalability to enhance the overall user experience. From the perspective of the report design process, a custom group is an object that can be placed on a template. Keep Group Structure, which indicates that the custom group is not sorted (the default) Sort on Attribute ID. To apply the selections as a slice,. Grouping specific months into a seasons consolidation. Step 2. microstrategy. 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. Syntax . MicroStrategy has partnered with MobileIron to add an extra layer of security to MicroStrategy Mobile applications running on iOS devices. 3. A Document Autostyle is a collection of formatting properties saved in a document for various control types (sections, text fields, lines, etc. 4. Insert an HTML container (and not an image) and insert the script below. 3 and later) Supports exporting to PDF (10. 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. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. 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. 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. 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. Credits; About the Authors. Business consolidation is used to improve operational efficiency by. Note that a custom group, 'Age Groups' from the MicroStrategy Tutorial project, is used in the page-by axis. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. 1. A custom group is made up of an ordered collection of elements called custom group elements. Consolidations: Virtual attributes. First, create a consolidation that has a few elements but specifically at least one element with more than 2 attribute elements in its consolidation. 6. All articles. Sankey diagrams visually emphasize the major transfers or flows within a system, helping users locate dominant contributions to an overall flow. ,) SQL level tuning (Stats, Indexes, Cross Join Avoid, etc. This knowledge base article explains an feature enhancement when using Consolidation or custom group. 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. simply a grouping of attribute elements is called Consolidation. Below are the steps to enable/disable the settings of data blending: 1. The fuel for business dashboards is data, so each one needs to have one or more data sources. The essential distinction is that consolidations work with attributes and custom groups use filters. 1. Reports that contain B or C will ignore filters on the other. 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. By default, this executable is located in C:Program FilesMicroStrategyIntegrity Manager. Following are the steps to create a custom group. Ans: MicroStrategy enables ad hoc analysis through an intuitive interface. To begin, the architecture for dashboard execution is. It provides the capability for complex calculations, trend analysis, etc. The report-related objects placed on the template, such as attributes. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. There are three types of objects: schema objects, application objects, and configuration objects. Selectors that contain attribute, custom group, or consolidation elements as selector items can also include an option to display totals. If the document is already open in Design Mode, click the Editable Mode icon . Consolidations allow users to group attribute elements in new ways without changing the metadata and warehouse definitions. 1. Type the following for the name: "Total for the #P #0". To allow sorting on the attribute elements after sorting by the metric total value, users may follow the steps below: Create a level derived metric to calculate on the attribute level at which the subtotal is calculated. Go to Project Configuration > Database Instances > Connection Mapping as seen below: Click on New to create a new Connection Map and fill in the Criteria for the USA users for their connection mapping, as shown below: Note: When creating a new connection map, the users can choose from the following two types of database instances. This prompt is used in a filter. The following window appears on completing the above step. objects that you can place on a report template. 4. Here we have compiled a set of MicroStrategy interview questions asked in top organizations around the world. The algorithm that calculates the table sizes performs the following steps: Calculate the number of levels per hierarchy: Hierarchy 1: 3. Unique Features. Number of consultants & teachers ___. 4. If the element name is shown, then the sum will be shown. Consolidation elements can also be an expression of attribute elements that make up a consolidation. To display a group horizontally. 2. Both products' features range. The following auto text codes allow you to add document variable information to your document. Paste the CSS for the style and the javascript code into the Code Editor tab. The purpose of this Tutorial is to create a report which displays the top ten contributors versus all other contributors by use of custom groups in MicroStrategy Web. g. In general, a user specifies a list of conditions and corresponding return values. x, select 'Project Documentation' from the Tools menu to. See below: Notice in Developer, you can currently right click on this document and select the 'Edit' option. Calculate each attribute individual weight according to the level in the hierarchy (level in hierarchy/number of levels in hierarchy * 10). 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. ApplySimple() Accepts facts, attributes, and metrics as input. . Starting in MicroStrategy 2021 Update 1, there is an new out-of-the-box, feature-rich. Facts and fact tables have an associated level based on the attribute ID columns included in the fact table. The following procedure describes how to. 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. – Calculations. likes. Enter a name for the custom group in the Enter Custom Group Name Here field. Select Field Status Group and press Choose Detail button. Create or edit. MicroStrategy is the best BI tool used for reporting the data in very good design and graphical way. Target: The target is the attribute level at which the metric calculation groups. Extensively worked in creating and integrating MicroStrategy reports and objects (Attributes, Filters, Metrics, Facts, Prompts, Templates, Consolidation and Custom Groups) with the data warehouse. Overall customer rating 9. A physical snapshot of the solution is: Each attribute has a 1-M relationship with its child. {&GROUPLABEL} Name of the graph item's category.