Create a Report Services Document 2. MicroStrategy AI is here. For example, a transformation metric can help a user compare last month's revenue to this month's revenue. Featured on Meta Update: New Colors Launched. Right-click the table, point to Recognize, and then select Attributes. Open attribute editor (right-click on attribute and. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. April 28, 2009 Architect, MicroStrategy Compound Attribute Sorin Suciu. Count of Parents in Platform Analytics: There is an OOTB metric called Objects, which calculates the parents of a component object. Press and hold the Ctrl key to select multiple attributes or metrics. The attribute editor allows users to create attribute forms, connect attributes to logical tables in the schema, and edit form expressions. 4. 4. To pass the prompt answer for an unanswered optional element prompt in the URL, you simply specify the AttributeID for the unanswered prompt, followed by a semi-colon, but do not include the AttributeElementID. (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. 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. For examples of joining datasets, see Defining a dataset as primary or secondary and Joining multiple datasets: Examples. It supports interactive dashboard, highly detailed reports, ad-hoc query, automated report dispute, and Microsoft Office integration. This technote describes a current defect in MicroStrategy Distribution Services 9. In the list of categories on the left, click Subtotals. In MicroStrategy Developer, open the folder that contains the attribute to modify. Attribute forms are defined by at least one expression, and these expressions act on column data and can contain functions. A compound attribute is an attribute with multiple columns specified as the ID column. The implicit attribute has its own expression. 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. For the Time hierarchy, the offset can. Compound Key. x, the Report Objects window shows the same attribute form multiple times, as shown: In the above example, the 'Store ID' form shows up twice. 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. 13. These functions can be used in a MicroStrategy expression as follows, take ApplySimple function for example, create a metric using expression below (Average and Avg are existing. Micro Strategy also supports mobile BI. metrics (list or None, optional): ID numbers of metrics to be included in the filter. Also, you add both attribute IDs, in this case Item_ID and Color_ID, to the fact table as shown in the following diagram. The purpose of filtering these tables is to obtain datasets that have a common attribute, but different values for it to ensure no overlap. Create Dossier and Chapter Filters. The resulting SQL will contain just the Metric Alias. Select the Repeat attribute column checkbox to display the attribute. x . Quite often these attributes have automatic mapping for one ID and manual mapping for the other one. Metric A has corresponding value for element t1 while B does not. MicroStrategy Object Manager makes a list of all object dependencies before copying an object to prevent metadata inconsistency. 4. Therefore, more than one column is needed to identify that compound attribute distinctively. 2, the selector will not work if using the Include option for the selector. Click the check mark symbol on the right of the drop-down. A compound key attribute is an attribute that has two or more IDs. Solution. In MicroStrategy Analytics Enterprise Web 10, users can now simultaneously import two or more tables from one or more supported data sources, this feature is called Multi-Table Data Import (MTDI). The first value in each attribute is added to the list. x and 10. Split Hierarchy with M-M relationships: Explanation. 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. Create compound attributes. Prompt-in-prompt is a feature in which the answer to one prompt is used to define another prompt. This URL executes a report with one prompt. Create the following objects: a. 175. Attribute ID form expressions will always appear in the group by clause, because this is necessary to define the aggregation level for the query. A derived metric is a calculation based on metric data included in the report definition. 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. Compound Attribute: A compound attribute is an attribute whose primary key is made up of the combination of two or more columns. This allows developers to model attributes and facts whose. In Visual Insight in MicroStrategy Web 9. These privileges are part of OLAP Services. This is the essence of a joint child relationship. 4 Basic Functions are supported by the MicroStrategy Analytical Engine: First. You can quickly create multiple element groups at the same time. Each attribute form must have at least one expression. Create a. What is compound and smart metrics?. 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. Use the Object Browser on the left to locate the prompt to add to the metric's definition. Define the statistics and enterprise warehouse database. Using a combination of filters and metric dimensionality, the same results can be achieved. The intersection of two sets yields a TRUE value only when both sets of filtering. Metrics: Component Objects. All the forms for the selected attribute will be displayed. VLDB properties allow you to customize the SQL that MicroStrategy generates. Candidate Key. 2. Important: Parts of a compound attribute cannot be omitted. The attribute editor allows users to create attribute forms, connect attributes to logical tables in the schema, and edit form expressions. Compound Grid visualizations. compound attributes. This is a known issue with MicroStrategy 10. . For example, consider the relationship between three attributes: Promotion, Item, and Quarter. The MicroStrategy Advanced Reporting Help provides comprehensive information on advanced topics for using the MicroStrategy query and reporting products. KB6669: How to create dynamic date filters on time attributes other than Date using custom SQL. Enable smart metric for the metric. )Create a new compound metric in Tutorial in MicroStrategy 10. The database repository where definitions of all MicroStrategy objects are stored. For Compound Profit to be dynamically aggregated correctly, you change the dynamic aggregation function to Sum. Compound Keys - Advanced Architect Part 2 - MicroStrategy - YouTube Part 2 of the MicroStrategy Advanced Architect series where I demonstrate how to create compound attribute. These attributes require a compound primary key in the data warehouse to uniquely identify their elements. Create or edit reports with authoring functionality. MicroStrategy provides ETL, data warehousing and data mining for data analysis. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. It is used with database-specific OLAP functions such as Rank(). The multiple columns are joined with other. Enable the Source Visualization to Update the Target Visualization. a) Attribute form qualification Filters data related to a business attribute’s form(s), such as ID or description. 78K. MicroStrategy Command Manager automates maintenance and other administrative operations using simple text-based commands. 8K views 4 years ago n this brief video tutorial, Stephen Goodson, a senior instructor. If the attriubte name has spaces, use the '' symbols to group the name. A report is a MicroStrategy object that represents a request for a specific set of formatted data from your data source. . Select the heat map visualization. MicroStrategy SQL generation engine uses COALESCE in two principal ways: to merge attribute ID columns in full outer joins, and (in some database platforms) for metric null checking. In MicroStrategy Desktop/Developer 9. Make B and C parents of a new compound attribute using both columns as its ID with A B and C as its parents. Users might observe that when an attribute with a compound form is added to a report in MicroStrategy Developer 9. 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. Metrics can be calculated to any attribute level in Report Objects regardless of whether that attribute is on the report template. Only two leading objects are defined in the query language. NOTE: The 'Refresh' option assists in frequent updates to the interface for end user objects such as metrics, filters, prompts, etc. Compound Metrics. Scenario: Attribute1 is a compound key attribute with a ginormous number of values. Report R contains attribute T. Attribute forms contain additional descriptive information about a given attribute. Learn how to switch to a compound grid, add column sets in this new visualization. In MicroStrategy Workstation, architects can create and edit attribute objects. MicroStrategy pushes the calculations for the following built-in basic functions down to Teradata using the associated SQL patterns. One-to-one: Each element in the parent attribute corresponds to one and only one element in the child attribute, and each child attribute. Find the attribute Ship Date in the Object Browser (in the Customer hierarchy) and drag it to the Attribute field. In the pane, begin typing the metric formula. A derived metric is a calculation based on metric data included in the report definition. 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. Drag an attribute from the Datasets panel to the Rows area of the Editor panel. If the Region attribute is removed from the grid, the metric value is dynamically aggregated to the Day level. Natural Language Query (NLQ) allows end users to build dossiers and get insights just by typing questions. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. In MicroStrategy Workstation, architects can create and edit attribute objects. This condition may be implemented through an ApplySimple statement such as the following: The user will find that the CASE statement. For examples of joining datasets, see Defining a dataset as primary or secondary and Joining multiple datasets: Examples. Some formulas expect related attributes to exist on the template, and they will return incorrect results (or an error) if the attributes are omitted; other. 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. When the attribute used as a selector has a compound key, i. Attributes give users context for reporting on and analyzing data. Go to Data > VLDB Properties > Joins > "Preserve all final pass result elements. The boolean datatype should be seen as "Unknown"; it is not natively supported by MicroStrategy 9. Example A compound key attribute is an attribute whose primary key is made up by the combination of two or more columns. HyperWeb surfaces cards on a web browser based on a keyword that matches the underlying criteria set by the card author. This article describes the purpose of the Sub Query Type VLDB property in MicroStrategy. 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. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. You can use derived metrics to. x and 10. The operators and functions of a compound metric can be applied to facts, attributes, or metrics within the compound metric. February 19, 2009 Architect, MicroStrategy Compound Key Attribute Sorin Suciu. 4. From within a blank report in MicroStrategy Tutorial, double-click inside the Report Filter pane. Click the Add icon to the right of the Element list. Therefore, its ID form maps to a combination of columns. There's a reason we're at the top of the list. You cannot change the join types of. The multiple columns are joined with other attributes, typically in a many-to-many relationship. Attribute name:XXXX" is thrown after attempting to map a compound key attribute to SAP properties in MicroStrategy Analytics Enterprise. It is derived based on a count against the fact_object_component table. For example, the form expression for the Customer First Name attribute form is CUST_FIRST_NAME. Open the dossier you want to modify. This guide assumes and continues to build on a basic understanding of information provided in the Basic Reporting Guide. member_terminal. 4. 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. Generally, you create a compound attribute when your logical data model reflects that a compound key relationship is present. The dynamic aggregation itself is highlighted in red. 2. Follow the steps below. To view and edit the parents and children of an attribute. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. A compound attribute is defined as an attribute with more than one column specified as the ID column. Place attributes Country and Distribution Center on report template, and the above metric either on report template, or in Report Objects window if you have an OLAP license. 1 : In the Project Creation Assistant, click Create attributes. For each form listed, select or clear the corresponding checkbox in the Show on Grid column. 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. One advantage of compound metrics compared to simple metrics is that compound metrics can use smart totals. A compound key attribute is an attribute that has two or more IDs. Once these Logical views are created, they are available to. MicroStrategy requires compound ID form attributes to have all source tables for all of the ID forms in the ID form group. Note that only the naming convention has changed, as the functionality remains the same. Compound Attributes: Microstrategy Related Tutorials; Informatica Tutorial: IBM Cognos Tutorial: Teradata Tutorial: Adv Java Tutorial: Cloud Computing Tutorial: SQL Database Tutorial:How to include an attribute form in a compound or derived metric in MicroStrategy Developer 9. In the report, the attribute with the compound key is Distribution Center. : 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. Attribute qualification filter These types of qualifications restrict data related to attributes on the report. 4. In Data Preview page, use ctrl or shift key to select multiple columns, and right mouse click, choose "Create Multiform Attribute" function, as shown below: In the Create Multi-form Attribute window, assign Form. Set the qualification type to 'Custom'. You need the Create Derived Metrics (MicroStrategy Developer) and/or the Web Create Derived Metrics and Derived Attributes (MicroStrategy Web) privileges to create derived metrics. The ApplyOLAP function is used to define compound metrics. Transformations allow you to apply an attribute-element based offset to compare metric data. For instance, the attribute City may be defined in the data model as a combination of COUNTRY_ID and CITY_ID. x where all hyperlinks based on Applysimple no longer work when exporting to Flash, generating a MHT file. Each attribute form must have at least one expression. 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. The Compound Grid is a new visualization introduced in the MicroStrategy 2020 release. Create a new dataset DS1:In MicroStrategy Web 9. MicroStrategy Internal Reference number for this technical note is KB483638 and US144497. This feature is only implemented for element list prompts. Here the many-to-many relationship is converted into a compound attribute relationship. The operators and functions can be applied to facts, attributes, or metrics. Attribute forms are displayed incorrectly in the view filter element browser when the attribute has compound ID in MicroStrategy Developer 9. Select Custom as the Category and create the format using the number format symbols listed in the table below. This has been identified as a defect in MicroStrategy Web 10. The Create New Attribute Form dialog box now appears. 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. Click Use Formula Editor. Set Data Engine Version setting to 11 or above. Click the Metric Options. Quite often these attributes have automatic mapping for one ID and manual. Any of the lookup table columns can be set as the attribute key by using 'Set as key' feature, but only the forms that are actual primary keys in the lookup tables should be used. PepsiCo. 1, an attribute in a grid can be used as selector to target other grids in the same dashboard. it seems like a small gap to breach to finalize this API endpoint. MicroStrategy is an enterprise BI application software. An additional modeling convention is to add unique identifiers for each attribute and fact. The Transformation Editor opens with the Select a Member Attribute dialog box displayed. This article notes a limitation of mapping MDX attributes to schema mapped attributesFor example: Simple or Compound Metrics . Each type is described below: . The Promotion attribute is related to a particular Item-Quarter pair, as opposed to it being related to Item and Quarter separately. Steps to Reproduce on a Compound Grid. Foreign Key. Select the check box for any smart attribute that needs to be created. A compound attribute is defined as an attribute with more than one column specified as the ID column. You. Following examples uses MicroStrategy Tutorial project to demonstrate the problem and solution. Although transformations can be applied to any attribute hierarchy, the Time hierarchy is used most often. An attribute form on the parent attribute also appears on the child attribute. The Compound Grid is a new visualization introduced in the MicroStrategy 2020 release. Count of Parents in Platform Analytics: There is an OOTB metric called Objects, which calculates the parents of a component object. Enter a Form name and Description. You can connect MicroStrategy reporting tool with any data, including big data, flat files, social media data, and. Result for new metric is blank. These attributes require a compound primary key in the data warehouse to uniquely identify their elements. The Results Preview dialog box opens. This is a known issue in MicroStrategy 10. There's a reason we're at the top of the list. Click the Options icon . VLDB Properties. 2. ExampleA compound attribute has its value determined by an expression which combines two or more columns in a database to create a new column. This article does contain a solution. 12 String Functions are supported by the MicroStrategy Analytical Engine; however, the following functions can push down: Char. This knowledge base article documents the process of creating compound keys for attributes in MicroStrategy Developer 9. Create a report containing the new metric. Ensure that the project schema for your new attribute is available for editing. This change applies to metric creation in either Developer or Web. Arithmetic operators are +, -, *, and /; non-group functions are OLAP and scalar functions such as running sum or rank. Only two leading objects are defined in the query language. Datasets define which information the Intelligence Server should retrieve from the data warehouse or cache. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. 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. Using this grid, you can have multiple unrelated attributes and metrics in different sets of columns that are stitched together. 4. Go to Smart Attribute blade on the Attributes Editor. Click Use Formula Editor. To enable totals or subtotals for a metric. Open the dossier you want to modify. Slice your data into columns of graphs. What are Configuration Objects? Configuration objects are MicroStrategy objects which can be re used in multiple projects and they appear in the. This technote describes a current defect in MicroStrategy Distribution Services 9. Use "Access External Data" feature in MicroStrategy Web 10 to import data. I have a metric A = Avg(0. Under 'Source tables', select a table and click 'Set as Lookup'. The compound join saves memory space and processing time on the Intelligence Server executing the document. KB4641: How to set up a Compound Key for an attribute in MicroStrategy Developer 9. 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. A compound key attribute is an attribute whose primary key is made up by the combination of two or more columns. 4. more columns. In MicroStrategy Web 2020, create a dossier with a Compound Grid visualization. The multiple columns are joined with other attributes, typically in a many-to-many relationship. Drag an attribute or metric from the Datasets panel to the Columns Set area in the Editor Panel. leading_object{. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched. e. Turning on totals returns a row for the total, even though there are not rows of data to show. 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. A compound attribute is defined as an attribute with more than one column specified as the ID column. Attributes are MicroStrategy objects that represent the business concepts reflected in your stored business data in your data source. April 28, 2009 Architect, MicroStrategy Compound Attribute Sorin Suciu. Might need to play with formatting to make sure. We're sorry. These privileges are part of OLAP Services. Primary Key – is a column or group of columns in a table that uniquely identify every row in that table. e. DaysBetween(DIM_RELEASE_DATE. The ApplyOLAP function is used to define compound metrics. How to Create a Derived Attribute or Metric. A metric is a compound metric if it consists of two or more existing metrics joined by an arithmetic operator (+, -, *, and /). To create a compound key (composite key), users. An in-line many-to-many relationship involves an attribute with at least one parent and one child. On each column set, add at least one attribute. 0 or above. The presence of a compound key relationship is. x-10. Compound Metric; Steps to Reproduce. There are no restrictions on the names for the columns used in the expressions of a given attribute. Last. Use a Comparison KPI to indicate the progress towards an objective, like sales and goal. This section focuses on the VLDB properties that are set at the metric and report level. You must create a compound attributes when an attribute requires two or more columns to uniquely identify its elements. The Metric Editor opens in either Function Editor mode or Formula Editor mode, depending on the type of metric you chose to edit. The Metric Editor opens in either Function Editor mode or Formula Editor mode, depending on the type of metric you chose to edit. These types of qualifications restrict data based on the value, rank, or percentage of a metric, or based on the relationships between the attributes on the report. Compound Key Attribute. You are returned to MicroStrategy Developer. Click here to view help for the latest version of this product or search MicroStrategy Community. x?; Knowledge Base: How to concatenate two. The attribute editor allows users to create attribute forms, connect attributes to logical tables in the schema, and edit form expressions. 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. 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. x. STEPS TO REPRODUCE: 1. The attribute editor allows users to create attribute forms, connect attributes to logical tables in the schema, and edit form expressions. Attributes can have multiple attribute forms. (Optional) Use the Up and Down. Double-click the attribute to edit. Defining the partition for Super Cubes. Users can also create compound attributes, define attribute relationships in the system hierarchy and modify display and sort. 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. The Compound Grid is a new visualization introduced in the MicroStrategy 2020 release. Although transformations can be applied to any attribute hierarchy, the Time hierarchy is used most often. MicroStrategy builds the rules that MicroStrategy SQL Engine uses to generate SQL when a report request is made. When the 'Customer' attribute is removed from the grid, the newly created metric dynamically shows the distinct count of customers at the Day, Region level as s hown below. Double-click Time to open the folder, then double-click Year. x. Mapping geo attributes. x. Attribute qualification filter These types of qualifications restrict data related to attributes on the report. And leverage the Page-By function to focus your analysis on one element. Change Qualify on to ID. If you are leveraging Web ASP, see KB484127 to use this feature. MicroStrategy 9. Create an Attribute Open the Workstation. In the visualization's Editor panel, right-click the attribute to group and choose Create Groups. You cannot change the join types of. There's a reason we're at the top of the list. 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. The ApplyAgg function itself is a group-value function and accepts facts, attributes, and metrics as input. The attributes that are single in definition but the instances of the attribute can behave differently according to the role they take. It uses Business Scenarios to provide examples of each concept. Calculated expressions are created directly in text fields on the document, which makes them. 3. Each graph appears in a separate row, one for each element in the attribute. Like other visualizations, a Compound Grid can be used as the target of a selector. The operators and functions of a compound metric can be applied to facts, attributes, or metrics within the compound metric. 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. Therefore, it is possible to have the attribute specified at the metric dimensionality level and only have Category in the report template. 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. Composite Key. To Create a Metric Using the Formula Editor. 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. How to create a conditional attribute in MicroStrategy Desktop. The smart metric property of a compound metric allows the user to change the default evaluation order of the metric. database column=2E Its a relational database thing, enabling high=. To Create a Metric Using the Formula Editor. Click OK. Dataset DS1 with attribute 'Year' and metric 'Profit'. There's a reason we're at the top of the list. Mode. You can type arithmetic operators (such as + and -) and comparison operators (such as < and >) directly in the metric expression. 10869 views | September 04, 2020 01:10. Each type is described below: . The 'Set as key' option is used for defining the lookup table primary key for the attributes when generating SQL with MicroStrategy Engine. 175. Create and Edit a Visualization-Based Filter. MicroStrategy ONE introduces new features that provide better performance and scalability to enhance the overall user experience. The Create New Attribute Form dialog box now appears. Modify the Address form so that it has a descending report sort order. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. 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. These commands can be compiled into script files and run from a graphical interface or from the command line. Attributes are defined by these properties: •. Select Manual from the Aggregation and Subtotal Behavior drop-down. Click Create on any page, and select New Metric. 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. Count Compound Attribute is an advanced property that is hidden by default. You can also access the Attribute Creation Wizard at any time in the development of a project from the Schema menu in MicroStrategy Developer. 2. a compound key is a primary key consisting of more than one=. Create compound attributes. Compound attributes. Study with Quizlet and memorize flashcards containing terms like Metadata, Metadata Components, heterogeneous mapping and more. The first value in each attribute is added to the list. x-10. Relate tables store information about the relationship between two attributes when one a parent of the other or vice-versa. In the Editor Panel, right-click the attribute in Column Set 1 and select Display Attribute Forms. The ApplyAgg function itself is a group-value function and accepts facts, attributes, and metrics as input. The Metric Options dialog opens. 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). Subqueries (or correlated subqueries) are used infrequently but significantly in the MicroStrategy SQL Generation Engine. 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: .