These units are part of an attribute, for example, Customer. 4. 4 of 5 Null/Zero Functions are pushed down to Teradata. Right-click the table, point to Recognize, and then select Attributes. April 28, 2009 Architect, MicroStrategy Compound Attribute Sorin Suciu. Rather than creating attributes by manually creating an attribute expression, you can allow Architect to automatically create simple attributes defined on one column. Go to Smart Attribute blade on the Attributes Editor. This online help builds on a basic understanding of information provided in the Basic Reporting Help. (In this cube, Product Hierarchy Level 00 corresponds to the MicroStrategy Tutorial Category attribute; Product Hierarchy Level 01 corresponds to Subcategory. It is used with database-specific OLAP functions such as Rank(). Split Hierarchy with M-M relationships: Explanation. 4. Derived Attributes A derived attribute has its value determined by an expression which combines two or more columns in a database to create a new column. MicroStrategy requires compound ID form attributes to have all source tables for all of the ID forms in the ID form group. A compound attribute is an attribute with multiple columns specified as the ID column. In Desktop 2020 you can only use attributes in rows. Click All Objects View. x: Create a metric called A with expression "Min(1){~}" as shown below. MicroStrategy is a business intelligence tool, that supports interactive dashboards, highly formatted reports, scorecards, alerts, ad hoc queries, automated report distribution, thresholds, etc. Four types of direct relationships can exist between related attributes, and these relationships are defined by the attribute elements that exist in the related attributes. A compound attribute is one that uses two or more columns as its ID. In the Datasets panel, double-click attributes and metrics to add them to the visualization. database to create a new column. Attributes with compound IDs are always showing the IDs with the elements when using the In List function for a View Filter in MicroStrategy Web 9. Let’s look at each of the keys in DBMS with example: Super Key – A super key is a group of single or multiple keys which identifies rows in a table. x and 10. it was very disappointing to find out mid-way that it is so limited (and the option to create a "multi-form" attribute from data import exists for 3 years or saw from the web interface. Calculate each attribute individual weight according to the level in the hierarchy (level in hierarchy/number of levels in hierarchy * 10). In the Gallery, click Compound Grid . the report designer in a way similar to any other table. Intersection behaves as the term AND does in grammar. intermediate object}. The attribute level follows a consecutive order from. Navigate to the Schema Objects folder, open the Attributes folder, and then the Geography folder. In MicroStrategy Web 2020, create a dossier with a Compound Grid visualization. Learn how to create compound project attributes in MicroStrategy Developer, an advanced environment providing a complete range. Therefore, its ID form maps to a combination of columns. Change Qualify on to ID. The Compound Grid is a new visualization introduced in the MicroStrategy 2020 release. There's a reason we're at the top of the list. Attribute_ID1 = “,A1,” AND a11. To create a last year transformation based on an expression. ACTION: This issue has been addressed in MicroStrategy 10. With MicroStrategy HyperIntelligence, organizations can inject Zero-Click Intelligence about customers, products, people, and more directly into websites or web applications. For the Time hierarchy, the offset can. Drag at least one attribute to the top. 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. Click the Options icon . ) In the metric formula, the desired output dimensionality is given. In this case, MicroStrategy would know to aggregate Airport level fact data up to the Location level in when for example, only Location and Revenue need to be displayed. 4. 176. Attributes can have many descriptors, or forms, shown as distinct columns that are. Open a dossier. It uses Business Scenarios to provide examples of each concept. The 'Set as key' option is used for defining the lookup table primary key for the attributes when generating SQL with MicroStrategy Engine. A title bar allows MicroStrategy Web users to minimize and maximize the Grid/Graph, and it provides an identifier for the Grid/Graph in all views. MicroStrategy HyperIntelligence is the next step in the future of data analytics. Writing the WHERE block should be no problem, as you can generate it in MS Excel based on the two columns… something like =CONCATENATE(“OR (a11. x There may be instances when it is necessary to include an attribute form in a derived or a compound metric in order to carry out calculations based on the form value in MicroStrategy Developer 9. A compound attribute is an attribute with multiple columns specified as the ID column. An implicit expression is required for creating such an attribute. This technote describes a current defect in MicroStrategy Distribution Services 9. To use Natural Language Query, go to the Dossier Authoring interface (Web, Workstation, or Desktop), and click on the insight icon located at the top right corner: . Also, you add both attribute IDs, in this case Item_ID and Color_ID, to the fact table as shown in the following diagram. Open the dossier you want to modify. Here is the workaround to achieve the attribute left outer join on MicroStrategy Web. compound attributes. MicroStrategy is an enterprise BI application software. Multiple elements are highlighted when using an attribute with compound key as a selector in Visual Insight and MicroStrategy Web 9. Incident update and uptime reporting. it is the same as the Attribute property). Click Use Formula Editor. Quite often these attributes have automatic mapping for one ID and manual mapping for the other one. This implies that more than one ID column is needed to uniquely identify the elements of that attribute. A compound attribute is an attribute with multiple columns specified as the ID column. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Set the qualification type to 'Custom'. Users can also create compound attributes, define attribute relationships in the system hierarchy and modify display and sort. These commands can be compiled into script files and run from a graphical interface or from the command line. When the attribute used as a selector has a compound key, i. To create a compound key (composite key), users. A compound attribute is one that uses two or more columns as its ID. 12 String Functions are supported by the MicroStrategy Analytical Engine; however, the following functions can push down: Char. In MicroStrategy Developer, from the File menu, point to New, and select Transformation. Arithmetic operators are +, -, *, and /. The implicit attribute has its own expression. There's a reason we're at the top of the list. ". Any time you type an attribute whose name contains one or more spaces, the attribute must be enclosed in square brackets. The attribute editor allows users to create attribute forms, connect attributes to logical tables in the schema, and edit form expressions. This has been identified as a defect in MicroStrategy Web 10. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a red "X" as shown below: However, the images in the report display properly when the report is. In the pane, begin typing the metric formula. A split hierarchy is one - that at the lowest level - has more than one child. Attribute_ID1 = “,A1,” AND a11. To uniquely identify a distribution center, one must know two details about the distribution center: the ID of the distribution center and the country in which it exists. Custom number formatting symbols. This article notes a limitation of mapping MDX attributes to schema mapped attributes For example: Simple or Compound Metrics . 2. In the pane, begin typing the metric formula. Compound Metrics. Check other tables and select/deselect correct tables. Some of the main features offered by MicroStrategy are Advanced Analytics, Data Discovery, Data Visualisation, Embedded BI, and detailed reports and statements. Attribute elements, or the actual data values for an attribute, dictate the relationships that you define between attributes. A report is a MicroStrategy object that represents a request for a specific set of formatted data from your data source. In the report, the attribute with the compound key is Distribution Center. Creating Compound Attributes MicroStrategy Community 3. The Metric Editor opens in either Function Editor mode or Formula Editor mode, depending on the type of metric you chose to edit. Attribute forms. Several non-group functions that are. Under 'Source tables', select a table and click 'Set as Lookup'. For more information on VLDB properties, refer to the. more columns. A compound attribute is an attribute with multiple columns specified as the ID column. Filtering Compound Attributes. The time required for dependency checking varies based on a customer's metadata size and schema complexity. MicroStrategy can help you with that, with the creation of derived attributes and metrics. To Create a Metric Using the Formula Editor. PepsiCo ( PEP 0. A sample URL that answers an element prompt when the attribute has a compound ID is shown below. For example, a transformation metric can help a user compare last month's revenue to this month's revenue. When there are multiple datasets in a document, the grouping and sorting dataset is the one that is bolded in the Dataset. We're sorry. This design may look strange, but in most cases there are. microstrategy attribute selector values wtd mtd qtd ytd An alternative approach, which meets the time period requirement and reduces the time to market of the analytical application is creating a Custom Group with the time periods, then using a selector on the Report Services Document to filter the data by the time periods. The new grouped attribute appears in the Attribute Name field as. 4. Create your metric's formula. DATE are attributes. In Microstrategy, the lookup tables represent the attributes. It is derived based on a count against the fact_object_component table. Like other visualizations, a Compound Grid can be used as the target of a selector. HyperIntelligence allows you to add various, or alternate, forms of the keyword attribute for matching. In some business scenarios, it is required to apply threshold on rows without specific characters in attribute element names in a report with compound metrics in MicroStrategy Developer. Consider the sales figures of your company. Compound Keys - Advanced Architect Part 2 - MicroStrategy - YouTube Part 2 of the MicroStrategy Advanced Architect series where I demonstrate how to create compound attribute. Attribute_ID2= “,B1,”)”). Logical Size in Microstrategy: The logical size of a table depends on the number of attributes in that table and position of that attribute in Hierarchy. In this case, Promotion has a many-to-many relationship to both Item and. A compound attribute is defined as an attribute with more than one column specified as the ID column. This visualization allows you to create a grid that analyzes different aspects of data across a common dimensions or attributes in rows. The examples below describe how to drill on these compound metrics on both grid and graph reports. Under 'Source tables', select a table and click 'Set as Lookup'. It supports interactive dashboard, highly detailed reports, ad-hoc query, automated report dispute, and Microsoft Office integration. 4. e. On each column set, add at least one. (The compound metric also enables the "Allow Smart Metric" option in the Subtotals/Aggregation tab of the metric editor. Drag at least one attribute to the top of the Vertical area. Configuration Objects:. By ManishaGupta that reached out to me via. A data warehouse is an integrated set of data, derived basically from operational data to use in decision making strategy and business intelligence using (OLAP) techniques. Automatic recognition is enabled by the VLDB property Engine Attribute Role Options at the database instance level. Generally, you create a compound attribute when your logical data model reflects that a compound key relationship is present. DATE ie. For example, consider the relationship between three attributes: Promotion, Item, and Quarter. A compound key attribute is an attribute that has two or more IDs. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in one. If you are leveraging Web ASP, see KB484127 to use this feature. How to include an attribute form in a compound or derived metric in MicroStrategy Developer 9. The Compound Grid is a new visualization introduced in the MicroStrategy 2020 release. Drag an attribute from the object browser into the text box next to the qualification type or enter the attribute name and its form according to the following format: attribute_name@form_name. The multiple columns are joined with other attributes, typically in a many-to-many relationship. This change applies to metric creation in either Developer or Web. The algorithm that calculates the table sizes performs the following steps: Calculate the number of levels per hierarchy: Hierarchy 1: 3. Types of filters in Microstrategy Below are the types of filters: 1. A compound key attribute is an attribute that has two or more IDs. In the MicroStrategy Tutorial project, Distribution Center is an example of a compound attribute. Compound Key Attribute A compound key attribute is an attribute whose primary key is made up by the combination of two or. If the user defines more than one expression for a given form, heterogeneous mapping will automatically take place when tables and column names require it. This section focuses on the VLDB properties that are set at the metric and report level. Create or edit reports with authoring functionality. MicroStrategy Object Manager makes a list of all object dependencies before copying an object to prevent metadata inconsistency. 2. In this case, enter 'Date@ID'. Set the qualification type to 'Custom'. There may be instances when it is necessary to include an attribute form in a derived or a compound metric in order to carry out calculations based on the form value in MicroStrategy Developer 9. 2. You can also access the Attribute Creation Wizard at any time in the development of a project from the Schema menu in MicroStrategy Developer. Compound attributes are usually counted by concatenating the keys of all of the attributes that form the key. Document with no element attributes in the group by section. Any time you type an attribute whose name contains one or more spaces, the attribute must be enclosed in square brackets. Introduced in MicroStrategy 2020, the Compound Grid is especially useful for financial analysis when you need to analyze several KPIs across a common dimension, like investment vehicle or region. Attribute name:XXXX" is thrown after attempting to map a compound key attribute to SAP properties in MicroStrategy Analytics Enterprise. Logical Views allows application architects to create any. Using this grid, you can have multiple unrelated attributes and metrics in different sets of columns that are stitched together. Is there any easy way to find the lineage information from Report to the actual Warehouse table ?. 4. Example:. The two fundamental parameters are the evt (short for “event”) parameter and the src (short for “source”) parameter. Create a. This condition may be implemented through an ApplySimple statement such as the following: The user will find that the CASE statement. Here the many-to-many relationship is converted into a compound attribute relationship. (15-minute smart attribute is always required by default, if any smart attribute is checked) You can rename the time attributes or apply default sorting for each smart attribute. In Visual Insight in MicroStrategy Web 9. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a red "X" as shown below: However, the images in the report display properly when the report is. The types of attribute form expressions are as follows: Simple. You can create them in a report,. Creating attributes with multiple ID columns: Compound attributes • Modifying how to use attributes to browse and report on data • Specifying attribute roles: Attributes that use the same lookup • Supporting data internationalization for attribute elements Modifying attributes with the Properties pane A compound key attribute is an attribute whose primary key is made up by the combination of two or more columns. Currently the DIM_DATE. For example, for the Customer attribute, Customer Email, Customer First Name, and Customer Last Name are examples of attribute forms. intermediate object}. (The use of brackets around compound object names is standard for many objects in MicroStrategy and is not restricted to custom expressions and Apply. a) Attribute form qualification Filters data related to a business attribute’s form(s), such as ID or description. Open a report in MicroStrategy Developer. x and 10. 2. By choosing Automatic, if the largest table is >= 1M rows, MicroStrategy will choose the attribute. A compound attribute is defined as an attribute with more than one column specified as the ID column. The derived metric aggregates at the level of the attributes on the visualization by default. In the list of categories on the left, click Subtotals. Open MicroStrategy Web. x where all hyperlinks based on Applysimple no longer work when exporting to Flash, generating a MHT file. MicroStrategy is a business intelligence tool, that supports interactive dashboards, highly formatted reports, scorecards, alerts, ad hoc queries, automated report distribution, thresholds, etc. Compound metric C is made up of two metrics A and B with expression (A+B). You can type arithmetic operators (such as + and -) and comparison operators (such as < and >) directly in the metric expression. This technote describes a current defect in MicroStrategy Distribution Services 9. Attributes are MicroStrategy objects that represent the business concepts reflected in your stored business data in your data source. This article notes a limitation of MDX data sources for filters on different levelsStarting in MicroStrategy 10. The metric values roll up to the new attribute level of the grid. Dynamic aggregation happens on the fly, in memory. For Compound Profit to be dynamically aggregated correctly, you change the dynamic aggregation function to Sum. A derived attribute has its value determined by an expression which combines two or more columns in a. The formula of a compound metric is based on arithmetic operators and non-group functions. MicroStrategy AI is here. The operators and functions of a compound metric can be applied to facts, attributes, or metrics within the compound metric. Visit the data visualization and data dashboard galleries for inspiration. By default, the Partition Attribute pull-down menu is set to Automatic, which allows MicroStrategy Web to set the number of partitions. Add data to the report and leverage formatting capabilities. KB6669: How to create dynamic date filters on time attributes other than Date using custom SQL. There are no restrictions on the names for the columns used in the expressions of a given attribute form. Joint child relationships are really another type of many-to-many relationship where one attribute has a many-to-many relationship to two otherwise unrelated attributes. From there, put the elements into one group that is labeled "Inbound Costs" and make another that is labeled "Outbound Costs". In MicroStrategy Web, click the metric for which you want to enable a grand total or subtotals. Example:. Natural Language Query (NLQ) allows end users to build dossiers and get insights just by typing questions. Problem. Users can also create compound attributes, define attribute relationships in the system hierarchy and modify display and sort forms. To view and edit the parents and children of an attribute. The ApplyAgg function itself is a group-value function and accepts facts, attributes, and metrics as input. Turning on totals returns a row for the total, even though there are not rows of data to show. 78K. Find the attribute Ship Date in the Object Browser (in the Customer hierarchy) and drag it to the Attribute field. A percent-to-total shortcut metric displays the percent in relation to a selected total of each item affected by the metric. What is a compound attribute in Microstrategy? A compound attribute has its value determined by an expression which combines two or more columns in a database to create a new column . Select the check box for any smart attribute that needs to be created. 4. Drag an attribute or metric from the Datasets panel to the Columns Set area in the Editor Panel. 10869 views | September 04, 2020 01:10. In Visual Insight in MicroStrategy Web 9. II. In both a Grid and a Compound Grid, checking multiple attribute display forms and displaying attribute form names will cause the enabling or disabling of other attribute's subtotals. : ToString("Coal") Then add this attribute to the compound grid Columns group:A compound attribute is defined as an attribute with more than one column specified as the ID column. x-10. For Compound Profit to be dynamically aggregated correctly, you change the dynamic aggregation function to Sum. What are Configuration Objects? Configuration objects are MicroStrategy objects which can be re used in multiple projects and they appear in the. Therefore, more than one column is needed to identify that compound attribute distinctively. The following procedure describes how to achieve this: Create the highest level filter. In this case, Promotion has a many-to-many relationship to both Item and Quarter. If you were informed that your company had sales of $100,000, you can gather. This attribute join type is the default setting. When trying to use a selector based in a compound attribute, in MicroStrategy Mobile 10. Generally, you create a compound attribute when your logical data model reflects that a compound key relationship is present. leading_object{. The intersection of two sets yields a TRUE value only when both sets of filtering. A Compound Grid stitches multiple simple Grid visualizations together to provide a more holistic grid view with richer data insights. This implies that more than one ID column is needed to uniquely identify the elements of that attribute. Last. In the Editor Panel, right-click the attribute in Column Set 1 and select Display Attribute Forms. intermediate object}. A compound attribute is defined as an attribute with more than one column specified as the ID column. For example, the form expression for the Customer First Name attribute form is CUST_FIRST_NAME. KB17619: How to create a conditional attribute in MicroStrategy Desktop 8. The hyperlinks based on an attribute form compound by Applysimple no longer work when exporting to MHT in MicroStrategy 9. The Year - Define a new member attribute. Users can also create compound attributes, define attribute relationships in the system hierarchy and modify display and sort. If ReportLevel includes all the attributes on the template and in the report objects window, and ViewLevel includes only the attributes on the template, then the following is an example of how dynamic aggregation would apply to a smart metric. One-to-one: Each element in the parent attribute corresponds to one and only one element in the child attribute, and each child attribute. For example, you create an attribute called Customer to represent customers in your. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. 2987. Compound Attribute: A compound attribute is an attribute whose primary key is made up of the combination of two or more columns. Select the heat map visualization. All placeholders must begin with #0 and increase in increments of 1. To ensure consistency between the metadata and the object cache, remember to update the schema after schema object modifications (i. engine to explore locical dependencies between the attributes in=. In MicroStrategy Workstation, architects can create and edit attribute objects. The report-related objects placed on the template. Add a compound attribute, For instance "Seasons", to Page-by and enable subtotal for the report. To configure:-. Attribute description forms can be rendered into SQL in two ways. I have a metric A = Avg(0. Although transformations can be applied to any attribute hierarchy, the Time hierarchy is used most often. You are returned to MicroStrategy Developer. Defining the partition for Super Cubes. Including attribute forms in your logical data model can help you get a more complete view of all of the information that is made available in your project. Report R contains attribute T. If information about a. Generally, you build a compound attribute when your logical data model reflects that a. Use a percent-to-total shortcut metric to show cell-level values as percents of an accumulated row or column total. Select Custom as the Category and create the format using the number format symbols listed in the table below. Using datasets in documents. Create a compound metric defined as the division of the two metrics created previously, and configure it to be a smart metric, leaving the 'Dynamic aggregation function' as 'Default' as shown below: Create a report with the attributes Region, Month of the Year, and Category and the compound metric created before. This name change is visible in. Type the number of elements to display at one time and click OK. In this article, we clarify your questions regarding Pattern Matching and how it is different from the standard Keyword Matching. There's a reason we're at the top of the list. Set Data Engine Version setting to 11 or above. Various types of attributes in Microstrategy desktop include, Implicit Attributes; Compound Key Attribute; Derived Attributes; Simple Attribute; 23) Mention what is the difference between Custom group and Consolidations? Custom group Consolidations; A custom group is a set of filters that can be placed on a template. Create a report with the attributes Region and Promotion Type as seen below: 2. Once these Logical views are created, they are available to. The attribute editor allows users to create attribute forms, connect attributes to logical tables in the schema, and edit form expressions. In the Hierarchy Editor or Architect, click Save and. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. 3. You can format a graph report by adjusting colors, and applying a variety of graphical effects, including gradients, transparency, patterns, pictures, textures, and bevel effects. The formula of a compound metric is based on arithmetic operators and non-group functions. The operators and functions can be applied to facts, attributes, or metrics. Types of filters in Microstrategy Below are the types of filters: 1. One advantage of compound metrics compared to simple metrics is that compound metrics can use smart totals. This implies. To add a filter: Open the dossier with the heat map visualization you created in How to Create Your Heat Map Visualization. a) Attribute form qualification Filters data related to a business attribute’s form(s), such as ID or description. When naming a MicroStrategy object, you must follow the naming convention rules for your particular database platform. A normal attribute represents a single hierarchy level (for example, Month). When they do appear, report designers have some degree of control over the subquery syntax using the Very Large Data Base (VLDB. Workaround 4: Create a metric based on the attribute Country, for example Max (Country). Today, we are covering how to create derived attributes and metrics in MicroStrategy. MicroStrategy Internal Reference number for this technical note is KB483638 and US144497. In-line M-M Relationships: Explanation. performance and data integrity=2E. On the Security Filter tab, select a project under which you want to assign a security filter to the user or group. You can use derived metrics to. For instance, the attribute City may be defined in the data model as a combination of COUNTRY_ID and. Generally, you create a compound attribute when your logical data model reflects that a compound key relationship is present. 1 where when a Compound Attribute containing a Date Format ID is used as a dynamic textbox on a Flash document, the exporting does not format correctly when exported to. Heterogeneous mapping allows the engine to perform joins on unlike column names. You can apply an inner or outer join, which are described in more detail below. Attribute qualification filter These types of qualifications restrict data related to attributes on the report. MicroStrategy interfaces include desktop (for developers), web, Microsoft Office integration as well as Mobile Applications. Most of the creation of data multidimensional data warehouses is done manually, but it is a very complex and takes a long time and usually has a risk of fail. Super Cubes are simply a renaming of what was previously referred to as MTDI (Multi Table Data Import) Cubes. Metrics used to define the calculated metric can come from different datasets. Introduced in MicroStrategy 2020, the Compound Grid is especially useful for financial analysis when you need to analyze several KPIs across a common dimension, like investment vehicle or region. Select the Repeat attribute column checkbox to display the attribute. For example, consider the relationship between three attributes: Promotion, Item, and Quarter. In Desktop 2020 you can only use attributes in rows. Most attributes have at least two forms, ID and description (Desc). 4. Double-click the Column Set name to rename the set. You cannot change the join types of. What is a compound attribute in Microstrategy? A compound attribute has its value determined by an expression which combines two or more columns in a database to create a new column. Micro Strategy also supports mobile BI. In the Gallery, click Compound Grid . In SQL, the formula commonly becomes part of the SELECT clause of the SQL command. In the relational database. Use the Object Browser on the left to locate the prompt to add to the metric's definition. In the list of categories on the left, click Subtotals. MicroStrategy is an enterprise BI application software. attr_elementsApplySimple. There's a reason we're at the top of the list. Relate tables contain the ID columns of two or more attributes, which will define associations between them. This allows developers to model attributes and facts whose. This URL executes a report with one prompt. 4. (Optional) Use the Up and Down. Sorin is a MicroStrategy specialist, experienced in Retail. What is a compound attribute?A compound attribute has its value determined by an expression which combines two or more columns in a database to create a new column. Apply Filter Changes. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. 0 or above. member_terminal. For instance, the attribute City may be defined in the data model as a combination of COUNTRY_ID and CITY_ID. The attribute editor allows users to create attribute forms, connect attributes to logical tables in the schema, and edit form expressions. This is a single-value function. Users can also create compound attributes, define attribute relationships in the system hierarchy and modify display and sort. The operators and functions can be applied to facts, attributes, or metrics. The Metric Names attribute automatically appears in the Editor panel. An attribute on a dossier serves as a label for a group of metrics. ExampleA compound attribute has its value determined by an expression which combines two or more columns in a database to create a new column. In the Editor panel, click Add Column Set to create another column set. Dataset DS2 with attribute 'Year' and metrics 'Revenue', 'Profit', 'Profit Margin' (this is a compound smart metric calculated from metrics Revenue and Profit). The Promotion attribute is related to a particular Item-Quarter pair, as opposed to it being related to Item and Quarter separately. Create a new dataset DS1:In MicroStrategy Web 9. There may be instances when it is necessary to include an attribute form in a derived or a compound metric in order to carry out calculations based on the form. The form expression for the Customer Last Name attribute form is CUST_LAST_NAME. The operators and functions of a compound metric can be applied to facts, attributes, or metrics within the compound. The multiple columns are joined with other attributes, typically in a many-to-many relationship.