Definition : Max(Day) Condition : nothing; Level : Remove report level and add Day (standard, standard) Create a. 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. 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. This optimizes the SQL generated considerably:Visualizations that can be used in a dossier appear in the Gallery panel. Although transformations can be applied to any attribute hierarchy, the Time hierarchy is used most often. The types of keys that can be assigned to a table include: •. Do not set any additioMicrostrategy Dossiers With the release of MicroStrategy 10. 16K KB41943: How to create a metric that calculates the distinct count of an attribute. This attribute join type is the default setting. This condition may be implemented through an ApplySimple statement such as the following: The user will find that the CASE statement. The attribute acts like a column header and the. Create a report with the attributes Region and Promotion Type as seen below: 2. Each attribute form must have at least one expression. Type the following for the name: "Total for the #P #0". For more information regarding the MicroStrategy products or the process of customizing MicroStrategy products, please refer to MicroStrategy Developer Zone (to Create Smart Attributes. Attribute form: contains an identifier or descriptor of an attribute. 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. Once you’ve downloaded the example excel sheet, we will proceed to explain step by step how to import our file. If you know of better/faster ways, please share. Use the Ctrl key to select multiple attributes and metrics. Glossary. So the good idea is to create a separate table and push multivalued attribute into it. Create a compound ID attribute based on multiple data sets. However, before changing the way MicroStrategy products look or behave, it is helpful to understand how the application is built. Advanced topics include the following: Introduction to Advanced Reporting, reviews the tasks and objects to create a basic report and previews advanced reporting concepts. Open any folder page (for example, click Shared Folders on the home page). By choosing Automatic, if the largest table is >= 1M rows, MicroStrategy will choose the attribute. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. . 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. For example, consider the relationship between three attributes: Promotion, Item, and Quarter. OrgChartVisPlugin. " Click "prompt on attribute element list" and click "Next" through the rest of the screens to accept the default values. In MicroStrategy Developer, open Architect. 4. In the MicroStrategy. Create another dynamic date filter 'OBJ2 - Last Month' Create a Metric 'OBJ3 - Max Day No Filter' that returns the day value in a metric for a given day. This tutorial will guide MSTR users to share dossiers through Web and Library. 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. How to force non-key template attributes to appear in the SELECT and GROUP BY statements in intermediate passes of MicroStrategy SQL Generation EngineUse the Selections pane (the bottom pane on the right) in the Query Builder Editor to map the columns in your SQL query to attributes and metrics that appear in the Query Builder report. Save the report as “Email Bursting”. A percent-to-total shortcut metric displays the percent in relation to a selected total of each item affected by the metric. For any Apply function, the attribute form in the arguments should be a single form—not a form group. The following procedure describes how to achieve this: Create the highest level filter. Compound metric C is made up of two metrics A and B with expression (A+B). Select the attributes and facts from that table. For information on compound attributes, see Attributes with multiple ID columns: Compound attributes. Beginning in MicroStrategy 11. Video Tutorials. For the Time hierarchy, the offset can. 4. Click Filter . " Click "prompt on attribute element list" and click "Next" through the rest of the screens to accept the default values. Click the “Select File” option. 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. To change the lookup table from 'LU_COUNTRY' to 'LU_REGION' (for example), click on 'Modify' in the Form definition section. In MicroStrategy Developer, go to the Tools menu and select Desktop Preferences. Update:Projects - MicroStrategy. The Compound Grid is a new visualization introduced in the MicroStrategy 2020 release. Generally, you create a compound attribute when your logical data model reflects that a compound key relationship is present. Select the Relationships tab. But in reality, many of these dimensional relationships change over time. The primary key is made up of the lowest level attributes. In the MicroStrategy Tutorial project, Distribution Center is an example of a compound attribute. STEPS TO IMPLEMENT. You cannot change the join types of. You must select properties for each form when you create forms in the Attribute Editor or Architect in MicroStrategy Developer. In MicroStrategy Developer, from the File menu, point to New, and select Transformation. 2. Double-click the Column Set name to rename the set. 10?; Knowledge Base: How can I filter a visualization on a dossier that users can’t view or manipulate?;. Create 2 datasets. This calculation can be aggregated from the Employee level to the Region level. It causes the SQL Engine to calculate for only the attribute elements that exist in both the lookup and fact tables. The objects you can create in MicroStrategy fall into one of three groups: schema objects, application objects, and reports and documents. To display this property, enable 'Show Advance Settings' from the Tools menu in the VLDB properties editor. 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. In MicroStrategy Developer, go to File > New > Metric. Attribute Creation. We use MicroStrategy Tutorial tables that have the Month Id. Select Custom as the Category and create the format using the number format symbols listed in the table below. 3. You treat one attribute as a child of the other and have a compound key for the lower level attribute. KB42704: When adding an attribute to a hierarchy, the attribute is not showing up in the MicroStrategy Developer 9. The database will combine its values to create a unique identifier for each record. Create a filter on the attribute "Year. Logical size is Microstrategy way of generating the best suitable/optimized SQL to fetch the required data. Follow the steps below to create a metric that counts the unique combination of two different attributes: 1. There are no restrictions on the names for the columns used in the expressions of a given attribute. Here the many-to-many relationship is converted into a compound attribute relationship. This is a filter which contains a prompt on an attribute element list. Drag an attribute from the Datasets panel to the Rows area of the Editor panel. Double-click Time to open the folder, then double-click Year. Select an attribute to place in the 'Attribute' box by clicking the browse button. Create the list using the buttons described below: Select Objects dialog box. Use the Ctrl key to select multiple attributes and metrics. Might need to play with formatting to make sure. Which key structure you use to identify a unique attribute in a table depends on the nature of your data and business requirements. To add a parent attributes, drag the appropriate attributes from the Candidates list into the Parent drop zone under Directly Related Attributes. x with any number of attributes. 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',. Name this filter "Greater than 3,000,000". Turn off the Platform Analytics Consumer. x-10. Select the data set and click Prepare Data. Do not set any additioHere is the workaround to achieve the attribute left outer join on MicroStrategy Web. 0. P12 certificate and key file into a . Refer. " Click "prompt on attribute element list" and click "Next" through the rest of the screens to accept the default values. 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. 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. This video show how to share a filter with other Library users. The logical keys of a fact table in a data warehouse are any columns on which an attribute has been defined in the project. Several non-group functions that are. Click Create on any page, and select New Metric. You must create a compound attributes when an attribute requires two or more columns to uniquely identify its elements. An attribute is only eligible to be a child of another attribute only if the two attributes share columns which exist in a common lookup table that can be used to join the two tables. Calculate each attribute individual weight according to the level in the hierarchy (level in hierarchy/number of levels in hierarchy * 10). For example, in the MicroStrategy Tutorial project, for the 'Month' attribute, instead of seeing the description as 'September 2007, users might prefer to see 'Sep'. Click the “Burst. 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. Compound keys add complexity to SQL. Choose your environment and project. From the Insert menu, select New Metric. 3. The steps to create such an attribute: The primary key is made up of the lowest level attributes. 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. Do not set any additioIn MicroStrategy Web 2020, create a dossier with a Compound Grid visualization. Setting the metric formula join type for compound metrics. 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. Do not set any additioHow to include an attribute form in a compound or derived metric in MicroStrategy Developer 9. Select the attributes and facts from that table. 2. Click the Create Filter icon . To change the order of the transformations, select a transformation and use the directional arrows to re-position it. Connectivity. Create a filter on the attribute "Year. To enable or disable Smart Totals in MicroStrategy Developer, follow the steps below: Open the compound metric in the metric editor. In Microstrategy Developer, create a new attribute by navigating to File > New > Attribute. Create the relationships and hierarchies. long_description is the long description of the attribute, of type string, between double quotes ("). Also, you add both attribute IDs, in this case Item_ID and Color_ID, to the fact table as shown in the following diagram. This is a filter which contains a prompt on an attribute element list. However, before changing the way MicroStrategy products look or behave, it is helpful to understand how the application is built. An input box will be displayed with a list of recommended questions based. Create a Default Dynamic Selection Filter. g. Open the registry key at HKEY_LOCAL_MACHINE]\SOFTWARE\MicroStrategy\DSS Server\Castor. Select the Logical View Tab of both tables to see all the logical objects mapped to the table. Double-click the security role you want to assign to the user or group. An attribute on a dossier serves as a label for a group of metrics. Click Advanced, then New to create a custom subtotal. Click Use Formula Editor. Check the checkbox 'Apply background color as a graph threshold,' as seen below: Click OK. 4. By ManishaGupta that reached out to. •. To manually enter the definition of the derived attribute. In the attributes list, right-click the Commute Distance attribute and then select New Attribute Relationship. 1 Answer. 1 and 10. Drag an attribute or metric from the Datasets panel to the Columns Set area in the Editor Panel. Visit the data visualization and data dashboard galleries for inspiration. Setting a join specification allows you to place conditions on the data selected for display in a report. Create a duplicate of the Month attribute and name it 'AliasMonth' Create a filter that will prompt users to select the Month attribute. Each custom format can have up to four. Even though all the ID forms of a compound key attribute do not exist on the fact table, that attribute is seen in the fact entry level of that fact table The Compound Grid is a new visualization introduced in the MicroStrategy 2020 release. Click Filter and choose Element/Value Filter. The primary key should contain the fewest possible number of columns (limit the use of compound keys). Create a filter on the attribute "Year. Open the dossier you want to modify. 3. Type the following for the name: "Total for the #P #0". more columns. 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. The derived metric's value is 12. (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. A joint child is Microstrategy way of handling Composite Keys. Open a report in MicroStrategy Developer. 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 primary key should contain the fewest possible number of columns (limit the use of compound keys). 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. Use fictional primary key (i. In MicroStrategy Developer, log in to the project source that contains the MicroStrategy Tutorial project and then log in to MicroStrategy Tutorial. Choose one of the following: Save the metric. Click 'Browsing Options' and check the 'Display hidden objects' checkbox and click OK twice. Select multiple attribute forms, right-click, and choose Group. 8K views 4 years ago n this brief video tutorial, Stephen Goodson, a senior instructor. The hyperlinks based on an attribute form compound by Applysimple no longer work when exporting to MHT in MicroStrategy 9. The key immediately following this keyword is the selector control key. Create a filter on the attribute "Year. 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. This is a filter which contains a prompt on an attribute element list. You can also create new attributes, based on existing attributes in your dataset, while viewing a dossier. Hierarchy 2: 4. xThe following procedure describes how to achieve this: Create the highest level filter. Click Insert Visualization . In some cases, it may be preferable to define multi-level calculations as cube objects, rather than as metrics in MicroStrategy. The Customer attribute in the MicroStrategy Tutorial has various forms, including the Customer Name and the Address forms. Logical Views allows application architects to create any desired view using MicroStrategy, without DBA involvement. For example, if attribute Region is 'Central' then derived metric value should be 'Profit + Cost'. In the Object Browser, locate and double-click the metric Cost. Glossary. These attributes can be primary keys or non-primary keys. 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. STEPS TO REPRODUCE: 1 - In the MicroStrategy Tutorial project create a new attribute form in the Category attribute with the following expression:Multiple elements are highlighted when using an attribute with compound key as a selector in Visual Insight and MicroStrategy Web 9. Select the heat map visualization. In MicroStrategy Desktop/Developer 9. Create an attribute with a compound key In the metric editor, drag the attribute to the metric definition Consider the following: if the attribute you created is. Attribute T contains an element t1. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. Create Custom Tooltips. An in-line many-to-many relationship involves an attribute with at least one parent and one child. . However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. To enable or disable Smart Totals in MicroStrategy Developer, follow the steps below: Open the compound metric in the metric editor. Related articles from the Community: Knowledge Base: Is it possible to expose “Create Personal View” subscription option in. After choosing the attribute, choose to qualify on the ID, as in shown below: The user will now be able to access the. In the relational database. Create and Edit a Visualization-Based Filter. 3. In this case, from the Table Editor's Layout tab, you. Drag an attribute from the Datasets panel to the Rows area of the Editor panel. Attribute_ID1 = “,A1,”. You can use the Custom Visualization API to create tooltip functionality using third-party plotting libraries like D3. e. To access the Date Editor to create dynamic dates, execute the following steps: In the Filter Editor, choose to add an attribute qualification. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence; Multi-Cloud. x . Do not set any additioUsers may have a requirement to create a metric that counts the unique combination of two different attributes. Select the function to use to calculate data in the metric. Open the dossier you want to modify. ". Metrics are completely reusable - they can be added to different reports or even other metrics. From there, put the elements into one group that is labeled "Inbound Costs" and make another that is labeled "Outbound Costs". The following procedure describes how to achieve this: Create the highest level filter. A derived attribute works the same as any other attribute. You must determine which attribute will be displayed to the user when the user is prompted. (The use of brackets around compound object names is standard for many objects in MicroStrategy and is not restricted to custom expressions and Apply. 1, an attribute in a grid can be used as selector to target other grids in the same dashboard. A compound key attribute is an attribute that has two or more IDs. From the MicroStrategy Developer File menu, point to New > Attribute. Create a filter on the attribute "Year. Select the Members tab. x?. •Transformations allow you to apply an attribute-element based offset to compare metric data. In Web 2020 you can only use attributes in rows. The following procedure describes how to achieve this: Create the highest level filter. See Column data descriptions and identifiers. Here is the workaround to achieve the attribute left outer join on MicroStrategy Web. In Fiddler, users can use the Inspectors > WebForms > params feature to view the body of the request. Create a duplicate of the Month attribute and name it 'AliasMonth' Create a filter that will prompt users to select the Month attribute. Go to Smart Attribute blade on the Attributes Editor. The steps below use objects from the MicroStrategy Tutorial project as an example. Execute the report. To Create an Attribute-To-Attribute Qualification that Compares the Call Center and Customer City Attributes In MicroStrategy Web, log in to a project. Select an operator, such as Equals or Less Than, from the next drop-down. See below: Notice in Developer, you can currently right click on this document and select the 'Edit' option. 'Customer Birthdate' is used in this example. Generally, you create a compound attribute when your logical data model reflects that a compound key relationship is present. If the document is already open in Design Mode, click the Editable Mode icon . Generally, you create a compound attribute when your logical data model reflects that a compound key relationship is present. Time zone aware attribute must be a single form with the TimeStamp data type. Browse to the Platform Analytics Cube in the Platform Analytics Project and select the option to create a new dossier. Click the visualization to add the group to. Note that only the naming convention has changed, as the functionality remains the same. . 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?. Here's what you would need to do in your code: public class MyTable { [Key, Column (Order = 0)] public string SomeId { get; set; } [Key, Column (Order = 1)] public int OtherId { get; set; } } You can also look at this SO question. Click OK. Open up the same document in MicroStrategy Web 10. Do not set any additioIn the Format Definition section, click on Cell Formatting. I want to create an index for efficient lookup when 3 or more values are specified in the "where" clause. Typically, dimensional hierarchies are presented as independent of time, e. x. An example showing a control key value of F59 is shown below: Follow the URL syntax in KB38841 to create the hyperlink for passing selections. the logical key gets mapped for a table in. In Microstrategy Developer, create a new attribute by navigating to File > New > Attribute. Click All Objects View. A setting in MicroStrategy Web 9. The recommended way to model attribute roles in MicroStrategy 10 is using explicit table aliases. The only solution that I can think of is to create a FreeForm SQL Report. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in one. " Click. The following procedure describes how to achieve this: Create the highest level filter. Obviously, you create the table, load it into the Warehouse Catalog, create the new fact and update the schema. After migrating to MicroStrategy 9. All articles. English Deutsch Français Español Português Italiano Român Nederlands Latina Dansk Svenska Norsk Magyar Bahasa Indonesia Türkçe Suomi Latvian Lithuanian česk. In general, ApplySimple can be used to create the following objects: •. 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: . Execute the report and notice the report only shows the subtotal of the attribute Region, as illustrated below:In SQL View look at where the cross join appears, and between which tables the cross join appears. The only solution that I can think of is to create a FreeForm SQL Report. KB17619: How to create a conditional attribute in MicroStrategy Desktop 8. This compound metric will be a "Percent to Regional Total" and created as follows:The algorithm that calculates the table sizes performs the following steps: Calculate the number of levels per hierarchy: Hierarchy 1: 3. Attribute_ID2= “,B1,”)”). This implies that more than one ID column is needed to uniquely identify the elements of that attribute. 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. Save and close the report as 'Test Nile'. Right-click the group and choose Set as key. x Product Suite, all the application, schema and configuration object definitions and other project-related settings are stored in the metadata. The attribute level follows a consecutive order from. Using the MicroStrategy Project Tutorial, create a report with the attributes Category, Subcategory and the metric Revenue. Open MicroStrategy Web. Attributes must contain at least one ID form, which uniquely identifies the attribute. While this feature is similar to using an ApplySimple in a filter, the difference is that you can customize both sides of the condition, whereas with the ApplySimple you can only customize one side to be equal to a single Attribute Form. Hierarchy 2: 4. So the good idea is to create a separate table and push multivalued attribute into it. The object's editor or wizard opens. Create a compound ID attribute based on multiple data sets. 4. Click Advanced, then New to create a custom subtotal. Right-click, choose Calculation, and the type of calculation to create the derived element based on. There is a Filter Editor, Template Editor, Attribute Editor, Metric Editor, Report Editor, and so on. In the visualization, select the attribute elements to use in the group. It helps to merge or concat two columns in the same group. The Results Preview dialog box opens. Select the check box for any smart attribute that needs to be created. On the example above, they are displayed as Report Objects on the left of the Report Viewer. Set the qualification type to 'Custom'. ” icon to expand it: All page-by attributes will. 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. Double-click the Column Set name to rename the set. The derived attribute can be a string, number, or date. Use fictional primary key (i. 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. The form expression for the Customer Last Name attribute form is CUST_LAST_NAME. There are no restrictions on the names for the columns used in the expressions of a given attribute form. Create a new derived attribute by. An attribute form qualification might filter on the form Last Name, the operator Begins With, and the letter H. Create the highest level filter. 4. desc is the description of the attribute, of type string, between double quotes ("). We decided to gather them in one placing using our experience and MicroStrategy materials. In the visualization's Editor panel, right-click the attribute to group and choose Create Groups. Create a filter on the attribute "Year. Click Add, select the elements, then click OK. How to apply threshold on rows without specific characters in attribute element. STEPS TO REPRODUCE: Create a document in MicroStrategy Developer or Web 10. EN. The primary key should be compact (avoid the use of long data types). x and 10. 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. For Compound Profit to be dynamically aggregated correctly, you change the dynamic aggregation function to Sum. Drag from the middle of the attribute to an. Then, click 'OK'. The following SQL demonstrates that by having all the keys from the fact table on the report template, the setting "The key specified is the true key for the warehouse table" allows the metric to return the values straight from the fact table without aggregation. Advanced Metrics, explains level metrics, conditional metrics, transformation. This is a filter which contains a prompt on an attribute element list. 4. To achieve this, perform the following step using the MicroStrategy Tutorial project: Create a compound metric that is defined as metrics Profit + Revenue and name it "Profit + Revenue Compound Metric". Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. In the Datasets panel, right-click the attribute to use to create a derived metric and choose Duplicate as Metric. An Attribute Qualification prompt can be used in an Attribute form qualification. How to create an attribute that masks data elements in MicroStrategy Developer (formerly Desktop). This implies that more than one ID column is needed to uniquely identify the elements of that attribute. KB39189: How to create a count of different attribute element values using subtotals in MicroStrategy Desktop 9. Composite keys are constituted of two or more columns which together act as unique identifier. It is used to insert any single-value, database-specific functions and simple operators directly into SQL. Select the heat map visualization. Slowly changing dimensions (SCDs) are a common characteristic in many business intelligence environments. End_date. " Click "prompt on attribute element list" and click "Next" through the rest of the screens to accept the default values. " Click "prompt on attribute element list" and click "Next" through the rest of the screens to accept the default values. Attribute form. The procedure below describes how to create a compound attribute using Architect, and follows the example scenario provided in Example. Create a new dossier or open an existing one. Still need help? The Compound Grid is a new visualization introduced in the MicroStrategy 2020 release. To access the Date Editor to create dynamic dates, execute the following steps: In the Filter Editor, choose to add an attribute qualification. mstrc file created before and click Continue. Create a compound metric based on the previous two metrics, "Revenue" (Call Center Level) and "Revenue_by_Region" (Region Level). it seems like a small gap to breach to finalize this API endpoint. It causes the SQL Engine to calculate for only the attribute elements that exist in both the lookup and fact tables. This is a filter which contains a prompt on an attribute element list. Right-click the selected columns and select Create Multi-form Attribute. Candidate Key – is a set of attributes that uniquely. Workaround / Solution. Drag the attributes and metrics. How to create a dense rank metric in Microstrategy Developer 9. For example, a warehouse table's primary key is defined using the columns CUSTOMER_ID, PRODUCT_ID, and ORDER_ID. How to create an attribute in MicroStrategy What are attributes? Attributes are groups of related data, such as table columns. Then you also set the parent child relationships in. A screen appears where users can choose to create a specific type of value. The following procedure describes how to achieve this: Create the highest level filter. " Click "prompt on attribute element list" and click "Next" through the rest of the screens to accept the default values. Open a new or existing dossier. For a New Attribute. Once you have the group made, then just drag in the original attribute under it. This name change is visible in. In this case, enter 'Date@ID'. Starting in MicroStrategy 11. " Click "prompt on attribute element list" and click "Next" through the rest of the screens to accept the default values. Here is the workaround to achieve the attribute left outer join on MicroStrategy Web. This is a filter which contains a prompt on an attribute element list. Under 'Source tables', select a table and click 'Set as Lookup'. Select the chapter that contains the visualization to filter. 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 procedure describes how to achieve this: Create the highest level filter. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched.