Companies of all sizes use this platform to assess, visualise, and build dashboards. The ApplyOLAP function is used to define compound metrics. e. Use the Object Browser on the left to locate the prompt to add to the metric's definition. Types of filters in Microstrategy Below are the types of filters: 1. In the Editor Panel, right-click the attribute in Column Set 1 and select Display Attribute Forms. multiple attribute forms conform the ID form, any element that matches at least one of the ID's will become highlighted, like shown below. The formula of a compound metric is based on arithmetic operators and non-group functions. Workaround 4: Create a metric based on the attribute Country, for example Max (Country). 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. Consider the sales figures of your company. Relate tables are often used to create relationships between. The time required for dependency checking varies based on a customer's metadata size and schema complexity. With Architect, rather than defining parent and child. The examples below describe how to drill on these compound metrics on both grid and graph reports. Let’s get started. Modify the Address form so that it has a descending report sort order. ) In the metric formula, the desired output dimensionality is given. Use a Comparison KPI to indicate the progress towards an objective, like sales and goal. To enable totals or subtotals for a metric. 4. A compound attribute is defined as an attribute with more than one column specified as the ID column. Add an attribute and a metric to both Column Set 1 and Column Set 2. Click the Options icon . When the attribute used as a selector has a compound key, i. In MicroStrategy Web 2020, create a dossier with a Compound Grid visualization. Intersection behaves as the term AND does in grammar. Change Qualify on to ID. These privileges are part of OLAP Services. database column=2E Its a relational database thing, enabling high=. Temporary policy. Here the many-to-many relationship is converted into a compound attribute relationship. For information on how to display this property, see Viewing and Changing Advanced VLDB Properties. Therefore, it is possible to have the attribute specified at the metric dimensionality level and only have Category in the report template. , Attributes, Facts, Hierarchies, partition mappings, Tables or Transformation). You can type arithmetic operators (such as + and -) and comparison operators (such as < and >) directly in the metric expression. 4. A sample report is: Attributes: Metadata, Project, Object, Object Type, Component Object Type. The Metric Names attribute automatically appears in the Editor panel. After adding the table, a MicroStrategy partition-mapping object has to be defined (File > New > Partition menu). Including attribute forms in your logical data model can help you get a more complete view of all of the information that is made available in your project. 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 include an attribute form in a compound or derived metric in MicroStrategy Developer 9. For example, the form expression for the Customer First Name attribute form is CUST_FIRST_NAME. Featured on Meta Update: New Colors Launched. For example, in the image below the document level global lookup table uses two-key (or two-ID) sorting, while the lookup tables use a single key (ID) sorting. The Compound Grid is a new visualization introduced in the MicroStrategy 2020 release. 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. A user may want to create an attribute with an alternating expression depending on a certain condition, a conditional attribute. Attributes are defined by these properties: •. Open attribute editor (right-click on attribute and. Double-click Time to open the folder, then double-click Year. x. Joint Element Lists are an advanced filtering qualification in MicroStrategy Developer / SQL Engine that can be used to filter on combinations of attribute element ID's from multiple attributes. If a message is displayed asking if you want to use read only mode or edit mode, select Edit and click OK to open the Attribute Editor in edit mode so that you can make changes to the attribute. This implies. Datasets define which information the Intelligence Server should retrieve from the data warehouse or cache. When there are multiple datasets in a document, the grouping and sorting dataset is the one that is bolded in the Dataset. Attribute_ID1 = “,A1,” AND a11. ACTION: This issue has been addressed in MicroStrategy 10. 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. In the Gallery, click Compound Grid . 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. All placeholders must begin with #0 and increase in increments of 1. Multiple elements are highlighted when using an attribute with compound key as a selector in Visual Insight and MicroStrategy Web 9. KB6669: How to create dynamic date filters on time attributes other than Date using custom SQL. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence; Multi-Cloud. Hover over the Properties column and click Open Intelligence Server Administration Portal . This URL executes a report with one prompt. This knowledge base article documents the process of creating compound keys for attributes in MicroStrategy Developer 9. 0 or above. Currently the DIM_DATE. As you type, matching objects, such as attributes. Reports are now available to use and interact with in MicroStrategy Library: View standard reports in MicroStrategy Library to get a simple, grid view of data. This visualization allows you to create a grid that analyzes different aspects of data across a common dimensions or attributes in rows. When trying to use a selector based in a compound attribute, in MicroStrategy Mobile 10. We're sorry. For examples of joining datasets, see Defining a dataset as primary or secondary and Joining multiple datasets: Examples. DaysBetween(DIM_RELEASE_DATE. Automatic attribute role recognition, where you create multiple attributes that have the same lookup table and allow MicroStrategy to automatically detect the multiple roles. This implies that more than one ID column is needed to uniquely identify the elements of that attribute. A Compound Grid stitches multiple simple Grid visualizations together to provide a more holistic grid view with richer data insights. Go to Smart Attribute blade on the Attributes Editor. A sample report is: Attributes: Metadata, Project, Object, Object Type, Component Object Type. When trying to use a selector based in a compound attribute, in MicroStrategy Mobile 10. Only two leading objects are defined in the query language. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. This design may look strange, but in most cases there are sound. Each attribute form must have at least one expression. For example, the Customer attribute in the MicroStrategy Tutorial project has the five attribute forms shown below: Of these five attribute forms, only Last Name has a default report sort order defined. Once these Logical views are created, they are available to. 1 where when a Compound Attribute containing a Date Format ID is used as a dynamic textbox on a Flash document, the exporting does not format correctly when exported to a Flash MHT file. The attribute level follows a consecutive order from. 11 a change is being made to the default value of the use lookup for attributes function parameter when making metrics. 4. The Profit metric is a simple sum of the Profit fact. Put the attribute in the columns, then right-click and select "Create Groups. There's a reason we're at the top of the list. It is. Any time you type an attribute whose name contains one or more spaces, the attribute must be enclosed in square brackets. 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. Click User Manager . Form groups in Microstrategy - Form groups in Microstrategy courses with reference manuals and examples pdf. The targeted grid will show no value no matter the attribute and the metric in the grid is related to the group by attribute or not. Four types of direct relationships can exist between related attributes, and these relationships are defined by the attribute elements that exist in the related attributes. 0:50. Select Custom as the Category and create the format using the number format symbols listed in the table below. The report-related objects placed on the template. Compound metric C is made up of two metrics A and B with expression (A+B). You can connect MicroStrategy reporting tool with any data, including big data, flat files, social media data, and. Therefore, more than one column is needed to identify that compound attribute distinctively. You can also apply a set of color and shading schemes to all the objects on a graph report. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. Count of Parents in Platform Analytics: There is an OOTB metric called Objects, which calculates the parents of a component object. e. compound attributes. 4. The ApplyOLAP function is used to define compound metrics. This URL executes a report with one prompt. a) Attribute form qualification Filters data related to a business attribute’s form(s), such as ID or. Total (profits/unit sold) Smart Metrics: Total (profit)/ Total (sold) 8) Mention what types of testing can be carried out over the Microstrategy reports? Microstrategy can carry out test like • Naming convention tests • Total calculations test • SQL query validations • Attribute and metric. A compound attribute is defined as an attribute with more than one column specified as the ID column. The Create New Attribute Form dialog box now appears. This implies that more than one ID column is needed to uniquely identify the elements of. DATE and DIM_RELEASE_DATE. This article notes a limitation of mapping MDX attributes to schema mapped attributesFor example: Simple or Compound Metrics . In MicroStrategy SQL Generation Engine, when simple Period to Date (PTD) reports are needed, there is no need to create a transformation table. MicroStrategy needs to be explicitly told that there is a Many-1 relationship between Location and Airport, which can only be done by creating them as two separate attributes. There are several ways to create and apply filters to individual chapters, multiple chapters, or across an entire dossier. Use "Access External Data" feature in MicroStrategy Web 10 to import data. 3. MicroStrategy is a business intelligence tool, that supports interactive dashboards, highly formatted reports, scorecards, alerts, ad hoc queries, automated report distribution, thresholds, etc. The metric values roll up to the new attribute level of the grid. Compound Attribute: A compound attribute is an attribute whose primary key is made up of the combination of two or more columns. Prompt-in-prompt is a feature in which the answer to one prompt is used to define another prompt. If a message is displayed asking if you want to use read only mode or edit mode, select Edit and click OK to open the Attribute Editor in edit mode so that you can make changes to the attribute. 0: Profit/Revenue. Type the number of elements to display at one time and click OK. This is a compound metric that calculates the percentage change between the previous row and the current row. Now Edit the "Revenue for Books metric and Replace Category@ID with this new Books metric formula would looks like this Case ( (Books = 1), Revenue, 0. x and 10. create 2 similar region prompt ( call it region 1 & region 2) now create 2 revenue metric , region1 revenue ( with region 1 prompt in filter) and region 2 revenue ( with region 2 prompt in filter) in custom group band could be like following YY - region1 revenue > 0 AND region 2 revenue > 0. For example, consider the relationship between three attributes: Promotion, Item, and Quarter. 4. Under 'Source tables', select a table and click 'Set as Lookup'. If the database platform does not support COUNT on concatenated strings, this property should be disabled. Attribute forms. In the report, the attribute with the compound key is Distribution Center. The multiple columns are joined with other attributes, typically in a many-to-many relationship. In MicroStrategy Web, click the metric for which you want to enable a grand total or subtotals. The attribute editor allows users to create attribute forms, connect attributes to logical tables in the schema, and edit form expressions. To view the various properties of an attribute in Architect, from the Attributes tab of the Properties pane, select the attribute from the drop-down list. These settings affect how MicroStrategy Intelligence Server manages joins, metric calculations, and query optimizations, among other options. Select Category and Quarter from the Available attributes list and click > to add them to the Selected attributes list. When the 'Customer' attribute is removed from the grid, the newly created metric dynamically shows the distinct count of customers at the Day, Region level as s hown below. For instance, the attribute City may be defined in the data model as a combination of COUNTRY_ID and. . (Optional) Use the Up and Down. You cannot change the join types of. Micro Strategy also supports mobile BI. For the Time hierarchy, the offset can. Click here to view help for the latest version of this product or search MicroStrategy Community. To create a compound key (composite key), users. MicroStrategy is a business intelligence tool, that supports interactive dashboards, highly formatted reports, scorecards, alerts, ad hoc queries, automated report distribution, thresholds, etc. Users can also create compound attributes, define attribute relationships in the system hierarchy and modify display and sort forms. 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. 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. When evaluating compound metric expressions in SQL, a null value from one of the component metrics may cause the entire expression to evaluate as null -- NULL. 1/10. The attributes and metrics appear as filters. On each column set, add at least one attribute. You can use the AppleSimple function to insert database-specific functions and simple operators directly into SQL. Attributes give users context for reporting on and analyzing data. A percent-to-total shortcut metric displays the percent in relation to a selected total of each item affected by the metric. The multiple columns are joined with other. x? Number of Views 6. You can create them in a report,. An attribute form on the parent attribute also appears on the child attribute. Upgrade to MicroStrategy 11. x and 10. In the MicroStrategy Tutorial project, Distribution Center is an example of a compound attribute. We are trying to calculate the Days Between DIM_RELEASE_DATE. Slice your data into columns of graphs. To display a title bar, do the following: Set Show title bar to True. Count Compound Attribute is an advanced property that is hidden by default. Once you have the group made, then just drag in the original attribute under it. You can format a graph report by adjusting colors, and applying a variety of graphical effects, including gradients, transparency, patterns, pictures, textures, and bevel effects. Function. For example, the attribute name (original object name) is called, Category. Compound Metrics. This article describes why an attribute with a compound ID may fail the execution of a dossier if the compound ID has locale sorting that is inconsistent with the order by the. In Microstrategy, the lookup tables represent the attributes. The intersection of two sets yields a TRUE value only when both sets of filtering. In the top toolbar, click Insert Visualization . MicroStrategy builds the rules that MicroStrategy SQL Engine uses to generate SQL when a report request is made. 78K. These privileges are part of OLAP Services. VLDB properties allow you to customize the SQL that MicroStrategy generates. In MicroStrategy Workstation, architects can create and edit attribute objects. Compound Attribute Date ID forms do not format correctly when ran correctly in Flash in MicroStrategy Web. x. Compound Metric; Steps to Reproduce. MicroStrategy interfaces include desktop (for developers), web, Microsoft Office integration as well as Mobile Applications. In the visualization's Editor panel, right-click the attribute to group and choose Create Groups. An attribute form expression defines what columns in the warehouse are used to represent the attribute form in SQL. Usually this is the attribute to which the form belongs (i. Example for this can be a database of airports around the world. . MicroStrategy Command Manager automates maintenance and other administrative operations using simple text-based commands. 1 : In the Project Creation Assistant, click Create attributes. Click OK. From within a blank report in MicroStrategy Tutorial, double-click inside the Report Filter pane. intermediate object}. Attribute_ID1 = “,A1,” AND a11. In MicroStrategy Developer, open the folder that contains the attribute to modify. 1 where when a Compound Attribute containing a Date Format ID is used as a dynamic textbox on a Flash document, the exporting does not format correctly when exported to. Create a Report Services Document 2. Using the description tables and Ids, the attribute information is stored. This has been identified as a defect in MicroStrategy Web 10. tailing_objectleading_object{. For example, you create an attribute called Customer to represent customers in your. In the MicroStrategy Tutorial project, Distribution Center is an example of a compound attribute. The compound join saves memory space and processing time on the Intelligence Server executing the document. Important: Parts of a compound attribute cannot be omitted. x and 10. Setting a join specification allows you to place conditions on the data selected for display in a report. MicroStrategy is an enterprise BI application software. In MicroStrategy 2020, the Compound Grid was introduced in dossier authoring. In MicroStrategy Workstation, architects can create and edit attribute objects. A compound attribute is one that uses two or more columns as its ID. The operators and functions of a compound metric can be applied to facts, attributes, or metrics within the compound metric. Mapping geo attributes. Attribute forms contain additional descriptive information about a given attribute. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Compound Grid visualizations. Users can also create compound attributes, define attribute relationships in the system hierarchy and modify display and sort. x-10. The MicroStrategy 8 - Advanced Reporting Guide provides comprehensive information on advanced topics in the MicroStrategy query and reporting products. Transformations allow you to apply an attribute-element based offset to compare metric data. To enable totals or subtotals for a metric. Add the metric from Step 2 to the report shown above. MicroStrategy Web. 1. e. In MicroStrategy Developer, open the folder that contains the attribute to modify. 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. Follow the steps below to display row numbers in one column on the report in MicroStrategy Developer 9. A derived metric is a calculation based on metric data included in the report definition. You need the Create Derived Metrics (MicroStrategy Developer) and/or the Web Create Derived Metrics and Derived Attributes (MicroStrategy Web) privileges to create derived metrics. Create a new attribute form without the undesired source table. Make B and C parents of a new compound attribute using both columns as its ID with A B and C as its parents. To specify a transformation, double-click it in the Object Browser to add it to the Transformations definition pane. In the relational database. You can use derived metrics to. Attribute forms are identifiers or descriptors of an attribute, such as ID, Name, and Address. Primary Key – is a column or group of columns in a table that uniquely identify every row in that table. In fact. 4. MicroStrategy provides two types of attributes: normal attributes and hierarchical attributes. 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 Desktop 2020 you can only use attributes in rows. xA connection map in MicroStrategy is a link between a MicroStrategy user, a database connection, and a database login. Foreign Key. If the base metrics are selected to return to the end user in the same pass that calculates the compound metric, since the temporary tables containing data for base metrics are full outer joined, as long as an element has value for either of the base metrics, the row appears in the final grid view. The compound join saves memory space and processing time on the Intelligence Server executing the document. In the MicroStrategy Tutorial project, for instance, if a report includes only the Category attribute, report level metrics could use the YR_CATEGORY_SLS table. Attribute name:XXXX" is thrown after attempting to map a compound key attribute to SAP properties in MicroStrategy Analytics Enterprise. The presence of a compound key relationship is. The ApplyAgg function itself is a group-value function and accepts facts, attributes, and metrics as input. Drag an attribute from the Datasets panel to the Rows area of the Editor panel. ApplyAgg() Accepts facts, attributes, and metrics as input. Create an Attribute Open the Workstation window with the Navigation pane in smart mode. Click the check mark symbol on the right of the drop-down. This function is an OLAP function. metrics (list or None, optional): ID numbers of metrics to be included in the filter. Metrics can be calculated to any attribute level in Report Objects regardless of whether that attribute is on the report template. Creating attributes with multiple ID columns: Compound attributes. If information about a. 4. Compound attributes are usually counted by concatenating the keys of all the attributes that form the key. Related articles from the Community: Knowledge Base: How to create a derived metric in MicroStrategy Developer 9. The Attribute Creation Wizard opens,. Open MicroStrategy Web. Micro Strategy also supports mobile BI. A normal attribute represents a single hierarchy level (for example, Month). In this case, enter 'Date@ID'. Example:. x?; Knowledge Base: How to concatenate two. In this case, you would create a dummy derived attribute. 1 where when a Compound Attribute containing a Date Format ID is used as a dynamic textbox on a Flash document, the formatting will not show correctly when viewed. To determine which attribute forms to display to the user. You. 32. Here is the workaround to achieve the attribute left outer join on MicroStrategy Web. Want to learn more? Check out my Architect co. Attribute T contains an element t1. Now to fix this create a new Derived metric on Category attribute first with formula as Max (Category) {~ } and calling Books. Attribute forms are defined by at least one expression, and these expressions act on column data and can contain functions. Count of Parents in Platform Analytics: There is an OOTB metric called Objects, which calculates the parents of a component object. Using a combination of filters and metric dimensionality, the same results can be achieved. Introduced in MicroStrategy 2020, the Compound Grid is especially useful for financial analysis when you need to analyze several KPIs across a common dimension, like investment vehicle or region. MicroStrategy recommends to have only one child at the lowest level. 4. When they do appear, report designers have some degree of control over the subquery syntax using the Very Large Data Base (VLDB. Configuration Objects:. You must create a compound attributes when an attribute requires two or more columns to uniquely identify its elements. Each type is described below: . Click the visualization to add the group to. The Metric Options dialog opens. 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. When the attribute used as a selector has a compound key, i. To do this: a. x, if there are any compound metrics included in the interface, users may click on the word Metrics, and that will break down all compound metrics into its constituent simple metrics. Quite often these attributes have automatic mapping for one ID and manual. For instance, the attribute City may be defined in the data model as a combination of COUNTRY_ID and CITY_ID. Select Joint Element List from the Option pull-down list. Select a Form category, Display type and Default sort from the lists. There's a reason we're at the top of the list. A compound attribute has its value resolute by an expression that join two or more columns in a database to make a new column. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformAttribute T contains a form called "email" whose values are email addresses that will be used in the dynamic subscription in Narrowcast. You must create a compound attributes when an attribute requires two or more columns to uniquely identify its elements. Set the qualification type to 'Custom'. What is compound and smart metrics?. Answer / nadia sheikh. This is a filter which contains a prompt on an attribute element list. Each graph appears in a separate row, one for each element in the attribute. In MicroStrategy Desktop/Developer 9. In MicroStrategy, create an attribute that can return all the location data for each entry. A sample URL that answers an element prompt when the attribute has a compound ID is shown below. When generating the SQL for the report containing such a metric, the subquery will only perform the max or min on the first ID in the attribute ID form. 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. Attributes can have many descriptors, or forms, shown as distinct columns that are. What is a compound attribute in Microstrategy? A compound attribute has its value determined by an expression which combines two or more columns in a database to create a new column. This technote describes a current defect in MicroStrategy Distribution Services 9. In Visual Insight in MicroStrategy Web 9. What is a compound attribute in Microstrategy? A compound attribute has its value determined by an expression which combines two or more columns in a database to create a new column. ESRI attributes such as latitude and longitude, zip code, state, city,. 09%) is another ROIC powerhouse with rock-solid demand stability and a balance sheet that supports continued dividend growth. There's a reason we're at the top of the list. For example, in a schema where Store is a compound attribute with Region-Market-Store, and the. Select Add an Advanced Qualification and click OK. Sometimes you don’t have all the columns that are necessary for creating your visualizations. For more information on VLDB properties, refer to the. This visualization allows you to create a grid that analyzes different aspects of data across a common dimensions or attributes in rows. An additional modeling convention is to add unique identifiers for each attribute and fact. Generally, you create a compound attribute when your logical data model reflects that a compound key relationship is present. Here the many-to-many relationship is converted into a compound attribute relationship. Count Compound Attribute. Whenever the attributes in Report Objects are not the same as the attributes on the grid, dynamic aggregation has occurred. Find the attribute Ship Date in the Object Browser (in the Customer hierarchy) and drag it to the Attribute field. Here the many-to-many relationship is converted into a compound attribute relationship. It is derived based on a count against the fact_object_component table. Drag at least one attribute to the top of the Vertical area. Open the dossier you want to modify. 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. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. The boolean datatype should be seen as "Unknown"; it is not natively supported by MicroStrategy 9. Press and hold the Ctrl key to select multiple attributes or metrics. Compound attributes. e. The Allow URLs to Export setting allows administrator's to specify the only URLs and URL paths that can be exported to PDF or Excel. To create a compound key (composite key), users. 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. the report designer in a way similar to any other table. microstrategy; or ask your own question. 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. A split hierarchy is one - that at the lowest level - has more than one child. A user with a security filter on Call Center would not be able to use this table because the security filter cannot be written against it. Smart totals define the evaluation order. Users can also create compound attributes, define attribute relationships in the system hierarchy and modify display and sort. Drag an attribute or metric from the Datasets panel to the Columns Set area in the Editor Panel. To uniquely identify a distribution center, one must know two details about the distribution center: the ID. What is a Implicit Attribute? An implicit attribute is a virtual or constant attribute that does not physically exist in the database because it is created at the application level. To uniquely identify a distribution center, one must know two details about the distribution center: the ID of the distribution center and the country in which it. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. 4. An input box will be displayed with a list of recommended questions based. The Category attribute of the MicroStrategy Tutorial project shown below is used as an example of how you can modify and view attributes using Architect. Attribute_ID2= “,B1,”)”). Double-click the attribute to edit. The Compound Grid is a new visualization introduced in the MicroStrategy 2020 release. Follow the steps below. To toggle smart metrics on and off, use the checkbox (Allow Smart Metric) at the bottom of the Subtotals/Aggregation tab in the Metric Editor. In MicroStrategy Web 2020, create a dossier with a Compound Grid visualization. What are Configuration Objects? Configuration objects are MicroStrategy objects which can be re used in multiple projects and they appear in the. WORKAROUND: Instead of using the formula editor, type in the formula expression manually and it will validate. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. Steps to Create Smart Attributes. You are returned to MicroStrategy Developer. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. This version of the product is no longer supported in accordance with MicroStrategy's support lifecycle. Also, you add both attribute IDs, in this case Item_ID and Color_ID, to the fact table as shown in the following diagram. Select Manual from the Aggregation and Subtotal Behavior drop-down. Connection mapping allows administrators to assign a user or group in the MicroStrategy system to a specific login ID on the data warehouse. KB4641: How to set up a Compound Key for an attribute in MicroStrategy Developer 9. In the right corner of the dashboard, change the. For information on training metrics and creating predictive.