Note that only the naming convention has changed, as the functionality remains the same. The union of two sets yields a TRUE value any time that either or both of the sets of filtering criteria are met. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformAttribute T contains a form called "email" whose values are email addresses that will be used in the dynamic subscription in Narrowcast. The intersection of two sets yields a TRUE value only when both sets of filtering. Visit the data visualization and data dashboard galleries for inspiration. It is a very popular BI tool since it allows organizations to analyze their data in-depth and make better decisions. A sample report is: Attributes: Metadata, Project, Object, Object Type, Component Object Type. Metrics used to define the calculated metric can come from different datasets. 0:50. Workaround / Solution. Joint Element Lists are an advanced filtering qualification in MicroStrategy Developer / SQL Engine that can be used to filter on combinations of attribute element ID's from multiple attributes. Right-click the attribute to limit, point to Element Display, and then select Limit. 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. n this brief video tutorial, Stephen Goodson, a senior instructor from our Customer Education team explains what compound attributes are and demonstrates how. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence; Multi-Cloud. For instance, the attribute City may be defined in the data model as a combination of COUNTRY_ID and CITY_ID. In Desktop 2020 you can only use attributes in rows. You can use the AppleSimple function to insert database-specific functions and simple operators directly into SQL. 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 a Flash MHT file. 4. In Visual Insight in MicroStrategy Web 9. A compound key attribute is an attribute that has two or more IDs. Set the qualification type to 'Custom'. For. The multiple columns are joined with other attributes, typically in a many-to-many relationship. 3. Total (profits/unit sold) Smart Metrics: Total (profit)/ Total (sold) 8) Mention what types of testing can be carried out over the Microstrategy reports? Microstrategy can carry out test like • Naming convention tests • Total calculations test • SQL query validations • Attribute and metric. The Metric Editor opens in either Function Editor mode or Formula Editor mode, depending on the type of metric you chose to edit. Microstrategy is based on single meta-data repository; Microstrategy can be operated as web based and a desktop tool; There is no cube data-set for Microstrategy, and we obtain latest data-set from data-warehouse automatically; Microstrategy reporting is fast; Cognos has two meta-data repository based database; It can be used as web-base. For the Time hierarchy, the offset can. Here the many-to-many relationship is converted into a compound attribute relationship. MicroStrategy's default technique is to write description form expressions into the SQL Max() function. multiple attribute forms conform the ID form, any element that matches at least one of the ID's will become highlighted, like shown below. The Results Preview dialog box opens. The Transformation Editor opens with the Select a Member Attribute dialog box displayed. There are several ways to create and apply filters to individual chapters, multiple chapters, or across an entire dossier. Due to how the editor works it is not possible to force this restriction upon creation. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. x doesn't have mapping between boolean type and MicroStrategy internal datatype. member_terminal. (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. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Depending on your MicroStrategy product and licensing, this function may not be available. This implies that more than one ID column is needed to uniquely identify the elements of. xThis results in the error: “Engine Logic:Cannot get the column reference of a join attribute from the associated table”. Count of Parents in Platform Analytics: There is an OOTB metric called Objects, which calculates the parents of a component object. Example A compound key attribute is an attribute whose primary key is made up by the combination of two or more columns. Compound Grid visualizations. An attribute form expression defines what columns in the warehouse are used to represent the attribute form in SQL. This version of the product is no longer supported in accordance with MicroStrategy's support lifecycle. Create or edit reports with authoring functionality. 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. Use the Object Browser on the left to locate the prompt to add to the metric's definition. 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. If you know of better/faster ways, please share. Create Dossier and Chapter Filters. Automatic recognition is enabled by the VLDB property Engine Attribute Role Options at the database instance level. When generating the SQL for the report containing such a metric, the subquery will only perform the max or min on the first ID in the attribute ID form. Also, you add both attribute IDs, in this case Item_ID and Color_ID, to the fact table as shown in the following diagram. Setting a join specification allows you to place conditions on the data selected for display in a report. The Allow URLs to Export setting allows administrator's to specify the only URLs and URL paths that can be exported to PDF or Excel. Compound Metrics. The new grouped attribute appears in the Attribute Name field as. This design may look strange, but in most cases there are. This is a known issue in MicroStrategy 10. Mode. The dynamic aggregation itself is highlighted in red. Dataset DS2 with attribute 'Year' and metrics 'Revenue', 'Profit', 'Profit Margin' (this is a compound smart metric calculated from metrics Revenue and Profit). We recommend the latest version. ApplyAgg() Accepts facts, attributes, and metrics as input. Drag at least one attribute to the top of the Vertical area. This change applies to metric creation in either Developer or Web. The form expression for the Customer Last Name attribute form is CUST_LAST_NAME. This is a single-value function. If information about a. A user with a security filter on Call Center would not be able to use this table because the security filter cannot be written against it. Create a new attribute form without the undesired source table. MicroStrategy requires compound ID form attributes to have all source tables for all of the ID forms in the ID form group. This calculation can be aggregated from the Employee level to the Region level. To add a filter: Open the dossier with the heat map visualization you created in How to Create Your Heat Map Visualization. And leverage the Page-By function to focus your analysis on one element. Update:Multi-Metric KPI is best when you have several important indicators that you want to display in one, responsive visualization together. Types of filters in Microstrategy Below are the types of filters: 1. Prompt-in-prompt is a feature in which the answer to one prompt is used to define another prompt. Using the description tables and Ids, the attribute information is stored. Select the data set and click Prepare Data. The ApplyOLAP function is used to define compound metrics. If you make both of the above physical implementations, the SQL Engine uses the related table when no metric is included on the report. Steps to Reproduce on a Compound Grid. This happens with compound attributes. 12 String Functions are supported by the MicroStrategy Analytical Engine; however, the following functions can push down: Char. Click User Manager . To do this: a. There's a reason we're at the top of the list. 1. Now Edit the "Revenue for Books metric and Replace Category@ID with this new Books metric formula would looks like this Case ( (Books = 1), Revenue, 0. The user also requires that when drilling down from Region to lower-level attributes, the rank values for those attributes should be calculated on a company-wide basis rather than constrained by the Region from which. Plus, it connects business apps while integrating data. 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. Arithmetic operators are +, -, *, and /. UnderstandingFunctionsinMicroStrategy 5 TheBasicsofMicroStrategyObjects,ObjectDefinitions,andFunctions 6 FunctionSyntaxandFormulaComponents 9Consider the following scenerio: A user wants to create a metric which ranks the Regions according to Revenue at a company-wide level. To create a compound key (composite key), users must create multiple attribute forms, group them together, and set the form group as the key for the attribute. Formula: Is a mathematical expression using one or more functions, applied to the data to be used in the calculation (facts, attributes, constants, or metrics). Click All Objects View. Attribute description forms can be rendered into SQL in two ways. To display a title bar, do the following: Set Show title bar to True. ESRI attributes such as latitude and longitude, zip code, state, city,. You can also access the Attribute Creation Wizard at any time in the development of a project from the Schema menu in MicroStrategy Developer. 4. I'm working on a dossier and I have a dataset that includes customer types. These attributes require a compound primary key in the data warehouse to uniquely identify their elements. DaysBetween(DIM_RELEASE_DATE. A report is a MicroStrategy object that represents a request for a specific set of formatted data from your data source. xattributes (list or None, optional): ID numbers of attributes to be included in the filter. Each attribute form must have at least one expression. All placeholders must begin with #0 and increase in increments of 1. For example, consider the relationship between three attributes: Promotion, Item, and Quarter. Select a Form category, Display type and Default sort from the lists. This online help builds on a basic understanding of information provided in the Basic Reporting Help. Note that for rule 2, there are three levels in which an attribute names can be defined in the product: at the individual attribute object level (applicable to project schema attributes), at the report or cube level, and at the level of the dossier (via the Datasets panel). Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. 2, the selector will not work if using the Include option for the selector. Total (profits/unit sold) Smart Metrics: Total (profit)/ Total (sold) 8) Mention what types of testing can be carried out over the Microstrategy reports? Microstrategy can carry out test like • Naming convention tests • Total calculations test • SQL query validations • Attribute and metric. To ensure consistency between the metadata and the object cache, remember to update the schema after schema object modifications (i. This information can help define primary keys in the physical warehouse schema (see Uniquely identifying data in tables. This guide assumes and continues to build on a basic understanding of information provided in the Basic Reporting Guide. Relate tables are often used to create relationships between. x and 10. Compound Attribute Date ID forms do not format correctly when ran correctly in Flash in MicroStrategy Web. To create a last year transformation based on an expression. Multiple elements are highlighted when using an attribute with compound key as a selector in Visual Insight and MicroStrategy Web 9. Now to fix this create a new Derived metric on Category attribute first with formula as Max (Category) {~ } and calling Books. Select Add an Advanced Qualification and click OK. A compound key attribute is an attribute whose primary key is made up by the combination of two or more columns. A compound attribute is an attribute with multiple columns specified as the ID column. The smart metric property of a compound metric allows the user to change the default evaluation order of the metric. In the MicroStrategy Tutorial project, Distribution Center is an example of a compound attribute. Sometimes you don’t have all the columns that are necessary for creating your visualizations. Click the visualization to add the group to. Metadata could be hosted on most databases. Users might observe that when an attribute with a compound form is added to a report in MicroStrategy Developer 9. In the pane, begin typing the metric formula. Result for new metric is blank. . The Attribute Creation Wizard opens,. Attribute_ID1 = “,A1,” AND a11. All placeholders must begin with #0 and increase in increments of 1. To enable totals or subtotals for a metric. The targeted grid will show no value no matter the attribute and the metric in the grid is related to the group by attribute or not. Users can also create compound attributes, define attribute relationships in the system hierarchy and modify display and sort forms. This is a filter which contains a prompt on an attribute element list. This article describes the purpose of the Sub Query Type VLDB property in MicroStrategy. You can create them in a report,. 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. To create a derived metric. Candidate Key. Creating a grid report. In MicroStrategy Web 2020, create a dossier with a Compound Grid visualization. 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: . In the report, the attribute with the compound key is Distribution Center. The Compound Grid is a new visualization introduced in the MicroStrategy 2020 release. In the list of categories on the left, click Subtotals. 4. This join type lets you display only those attribute elements that are common to the lookup tables and the fact tables in your data warehouse. For example, if sales data is stored in the data warehouse at the day level, a month attribute allows users to. On the template, the month attribute, A - NORMAL SUM, C - DATA PREVIOUS ROW (B - A) and D - % CHANGE ((A-C)/C) are. MicroStrategy interfaces include desktop (for developers), web, Microsoft Office integration as well as Mobile Applications. 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. Compound Metric; Steps to Reproduce. 3. Whenever the attributes in Report Objects are not the same as the attributes on the grid, dynamic aggregation has occurred. Type the number of elements to display at one time and click OK. SYMPTOM:The attributes Customer City and Call Center are enclosed in brackets. By default, the Partition Attribute pull-down menu is set to Automatic, which allows MicroStrategy Web to set the number of partitions. Separate attribute forms should be created for latitude and longitude, and should also support the numeric data of these values. The prompt displays the related attribute elements for users to select their filter criteria from. The attribute editor allows users to create attribute forms, connect attributes to logical tables in the schema, and edit form expressions. To view the various properties of an attribute in Architect, from the Attributes tab of the Properties pane, select the attribute from the drop-down list. PepsiCo. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. a) Attribute form qualification Filters data related to a business attribute’s form(s), such as ID or. In the Actions column, select the Edit icon for the user to modify. In MicroStrategy Web 2020, create a dossier with a Compound Grid visualization. This condition may be implemented through an ApplySimple statement such as the following: The user will find that the CASE statement. When evaluating compound metric expressions in SQL, a null value from one of the component metrics may cause the entire expression to evaluate as null -- NULL. Ans: Statistics tables contain data on the MicroStrategy system’s usage and performance and are populated by all projects that are configured to log statistics. For example, in a schema where Store is a compound attribute with Region-Market-Store, and the. April 28, 2009 Architect, MicroStrategy Compound Attribute Sorin Suciu. Open MicroStrategy Web. It causes the SQL Engine to calculate for only the attribute elements that exist in both the lookup and fact tables. In the MicroStrategy Tutorial project, for instance, if a report includes only the Category attribute, report level metrics could use the YR_CATEGORY_SLS table. 09%) is another ROIC powerhouse with rock-solid demand stability and a balance sheet that supports continued dividend growth. MicroStrategy recommends to have only one child at the lowest level. This article notes a limitation of mapping MDX attributes to schema mapped attributes For example: Simple or Compound Metrics . ; Dossier authoring enhancements, including: New context menu options to move, copy, or duplicate images, text boxes, and HTML. Currently the DIM_DATE. (The use of brackets around compound object names is standard for many objects in MicroStrategy and is not restricted to custom expressions and Apply. The time required for dependency checking varies based on a customer's metadata size and schema complexity. attr_elementsApplySimple. This implies, of course, that more than one ID column is needed to. You can use derived metrics to. 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. Problem. 4. If a message is displayed asking if you want to use read only mode or edit mode, select Edit and click OK to open the Attribute Editor in edit mode so that you can make changes to the attribute. Attribute_ID2= “,B1,”)”). Generally, you create a compound attribute when your logical data model reflects that a compound key relationship is present. April 28, 2009 Architect, MicroStrategy Compound Attribute Sorin Suciu. Visit the data visualization and data dashboard galleries for inspiration. A compound attribute is one that uses two or more columns as its ID. Here the many-to-many relationship is converted into a compound attribute relationship. Attribute forms contain additional descriptive information about a given attribute. Built by MicroStrategy, a worldwide leader in enterprise analytics and mobility, the. Knowledge Base: Working with Compound Grids in MicroStrategy 2020;. This article describes why an attribute with a compound ID may fail the execution of a dossier if the compound ID has locale sorting that is inconsistent with the order by the. For example, consider the relationship between three attributes: Promotion, Item, and Quarter. The graph legend or axes can be formatted as well. Therefore, it is possible to have the attribute specified at the metric dimensionality level and only have Category in the report template. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. For instance, the attribute City may be defined in the data model as a combination of COUNTRY_ID and. Arithmetic operators are +, -, *, and /; non-group functions are OLAP and scalar functions such as running sum or rank. A compound attribute is an attribute that consists of more than one atomic attribute through an object join or member terminals that use dot notation. To uniquely identify a distribution center, one must know two details about the. A compound attribute is an attribute with multiple columns specified as the ID column. By design, Joint Element Lists will only qualify on attribute ID's. On the Attribute Forms editor, click the Current Attribute drop-down and select an attribute. MicroStrategy AI is here. This function is an OLAP function. You can use derived metrics to. This article notes a limitation of MDX data sources for filters on different levelsStarting in MicroStrategy 10. tailing_objectleading_object{. Each custom format can have up to four. Modify the Address form so that it has a descending report sort order. 1 and 10. Incident update and uptime reporting. In MicroStrategy Web 2020, create a dossier with a Compound Grid visualization. In the Datasets panel, double-click attributes and metrics to add them to the visualization. STEPS TO REPRODUCE: 1. You. 0 and 2019, users will notice objects referred to as "Super Cubes". Drag an attribute or metric from the Datasets panel to the Columns Set area in the Editor Panel. x: Create a metric called A with expression "Min(1){~}" as shown below. Count of Parents in Platform Analytics: There is an OOTB metric called Objects, which calculates the parents of a component object. This is a compound metric that calculates the percentage change between the previous row and the current row. MicroStrategy ONE introduces new features that provide better performance and scalability to enhance the overall user experience. 176. 1 and 10. An attribute form is a descriptive aspect of an attribute. In the Query Detail, the Engine is guided by the metric guide and pick the correct table. 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. tailing_objectleading_object{. Only two leading objects are defined in the query language. Example: Creating compound attributes. A compound key attribute is an attribute that has two or more IDs. We're sorry. Syntax . It is. Let’s get started. For the Time hierarchy, the offset can. The formula of a compound metric is based on arithmetic operators and non-group functions. KB6669: How to create dynamic date filters on time attributes other than Date using custom SQL. On the Security Filter tab, select a project under which you want to assign a security filter to the user or group. If the Object Browser is not displayed, from the View menu select Object Browser. While knowing your company’s total sales is useful, knowing when and where the sales took place provides the kind of analytical depth that users require on a daily basis. You cannot change the join types of. Generally, you create a compound attribute when your logical data model reflects that a compound key relationship is present. Consider the sales figures of your company. Form groups in Microstrategy - Form groups in Microstrategy courses with reference manuals and examples pdf. e. The Year - Define a new member attribute. A sample report is: Attributes: Metadata, Project, Object, Object Type, Component Object Type. Ensure that the project schema for your new attribute is available for editing. For Compound Profit to be dynamically aggregated correctly, you change the dynamic aggregation function to Sum. MicroStrategy download site to. On each column set, add at least one attribute. What are compound metrics? Metrics made up of metrics: Compound metrics. The ApplyAgg function itself is a group-value function and accepts facts, attributes, and metrics as input. I have a metric A = Avg(0. Following examples uses MicroStrategy Tutorial project to demonstrate the problem and solution. x and 10. 3. The MicroStrategy 8 - Advanced Reporting Guide provides comprehensive information on advanced topics in the MicroStrategy query and reporting products. Configuration Objects:. Attributes provide a. Mapping geo attributes. Like other visualizations, a Compound Grid can be used as the target of a selector. Attribute ID form expressions will always appear in the group by clause, because this is necessary to define the aggregation level for the query. This visualization allows you to create a grid that analyzes different aspects of data across a common dimensions or attributes in rows. By choosing Automatic, if the largest table is >= 1M rows, MicroStrategy will choose the attribute. Intersection behaves as the term AND does in grammar. Click the Add icon to the right of the Element list. 11. 4. There are no restrictions on the names for the columns used in the expressions of a given attribute. There's a reason we're at the top of the list. Once you have the group made, then just drag in the original attribute under it. The attribute level follows a consecutive order from. The compound join saves memory space and processing time on the Intelligence Server executing the document. The Metric Options dialog opens. Open a dossier. DATE@ID) My. 176. When there are multiple datasets in a document, the grouping and sorting dataset is the one that is bolded in the Dataset. Drag an attribute from the Datasets panel to the Rows area of the Editor panel. In this article, we clarify your questions regarding Pattern Matching and how it is different from the standard Keyword Matching. KB4641: How to set up a Compound Key for an attribute in MicroStrategy Developer 9. The use of compound attributes in a non-aggregatable metric is not supported in MicroStrategy Developer 9. This has been identified as a defect in MicroStrategy Web 10. (Optional) Use the Up and Down. Create an Attribute Open the Workstation window with the Navigation pane in smart mode. Even though all the ID forms of a compound key attribute do not exist on the fact table, that attribute is seen in the fact entry level of that fact table. This implies, of course, that more than one ID column is needed to uniquelyidentify the elements of that attribute. Several non-group functions that are. The attribute editor allows users to create attribute forms, connect attributes to logical tables in the schema, and edit form expressions. Currently, all connectors in MicroStrategy Web 10 except "OLAP" and "Search Engine Indices" support Multi-Table Data Import. For example, the attribute name (original object name) is called, Category. In MicroStrategy Web, click the metric for which you want to enable a grand total or subtotals. To enable totals or subtotals for a metric. In MicroStrategy, users can create compound metrics belonging to MDX Cubes imported from multidimensional data sources such as SAP BW, Microsoft Analysis Services, or Hyperion Essbase. a compound key is a primary key consisting of more than one=. One advantage of compound metrics compared to simple metrics is that compound metrics can use smart totals. 4. You can connect MicroStrategy reporting tool with any data, including big data, flat files, social media data, and. To configure:-. The ApplyOLAP function is used to define compound metrics. If list is empty, no attributes will be selected and metric data will be aggregated. Attribute name:XXXX" is thrown after attempting to map a compound key attribute to SAP properties in MicroStrategy Analytics Enterprise. An implicit expression is required for creating such an attribute. Choose Grid > Compound Grid . A metric is a compound metric if it uses a non-group function, which includes OLAP functions and scalar functions. Unique identifiers denote the key that maps an attribute to its source data in the source system, when applicable. This implies that more than one ID column is needed to uniquely identify the elements of that attribute. DATE and DIM_DATE. You treat one attribute as a child of the other and have a compound key for the lower level attribute. Join Specifications. 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. MicroStrategy is an enterprise BI application software. A compound key attribute is an attribute whose primary key is made up by the combination of two or. 4. When trying to use a selector based in a compound attribute, in MicroStrategy Mobile 10. In MicroStrategy Workstation, architects can create and edit attribute objects. A compound attribute is a Microstrategy thing, enabling the MSI=. A hierarchical attribute represents an entire hierarchy and its levels (for example, Time includes levels of Year, Quarter, Month, and Day). WORKAROUND: There are a couple of options to workaround this limitation. Click the check mark symbol on the right of the drop-down. The operators and functions can be applied to facts, attributes, or metrics. Users can also create compound attributes, define attribute relationships in the system hierarchy and modify display and sort forms. Click the Add icon to the right of the Element list. It's. (The use of brackets around compound object names is standard for many objects in MicroStrategy and is not restricted to custom expressions and Apply. 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. In MicroStrategy Web, click the metric for which you want to enable a grand total or subtotals. Update:Unique identifiers. A compound attribute is an attribute with multiple columns specified as the ID column. This calculation can be aggregated from the Employee level to the Region level. To uniquely identify a distribution center, one must know two details about the distribution center: the ID. e. However, on editing the attribute, this form appears only once as. This case is also explained with an example based on the MicroStrategy Tutorial project. There's a reason we're at the top of the list. x. Compound metric C is made up of two metrics A and B with expression (A+B). The attribute editor allows users to create attribute forms, connect attributes to logical tables in the schema, and edit form expressions. 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. CONTENTS 1. 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. In this case, Promotion has a many-to-many relationship to both Item and Quarter. 11 hours ago · 2. leading_object{. Open a report in MicroStrategy Developer. For Compound Profit to be dynamically aggregated correctly, you change the dynamic aggregation function to Sum. Right-click a derived metric and choose Edit. Like other visualizations, a Compound Grid can be used as the target of a selector. Users can also create compound attributes, define attribute relationships in the system hierarchy and modify display and sort. This implies. Click Use Formula Editor. HistogramMedian. Set qualifications. The operators and functions of a compound metric can be applied to facts, attributes, or metrics within the compound metric. 4. For example, the form expression for the Customer First Name attribute form is CUST_FIRST_NAME. Relate tables contain the ID columns of two or more attributes, which will define associations between them. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Drag attributes or metrics from the Datasets panel to the Filter panel. This tutorial shows how to create derived attributes and metrics in a dossier. An attribute-to-attribute qualification can compare the City form of both attributes to display only the Call Centers and Customer Cities that are in the same city. In the Gallery, click Compound Grid . When they do appear, report designers have some degree of control over the subquery syntax using the Very Large Data Base (VLDB. You can also apply a set of color and shading schemes to all the objects on a graph report. 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. Right-click the table, point to Recognize, and then select Attributes. Surrogate Key.