Check the checkbox 'Apply background color as a graph threshold,' as seen below: Click OK. For information on how to display this property, see Viewing and Changing Advanced VLDB Properties. To Create a Query Builder Report from an Excel File. Create an attribute with a compound ID. Here the many-to-many relationship is converted into a compound attribute relationship. 1 Answer. Create a report that makes use of the metric. STEPS TO REPRODUCE: Create a document in MicroStrategy Developer or Web 10. Attribute_ID2= “,B1,”)”). By default, the metrics Compound Profit and Profit Margin do not use a dynamic aggregation function. In short, an inner join includes only the data common to all the elements in the join, whether that data is tables or metrics. You can quickly create multiple element groups at the same time. Therefore, if a metric is specified to calculate to an explicit attribute level and the attribute is not on the report template or in the Report Objects window, it will not calculate to that level, but. Can you apply themes to MicroStrategy Web? How to create a one? After a bulk. To create a derived metric. For information on compound attributes, see Attributes with multiple. 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. Follow the steps below. 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: . On the Freeform Sources tab, select Create Freeform SQL report. After choosing the attribute, choose to qualify on the ID, as in shown below: The user will now be able to access the. Compound attributes are usually counted by concatenating the keys of all of the attributes that form the key. . Upgrade your Web. To do this: a. Enter a name to use for the new attribute in New Attribute Name. Select the Logical View Tab of both tables to see all the logical objects mapped to the table. MicroStrategy recommends to have only one child at the lowest level. Select the Members tab. These auto text codes are automatically replaced by information about the document. Drag an attribute from the Datasets panel to the Rows area of the Editor panel. Data displayed in MicroStrategy Viewers can be filtered by different criteria. This level of control can ensure consistent Engine behavior. To create a logical table alias, right-click the logical table name and select Create Table Alias. 8K views 4 years ago n this brief video tutorial, Stephen Goodson, a senior instructor. 1 and… Number of Views 618 KB14936: When drilling across to a hierarchy in. an integer number) for your main table and link each set of D values to the necessary record. After choosing the attribute, choose to qualify on the ID, as in shown below: The user will now be able to access the. An empty filter appears in the dossier. For any Apply function, the attribute form in the arguments should be a single form—not a form group. Click Filter . Metric Guide; Compound Metric; Steps to Reproduce. An attribute form expression defines what columns in the warehouse are used to represent the attribute form in SQL. Composite keys are constituted of two or more columns which together act as unique identifier. Drag the attributes and metrics for filtering from the Datasets panel to the empty filter. Arithmetic operators are +, -, *, and /; non-group functions are OLAP and scalar functions such as running sum or rank. In this case, enter 'Date@ID'. Click on 'OK' and save the. Create a filter on the attribute "Year. If these three columns are mapped to attributes in MicroStrategy, then the primary key is represented correctly. This implies that more than one ID column is needed to uniquely identify the elements of that attribute. Attribute_ID1 = “,A1,” AND a11. Create a Compound Attribute. Compound Key Attribute. 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. Right-click the selected columns and select Create Multi-form Attribute. x although it can be done from MicroStrategy Developer 10. Update: To add a filter: Open the dossier with the heat map visualization you created in How to Create Your Heat Map Visualization. To add an advanced filter, click More in the upper right corner of a visualization and choose. 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. SUBCAT_ID. In Fiddler, users can use the Inspectors > WebForms > params feature to view the body of the request. Upgrade your Web. It helps to merge or concat two columns in the same group. 'Create Individual Index' VLDB setting is an advanced setting that is hidden by default. To create an attribute relationship. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. Use an ApplySimple statement that masks the data contained in the columns when the data is 'not null' as shown below: Validate the expression before saving and closing. Select 'Yes or 'No' from the drop down list. For example, a transformation metric can help a user compare last month's revenue to this month's revenue. Create a metric with the formula Max(Month Duration) {~} (metric max month) called 'max month'. To create a last year transformation based on an expression. 78K. With Architect, you can create and modify multiple attributes in your project quickly from an integrated interface. Implicit attribute; Derived attribute; Compound Key attribute; How to create a derived attribute in MicroStrategy? A derived attribute in Microstrategy has a value that is decided by the combination of two or more columns. Do not set any additioUsers may have a requirement to create a metric that counts the unique combination of two different attributes. The steps to create such an attribute: The primary key is made up of the lowest level attributes. Hierarchy 2: 4. Visit the data visualization and data dashboard galleries for inspiration. This tutorial shows how to create derived attributes and metrics in a dossier. Create a report with the Region and Month attributes and the Revenue metric in the grid and filter on Month, selecting February 2003 and March 2003. " Click "prompt on attribute element list" and click "Next" through the rest of the screens to accept the default values. These attributes can be primary keys or non-primary keys. The examples below describe how to drill on these compound metrics on both grid and graph reports. Drag objects from the Datasets panel to the Editor panel to add the corresponding data to the visualization. This is a filter which contains a prompt on an attribute element list. The level of this metric should be report level. In Microstrategy Developer, create a new attribute by navigating to File > New > Attribute. Since by changing the ID form of the attribute (compound to single key), the attribute has become a new attribute, personalizations based on that attribute may no longer continue to work and should be recreated. 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. In the MicroStrategy. This is a filter which contains a prompt on an attribute element list. Do not set any additional conditions. " Click "prompt on attribute element list" and click "Next" through the rest of the screens to accept the default values. You can also create multiple attributes using Architect, which is described in Adding and modifying attributes. In Name, enter a descriptive name for the attribute. •Transformations allow you to apply an attribute-element based offset to compare metric data. In the report, the attribute with the compound key is Distribution Center. This video covers the process of requesting an ESRI License key and applying the license key to MicroStrategy Web. 1. 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. Right-click the table, point to Recognize, and then select Attributes. In addition to specifying the data type to be used for an attribute form, the column alias also lets you specify the column alias name to be used in the SQL generated by MicroStrategy. Do not set any additio In the relational database, a compound key is a primary key that consists of more than one database column. •. Use the Object Browser on the left to locate the prompt to add to the metric's definition. Using the MicroStrategy Project Tutorial, create a report with the attributes Category, Subcategory and the metric Revenue. By ManishaGupta that reached out to. insufficient. Make B and C parents of a new compound attribute using both columns as its ID with A B and C as its parents. Create a report with attribute 'Region', metric 'Revenue', 'Profit' and 'Cost'. In this case, only one form exists for each, as shown below: Natural Language Query (NLQ) allows end users to build dossiers and get insights just by typing questions. In general, ApplySimple can be used to create the following objects: •. 1; Product Documentation: How to Create a Derived Metric from an. 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: . Select 'Region' and click OK. Knowledge Base: Working with Compound Grids in MicroStrategy 2020;. In MicroStrategy Desktop/Developer 9. 4. However, before changing the way MicroStrategy products look or behave, it is helpful to understand how the application is built. To create a compound key, users must create multiple attribute forms, group them together and set the form group as the key for the attribute. Create a filter on the attribute "Year. In the pane, begin typing the metric formula. When the attribute used as a selector has a compound key, i. In MicroStrategy Developer, go to the Tools menu and select Desktop Preferences. How to start. This design may look strange, but in most cases there are sound. The following steps describes how to create such derived metric. Let's add the custom visualization to the Gallery. An empty filter appears in the dossier. In the MicroStrategy Tutorial project, Distribution Center is an example of a compound attribute. To view and edit the parents and children of an attribute. Create free Team Collectives™ on Stack Overflow. Calculate each attribute individual weight according to the level in the hierarchy (level in hierarchy/number of levels in hierarchy * 10). Create a filter on the attribute "Year. In this case, only one form exists for each, as shown below:Natural Language Query (NLQ) allows end users to build dossiers and get insights just by typing questions. Rather than creating attributes by manually creating an attribute expression, you can allow Architect to automatically create simple attributes defined on one column. The following procedure describes how to achieve this: Create the highest level filter. If you know of better/faster ways, please share. " Click "prompt on attribute element list" and click "Next" through the rest of the screens to accept the default values. The example shown in this document references the following three sample tables:In database design, a compound key is a key that consists of 2 or more attributes that uniquely identify an entity occurrence. Do not set any additioLogical size is Microstrategy way of generating the best suitable/optimized SQL to fetch the required data. Right-click in an empty area on the right side of. " Click "prompt on attribute element list" and click "Next" through the rest of the screens to accept the default values. Do not set any additioHere is the workaround to achieve the attribute left outer join on MicroStrategy Web. Choose your environment and project. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence; Multi-Cloud. The report should looks like: 2. In the Visualization Gallery, click Combo Chart to create a combination graph. Add an attribute and a metric to both Column Set 1 and Column Set 2. For example, consider the relationship between three attributes: Promotion, Item, and Quarter. Select the attribute form to filter report data from the drop-down list. Composite Key. The table now appears in bold as shown below. Double-click the security role you want to assign to the user or group. Custom number formatting symbols. Click Filter . Metrics are quantitative measures used to analyze the data in the particular context. Click Insert Visualization . Create a new derived attribute by. Remember that P displays the parent attribute and 0 (the number zero, not the letter o) displays all the forms of the parent attribute. We decided to gather them in one placing using our experience and MicroStrategy materials. Create a new metric based on the OLAP function RunningCount: 3. End_date. It helps to merge or concat two columns in the same group. Microstrategy - MSTR - Find the Lineage information from Table/Column to. How to create an attribute in MicroStrategy What are attributes? Attributes are groups of related data, such as table columns. 1) create a metric of your date value and force it to be at the=. When the attribute used as a selector has a compound key, i. Attributes are defined by these properties: •. Note that only the naming convention has changed, as the functionality remains the same. Consider the sales figures of your company. Drag an attribute or metric from the Datasets panel to the Columns Set area in the Editor Panel. Create a duplicate of the Month attribute and name it 'AliasMonth' Create a filter that will prompt users to select the Month attribute. Here the many-to-many relationship is converted into a compound attribute relationship. 1. A developer can build simple or compound metrics, apply to them many additional features like conditionality, level, transformation and also specify the formatting. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in one. You can type arithmetic operators (such as + and -) and comparison operators (such as < and >) directly in the metric expression. The multiple columns are joined with other attributes, typically in a many-to-many relationship. Open attribute editor (right-click on attribute and select ‘Edit’) Select the required forms to create the key From the ‘Edit’ menu, choose Group as shown below. 0. For detailed information on attribute roles, refer to Attributes that use the same lookup table: Attribute roles. You must determine which attribute will be displayed to the user when the user is prompted. 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. Attribute Creation. The implicit attribute has its own expression. In the Visualization Gallery, click Combo Chart to create a combination graph. Uncheck the 'Use default inherited value' box and set the option 'Create composite index for temporary table column indexing'. 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. Create a filter on the attribute "Year. In MicroStrategy Developer 9. Use the Ctrl key to select multiple attributes and metrics. Generally, you create a compound attribute when your logical data model reflects that a compound key relationship is present. Select the function to use to calculate data in the metric. Which key structure you use to identify a unique attribute in a table depends on the nature of your data and business requirements. Simultaneously creating multiple attributes. For any Apply function, the attribute form in the arguments should be a single form—not a form. A. In MicroStrategy Web create a new Visual Insight dashboard with the Year attribute, Region attribute and the Revenue metric. Surrogate Key. Do not set any additioThis article describes an issue in MicroStrategy where SQL will not be generated correctly when using an attribute with a compound ID in a metric without specifying a form. Select 'Yes or 'No' from the drop down list. 4. An attribute on a dossier serves as a label for a group of metrics. The following procedure describes how to achieve this: Create the highest level filter. Choose one of the following options: To display all of the attribute's elements to the user when they are answering the prompt, select List all elements (no restriction). A compound key attribute is an attribute that has two or more IDs. 16K KB41943: How to create a metric that calculates the distinct count of an attribute. Create a filter on the attribute "Year. In the relational database. You can create a Year derived attribute from a Date attribute in MMDDYYYY. Create a compound ID attribute based on multiple data sets. 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. To display this property, enable 'Show Advance Settings' from the Tools menu in the VLDB properties editor. Click the visualization to add the group to. Select the metric Revenue in the ValueList: 4. Create a filter on the attribute "Year. In the Project Creation Assistant, click Create attributes. Save and close the report as 'Test Nile'. The formula of a compound metric is based on arithmetic operators and non-group functions. Create a report with the attributes Region and Promotion Type as seen below: 2. Contact MicroStrategy Technical Support for assistance with the issue. x. Compound metric C is made up of two metrics A and B with expression (A+B). Uncheck the 'Use default inherited value' box and set the option 'Create composite index for temporary table column indexing'. ApplyComparison. Workaround / Solution. In the Object Browser, locate and double-click the metric Cost. Click Insert Visualization . x-10. Consider what key structures work best when creating lookup tables in the physical warehouse schema. Add the “Component Object” attribute to the filter panel and filter on the metric that is of interest. After migrating to MicroStrategy 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?. Rather than creating attributes by manually creating an attribute expression, you can allow Architect to automatically create simple attributes defined on one column. To create a compound key, users must create multiple attribute forms, group them together and set the form group as the key for the. x and 10. Update:To add a filter: Open the dossier with the heat map visualization you created in How to Create Your Heat Map Visualization. " Click. Forms other than key and relationships are removed if this setting is enabled. Adding attributes with the Attribute Editor. In general, ApplySimple can be used to create the following objects: Attribute form. primary key or a composite primary key. Create a report with Attribute "Year", custom group "Category" and Metric Revenue; Click in the Metric Revenue in Report Object and go to Insert Tab; Percent to Total; Total for each;A derived attribute has its value determined by an expression which combines two or more columns in a database to create a new column. For instance, the attribute City may be defined in the data model as a combination of COUNTRY_ID and. " Click "prompt on attribute element list" and click "Next" through the rest of the screens to accept the default values. database to create a new column. Drag an attribute from the Datasets panel to the Rows area of the Editor panel. A percent-to-total shortcut metric displays the percent in relation to a selected total of each item affected by the metric. In the Create New Form Expression window in the Attribute Editor, select the. Click "Prepare data" to enter Data Preview page. It is used to insert any single-value, database-specific functions and simple operators directly into SQL. " Click "prompt on attribute element list" and click "Next" through the rest of the screens to accept the default values. Create Custom Tooltips. II. To create a list of attribute elements from which users can choose, select Use a predefined list of elements. Create a new consolidation with three elements - Winter, Spring and Winter + Spring, as illustrated below: Create a report with the above created consolidation and three metrics - 'Revenue',. For example, if sales data is stored in the data warehouse at the day level, a month attribute allows users to. x, users can define a custom subtotal for a metric that returns a value that a compound level metric would return. From the Insert menu, select New Metric. . 3. 3. You must create a compound attributes when an attribute requires two or more columns to uniquely identify its elements. Connect to a database instance and drag tables into the canvas. Simple key requires only one column to identify a record uniquely within a table. Create a new derived attribute by. Click Use Formula Editor. Important: Most MDX Cube providers include functionality to create the analogue of MicroStrategy derived metrics, such as SAP's Calculated Key Figures or Microsoft Analysis Services' Calculated Members. The only solution that I can think of is to create a FreeForm SQL Report. x, the hyperlinks base on attribute form with Applysimple no longer work in the exported MHT file. 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. Use fictional primary key (i. To allow sorting on the attribute elements after sorting by the metric total value, users may follow the steps below: Create a level derived metric to calculate on the attribute level at which the subtotal is calculated. e. Modeling: Create Time Zone Aware Attributes and Smart Attributes Create Time Zone Aware Attributes. In the Gallery, click Compound Grid . To handle this case in. Want to learn more? Setting 'Mapping method' to 'Manual' forces users to manually select the source tables that use the expression. Drag the prompt onto the Definition pane at the bottom right, as shown in the image below:For example, the attributes Year, Quarter, Month of Year, Month, and Day in the MicroStrategy Tutorial project are gathered close together in the Hierarchy View, as shown below. 1 and 10. 4. Create a Default Dynamic Selection Filter. There are no restrictions on the names for the columns used in the expressions of a given attribute. Go to Smart Attribute blade on the Attributes Editor. This implies that more than one ID column is needed to uniquely identify the elements of that attribute. This article notes a limitation of mapping MDX attributes to schema mapped attributes Let’s say you need to create a new table that should contain the compound key attribute and a new fact. 2 From the Schema menu, select Architect. How to Create a Composite Key? Creating a composite key involves selecting the appropriate columns in a table and defining them as a unique identifier for each record. 5. The following procedure describes how to achieve this: Create the highest level filter. e. How to Create a Derived Attribute or Metric. 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. If you are on a folder page, click Create on the icon bar on the left, then select New Metric. This is a filter which contains a prompt on an attribute element list. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. Compound Metrics. location_path is the folder where the attribute is to be placed, of type string,. Do not set any additioMicrostrategy Dossiers With the release of MicroStrategy 10. To manually enter the definition of the derived attribute. xa) Attribute form qualification Filters data related to a business attribute’s form(s), such as ID or description. Ensure that the project schema for your new attribute is available for editing. Create a Default Dynamic Selection Filter. Hierarchy 2: 4. To create a visualization filter. You can also create new attributes, based on existing attributes in your dataset, while viewing a dossier. Apply Filter Changes. In the Source area, select a database instance for the database to access using Freeform SQL. After migrating to MicroStrategy 9. Schema objects: Schema objects are generally created by a project designer and include such things as facts, attributes, hierarchies, and transformations. Calculate each attribute individual weight according to the level in the hierarchy (level in hierarchy/number of levels in hierarchy * 10). From the 'Edit' menu, choose 'Group'. " Click "prompt on attribute element list" and click "Next" through the rest of the screens to accept the default values. Click 'Browsing Options' and check the 'Display hidden objects' checkbox and click OK twice. OrgChartVisPlugin. x? Number of Views 6. Consider the following scenerio: A user wants to create a metric which ranks the Regions according to Revenue at a company-wide level. To change the order of the transformations, select a transformation and use the directional arrows to re-position it. So the good idea is to create a separate table and push multivalued attribute into it. Open a report in MicroStrategy Developer. Attribute form: contains an identifier or descriptor of an attribute. e. Once an attribute has been selected, the button is replaced by the. Create a filter on the attribute "Year. You treat one attribute as a child of the other and have a compound key for the lower level attribute. This is a filter which contains a prompt on an attribute element list. Select the attributes, then click to return to the Prompt Generation Wizard. For steps to connect to and create a database instance for an Excel file, see Connect to Excel Files. This knowledge base article documents the process of creating compound keys for attributes in MicroStrategy Developer 9. This name change is visible in. Each custom format can have up to four. Right-click the group and choose Set as key. The cursor is positioned between the parentheses in the Definition pane. Create 2 datasets. Definition : Max(Day) Condition : nothing; Level : Remove report level and add Day (standard, standard) Create a. 4. Open the Workstation window with the Navigation pane in smart mode. 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. This article notes a limitation of mapping MDX attributes to schema mapped attributesLet’s say you need to create a new table that should contain the compound key attribute and a new fact. Launch the Prompt Generation Wizard in MicroStrategy Developer by going to File menu > New and choosing 'Prompt'. The operators and functions can be applied to facts, attributes, or metrics. Choose one of the following options: To display all of the attribute's elements to the user when they are answering the prompt, select List all elements (no restriction). A joint child is Microstrategy way of handling Composite Keys. " Click "prompt on attribute element list" and click "Next" through the rest of the screens to accept the default values. This video show how to share a filter with other Library users. The following procedure describes how to achieve this: Create the highest level filter. 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. All Files. This is a filter which contains a prompt on an attribute element list. Visit the data visualization and data dashboard galleries for inspiration. In Web 2020 you can only use attributes in rows. Create a filter on the attribute "Year. Attributes are the business concepts reflected in your data. Attributes provide a context in which to report on and analyze business facts or calculations. 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. MicroStrategy Web automatically creates attributes when you import data. Press and hold the Ctrl key to select multiple columns. You can add it to a visualization, drag it into a text field to display it as a label, or use it as a filter. The Group Editor opens. The Compound Grid is a new visualization introduced in the MicroStrategy 2020 release. However, before changing the way MicroStrategy products look or behave, it is helpful to understand how the application is built. This tutorial will guide MSTR users to share dossiers through Web and Library. An in-line many-to-many relationship involves an attribute with at least one parent and one child. From the Select a Project drop-down list, select the project for which to assign the security role. 10?; Knowledge Base: How can I filter a visualization on a dossier that users can’t view or manipulate?;. Create a filter on the attribute "Year. The implicit attribute has its own expression. To create an attribute filter Open the dossier you want to modify. Composite Key: A composite key is made by the combination of two or more columns in a table that can be used to uniquely identify each row in the table when the columns are combined uniqueness of a row is guaranteed, but when it is taken individually it does not guarantee uniqueness, or it can also be understood as a primary key made by. So for example, I could use the autoincrement column from our MySQL table as the HASH, but then all of the examples I see of RANGE keys, global/local secondary indices, etc. In Workstation 2020 you can only use attributes in rows. Then, click 'OK'. 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. To verify this issue a backup of the Metadata is required to generate an Object Manager package to fix the data type inconsistencies and then the custom ScanMD test will resolve the duplicate columns. The following procedure describes how to achieve this: Create the highest level filter. Part 2 of the MicroStrategy Advanced Architect series where I demonstrate how to create compound attribute keys. x allows users and administrators to decide if the attribute titles are displayed using the attribute name or the attribute form name: The setting to control the appearance of the attribute title is located under Preferences - Grid Display: Show Attribute Form Names. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. The functionality of MicroStrategy is such that the outer functions of metrics can only calculate to levels that are specified on the report. A compound key is a primary key made up of two or more attributes (fields) that uniquely identify a row in a table. In the MicroStrategy Tutorial project, Distribution. the logical key gets mapped for a table in. Get the instant response experience with new features unique to the app such as Smart Download and Automatic Refresh that predict and proactively download the content you need both online and offline. This condition may be implemented through an ApplySimple statement such as the following: The user will find that the CASE statement. To create an attribute filter Open the dossier you want to modify. Create the relationships and hierarchies. View the report as a graph and notice that the. The derived attribute can be a string, number, or date. 4. On the toolbar, click the drop-down arrow on the Create a New Object icon, and select the type of object to create. Enter a name for the form. Save and assign a name to the file like “My_first_connection_file. Open the dossier you want to modify. To create a compound key, users must create multiple attribute forms, group them together and set the form group as the. Ans: In Microstrategy, facts are the numeric data and attributes are contextual data for the facts which. Advanced Metrics, explains level metrics, conditional metrics, transformation.