Super Cubes are simply a renaming of what was previously referred to as MTDI (Multi Table Data Import) Cubes. Right-click the table, point to Recognize, and then select Attributes. Note that for rule 2, there are three levels in which an attribute names can be defined in the product: at the individual attribute object level (applicable to project schema attributes), at the report or cube level, and at the level of the dossier (via the Datasets panel). In both a Grid and a Compound Grid, checking multiple attribute display forms and displaying attribute form names will cause the enabling or disabling of other attribute's subtotals. To determine which attribute forms to display to the user. (15-minute smart attribute is always required by default, if any smart attribute is checked) You can rename the time attributes or apply default sorting for each smart attribute. What is compound and smart metrics?. 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. A compound attribute has its value resolute by an expression that join two or more columns in a database to make a new column. Passing prompt answers for an element prompt when the attribute has a compound ID. In MicroStrategy Workstation, architects can create and edit attribute objects. Microstrategy is based on single meta-data repository; Microstrategy can be operated as web based and a desktop tool; There is no cube data-set for Microstrategy, and we obtain latest data-set from data-warehouse automatically; Microstrategy reporting is fast; Cognos has two meta-data repository based database; It can be used as web-base. This implies that more than one ID column is needed to uniquely identify the elements of that attribute. 0-10. Attribute forms are identifiers or descriptors of an attribute, such as ID, Name, and Address. Press and hold the Ctrl key to select multiple attributes or metrics. 4. DATE ie. Steps to Create Smart Attributes. Use a Comparison KPI to indicate the progress towards an objective, like sales and goal. 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. DATE and DIM_RELEASE_DATE. Natural Language Query (NLQ) allows end users to build dossiers and get insights just by typing questions. Quite often these attributes have automatic mapping for one ID and manual. The Compound Grid is a new visualization introduced in the MicroStrategy 2020 release. Click Insert Visualization . Generally, you create a compound attribute when your logical data model reflects that a compound key relationship is present. This 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. Depending on your MicroStrategy product and licensing, this function may not be available. The MicroStrategy SQL Engine does not require a pure dimensional model and has built-in support for many constructs that are typical in Entity-Relationship (ER) schemas such as compound keys, many-to-many relationships, fact. This case is also explained with an example based on the MicroStrategy Tutorial project. A compound attribute is defined as an attribute with more than one column specified as the ID column. To create a compound key, users must create multiple attribute forms, group them together and set the form group as the key. Might need to play with formatting to make sure. Define the statistics and enterprise warehouse database. If you know of better/faster ways, please share. 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. Starting in MicroStrategy 11. For instance, the attribute City may be defined in the data model as a combination of COUNTRY_ID and CITY_ID. Open the dossier you want to modify. Follow the steps below to display row numbers in one column on the report in MicroStrategy Developer 9. Click All Objects View. 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. This article describes the purpose of the Sub Query Type VLDB property in MicroStrategy. MicroStrategy Command Manager automates maintenance and other administrative operations using simple text-based commands. The Create New Attribute Form dialog box now appears. Here is the workaround to achieve the attribute left outer join on MicroStrategy Web. The Metric Editor opens in either Function Editor mode or Formula Editor mode, depending on the type of metric you chose to edit. Check other tables and select/deselect correct tables. 1 and 10. 4. Derived Attributes A derived attribute has its value determined by an expression which combines two or more columns in a database to create a new column. A compound attribute is an attribute with multiple columns specified as the ID column. We decided to gather them in one placing using our experience and MicroStrategy materials. The Group Editor opens. Example:. Micro Strategy also supports mobile BI. For example, consider the relationship between three attributes: Promotion, Item, and Quarter. For example, the form expression for the Customer First Name attribute form is CUST_FIRST_NAME. Create an Attribute Open the Workstation window with the Navigation pane in smart mode. Subqueries (or correlated subqueries) are used infrequently but significantly in the MicroStrategy SQL Generation Engine. Create your metric's formula. Set the qualification type to 'Custom'. Arithmetic operators are +, -, *, and /; non-group functions are OLAP and scalar functions such as running sum or rank. 1, an attribute in a grid can be used as selector to target other grids in the same dashboard. To uniquely identify a distribution center, one must know two details about the distribution center: the ID. For example, in the MicroStrategy Tutorial project, the Time hierarchy includes relationships between the attributes Year, Quarter, Month of Year, Month, and Day. it is the same as the Attribute property). Steps to Reproduce on a Compound Grid. A Compound Grid stitches multiple simple Grid visualizations together to provide a more holistic grid view with richer data insights. How to create a conditional attribute in MicroStrategy Desktop. Turning on totals returns a row for the total, even though there are not rows of data to show. In addition, this release introduces new features across the analytics, mobility, and security platforms—making it easier for users to build applications faster. This section focuses on the VLDB properties that are set at the metric and report level. Any time you type an attribute whose name contains one or more spaces, the attribute must be enclosed in square brackets. This feature is only implemented for element list prompts. Attribute form: contains an identifier or descriptor of an attribute. Type the number of elements to display at one time and click OK. 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 exists. Several non-group functions that are. Passing prompt answers for an element prompt when the attribute has a compound ID. Option A 1. Using this grid, you can have multiple unrelated attributes and metrics in different sets of columns that are stitched together. Choose one of the following options: To display all of the attribute's elements to the user when they are answering the prompt, select List all elements (no restriction). The goal is to create an image link that is used to export the grid, like shown below: Document in Edit Mode Follow the steps below: 1. 32. (The use of brackets around compound object names is standard for many objects in MicroStrategy and is not restricted to custom expressions and Apply. Set Data Engine Version setting to 11 or above. Make two grids with different attributes and metrics in each 3. Metrics can be calculated to any attribute level in Report Objects regardless of whether that attribute is on the report template. In the report, the attribute with the compound key is Distribution Center. Select Joint Element List from the Option pull-down list. 939 views 3 years ago. The smart metric property of a compound metric allows the user to change the default evaluation order of the metric. In fact. A sample URL that answers an element prompt when the attribute has a compound ID is shown below. This implies that more than one ID column is needed to uniquely identify the elements of that attribute. In MicroStrategy, create an attribute that can return all the location data for each entry. The Compound Grid is a new visualization introduced in the MicroStrategy 2020 release. Compound Metric; Steps to Reproduce. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. A sample report is: Attributes: Metadata, Project, Object, Object Type, Component Object Type. 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. An attribute-to-attribute qualification can compare the City form of both attributes to display only the Call Centers and Customer Cities that are in the same city. MicroStrategy interfaces include desktop (for developers), web, Microsoft Office integration as well as Mobile Applications. The Metric Editor opens in either Function Editor mode or Formula Editor mode, depending on the type of metric you chose to edit. A compound key attribute is an attribute whose primary key is made up by the combination of two or. Open MicroStrategy Web. When naming a MicroStrategy object, you must follow the naming convention rules for your particular database platform. Syntax . Some formulas expect related attributes to exist on the template, and they will return incorrect results (or an error) if the attributes are omitted; other. This implies that more than one ID column is needed to uniquely identify the elements of that attribute (see Attributes with multiple ID columns: Compound attributes). These units are part of an attribute, for example, Customer. The Transformations definition pane displays below the Metric component pane. To display a title bar, do the following: Set Show title bar to True. Modify the Address form so that it has a descending report sort order. intermediate object}. In this case, enter 'Date@ID'. Create a compound metric called B with expression "RunningSum(A)" as shown below. Open attribute editor (right-click on attribute and. In the relational database. Therefore, its ID form maps to a combination of columns. Here is the workaround to achieve the attribute left outer join on MicroStrategy Web. Open a dossier. Users can also create compound attributes, define attribute relationships in the system hierarchy and modify display and sort forms. tailing_objectleading_object{. If ReportLevel includes all the attributes on the template and in the report objects window, and ViewLevel includes only the attributes on the template, then the following is an example of how dynamic aggregation would apply to a smart metric. A compound key attribute is an attribute that has two or more IDs. metrics (list or None, optional): ID numbers of metrics to be included in the filter. In MicroStrategy Workstation, architects can create and edit attribute objects. HistogramMedian. It is used to apply database (row-level) security to a MicroStrategy user. 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. Dataset DS2 with attribute 'Year' and metrics 'Revenue', 'Profit', 'Profit Margin' (this is a compound smart metric calculated from metrics Revenue and Profit). Surrogate Key. Enter a Form name and Description. Types of filters in Microstrategy Below are the types of filters: 1. In-line M-M Relationships: Explanation. The attributes Customer City and Call Center are enclosed in brackets. MicroStrategy ONE introduces new features that provide better performance and scalability to enhance the overall user experience. A compound attribute is defined as an attribute with more than one column specified as the ID column. e. To uniquely identify a distribution center, one must know two details about the. Currently, all connectors in MicroStrategy Web 10 except "OLAP" and "Search Engine Indices" support Multi-Table Data Import. 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. Derived Attributes. Hierarchy 2: 4. In the list of categories on the left, click Subtotals. 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. A compound key attribute is an attribute that has two or more IDs. This tutorial shows how to create derived attributes and metrics in a dossier. x-10. To enable totals or subtotals for a metric. Therefore, its ID form maps to a combination of 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. When there are multiple datasets in a document, the grouping and sorting dataset is the one that is bolded in the Dataset. . 1 - 10. x? Number of Views 6. Various types of attributes in Microstrategy desktop include, Implicit Attributes; Compound Key Attribute; Derived Attributes; Simple Attribute; 23) Mention what is the difference between Custom group and Consolidations? Custom group Consolidations; A custom group is a set of filters that can be placed on a template. In the Datasets panel, double-click attributes and metrics to add them to the visualization. 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. When there are multiple datasets in a document, the grouping and sorting dataset is the one that is bolded in the Dataset. By choosing Automatic, if the largest table is >= 1M rows, MicroStrategy will choose the attribute. Multiple elements are highlighted when using an attribute with compound key as a selector in Visual Insight and MicroStrategy Web 9. Composite Key. The compound join saves memory space and processing time on the Intelligence Server executing the document. (The use of brackets around compound object names is standard for many objects in MicroStrategy and is not restricted to custom expressions and Apply. leading_object{. MicroStrategy Internal Reference number for this technical note is KB483638 and US144497. 3. 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. Add a compound attribute, For instance "Seasons", to Page-by and enable subtotal for the report. e. You can connect MicroStrategy reporting tool with any data, including big data, flat files, social media data, and. 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. database column=2E Its a relational database thing, enabling high=. Open a report in MicroStrategy Developer. Allows you to choose whether you want to use the metric name as the column alias or whether to use a MicroStrategy- generated. Quite often these attributes have automatic mapping for one ID and manual mapping for the other one. Some of the main features offered by MicroStrategy are Advanced Analytics, Data Discovery, Data Visualisation, Embedded BI, and detailed reports and statements. In the list of categories on the left, click Subtotals. Update:1 Answer. In simple words, Metadata could be considered as the heart of MicroStrategy environment. microstrategy attribute selector values wtd mtd qtd ytd An alternative approach, which meets the time period requirement and reduces the time to market of the analytical application is creating a Custom Group with the time periods, then using a selector on the Report Services Document to filter the data by the time periods. Select a Form category, Display type and Default sort from the lists. or. In the list of categories on the left, click Subtotals. When trying to use a selector based in a compound attribute, in MicroStrategy Mobile 10. There's a reason we're at the top of the list. ". Visit the data visualization and data dashboard galleries for inspiration. The Metric Editor opens. In this case, enter 'Date@ID'. These functions can be used in a MicroStrategy expression as follows, take ApplySimple function for example, create a metric using expression below (Average and Avg are existing. Setting a join specification allows you to place conditions on the data selected for display in a report. Create compound attributes. Generally, you build a compound attribute when your logical data model reflects that a. Click the Add icon to the right of the Element list. An in-line many-to-many relationship involves an attribute with at least one parent and one child. Attribute elements, or the actual data values for an attribute, dictate the relationships that you define between attributes. The following procedure describes how to achieve this: Create the highest level filter. Here the many-to-many relationship is converted into a compound attribute relationship. Navigate to the Schema Objects folder, open the Attributes folder, and then the Geography folder. Create the following objects: a. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. In order to have a derived metric that can source from the join of multiple datasets a simple compound metric can be. Change Qualify on to ID. A compound attribute is an attribute that consists of more than one atomic attribute through an object join or member terminals that use dot notation. Problem. February 19, 2009 Architect, MicroStrategy Compound Key Attribute Sorin Suciu. In this article, we clarify your questions regarding Pattern Matching and how it is different from the standard Keyword Matching. Drag attributes or metrics from the Datasets panel to the Filter panel. ) In the metric formula, the desired output dimensionality is given. In Desktop 2020 you can only use attributes in rows. Go to Data > VLDB Properties > Joins > "Preserve all final pass result elements. A hierarchical attribute represents an entire hierarchy and its levels (for example, Time includes levels of Year, Quarter, Month, and Day). 4. This technote describes a current defect in MicroStrategy Distribution Services 9. intermediate object}. The Metric Names attribute automatically appears in the Editor panel. You can also apply a set of color and shading schemes to all the objects on a graph report. One-to-one: Each element in the parent attribute corresponds to one and only one element in the child attribute, and each child attribute. Attributes are defined by these properties: •. An attribute form expression defines what columns in the warehouse are used to represent the attribute form in SQL. Rather than creating attributes by manually creating an attribute expression, you can allow Architect to automatically create simple attributes defined on one column. For example, you create an attribute called Customer to represent customers in your. Smart metrics calculate subtotals on individual elements of the compound metric. Therefore, if a base metric appears in the template, Metric. Creating calculated expressions. Use "Access External Data" feature in MicroStrategy Web 10 to import data. To create a list of attribute elements from which users can choose, select Use a predefined list of elements. The operators and functions of a compound metric can be applied to facts, attributes, or metrics within the compound metric. In the Actions column, select the Edit icon for the user to modify. 4. An implicit expression is required for creating such an attribute. Insert an HTML container (and not an image) and insert the script below. To Create an Attribute-To-Attribute Qualification Filter. II. 2, the selector will not work if using the Include option for the selector. For instance, the attribute City may be defined in the data model as a combination of COUNTRY_ID and CITY_ID. Scenario: Attribute1 is a compound key attribute with a ginormous number of values. This article notes a limitation of mapping MDX attributes to schema mapped attributes For example: Simple or Compound Metrics . Create a compound metric defined as the division of the two metrics created previously, and configure it to be a smart metric, leaving the 'Dynamic aggregation function' as 'Default' as shown below: Create a report with the attributes Region, Month of the Year, and Category and the compound metric created before. The Compound Grid is a new visualization introduced in the MicroStrategy 2020 release. Attribute qualification filter These types of qualifications restrict data related to attributes on the report. Set qualifications. J2EE environment:A metric is a compound metric if it consists of two or more existing metrics joined by an arithmetic operator (+, -, *, and /). I have a metric A = Avg(0. a) Attribute form qualification Filters data related to a business attribute’s form(s), such as ID or description. This implies, of course, that more than one ID column is needed to uniquelyidentify the elements of that attribute. x and 10. Compound attributes. 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. For example, a transformation metric can help a user compare last month's revenue to this month's revenue. member_terminal. In the right corner of the dashboard, change the. 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. Select Custom as the Category and create the format using the number format symbols listed in the table below. If the database platform does not support COUNT on concatenated strings, this property should be disabled. Multiple elements are highlighted when using an attribute with compound key as a selector in Visual Insight and MicroStrategy Web 9. x There may be instances when it is necessary to include an attribute form in a derived or a compound metric in order to carry out calculations based on the form value in MicroStrategy Developer 9. This implies, of course, that more than one ID column is needed to. 2. Attribute name:XXXX" is thrown after attempting to map a compound key attribute to SAP properties in MicroStrategy Analytics Enterprise. Attribute having more than one ID from category. The implicit attribute has its own expression. 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. Compound Attribute: A compound attribute is an attribute whose primary key is made up of the combination of two or more columns. Related articles from the Community: Knowledge Base: How to create a derived metric in MicroStrategy Developer 9. 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. Find the attribute Ship Date in the Object Browser (in the Customer hierarchy) and drag it to the Attribute field. xOnly attributes in the WHERE clause are considered true filters, in the sense that they restrict the data set prior to producing the aggregated data. 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. Formula: Is a mathematical expression using one or more functions, applied to the data to be used in the calculation (facts, attributes, constants, or metrics). Syntax . To enable totals or subtotals for a metric. Metrics: Component Objects. For example, in a schema where Store is a compound attribute with Region-Market-Store, and the. 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. The resulting SQL will contain just the Metric Alias. x. Click More in the top right of the heat map and choose Create Contextual Link and select. Select Add an Attribute qualification and click OK. We are trying to calculate the Days Between DIM_RELEASE_DATE. What are Configuration Objects? Configuration objects are MicroStrategy objects which can be re used in multiple projects and they appear in the. Attributes are the business concepts reflected in your data. This has been identified as a defect in MicroStrategy Web 10. Whenever the attributes in Report Objects are not the same as the attributes on the grid, dynamic aggregation has occurred. To pass the prompt answer for an unanswered optional element prompt in the URL, you simply specify the AttributeID for the unanswered prompt, followed by a semi-colon, but do not include the AttributeElementID. Create and Edit a Visualization-Based Filter. Here the many-to-many relationship is converted into a compound attribute relationship. Create 2 datasets. Compound Key Attribute A compound key attribute is an attribute whose primary key is made up by the combination of two or. The attribute editor allows users to create attribute forms, connect attributes to logical tables in the schema, and edit form expressions. the report designer in a way similar to any other table. These commands can be compiled into script files and run from a graphical interface or from the command line. Each type is described below: . Click OK. Click OK. Video Tutorials. These privileges are part of OLAP Services. It is used with database-specific OLAP functions such as Rank(). A title bar allows MicroStrategy Web users to minimize and maximize the Grid/Graph, and it provides an identifier for the Grid/Graph in all views. Update:Unique identifiers. The Compound Grid supports similar operations as regular grids, such as:Relationship tables in Microstrategy. Apply Filter Changes. Attributes can have many descriptors, or forms, shown as distinct columns that are. The metric can also show a total by page, show a total for each value of the attribute, or show the grand. Note that only the naming convention has changed, as the functionality remains the same. If list is empty, no metrics will be selected. Follow the steps below. Consider the sales figures of your company. Example for this can be a database of airports around the world. Mapping geo attributes. Drag an attribute from the Datasets panel to the Rows area of the Editor panel. leading_object{. For this reason, a metric qualification in a filter is a type of set qualification. The 'Set as key' option is used for defining the lookup table primary key for the attributes when generating SQL with MicroStrategy Engine. We use MicroStrategy Tutorial tables that have the Month Id attribute and alter them. In MicroStrategy Workstation, architects can create and edit attribute objects. 1. 1 and 10. For example, consider the relationship between three attributes: Promotion, Item, and Quarter. How to include an attribute form in a compound or derived metric in MicroStrategy Developer 9. There may be instances when it is necessary to include an attribute form in a derived or a compound metric in order to carry out calculations based on the form value in MicroStrategy Developer 9. You can also access the Attribute Creation Wizard at any time in the development of a project from the Schema menu in MicroStrategy Developer. By default, the metrics Compound Profit and Profit Margin do not use a dynamic aggregation function. xattributes (list or None, optional): ID numbers of attributes to be included in the filter. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence; Multi-Cloud. You treat one attribute as a child of the other and have a compound key for the lower level attribute. 10) Define different types of attributes in Microstrategy desktop? Answer: Compound Key Attribute Implicit Attributes Derived Attributes Simple Attribute. There's a reason we're at the top of the list. It is derived based on a count against the fact_object_component table. Function. The time required for dependency checking varies based on a customer's metadata size and schema complexity. When they do appear, report designers have some degree of control over the subquery syntax using the Very Large Data Base (VLDB. In MicroStrategy Web, click the metric for which you want to enable a grand total or subtotals. tailing_objectleading_object{. In MicroStrategy Web, click the metric for which you want to enable a grand total or subtotals. Create an Attribute Open the Workstation. 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. This article does contain a solution. The only solution that I can think of is to create a FreeForm SQL Report. In the visualization's Editor panel, right-click the attribute to group and choose Create Groups. VLDB properties allow you to customize the SQL that MicroStrategy generates. Now to fix this create a new Derived metric on Category attribute first with formula as Max (Category) {~ } and calling Books. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in one. performance and data integrity=2E. You can re-use the same formula in multiple metric definitions. Count of Parents in Platform Analytics: There is an OOTB metric called Objects, which calculates the parents of a component object. An attribute form expression defines what columns in the warehouse are used to represent the attribute form in SQL. The multiple columns are joined with other. Workaround / Solution. Published: Sep 19, 2019Report will display result as below. Select Manual from the Aggregation and Subtotal Behavior drop-down. Drag an attribute or metric from the Datasets panel to the Columns Set area in the Editor Panel. These types of qualifications restrict data based on the value, rank, or percentage of a metric, or based on the relationships between the attributes on the report. Calculate each attribute individual weight according to the level in the hierarchy (level in hierarchy/number of levels in hierarchy * 10). The User Editor opens. To create a last year transformation based on an expression. Defining the partition for Super Cubes. KB6669: How to create dynamic date filters on time attributes other than Date using custom SQL. This design may look strange, but in most cases there are sound. In the report, the attribute with the compound key is Distribution Center. This article notes a limitation of mapping MDX attributes to schema mapped attributesA compound key attribute is an attribute whose primary key is made up by the combination of two or more columns. . Knowledge Base: Working with Compound Grids in MicroStrategy 2020;. For Compound Profit to be dynamically aggregated correctly, you change the dynamic aggregation function to Sum. Users can also create compound attributes, define attribute relationships in the system hierarchy and modify display and sort. 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. Attribute forms. You can use derived metrics to. It causes the SQL Engine to calculate for only the attribute elements that exist in both the lookup and fact tables. Logical Size in Microstrategy: The logical size of a table depends on the number of attributes in that table and position of that attribute in Hierarchy. In the top toolbar, click Insert Visualization . SUMMARY: This technote describes a current defect in MicroStrategy Web 9. In this case, Promotion has a many-to-many relationship to both Item and Quarter. b. multiple attribute forms conform the ID form, any element that matches at least one of the ID's will become highlighted, like shown below. Generally, you create a compound attribute when your logical data model reflects that a compound key relationship is present. We recommend the latest version. microstrategy; or ask your own question. SYMPTOM: In Visual Insight in. Want to learn more? Check out my Architect co. How to include an attribute form in a compound or derived metric in MicroStrategy Developer 9. ApplyAgg() Accepts facts, attributes, and metrics as input. 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. 2. The hyperlinks based on an attribute form compound by Applysimple no longer work when exporting to MHT in MicroStrategy 9. The graph legend or axes can be formatted as well. Creating Compound Attributes MicroStrategy Community 3. 11. 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.