In this case, the partition is defined by YEAR_ID and REGION_ID:. This implies. To add a filter: Open the dossier with the heat map visualization you created in How to Create Your Heat Map Visualization. Attribute T contains an element t1. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in one. Check other tables and select/deselect correct tables. This design may look strange, but in most cases there are. MicroStrategy is one of the leading business intelligence software that allows users to get some deep insights into the data trend by offering a plethora of analytical capabilities. In Desktop 2020 you can only use attributes in rows. Sometimes you don’t have all the columns that are necessary for creating your visualizations. Create a compound metric called B with expression "RunningSum(A)" as shown below. 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. I want to be able to make one graph that shows only customer types A, B and C, and a second graph on the same page that shows only customer type D. MicroStrategy AI is here. What is compound and smart metrics?. A sample URL that answers an element prompt when the attribute has a compound ID is shown below. 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. Attribute forms are identifiers or descriptors of an attribute, such as ID, Name, and Address. WORKAROUND: There are a couple of options to workaround this limitation. database column=2E Its a relational database thing, enabling high=. When there are multiple datasets in a document, the grouping and sorting dataset is the one that is bolded in the Dataset. 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. 11. Calculate each attribute individual weight according to the level in the hierarchy (level in hierarchy/number of levels in hierarchy * 10). An additional modeling convention is to add unique identifiers for each attribute and fact. Select Custom as the Category and create the format using the number format symbols listed in the table below. MicroStrategy ONE introduces new features that provide better performance and scalability to enhance the overall user experience. Create a Report Services Document 2. A compound key attribute is an attribute whose primary key is made up by the combination of two or more columns. The formula of a compound metric is based on arithmetic operators and non-group functions. To display a title bar, do the following: Set Show title bar to True. The intersection of two sets yields a TRUE value only when both sets of filtering. 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. This property is used to indicate when this occurs. Select the heat map visualization. In MicroStrategy Analytics Enterprise Web 10, users can now simultaneously import two or more tables from one or more supported data sources, this feature is called Multi-Table Data Import (MTDI). Metrics made up of metrics: Compound metrics. Compound Metrics. Arithmetic operators are +, -, *, and /; non-group functions are OLAP and scalar functions such as running sum or rank. In order to have a derived metric that can source from the join of multiple datasets a simple compound metric can be. SUMMARY: This technote describes a current defect in MicroStrategy Web 9. Below are the new features exclusive to. 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 executed in. Dynamic aggregation occurs when you move an attribute from the report grid to the Report Objects pane. A sample report is: Attributes: Metadata, Project, Object, Object Type, Component Object Type. It is derived based on a count against the fact_object_component table. This article notes a limitation of mapping MDX attributes to schema mapped attributesFor example: Simple or Compound Metrics . 1. Each type is described below: . Under 'Source tables', select a table and click 'Set as Lookup'. Place attributes Country and Distribution Center on report template, and the above metric either on report template, or in Report Objects window if you have an OLAP license. An attribute on a dossier serves as a label for a group of metrics. Follow the steps below to create a metric that counts the unique combination of two different attributes: 1. Therefore, its ID form maps to a combination of columns. A compound attribute is an attribute with multiple columns specified as the ID column. intermediate object}. The 'Set as key' option is used for defining the lookup table primary key for the attributes when generating SQL with MicroStrategy Engine. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. We're sorry. Select Add an Advanced Qualification and click OK. xA connection map in MicroStrategy is a link between a MicroStrategy user, a database connection, and a database login. a) Attribute form qualification Filters data related to a business attribute’s form(s), such as ID or description. For Compound Profit to be dynamically aggregated correctly, you change the dynamic aggregation function to Sum. The attribute editor allows users to create attribute forms, connect attributes to logical tables in the schema, and edit form expressions. Click the Add icon to the right of the Element list. A compound attribute is defined as an attribute with more than one column specified as the ID column. Update:Unique identifiers. The presence of a compound key relationship is. desired view using MicroStrategy, without DBA involvement. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. 4. 4. Due to how the editor works it is not possible to force this restriction upon creation. Under 'Source tables', select a table and click 'Set as Lookup'. Quite often these attributes have automatic mapping for one ID and manual mapping for the other one. Each type is described below: . Quite often these attributes have automatic mapping for one ID and manual mapping for the other one. When the attribute used as a selector has a compound key, i. Most attributes have at least two forms, ID and description (Desc). The corresponding attributes and metrics in this local schema only. Mapping is required only if you want to display areas on your map on a local server. In this case, Promotion has a many-to-many relationship to both Item and. The derived metric aggregates at the level of the attributes on the visualization by default. Each attribute form must have at least one expression. Function. For more information on VLDB properties, refer to the. An input box will be displayed with a list of recommended questions based. In the relational database. To determine which attribute forms to display to the user. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. A compound attribute is defined as an attribute with more than one column specified as the ID column. Attributes provide a context in which to report on and analyze business facts or calculations. Count of Parents in Platform Analytics: There is an OOTB metric called Objects, which calculates the parents of a component object. Also, you add both attribute IDs, in this case Item_ID and Color_ID, to the fact table as shown in the following diagram. 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. For instance, the attribute City may be defined in the data model as a combination of COUNTRY_ID and. We use MicroStrategy Tutorial tables that have the Month Id attribute and alter them. The dynamic aggregation itself is highlighted in red. Double-click the Column Set name to rename the set. 4. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. 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. You can connect MicroStrategy reporting tool with any data, including big data, flat files, social media data, and. For instance, the attribute City may be defined in the data model as a combination of COUNTRY_ID and CITY_ID. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. 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. Attributes with compound IDs are always showing the IDs with the elements when using the In List function for a View Filter in MicroStrategy Web 9. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence; Multi-Cloud. This article does contain a solution. Attributes are MicroStrategy objects that represent the business concepts reflected in your stored business data in your data source. You can also apply a set of color and shading schemes to all the objects on a graph report. Navigate to the Schema Objects folder, open the Attributes folder, and then the Geography folder. In MicroStrategy Web, click the metric for which you want to enable a grand total or subtotals. By ManishaGupta that reached out to me via. 12 String Functions are supported by the MicroStrategy Analytical Engine; however, the following functions can push down: Char. HistogramMedian. 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 MicroStrategy 2020, the metric guide is supported and will guide the Engine to retrieve the metric from the correct table. The time required for dependency checking varies based on a customer's metadata size and schema complexity. STEPS TO REPRODUCE: 1. For examples of joining datasets, see Defining a dataset as primary or secondary and Joining multiple datasets: Examples. 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. In the Datasets panel, double-click attributes and metrics to add them to the visualization. The following steps demonstrate how to design this kind of report in MicroStrategy Tutorial project as shown below:The Cognos reporting can be considerably slow in performance than the microstrategy reporting. A compound key attribute is an attribute that has two or more IDs. The attributes and metrics appear as filters. The Year - Define a new member attribute. This is a compound metric that calculates the percentage change between the previous row and the current row. 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. 10 : If you have additional descriptive information that you want to make available for display. Super Cubes are simply a renaming of what was previously referred to as MTDI (Multi Table Data Import) Cubes. 4. How to create a conditional attribute in MicroStrategy Desktop. 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. The prompt displays the related attribute elements for users to select their filter criteria from. In the pane, begin typing the metric formula. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in one. When naming a MicroStrategy object, you must follow the naming convention rules for your particular database platform. 4. x? Number of Views 6. Click Insert Visualization . Here the many-to-many relationship is converted into a compound attribute relationship. We recommend the latest version. In MicroStrategy Web, click the metric for which you want to enable a grand total or subtotals. Create a new dataset DS1:In MicroStrategy Web 9. Follow the steps below to display row numbers in one column on the report in MicroStrategy Developer 9. This attribute join type is the default setting. Update:Multi-Metric KPI is best when you have several important indicators that you want to display in one, responsive visualization together. Using this grid, you can have multiple unrelated attributes and metrics in different sets of columns that are stitched together. Attribute elements, or the actual data values for an attribute, dictate the relationships that you define between attributes. Attribute qualification filter These types of qualifications restrict data related to attributes on the report. Select Category and Quarter from the Available attributes list and click > to add them to the Selected attributes list. 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. In some business scenarios, it is required to apply threshold on rows without specific characters in attribute element names in a report with compound metrics in MicroStrategy Developer. Attribute ID form expressions will always appear in the group by clause, because this is necessary to define the aggregation level for the query. A metric is a compound metric if it consists of two or more existing metrics joined by an arithmetic operator (+, -, *, and /). Arithmetic operators are +, -, *, and /. 1. PepsiCo ( PEP 0. KB17619: How to create a conditional attribute in MicroStrategy Desktop 8. MicroStrategy HyperIntelligence is the next step in the future of data analytics. Therefore, more than one column is needed to identify that compound attribute distinctively. Workaround / Solution. In the MicroStrategy Tutorial project, for instance, such a report could include the Year attribute, Customer Geography Ratio consolidation, the Profit and Revenue metrics, and a compound metric dividing Profit by Revenue. 09%) is another ROIC powerhouse with rock-solid demand stability and a balance sheet that supports continued dividend growth. 2. 2. Is there any easy way to find the lineage information from Report to the actual Warehouse table ?. The Create New Attribute Form dialog box now appears. The Metric Editor opens in either Function Editor mode or Formula Editor mode, depending on the type of metric you chose to edit. Drag the prompt onto the Definition pane at the bottom right, as shown in the image. Choose Grid > Compound Grid . 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. You can use derived metrics to. a) Attribute form qualification Filters data related to a business attribute’s form(s), such as ID or description. Creating attributes with multiple ID columns: Compound attributes. The use of compound attributes in a non-aggregatable metric is not supported in MicroStrategy Developer 9. 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. Here the many-to-many relationship is converted into a compound attribute relationship. Users can also create compound attributes, define attribute relationships in the system hierarchy and modify display and sort. Users can also create compound attributes, define attribute relationships in the system hierarchy and modify display and sort forms. KB6669: How to create dynamic date filters on time attributes other than Date using custom SQL. In MicroStrategy Developer, log in to the project source that contains the MicroStrategy Tutorial project and then log in to MicroStrategy Tutorial. This metric is used for getting "1" value for all rows. It uses Business Scenarios to provide examples of each concept. In the MicroStrategy Tutorial project, Distribution Center is an example of a compound attribute. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. A compound attribute is one that uses two or more columns as its ID. Add a compound attribute, For instance "Seasons", to Page-by and enable subtotal for the report. This implies, of course, that more than one ID column is needed to uniquelyidentify the elements of that attribute. Attribute form: contains an identifier or descriptor of an attribute. However, on editing the attribute, this form appears only once as. Although transformations can be applied to any attribute hierarchy, the Time hierarchy is used most often. Users can also create compound attributes, define attribute relationships in the system hierarchy and modify display and sort forms. If you are leveraging Web ASP, see KB484127 to use this feature. For example, for the Customer attribute, Customer Email, Customer First Name, and Customer Last Name are examples of attribute forms. In this article, we clarify your questions regarding Pattern Matching and how it is different from the standard Keyword Matching. . For information on training metrics and creating predictive. The boolean datatype should be seen as "Unknown"; it is not natively supported by MicroStrategy 9. 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. 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. 4. compound attributes. 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 technote describes a current defect in MicroStrategy Distribution Services 9. 1, an attribute in a grid can be used as selector to target other grids in the same dashboard. This technote describes a current defect in MicroStrategy Distribution Services 9. A split hierarchy is one - that at the lowest level - has more than one child. Click OK. SYMPTOM:The attributes Customer City and Call Center are enclosed in brackets. An implicit expression is required for creating such an attribute. A dataset is a MicroStrategy report that is used on a document and all of the report's elements–attributes, custom groups, consolidations, and metrics. x?; Knowledge Base: How to concatenate two. In the relational database. 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. If you make both of the above physical implementations, the SQL Engine uses the related table when no metric is included on the report. Plus, it connects business apps while integrating data. MicroStrategy recommends to have only one child at the lowest level. In MicroStrategy, create an attribute that can return all the location data for each entry. 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. For example, the attribute name (original object name) is called, Category. In MicroStrategy Workstation, architects can create and edit attribute objects. Attribute_ID1 = “,A1,” AND a11. The formula of a compound metric is based on arithmetic operators and non-group functions. Attributes are defined by these properties: •. The new grouped attribute appears in the Attribute Name field as. ; Dossier authoring enhancements, including: New context menu options to move, copy, or duplicate images, text boxes, and HTML. You can connect MicroStrategy reporting tool with any data, including big data, flat files, social media data, and. To create a last year transformation based on an expression. HyperIntelligence allows you to add various, or alternate, forms of the keyword attribute for matching. 4. The hyperlinks based on an attribute form compound by Applysimple no longer work when exporting to MHT in MicroStrategy 9. 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. Once you have the group made, then just drag in the original attribute under it. Create and Edit a Visualization-Based Filter. The resulting SQL will contain just the Metric Alias. ESRI attributes such as latitude and longitude, zip code, state, city,. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Click OK. How to create a conditional attribute in MicroStrategy Desktop A user may want to create an attribute with an alternating expression depending on a certain condition, a. xml, contains the information used to map ESRI geo attributes to the corresponding attributes in the MicroStrategy metadata. 11 hours ago · 2. ApplyAgg() Accepts facts, attributes, and metrics as input. The smart metric property of a compound metric allows the user to change the default evaluation order of the metric. Drag an attribute or metric from the Datasets panel to the Columns Set area in the Editor Panel. MicroStrategy Command Manager automates maintenance and other administrative operations using simple text-based commands. To Create a Metric Using the Formula Editor. 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. MicroStrategy provides two types of attributes: normal attributes and hierarchical attributes. 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. e. Sorin is a MicroStrategy specialist, experienced in Retail. 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 two fundamental parameters are the evt (short for “event”) parameter and the src (short for “source”) parameter. There's a reason we're at the top of the list. In MicroStrategy Developer, open the folder that contains the attribute to modify. Replace. You can re-use the same formula in multiple metric definitions. Select Joint Element List from the Option pull-down list. This visualization allows you to create a grid that analyzes different aspects of data across a common dimensions or attributes in rows. In the Actions column, select the Edit icon for the user to modify. Change Qualify on to ID. 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. 176. compound attributes. Drag the Metric Names attribute to the Rows or Columns areas to display metrics on the rows or columns of the grid. It supports interactive dashboard, highly detailed reports, ad-hoc query, automated report dispute, and Microsoft Office integration. Drag an attribute or metric from the Datasets panel to the Columns Set area in the Editor Panel. 175. Click All Objects View. Attribute qualification filter These types of qualifications restrict data related to attributes on the report. Open a report in MicroStrategy Developer. 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. It is used to apply database (row-level) security to a MicroStrategy user. Open the dossier you want to modify. When naming a MicroStrategy object, you must follow the naming convention rules for your particular database platform. In the list of categories on the left, click Subtotals. MicroStrategy's default technique is to write description form expressions into the SQL Max() function. Heterogeneous mapping allows the engine to perform joins on unlike column names. . The Input Metric Formula dialog box opens. In the list of categories on the left, click Subtotals. This implies that more than one ID column is needed to uniquely identify the elements of. MicroStrategy Object Manager makes a list of all object dependencies before copying an object to prevent metadata inconsistency. 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. Compound Attribute: A compound attribute is an attribute whose primary key is made up of the combination of two or more columns. Document with no element attributes in the group by section. 4. The Compound Grid is a new visualization introduced in the MicroStrategy 2020 release. Types of filters in Microstrategy Below are the types of filters: 1. (The use of brackets around compound object names is standard for many objects in MicroStrategy and is not restricted to custom expressions and Apply. If the database platform does not support COUNT on concatenated strings, this property should be disabled. 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. It supports interactive dashboard, highly detailed reports, ad-hoc query, automated report dispute, and Microsoft Office integration. These commands can be compiled into script files and run from a graphical interface or from the command line. Usually this is the attribute to which the form belongs (i. There are no restrictions on the names for the columns used in the expressions of a given attribute. tailing_objectleading_object{. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. For each form listed, select or clear the corresponding checkbox in the Show on Grid column. MicroStrategy can help you with that, with the creation of derived attributes and metrics. From within a blank report in MicroStrategy Tutorial, double-click inside the Report Filter pane. A compound attribute is one that uses two or more columns as its ID. Generally, you create a compound attribute when your logical data model reflects that a compound key relationship is present. 10) Define different types of attributes in Microstrategy desktop? Answer: Compound Key Attribute Implicit Attributes Derived Attributes Simple Attribute. 4 of 5 Null/Zero Functions are pushed down to Teradata. Several non-group functions that are. For the Time hierarchy, the offset can. However, for compound ID attributes specifically, MicroStrategy only stores the elements based on the sort order from the ID form without considering locale. A compound attribute is an attribute with multiple columns specified as the ID column. Composite Key. 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: . In MicroStrategy Workstation, architects can create and edit attribute objects. A metric is a compound metric if it uses a non-group function, which includes OLAP functions and scalar functions. Create a new attribute form without the undesired source table. The Profit metric is a simple sum of the Profit fact. For the Time hierarchy, the offset can. 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. 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. How to Create a Derived Attribute or Metric. database to create a new column. An in-line many-to-many relationship involves an attribute with at least one parent and one child. x, the Report Objects window shows the same attribute form multiple times, as shown: In the above example, the 'Store ID' form shows up twice. The operators and functions can be applied to facts, attributes, or metrics. You are returned to MicroStrategy Developer. Split Hierarchy with M-M relationships: Explanation. The Results Preview dialog box opens. To do this: a. member_terminal. Go to Data > VLDB Properties > Joins > "Preserve all final pass result elements. Select Joint Element List from the Option pull-down list. Compound Attributes: Microstrategy Related Tutorials; Informatica Tutorial: IBM Cognos Tutorial: Teradata Tutorial: Adv Java Tutorial: Cloud Computing Tutorial: SQL Database Tutorial:How to include an attribute form in a compound or derived metric in MicroStrategy Developer 9. Example:. MicroStrategy is a business intelligence tool, that supports interactive dashboards, highly formatted reports, scorecards, alerts, ad hoc queries, automated report distribution, thresholds, etc. 1 - 10. It's. Each of these compound metric types is described with examples below. x SUMMARY: Description of a known issue identified upon migrating to MicroStrategy 9. To create a compound key (composite key), users. The only solution that I can think of is to create a FreeForm SQL Report. A compound attribute is defined as an attribute with more than one column specified as the ID column. You can type arithmetic operators (such as + and -) and comparison operators (such as < and >) directly in the metric expression. This is a single-value function. Answer / nadia sheikh. In the MicroStrategy. Generally, you create a compound attribute when your logical data model reflects that a compound key relationship is present. 4. Option A 1. x and 10. Automatic attribute role recognition, where you create multiple attributes that have the same lookup table and allow MicroStrategy to automatically detect the multiple roles. 11 a change is being made to the default value of the use lookup for attributes function parameter when making metrics. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. (Optional) Use the Up and Down. This visualization allows you to create a grid that analyzes different aspects of data across a common dimensions or attributes in rows. Transformations allow you to apply an attribute-element based offset to compare metric data. Currently the DIM_DATE. For example, consider the relationship between three attributes: Promotion, Item, and Quarter. Use "Access External Data" feature in MicroStrategy Web 10 to import data. Enter a Form name and Description. MicroStrategy Internal Reference number for this technical note is KB483638 and US144497. Add an attribute and a metric to both Column Set 1 and Column Set 2. 2987. Allows you to choose whether you want to use the metric name as the column alias or whether to use a MicroStrategy- generated. In MicroStrategy Web 2020, create a dossier with a Compound Grid visualization. Today, we are covering how to create derived attributes and metrics in MicroStrategy. In the list of categories on the left, click Subtotals. In simple words, Metadata could be considered as the heart of MicroStrategy environment. Attribute name:XXXX" is thrown after attempting to map a compound key attribute to SAP properties in MicroStrategy Analytics Enterprise. The form expression for the Customer Last Name attribute form is CUST_LAST_NAME. In the MicroStrategy Tutorial project, Distribution Center is an example of a compound attribute.