Consolidations allow users to group attribute elements in new ways without changing the metadata and warehouse definitions. for each successive object passed. Select your custom visualization. The chart below contains a list of all the object types and object descriptions occurring in MicroStrategy metadata: Never used, and all functions should check that zero (0) never pass for a type. Run Repository Translation Wizard from the Start Menu -> Programs -> MicroStrategy-> Object Manager. mstr) file size (MB) setting. Depending on your MicroStrategy product and licensing, this function may not be available. Each element in the custom group can have a different output level. Business Consolidation: The consolidation of several business units or several different companies into a larger organization. This can be reproduced in Microstrategy Tutorial by following the steps below. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. Disadvantages of Power BI: Limited Data Capacity in Free Version: The Power BI Desktop version has a data capacity restriction, which can limit in-depth data analysis for larger datasets. Enter a name for the custom group in the Enter Custom Group Name Here field. . 1. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . microstrategy. 1. com Twitter: @MicroRoosterFormat: A MicroStrategy Online Training Video blog. Follow the steps below for an example of how to do this. This is a single-value function. This calculation takes place in an analytical Engine so this helps for better performance when compared to Custom Group. For example, a document contains two datasets. A consolidation element expression defines how the attribute elements are calculated. found that 75% of organizations are pursuing security vendor consolidation in 2022, up from 29% in 2020. It is derived based on a count against the fact_object_component table. Select any project that is in the project source that contains the users and groups and click Next. So distinct counts would not be possible. Summer consists of June + July + August, fall consists of September + October + November, and so on. Add a condition to a custom group element. These auto text codes are automatically replaced by information about the document. 2. Interact with the engaged MicroStrategy Community to get answers to all your. By implementing the security policies and configurations provided by MobileIron, administrators can apply enhanced protections to mobile devices in use across the enterprise. Credits; About the Authors. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . Normally, users would accomplish this with an attribute by setting it to the level of that attribute, however that may not produce desirable values. This feature is similar to what we see in. 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. Subtotals are totals of selected groups of your metric data, totaled at a level you select. There are three types of objects: schema objects, application objects, and configuration objects. 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. 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. Below are the new features exclusive to. For steps to create a custom group in MicroStrategy Developer, see the MicroStrategy. MicroStrategy has partnered with MobileIron to add an extra layer of security to MicroStrategy Mobile applications running on iOS devices. Example. Your personal view subscription is saved, and you are returned to the report, document, or quick dashboard. All articles. Create a report that uses this. In addition, notice that the bars are all separated as a single bar based on their Revenue. 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. The report is showing the correct results: Next, I created a Custom Group as follows: Now, add this custom group to the report and remove the Subcategory. Custom groups are used to apply different filters to different rows of a report. 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. This article will help you learn to use these elements to create more powerful and unique grids. Microstrategy Dossiers With the release of MicroStrategy 10. In the bottom left corner, click on the button "Generate Connection File". Slowly changing dimensions in MSTR. ApplyAgg. To open a document in Editable Mode, from a folder, right-click the document, point to Run as, and select Editable. This approach makes it easier for you to specify a flexible partitioning. custom groups. The following schema shows which setting takes precedence when set at different levels. Metrics: Component Objects. 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. Displaying Top 5 Customers, Top 5 Employees, and Top 5 Items on the same report. 4. For more details, see the Custom Groups and Consolidations chapter of the Advanced Reporting Help. Visit the data visualization and data dashboard galleries for inspiration. 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. 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. There's a reason we're at the top of the list. TYPE: Custom Group. For example, the application for the Sales team may be locked to two groups. The Custom Group Editor opens. 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. In the Report Data Options Window, Select Calculations > Subtotals. The abundant design options deliver full control over position, formatting, and interactivity. 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. 3. A physical snapshot of the solution is: Each attribute has a 1-M relationship with its child. Consolidations are groupings of attribute elements while custom groups are based on filter criteria. Michael Sandberg's Data Visualization BlogMicroStrategy ONE introduces new features that provide better performance and scalability to enhance the overall user experience. Click New Custom Group Element. For information on whether your database supports various date and time functions, see MicroStrategy and Database Support for Functions. Expand the Series category. Make two grids with different attributes and metrics in each 3. objects that you can place on a report template. When this custom group is placed on a report with the metric and an answer of '8' for the prompt, the following results are returned: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. Connect to and interact with the MicroStrategy environment. Created different types of objects such as attributes, metrics, filters, prompts, Custom Groups and Consolidation. Schema objects include facts, hierarchies, and custom groups; application objects include reports, documents, and metrics; and configuration objects include project sources, database instances. For example, a Time dimension in a star schema may be supported by a dimension table with the following structure: DAY_ID. Subtotals. First, create a consolidation that has a few elements but specifically at least one element with more than 2 attribute elements in its consolidation. In MicroStrategy Web, right-click an object and select Share. 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. ALTER CUSTOMGROUP "My Custom Groups" IN FOLDER "Public ObjectsCustom Groups" NAME "Modified My Custom Groups" DESCRIPTION "Modified Copy of My Custom Groups" FOLDER "Public ObjectsCustom GroupsModified Custom Groups" ENABLEHIERARCHICALDISPLAY FALSE ENABLESUBTOTALDISPLAY TRUE. 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. Fine Tuning how to do from BI Developer standpoint; VLDB properties (Changing governor settings, tuning the report sql, table creation type, pre/post sql statements for any stats, etc. Click 'OK'. Make two grids with different attributes and metrics in each 3. Each element contains a set of filtering or banding qualifications. Online Analytical Processing (OLAP) is a multidimensional analysis of business data. Number of years active 18. Microstrategy Dossiers With the release of MicroStrategy 10. 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. MicroStrategy recommends that you use event-triggered schedules in situations where it is important to control which node performs certain tasks. If the document is already open in Design Mode, click the Editable Mode icon . The. Case can be used for categorizing data based on multiple conditions. For example, the report below contains Region, Category, and Profit. 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. With an OLAP Services license, user can perform additional OLAP analysis, using the following features: Displaying data on the fly: dynamic aggregation, page. 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. Derived elements are available only from MicroStrategy web. KB42896: How to grant privileges to a user, user group or security role using MicroStrategy Command. Type the Name of the personal view. In free-form layout, we provide an intuitive way to let you visually “group” containers together. To access the setting, in MicroStrategy Developer right-click on the project and select Project Configuration…Then, In the Project Configuration dialog box, choose Project Definition >. The following table summarizes the similarities and differences between consolidations and custom groups. Create a report with Year on the rows and Revenue on the columns. Creates a connection object which is used in subsequent requests and manages the user’s connection with the MicroStrategy REST and Intelligence Servers. 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. A consolidation allows you to group together various elements of the Region attribute into various territories and place them on your template. 1. That is, we will not be able to create these elements using the. For example, we create a group that is “East Zone” and generate a list of regions that are in the east zone. Information about custom groups includes: About Custom Groups: Grouping Attribute Elements with Banding and Filtering Custom Group Effects on SQL Generation Custom Group Structure on Reports Creating a Custom Group Editing and Formatting a Custom Group Consolidations are groupings of attribute elements while custom groups are based on filter criteria. Being able to run this calculation would be useful for. Custom Group or Consolidation? - MicroStrategy James Oliver 10. The following auto text codes allow you to add document variable information to your document. 3. The report execution process is a three-step process: 1. MicroStrategy makes no warranty, express, implied or otherwise, regarding this product, including its performance or reliability. x, there is no way to duplicate a custom group element. They are made up of custom group. 5. Number of offices 3. Through these interview questions and answers you will learn what is metadata, attributes, mapping, hierarchies, facts, smart metrics, transformations, filters, prompts and more. Visit the data visualization and data dashboard galleries for inspiration. Consolidation elements can also be an expression of attribute elements that make up a consolidation. 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. Filters data related to a business attribute’s form (s), such as ID or description. Consolidations enable users to create customized groupings that allow row calculations between elements of a given attribute. In the Order column, select Ascending or Descending. 2. The 30+ free BI comparison graphs will give you instantly insight in the pros and cons. Custom groups are used to apply different filters to different rows of a report. If a user enters more than 15 digits for a. The Custom Group Editor appears. 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. II. Paste the CSS for the style and the javascript code into the Code Editor tab. 3. Find an event in a city near you. Consolidations enable users to create customized. Submit Search. 4. Custom: Define specific minimum and maximum values to use to display the selected metrics. A custom group is made up of an ordered collection of components called custom group elements. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence; Multi-Cloud; Embedded Analytics. Under Elements for this consolidation, right-click and select Add Element. attribute elements. To Create a Custom Group. The Custom Group Editor enables you to create and modify custom groups. 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). Open the custom group editor and drag an object from the object browser to create a custom group. Consolidations are used to group the attributes without disturbing the schema and it can group attributes based on the elements. There are three types of objects: schema objects, application objects, and configuration objects. The Metric Editor opens in either Function Editor mode or Formula Editor mode, depending on the type of metric you chose to edit. Fact table levels: The context of your data. Description: A training video demonstrating how to create, use and forma. You'll find everything from waterfall charts to word clouds in our community. A custom group lets you group attribute elements from the same or different attributes to meet your reporting requirements. Web Professional. Consolidations are used to group the attributes without disturbing the schema and it can group attributes based on the elements. – Calculations. We need to establish a consolidation route for each transport layer. 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. ). Click Advanced, then New to create a custom subtotal. microstrategy. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. I. x. Group Elements. The index for referencing these objects begins with 0 and increases by. 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. From the perspective of the report design process, a custom group is an object that can be placed on a template. Consolidations and custom groups can support, because another sql statement may be created and retrieve the correct results from base tables. From the Home menu, point to Subscribe to, and select FTP. The Document Properties dialog box opens. 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. Use a percent-to-total shortcut metric to show cell-level values as percents of an accumulated row or column total. A custom group lets you group attribute elements from the same or different attributes to meet your reporting requirements. The Report Pre Statement settings insert custom SQL statements at the beginning of the report SQL. Display the hierarchical view in the report (MicroStrategy Developer only) These tasks are completed at different levels and in different MicroStrategy. For example, you need to analyze data by season (Fall, Winter, and so on) although your project does not contain a Season attribute. When creating or editing a custom group in MicroStrategy Developer 9. community. Case This function evaluates multiple expressions until a condition is determined to be true, then returns a. By the way, there is no. The steps below show you how to create a custom group in MicroStrategy Web. The following window appears on completing the above step. From the Tools menu, select Document Properties. Right-click the header of the attribute whose elements you want to use to. Populate and Evaluate: Fill report data required for display. {&GROUPLABEL} Name of the graph. In the Navigation pane, click Dossiers. Drag an attribute from the Datasets panel to the Columns area of the Editor panel to add attributes to the columns. Select only Configuration Objects for documentation. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Enter a new name for the custom group element and press ENTER. These groups provide a new view of report data for analysis and formatting purposes. From the perspective of the report design process, a custom group is an object that can be placed on a template. location_path is the folder where the consolidation resides, of type string, between double quotes ("). Updated: November 2023. 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. Right-click the dossier you want to certify. Information about custom groups includes: About Custom Groups: Grouping Attribute Elements with Banding and Filtering Custom Group Effects on SQL Generation. Consolidation elements can also be an expression of attribute elements that make up a consolidation. A new custom group element is created, with the default name Custom Group Element1. For example, you might group the Month elements into December. . Change the formatting of the values to have different colors. 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. 1031 views | July 14, 2020 56:15. The "Grouping" property has six possible. An object is a basic building block in MicroStrategy. If a user enters more than 15 digits for a. Tableau has unique graphics options to present data in a meaningful manner. Save the report as “Email Bursting”. Object. Step 10) Press “Back” for the SAP Standard Toolbar. DEFINITION: This custom group is a custom group banding qualification created on the metric, with band size banding type and a step size of '1' (integers). The following procedure describes how to. Third party code/SQL: MicroStrategy Technical Support does not provide customized SQL queries. A custom group can group attribute elements in a way that is not defined in the data warehouse. Prompt-in-prompt is a feature in which the answer to one prompt is used to define another prompt. 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). Then, for mobile devices, our Responsive View will take over the layout and place groups. Create a Report Services Document 2. Learn more. Once data flows into the interface, the dashboard will come to life. Step 8) In the next screen, Select the Field Group to maintain the status. Click Save to save changes. The different kinds of value prompts are: Date prompt: Users enter a specific date for which to see data. Consolidation ; Custom group; Fact; Metric; Subtotal; Transformation; For information about consolidations, custom groups, metrics, and subtotals, see the Advanced Reporting Guide. Application objects: Application objects include filters, prompt, documents, templates, reports, custom groups, and. 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. Consolidations are used to define the data you want to view in your report. Consolidations enable users to create customized groupings that allow row calculations between elements of a given attribute. An object is a basic building block in MicroStrategy. Create New Metric in a report or VI. The third-party product(s) discussed in this article is manufactured by vendors independent of MicroStrategy. The Code Editor tab should be open. 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. Open the Workstation window. template, consolidation, and custom group objects in an Enterprise Data Warehouse team environment. 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. To Define Custom Group Elements. Ans: MicroStrategy enables ad hoc analysis through an intuitive interface. KB13530: Feature in MicroStrategy SQL Generation Engine: Set Operator Optimization . 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. Select Data > Report Data Options. Under 'Level…' choose the attribute. These groups provide a new view of report data for analysis and formatting purposes. Sankey diagrams visually emphasize the major transfers or flows within a system, helping users locate dominant contributions to an overall flow. 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. Get inspiration at the MicroStrategy data visualization gallery. UX Designer, MicroStrategy To enable totals or subtotals for a metric. September 22, 2023. Custom Group and Consolidation Comparison summarizes the differences between these objects. Moving the CG/Consolidation to the left as a first column may fix the problem. Select only Configuration Objects for documentation. A derived element allows us to group on the basis of: – List of elements. 1, custom group selector does not have the custom group elements, while in 9. In MicroStrategy Web, open the document in Design or Editable Mode. The Create Personal View dialog box opens. 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. 1, custom group selector does not have the custom group elements, while in 9. This tool is known for its flexibility and speed of data study without losing on. Follow the steps below to create a list of all groups and the users in each group: In MicroStrategy Developer 9. VLDB Category. You can consider custom groups as many different reports "stacked up" together. Click the Options icon . 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. From the Visualizations panel, select Grid . A custom group can group attribute elements in a way that is not defined in the data warehouse. 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. Click OK. Invoke the MicroStrategy Integrity Manager executable MIntMgr. ,) SQL level tuning (Stats, Indexes, Cross Join Avoid, etc. Step 2. 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. Open the Desktop Window with the Navigation pane in Smart Mode. This type of passthrough can be used to create flexible filters. Right-click the Grid/Graph, transaction table, or any of the text fields in the panel stack, then select Configure Transaction. Create a report with the custom group "CG1" and the MDX metric "Cost". 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. A cross join between datasets can result in rows or Group Header/Footer sections that do not have metric data. To execute more than five statements, insert multiple statements in Report. {&GROUPLABEL} Name of the graph. For example, the report below contains Region, Category, and Profit. 6. {&GROUPLABEL} Name of the graph. Connection mapping allows administrators to assign a user or group in the MicroStrategy system to a specific login ID on the data warehouse. Say you want to create a custom group called "Sales Region" based on the State attribute: Tom sales region - California, Oregon, Nevada; Mary sales region - Atlanta,. 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. And leverage the Page-By function to focus your analysis on one element. In the Calculations - Subtotals window, Select the desired Custom Group and select Yes in the Allow subtotals drop down. This is a list of the available auto text macros that the Report Services Document engine recognizes. The primary characteristic of star schema is its use of dimension tables rather than single-attribute lookup tables. x, select 'Project Documentation' from the Tools menu to start the wizard. Inherit Attribute Sort, which uses the default sort of the attribute form set to display first. . Yes. The Custom Learning Portal is a customized learning page, hosted on MicroStrategy. This is caused by subtotals for the custom group object being disabled at the report level. Run the document on iPad, as shown below: 12. This has been tested to work successfully in a 9. The maximum file size of dashboard (. A report is a MicroStrategy object that represents a request for a specific set of formatted data from your data source. Case. We can define a. This prompt is used in a filter. The Apply functions are not meant to take. {&GROUPLABEL} Name of the graph. Count of Parents in Platform Analytics: There is an OOTB metric called Objects, which calculates the parents of a component object. com, that centralizes your learning content, from custom courses to project overviews and how-to videos, all alongside Education courses and certifications. 1. MicroStrategy Advanced Reporting Guide provides comprehensive information on advanced topics for using the MicroStrategy query and reporting products. 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. Problem. Cards present predefined KPIs associated with a selected keyword sourced securely from MicroStrategy. Homogeneous mapping: For consistency, it is a good idea for columns that contain the same data to. Number of consultants & teachers ___. new_description is the new. Group Elements. The report displays derived elements defined using. Click OK. They can create custom calculations, prompt for inputs, and easily share findings. Both consolidations and custom groups provide flexibility in reports, but the objects differ in their structure and use. Microstrategy removing rows with Zero metric values If there are more than one metric and want to remove the rows with Zero metric values. The Metric Qualification dialog box opens. built from same attributes or from multiple attributes. Consolidations allow users to group attribute elements in new ways without changing the metadata and warehouse definitions. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories . Click the arrow to the left of a custom group element to expand it. 2. Enable hierarchical display for the custom group. The "Custom Group Element Header Display Position" should be selected to reflect where the user would like to display the partial sum. This allows you to group attribute elements on a report in a way that is not defined in your data warehouse. See below: Notice in Developer, you can currently right click on this document and select the 'Edit' option. In the "Metadata Repository" screen, select the "Project Source Name" and check the "Export Translations" option, as shown in the. A custom group lets you group attribute elements from the same or different attributes to meet your reporting requirements. Custom groups are. For example, the attribute Customer has the forms ID, First Name, Last Name, Address, and Birth Date. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. Normally, users would accomplish this with an attribute by setting it to the level of that attribute, however that may not produce desirable values. Create a Report Services Document 2. Custom groups enable users to view specific elements based on a metric or specification. The Metric Editor opens in either Function Editor mode or Formula Editor mode, depending on the type of metric you chose to edit. Choose File > New Consolidation. Level Metrics. A Group derived element is a combination of attribute elements into a single derived element. The Configure Transactions Editor opens. xConsolidations allow users to group attribute elements in new ways without changing the metadata and warehouse definitions. Target: The target is the attribute level at which the metric calculation groups. With pass-through functions, you can create custom expressions to define attributes, metrics and filters. Dataset 2 contains Year and Profit, filtered to return data for only two years (2008 and 2009). Each element contains a set of filtering or banding qualifications. You'll find everything from waterfall charts to word clouds in our community. Click Advanced, then New to create a custom subtotal.