Follow the steps below to reproduce it: Create report with consolidation Create project models from MicroStrategy Developer Create ad-hoc models from MicroStrategy Web; Workflow. For example, given a report with Revenue and Cost, the custom subtotal will return total Profit, as shown below:The Profit metric is a simple sum of the Profit fact. Follow the steps below to reproduce it: Create report with consolidationCreate project models from MicroStrategy Developer Create ad-hoc models from MicroStrategy Web; Workflow. Follow the steps below. In MicroStrategy, users can create an Average metric from an attribute description that will join to the fact table to calculate a weighted average. In Visual Insight in MicroStrategy Web 9. This is a filter which contains a prompt on an attribute element list. x . mstrc file created before and click Continue. During our 10+ years of work with MicroStrategy we often encountered overlapping cube and cache questions and what are the best practices in order to manage them. Select the Source Table that contains the desired attribute ID, and drag the attribute ID into the Form Expression window. Advanced topics include the following: Introduction to Advanced Reporting, reviews the tasks and objects to create a basic report and previews advanced reporting concepts. A setting in MicroStrategy Web 9. Do not set any additioIn MicroStrategy Web 2020, create a dossier with a Compound Grid visualization. Place the 'max month' metric created in step 4 in the Report objects window. The attribute level follows a consecutive order from. If the Object Browser is not displayed, from the View menu select Object Browser. Advanced Metrics, explains level metrics, conditional metrics, transformation. This calculation can be aggregated from the Employee level to the Region level. for that attribute ( say a dimension table). Multivalued attributes cannot work as primary keys. " Click "prompt on attribute element list" and click "Next" through the rest of the screens to accept the default values. Custom number formatting symbols. 4. A compound key attribute is an attribute that has two or more IDs. Attribute Creation. level at which the date will be unique=2E To do this I created an=. Type RunningAvg in the Definition pane. Drag attributes or metrics from the Datasets panel to the Filter panel. In Desktop 2020 you can only use attributes in rows. If the user defines more than one expression for a given form, heterogeneous mapping will automatically take place when tables and column names require it. Click 'Browsing Options' and check the 'Display hidden objects' checkbox and click OK twice. 1. You treat one attribute as a child of the other and have a compound key for the lower level attribute. Click the visualization to add the group to. The formula of a compound metric is based on arithmetic operators and non-group functions. To create a MicroStrategy Environment connection file . Attribute_ID2= “,B1,”)”). One of the component metrics that makes up the Compound metric is made with the Count() function and has the Metric Guide changed from "Automatic" to an attribute. 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. To access the Date Editor to create dynamic dates, execute the following steps: In the Filter Editor, choose to add an attribute qualification. Open attribute editor (right-click on attribute and select. View the report as a graph and notice that the. Drag an attribute or metric from the Datasets panel to the Columns Set area in the Editor Panel. Ans: A Compound key attribute is a primary key that is made up of two or more columns and these columns are joined with other attributes. Select the attributes and facts from that table. A sample URL that answers an element prompt when the attribute has a compound ID is shown below. The following steps can be used to concatenate two attribute forms. g. Create three reports named A (with attribute A), A&B (with attribute A and B),A&C (with attribute A and C) Create a dashboard based on the three reports created in last step. " Click "prompt on attribute element list" and click "Next" through the rest of the screens to accept the default values. To create a list of attribute elements from which users can choose, select Use a predefined list of elements. Glossary. Create a new attribute that maps to the same column as the original attribute. Press and hold the Ctrl key to select multiple attribute elements. Go to Smart Attribute blade on the Attributes Editor. Obviously, you create the table, load it into the Warehouse Catalog, create the new fact and update the schema. Click on 'OK' and save the. To create a derived metric. 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. Slowly Changing Dimensions. Can you apply themes to MicroStrategy Web? How to create a one? After a bulk. The hyperlinks based on an attribute form compound by Applysimple no longer work when exporting to MHT in MicroStrategy 9. For details on this feature, refer to the following MicroStrategy Knowledge Base article. Create a compound ID attribute based on multiple data sets. Right-click the header of the attribute whose elements you want to use to. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformCreate a report with attribute "Quarter", metric "Revenue" and "Rank Test". Create the highest level filter. Navigate to the Schema Objects folder, open the Attributes folder, and then the Geography folder. Select Custom as the Category and create the format using the number format symbols listed in the table below. In the Source area, select a database instance for the database to access using Freeform SQL. The Count function in MicroStrategy does have a parameter to include or exclude nulls, but including nulls can only count rows that exist in the result set. The implicit attribute has its own expression. 4. This optimizes the SQL generated considerably:Visualizations that can be used in a dossier appear in the Gallery panel. As you type, matching objects, such as attributes. 4. This implies that more than one ID column is needed to uniquely identify the elements of that attribute. Now to fix this create a new Derived metric on Category attribute first with formula as Max (Category) {~ } and calling Books. Insert a derived metric 'M01' with expression 'Max(Region@DESC) {~+} '. 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. Uncheck the 'Use default inherited value' box and set the option 'Create composite index for temporary table column indexing'. In Microstrategy Developer, create a new attribute by navigating to File > New > Attribute. Create a filter on the attribute "Year. NOTE: If the above drop down list is disabled, the metric is not a compound metric and so smart totaling does not apply. A compound key is a primary key made up of two or more attributes (fields) that uniquely identify a row in a table. There are several ways to create and apply filters to individual chapters, multiple chapters, or across an entire dossier. Create a Compound Attribute. 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. Click the Create Filter icon . Here is the workaround to achieve the attribute left outer join on MicroStrategy Web. Remember that P displays the parent attribute and 0 (the number zero, not the letter o) displays all the forms of the parent attribute. . The key attributes are determined solely by attribute mappings to the table and attribute relationships, where the logical table keys. The Create New Attribute Form dialog box now appears. Select multiple attribute forms, right-click, and choose Group. By ManishaGupta that reached out to. 2. 71K subscribers Subscribe 2. The Attribute element prompt is the most restrictive, allowing users to choose from the fewest number of attribute elements to define their filter criteria. For more information regarding the MicroStrategy products or the process of customizing MicroStrategy products, please refer to MicroStrategy Developer Zone (need to know the number of regions, so you create a derived metric from the Region attribute. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories. 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. Open the Filter Editor and select the 'Add an Attribute qualification' radio button. II. This is a filter which contains a prompt on an attribute element list. 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. The Attribute Creation Wizard opens, as shown below. (2) The MicroStrategy object that supports such a report. A derived attribute has its value determined by an expression which combines two or more columns in a. Click Save and Update Schema. Drag the attributes and metrics. Heterogeneous mapping allows the engine to perform joins on unlike column names. Continue creating the metric (for example, adding levels or conditionality) . In MicroStrategy Developer, log in to the project source that contains the MicroStrategy Tutorial project and then log in to MicroStrategy Tutorial. There are no restrictions on the names for the columns used in the expressions of a given attribute form. Advanced topics include the following: Introduction to Advanced Reporting, reviews the tasks and objects to create a basic report and previews advanced reporting concepts. Each attribute form must have at least one expression. Launch MicroStrategy Desktop and open a local dossier. 0 if there are multiple join paths between two or more One-to-Many relationship tables in a multi-table data import cube, rather than using the first available table join path, the analytical engine will look for the path with the least number of tables and the smallest table base on the following order/criteria:If it is desired to have SQL generated that specifies a distribution key on all columns that are used in the intermediate table (and not just attribute ID columns), the same combination of VLDB settings may be used as above, except for replacing the wildcard !a by !!! as below: Create Post String = DISTRIBUTE ON (!!!)This issue is being investigated by the MicroStrategy Technology team. 0 and 2019, users will notice objects referred to as "Super Cubes". Drag an attribute from the Datasets panel to the Rows area of the Editor panel. The following procedure describes how to achieve this: Create the highest level filter. 3. 10?; Knowledge Base: How can I filter a visualization on a dossier that users can’t view or manipulate?;. Dynamic dates are created in MicroStrategy Developer by using the Filter Editor. In MicroStrategy Developer, choose File > New > Report. x-10. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. The derived attribute can be developed based on an object. Create a new dossier or open an existing one. If the attriubte name has spaces, use the '' symbols to group the name. Select the attribute form to filter report data from the drop-down list. Creating attributes is an important step in the initial project design effort, which comes after creating facts when using the Project Creation Assistant. The forms you create must have a reference to a lookup table and can include multiple expressions. 5. Select the Relationships tab. This is a filter which contains a prompt on an attribute element list. only specify ONE other attribute as the RANGE. From the Insert menu, select New Training Metric to use derived metrics as part of Data Mining Services to create training metrics. 3. Simple key requires only one column to identify a record uniquely within a table. Attributes provide a context in which to report on and analyze business facts or calculations. In this case, Promotion has a many-to-many relationship to both Item and Quarter. Workaround / Solution. Logical size is Microstrategy way of generating the best suitable/optimized SQL to fetch the required data. A compound attribute is an attribute with multiple columns specified as the ID column. Consider the following scenerio: A user wants to create a metric which ranks the Regions according to Revenue at a company-wide level. I want to create an index for efficient lookup when 3 or more values are specified in the "where" clause. 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: . For any Apply function, the attribute form in the arguments should be a single form—not a form. Create a Default Dynamic Selection Filter. " Click. Create a metric that is defined as Max(Promotion Type @ DESC). The primary key should be compact (avoid the use of long data types). x. This is a filter which contains a prompt on an attribute element list. Right-click, choose Calculation, and the type of calculation to create the derived element based on. Create an attribute with a compound ID. 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. Enter a name to use for the new attribute in New Attribute Name. Data displayed in MicroStrategy Viewers can be filtered by different criteria. 0. A blank visualization appears in the dossier. Any time you type an attribute whose name contains one or more spaces, the attribute must be enclosed in square brackets. There are no restrictions on the names for the columns used in the expressions of a given attribute. 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. You cannot change the join types of. You then create a new metric based on the new fact and attempt to use it in a report, together with the compound key attribute. In the visualization, select the attribute elements to use in the group. Right-click the table, point to Recognize, and then select Attributes. Select the chapter that contains the visualization to filter. The steps below use objects from the MicroStrategy Tutorial project as an example. For Compound Profit to be dynamically aggregated correctly, you change the dynamic aggregation function to Sum. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in one. In the Create New Form Expression window in the Attribute Editor, select the above table as the source table and use the following ApplySimple statement to define the expression: Applysimple( "#0 '-' #1 '-' #2", ID, Quarter, Year)Here the many-to-many relationship is converted into a compound attribute relationship. Place the attribute 'Category' on the Page-by. Microstrategy - MSTR - Find the Lineage information from Table/Column to. Consolidation can not be used as Sort key from MicroStrategy Web 10. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. Compared to the out-of-the-box tooltip dropzone, custom. Create a filter on the attribute "Year. From the MicroStrategy home page, click New Metric . The key points are: 1) create the Contribution (%) derived metric in the report instead of in the dashboard; 2) use filtering selector instead of slicing selector. This video show how to share a filter with other Library users. Use the same steps as specified in the help menu: Open attribute editor (right-click on attribute and select 'Edit') Select the forms that will make up the compound key. Also, you add both attribute IDs, in this case Item_ID and Color_ID, to the fact table as shown in the following diagram. How to create an attribute in MicroStrategy What are attributes? Attributes are groups of related data, such as table columns. To Create a Query Builder Report from an Excel File. New user and application. an integer number) for your main table and link each set of D values to the necessary record. The only solution that I can think of is to create a FreeForm SQL Report. For example, a warehouse table's primary key is defined using the columns CUSTOMER_ID, PRODUCT_ID, and ORDER_ID. 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. In MicroStrategy Developer, open Architect. Press and hold the Ctrl key to select multiple attributes or metrics. Create a report that makes use of the metric. Join Specifications. Drag an attribute or metric from the Datasets panel to the Columns Set area in the Editor Panel. The Group Editor opens. In Fiddler, users can use the Inspectors > WebForms > params feature to view the body of the request. Save the filter as "YEAR FILTER:"Knowledge Base: How to create a metric to calculate the difference for a same metric but two different attribute elements in MicroStrategy Visual Insight? Knowledge Base: How to create a Derived Transformation Metric using the MicroStrategy Java Web SDK 9. The following steps describes how to create such derived metric. To uniquely identify a distribution center, one must know two details about the distribution center: the ID. Open up the same document in MicroStrategy Web 10. Drag attributes or metrics from the Datasets panel to the Filter panel. Consider what key structures work best when creating lookup tables in the physical warehouse schema. The object's editor or wizard opens. Choose File > New Attribute. 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. The following auto text codes allow you to add document variable information to your document. In this case, from the Table Editor's Layout tab, you can. You can narrow the list of functions displayed in the pane by doing one of the following: To search for the function by name, type the. Press and hold the Ctrl key to select multiple attribute elements. Might need to play with formatting to make sure. 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. the attribute definition window. The following procedure describes how to achieve this: Create the highest level filter. Browse to the Platform Analytics Cube in the Platform Analytics Project and select the option to create a new dossier. When the attribute used as a selector has a compound key, i. Attribute form. Visit the data visualization and data dashboard galleries for inspiration. x, the hyperlinks base on attribute form with Applysimple no longer work in the exported MHT file. If none of the built-in number formats meet your needs, you can create your own custom format in the Number tab of the Format Cells dialog box. Create a report with Category, and Revenue; 2. How to create a dense rank metric in Microstrategy Developer 9. Time zone aware attribute must be a single form with the TimeStamp data type. For instance, the attribute City may be defined in the data model as a combination of COUNTRY_ID and. In the report, the attribute with the compound key is Distribution Center. •Transformations allow you to apply an attribute-element based offset to compare metric data. 4. x although it can be done from MicroStrategy Developer 10. From the MicroStrategy Developer File menu, point to New > Attribute. Make B and C parents of a new compound attribute using both columns as its ID with A B and C as its parents. From the 'Edit' menu,. The following procedure describes how to achieve this: Create the highest level filter. 10789 views · September 04, 2020. If these three columns are mapped to attributes in MicroStrategy, then the primary key is represented correctly. The key immediately following this keyword is the selector control key. Name this filter "Greater than 3,000,000". Once an attribute has been selected, the button is replaced by the. Refer. Create a filter on the attribute "Year. Can you update a table in Warehouse using MicroStrategy? How will you resolve an issue when (by chance) an aggregate table at higher level has a higher LTS than an aggregate table at lower level?. The following window appears: Highlight the table 'LU_REGION' under 'Source tables' and click on the 'Set as Lookup' button. Simple key requires only one column to identify a record uniquely within a table. Creating smart metrics. 1 and… Number of Views 618 KB14936: When drilling across to a hierarchy in. MicroStrategy is as follows: 1. Select the check box for any smart attribute that needs to be created. 3 If a message is displayed asking if you want. From the Object browser, select an attribute and drag it on the filter pane on the right. database to create a new column. Count Compound Attribute. Let's add the custom visualization to the Gallery. Create a filter on the attribute "Year. Do not set any additio In the relational database, a compound key is a primary key that consists of more than one database column. Ultimately, it was. Select the correct Form Category, such as ID. In the relational database. To create an attribute using Architect 1 In MicroStrategy Developer, log in to a project. You must create a compound attributes when an attribute requires two or more columns to uniquely identify its elements. It helps to merge or concat two columns in the same group. Apply Filter Changes. The Transformation Editor opens with the Select a Member Attribute dialog box displayed. All articles. How to create an attribute that masks data elements in MicroStrategy Developer (formerly Desktop). 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',. 4. Create a new derived attribute by. How to convert a . It causes the SQL Engine to calculate for only the attribute elements that exist in both the lookup and fact tables. Forms other than key and relationships are removed if this setting is enabled. To access the Date Editor to create dynamic dates, execute the following steps: In the Filter Editor, choose to add an attribute qualification. Metric Guide; Compound Metric; Steps to Reproduce. To uniquely identify a distribution center, one must know two details about the distribution center: the ID. MSTR uses lots of components like attribute, metric, facts, Logical Tables etc to build a report. Attribute_ID2= “,B1,”)”). Shorter data types are faster to join than longer. 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. Attribute name:XXXX" is thrown after attempting to map a compound key attribute to SAP properties in MicroStrategy Analytics Enterprise. Click Attribute Qualification Prompt. With Architect, you can create and modify multiple attributes in your project quickly from an integrated interface. (in my example: table_id, start_date) 2) create a 2nd metric for your date value at your desired=. 8K views 4 years ago n this brief video tutorial, Stephen Goodson, a senior instructor. KB39189: How to create a count of different attribute element values using subtotals in MicroStrategy Desktop 9. Select the attributes and facts from that table. x and 10. The key icons are not intended to reflect the warehouse table's physical keys, but rather which logical attributes in the MicroStrategy schema should function as lowest-level join attributes for this table. By default, the metrics Compound Profit and Profit Margin do not use a dynamic aggregation function. You can create a stand-alone prompt, or you can create a prompt that is embedded in a filter. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. This video covers the process of requesting an ESRI License key and applying the license key to MicroStrategy Web. Click Qualify. This level of control can ensure consistent Engine behavior. Generally, you create a compound attribute when your logical data model reflects that a compound key relationship is present. In MicroStrategy Web, on the Home page, click New Prompt. Drag an attribute from the object browser into the text box next to the qualification type or enter the attribute name and its form according to the following format: attribute_name@form_name. To manually enter the definition of the derived attribute. The only solution that I can think of is to create a FreeForm SQL Report. Select the “File from Disk” option. 1) create a metric of your date value and force it to be at the=. Create and Edit a Visualization-Based Filter. In the MicroStrategy Tutorial project, Distribution. This guide builds on a basic understanding of information provided in the Basic Reporting Guide. Quite often these attributes have automatic mapping for one ID and manual mapping for the other one. In the MicroStrategy Tutorial project, Distribution Center is an example of a compound attribute. Microstrategy follows an algorithm to calculate the logical size of a table, which depends on the no of attributes and facts based on the table and also the position of those attributes in the system hierarchy. The types of keys that can be assigned to a table include: •. 4. Create Multiple Element Groups. Compound key requires multiple columns to identify a unique record. Attributes appear with an attribute icon on the Datasets and Editor panels. Select the chapter that contains the visualization to filter. Select "DESC" from the 'Qualify On' drop down options and change the operator to "Contains", as shown below:In MicroStrategy Developer, to create a list of the individual fact entries for an attribute in a scenario where the attribute has a fact table as its lookup table Very Large Database (VLDB) 'Distinct/Group By option (when no aggregation and not table key)', users can create an attribute 'Year' that uses the YR_CATEGORY_SLS fact table in. You must create a compound attributes when an attribute requires two or more columns to uniquely identify its elements. 4. 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. Here is the workaround to achieve the attribute left outer join on MicroStrategy Web. 1. Drag from the middle of the attribute to an. For example, if sales data is stored in the data warehouse at the day level, a month attribute allows users to. The key attributes are determined solely by attribute mappings to the table and attribute relationships, where the logical table keys. Modeling: Create Time Zone Aware Attributes and Smart Attributes Create Time Zone Aware Attributes. This article describes best practices to be taken when using a Teradata database in MicroStrategy. Make B and C parents of a new compound attribute using both columns as its ID with A B and C as its parents. x - 10. Click ( ) in the operator bar. Press and hold the Ctrl key to select multiple columns. Choose the option to create a 'Value prompt' in the Prompt Generation Wizard and click on 'Next', as shown below: Choose 'Date prompt' and click on 'Next'. Arithmetic operators are +, -, *, and /; non-group functions are OLAP and scalar functions such as running sum or rank. Microstrategy follows an algorithm to calculate the logical size of a table, which depends on the no of attributes and facts based on the table and also the position of those attributes in the system hierarchy. Drag an attribute from the Datasets panel to the Rows area of the Editor panel to add attributes to the rows. If you were informed that your company had sales of $100,000, you can gather. 4. You treat one attribute as a child of the other and have a compound key for the lower level attribute. Remember that P displays the parent attribute and 0 (the number zero, not the letter o) displays all the forms of the parent attribute. PEM push notification. 1; Product Documentation: How to Create a Derived Metric from an Attribute To Create a Combination Graph. mstrc, please open something similar to Notepad. Creating attribute form expressions • Creating and modifying attribute data types: Column aliases • 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 • Part 2 of the MicroStrategy Advanced Architect series where I demonstrate how to create compound attribute keys. You can use the Custom Visualization API to create tooltip functionality using third-party plotting libraries like D3. Continue with the previous Steps 2 and 3 above. II. All Files. An empty filter appears in the dossier. In short, an inner join includes only the data common to all the elements in the join, whether that data is tables or metrics. In the relational database. Here is the workaround to achieve the attribute left outer join on MicroStrategy Web. 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. Part 2 of the MicroStrategy Advanced Architect series where I demonstrate how to create compound attribute keys. The primary key should contain the fewest possible number of columns (limit the use of compound keys). For information on compound attributes, see Attributes with multiple ID columns: Compound attributes. Attributes must contain at least one ID form, which uniquely identifies the attribute. 2. Do not set any additioLogical size is Microstrategy way of generating the best suitable/optimized SQL to fetch the required data. Select the data set and click Prepare Data. 5. 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. Primary Key – is a column or group of columns in a table that uniquely identify every row in that table. Actually, multivalued attributes violate First Normal Form. The three dialog boxes are New Attribute, Create New Attribute Form, and Create New Attribute Form Expression. In Web 2020 you can only use attributes in rows. How to create attributes in MicroStrategy? Create an Attribute. The New Grid dialog box opens. A compound report displaying multiple grids and graphs. Create a compound key for an attribute; Create a derived attribute; Create and delete a form group for an attribute; Create a joint child attribute; Create a new attribute. These auto text codes are automatically replaced by information about the document. When the attribute used as a selector has a compound key, i. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. In the Gallery, click Compound Grid . A compound attribute is an attribute with multiple columns specified as the ID column. For Compound Profit to be dynamically aggregated correctly, you change the dynamic aggregation function to Sum. Autotext code/macros in Microstrategy Document/dashboard. It can be set at the project and. For instance, the attribute City may be defined in the data model as a combination of COUNTRY_ID and CITY_ID. Save the. 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. Create a report with attribute 'Region', metric 'Revenue', 'Profit' and 'Cost'. Click on the 'Subtotals' tab. Create a filter on the attribute "Year. In MicroStrategy Developer, open Architect. For steps to connect to and create a database instance for an Excel file, see Connect to Excel Files. This tutorial will guide MSTR users to share dossiers through Web and Library. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence; Multi-Cloud.