Add the metric from Step 2 to the report shown above. Click the Options icon . SYMPTOM:The attributes Customer City and Call Center are enclosed in brackets. 4. However it. Important: Parts of a compound attribute cannot be omitted. 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. To enable totals or subtotals for a metric. MicroStrategy requires compound ID form attributes to have all source tables for all of the ID forms in the ID form group. 12. Want to learn more? Check out my Architect co. A compound attribute is an attribute with multiple columns specified as the ID column. Ambiguity in filters, metrics, security filters, facts, and attribute expressions can be avoided by. From within a blank report in MicroStrategy Tutorial, double-click inside the Report Filter pane. If you know of better/faster ways, please share. 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. Drag an attribute from the object browser into the text box next to the qualification type or enter the attribute name and its form according to the following format: attribute_name@form_name. The multiple columns are joined with other. Transformations allow you to apply an attribute-element based offset to compare metric data. An input box will be displayed with a list of recommended questions based. DATE ie. The ApplyOLAP function is used to define compound metrics. Solution. Attribute forms are identifiers or descriptors of an attribute, such as ID, Name, and Address. The hyperlinks based on an attribute form compound by Applysimple no longer work when exporting to MHT in MicroStrategy 9. For large metadata and complex schemas, gathering all the dependencies may take a long time. A sample URL that answers an element prompt when the attribute has a compound ID is shown below. There's a reason we're at the top of the list. Follow the steps below to display row numbers in one column on the report in MicroStrategy Developer 9. Only two leading objects are defined in the query language. For example, consider the relationship between three attributes: Promotion, Item, and Quarter. 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. 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. Visit the data visualization and data dashboard galleries for inspiration. This technote describes a current defect in MicroStrategy Distribution Services 9. There's a reason we're at the top of the list. A compound attribute is an attribute with multiple columns specified as the ID column. Users can also create compound attributes, define attribute relationships in the system hierarchy and modify display and sort forms. member_terminal. Creating attributes with multiple ID columns: Compound attributes. For instance, to execute a SQL report with Category on the template, but filtering on Quarter, the database must exclude all fact-level data that do not meet the Quarter condition, and then. x-10. For Compound Profit to be dynamically aggregated correctly, you change the dynamic aggregation function to Sum. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. After adding the table, a MicroStrategy partition-mapping object has to be defined (File > New > Partition menu). 3. 71K subscribers Subscribe 2. This calculation can be aggregated from the Employee level to the Region level. In the list of categories on the left, click Subtotals. Create a report containing the new metric. Part 2 of the MicroStrategy Advanced Architect series where I demonstrate how to create compound attribute keys. Arithmetic operators are +, -, *, and /. Change Qualify on to ID. Each custom format can have up to four. 175. multiple attribute forms conform the ID form, any element that matches at least one of the ID's will become highlighted, like shown below. You. A sample report is: Attributes: Metadata, Project, Object, Object Type, Component Object Type. Attributes can have multiple attribute forms. The Compound Grid is a new visualization introduced in the MicroStrategy 2020 release. Therefore, more than one column is needed to identify that compound attribute distinctively. 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. The new grouped attribute appears in the Attribute Name field as. Replace. 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. Create an Attribute Open the Workstation window with the Navigation pane in smart mode. There's a reason we're at the top of the list. Currently the DIM_DATE. metrics (list or None, optional): ID numbers of metrics to be included in the filter. In the MicroStrategy. Each of these compound metric types is described with examples below. The compound join saves memory space and processing time on the Intelligence Server executing the document. Click Create on any page, and select New Metric. . Every request to a MicroStrategy Web product corresponds to a specific event or action, which is. Workaround 4: Create a metric based on the attribute Country, for example Max (Country). Relate tables are often used to create relationships between. This implies. The form expression for the Customer Last Name attribute form is CUST_LAST_NAME. 0 or above. MicroStrategy provides ETL, data warehousing and data mining for data analysis. 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 is a filter which contains a prompt on an attribute element list. And leverage the Page-By function to focus your analysis on one element. You can connect MicroStrategy reporting tool with any data, including big data, flat files, social media data, and. The multiple columns are joined with other attributes, typically in a many-to-many relationship. 176. 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. Calculated expressions are created directly in text fields on the document, which makes them. This design may look strange, but in most cases there are. For instance, the attribute City may be defined in the data model as a combination of COUNTRY_ID and CITY_ID. The ApplyOLAP function is used to define compound metrics. If list is empty, no metrics will be selected. The Input Metric Formula dialog box opens. If the attriubte name has spaces, use the '' symbols to group the name. Study with Quizlet and memorize flashcards containing terms like Metadata, Metadata Components, heterogeneous mapping and more. Click the Options icon . 0. Users might observe that when an attribute with a compound form is added to a report in MicroStrategy Developer 9. In MicroStrategy 2020, the Compound Grid was introduced in dossier authoring. There's a reason we're at the top of the list. Temporary policy. KB6669: How to create dynamic date filters on time attributes other than Date using custom SQL. A compound key attribute is an attribute that has two or more IDs. The Attribute Creation Wizard opens,. For example, for the Customer attribute, Customer Email, Customer First Name, and Customer Last Name are examples of attribute forms. Click Insert Visualization . Usually this is the attribute to which the form belongs (i. 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. Learn how to switch to a compound grid, add column sets in this new visualization. These privileges are part of OLAP Services. DATE are attributes. By ManishaGupta that reached out to me via. The ApplyAgg function itself is a group-value function and accepts facts, attributes, and metrics as input. 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. ExampleA compound attribute has its value determined by an expression which combines two or more columns in a database to create a new column. Attributes are MicroStrategy objects that represent the business concepts reflected in your stored business data in your data source. Edit the evaluation order for the report: set Total to 1, metric. x where all hyperlinks based on Applysimple no longer work when exporting to Flash, generating a MHT file. Using datasets in documents. 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. VLDB Properties. 11. Example A compound key attribute is an attribute whose primary key is made up by the combination of two or more columns. The operators and functions can be applied to facts, attributes, or metrics. 4) In the Break By tab, remove the attributes used to compound the Custom Group elements: 5) In the Sort By tab, a dd the Year and Month attributes: 6) Any attribute which is part of the Custom Group should be removed from report definition; it means, all attributes used to compound the Custom Group cannot be part of the report definition. 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. 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. 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. e. Open attribute editor (right-click on attribute and. 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. database to create a new column. Add a compound attribute, For instance "Seasons", to Page-by and enable subtotal for the report. In MicroStrategy 2020, the Compound Grid was introduced in dossier authoring. Select a Form category, Display type and Default sort from the lists. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in one. In the MicroStrategy Tutorial project, Distribution Center is an example of a compound attribute. 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. 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. However, it may be desired to created a similarly structured qualification on attribute. The metric formula defines the data to be used and the calculations to be performed on the data. it is the same as the Attribute property). 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 case is also explained with an example based on the MicroStrategy Tutorial project. Function. In MicroStrategy Web 2020, create a dossier with a Compound Grid visualization. The smart metric property of a compound metric allows the user to change the default evaluation order of the metric. The Compound Grid is a new visualization introduced in the MicroStrategy 2020 release. A compound key attribute is an attribute that has two or more IDs. Today, we are covering how to create derived attributes and metrics in MicroStrategy. A compound attribute is an attribute with multiple columns specified as the ID column. Click All Objects View. xA connection map in MicroStrategy is a link between a MicroStrategy user, a database connection, and a database login. Learn how to switch to a compound grid, add column sets in this new visualization. Select Add an Advanced Qualification and click OK. 2, the selector will not work if using the Include option for the selector. Make B and C parents of a new compound attribute using both columns as its ID with A B and C as its parents. It visualises interactive dashboards, charts and graphs and improves analytics and predictive modelling capabilities. In Visual Insight in MicroStrategy Web 9. It is derived based on a count against the fact_object_component table. What is a compound attribute?A compound attribute has its value determined by an expression which combines two or more columns in a database to create a new column. Automatic attribute role recognition, where you create multiple attributes that have the same lookup table and allow MicroStrategy to automatically detect the multiple roles. A set qualification first produces a set of attribute elements. A calculated expression is a metric that is calculated dynamically when the document is executed, directly from metrics on a document dataset. The types of attribute form expressions are as follows: Simple. This condition may be implemented through an ApplySimple statement such as the following: The user will find that the CASE statement. The examples below describe how to drill on these compound metrics on both grid and graph reports. 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. ACTION: Currently this issue is still being reviewed for feasibility by our Technology team and it is not scoped for any upcoming scheduled MicroStrategy release. The Profit metric is a simple sum of the Profit fact. 3. The attribute editor allows users to create attribute forms, connect attributes to logical tables in the schema, and edit form expressions. Automatic recognition is enabled by the VLDB property Engine Attribute Role Options at the database instance level. If information about a. 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. Select the heat map visualization. The graph legend or axes can be formatted as well. g. Click OK. It is derived based on a count against the fact_object_component table. Make two grids with different attributes and metrics in each 3. 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. Is there any easy way to find the lineage information from Report to the actual Warehouse table ?. Drag attributes or metrics from the Datasets panel to the Filter panel. e. 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. An attribute form on the parent attribute also appears on the child attribute. Built by MicroStrategy, a worldwide leader in enterprise analytics and mobility, the. If the database platform does not support COUNT on concatenated strings, this property should be disabled. We recommend the latest version. 10) Define different types of attributes in Microstrategy desktop? Answer: Compound Key Attribute Implicit Attributes Derived Attributes Simple Attribute. These attributes require a compound primary key in the data warehouse to uniquely identify their elements. This is a single-value function. x and 10. Select the data set and click Prepare Data. We use MicroStrategy Tutorial tables that have the Month Id attribute and alter them. Compound Metrics. Alternate Key. What is compound and smart metrics?. Intersection behaves as the term AND does in grammar. The schema looks like the following diagram. A sample report is: Attributes: Metadata, Project, Object, Object Type, Component Object Type. MicroStrategy AI is here. Arithmetic operators are +, -, *, and /. When there are multiple datasets in a document, the grouping and sorting dataset is the one that is bolded in the Dataset. Some of the main features offered by MicroStrategy are Advanced Analytics, Data Discovery, Data Visualisation, Embedded BI, and detailed reports and statements. As you type, matching objects, such as attributes. 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. It returns the base attribute that contains this form. 1, users can map attributes during Data Import to existing attributes. MicroStrategy builds the rules that MicroStrategy SQL Engine uses to generate SQL when a report request is made. x and 10. Press and hold the Ctrl key to select multiple attributes or metrics. 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. For example, a transformation metric can help a user compare last month's revenue to this month's revenue. 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. 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 is an enterprise BI application software. Creating calculated expressions. This implies that more than one ID column is needed to uniquely identify the elements of. There are several ways to create and apply filters to individual chapters, multiple chapters, or across an entire dossier. For each form listed, select or clear the corresponding checkbox in the Show on Grid column. Follow the steps below. MicroStrategy is a business intelligence tool, that supports interactive dashboards, highly formatted reports, scorecards, alerts, ad hoc queries, automated report distribution, thresholds, etc. Count of Parents in Platform Analytics: There is an OOTB metric called Objects, which calculates the parents of a component object. Generally, you create a compound attribute when your logical data model reflects that a compound key relationship is present. A compound key attribute is an attribute whose primary key is made up by the combination of two or more columns. Users can also create compound attributes, define attribute relationships in the system hierarchy and modify display and sort. Creating attributes with multiple ID columns: Compound attributes. The only solution that I can think of is to create a FreeForm SQL Report. This has been identified as a defect in MicroStrategy Web 10. In MicroStrategy Workstation, architects can create and edit attribute objects. Select Joint Element List from the Option pull-down list. Create compound attributes. Prompt-in-prompt is a feature in which the answer to one prompt is used to define another prompt. If the attriubte name has spaces, use the '' symbols to group the name. Compound Attribute Date ID forms do not format correctly when ran correctly in Flash in MicroStrategy Web. When trying to use a selector based in a compound attribute, in MicroStrategy Mobile 10. Click Add, select the elements, then click OK. In order to have a derived metric that can source from the join of multiple datasets a simple compound metric can be. In the relational database. Click OK. Creating a grid report. Drag the Metric Names attribute to the Rows or Columns areas to display metrics on the rows or columns of the grid. Types of filters in Microstrategy Below are the types of filters: 1. WORKAROUND: There are a couple of options to workaround this limitation. In-line M-M Relationships: Explanation. If you include Customer on a report with both Last Name and Address. You treat one attribute as a child of the other and have a compound key for the lower level attribute. Create an Attribute Open the Workstation. For examples of joining datasets, see Defining a dataset as primary or secondary and Joining multiple datasets: Examples. Compound Attribute Date ID forms do not format correctly when ran correctly in Flash in MicroStrategy Web. This technote describes a current defect in MicroStrategy Distribution Services 9. Learn how to create compound project attributes in MicroStrategy Developer, an advanced environment providing a complete range. You can connect MicroStrategy reporting tool with any data, including big data, flat files, social media data, and. 11 hours ago · 2. You can re-use the same formula in multiple metric definitions. Due to how the editor works it is not possible to force this restriction upon creation. Several non-group functions that are. 4 of 5 Null/Zero Functions are pushed down to Teradata. An attribute form expression defines what columns in the warehouse are used to represent the attribute form in SQL. A compound attribute is an attribute with multiple columns specified as the ID column. This tutorial shows how to create derived attributes and metrics in a dossier. Passing prompt answers for an element prompt when the attribute has a compound ID. Compound Metric; Steps to Reproduce. For. 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. In MicroStrategy Developer, from the File menu, point to New, and select Transformation. One-to-one: Each element in the parent attribute corresponds to one and only one element in the child attribute, and each child attribute. 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: . The algorithm that calculates the table sizes performs the following steps: Calculate the number of levels per hierarchy: Hierarchy 1: 3. 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. Go to Data > VLDB Properties > Joins > "Preserve all final pass result elements. It is derived based on a count against the fact_object_component table. The hyperlinks based on an attribute form compound by Applysimple no longer work when exporting to MHT in MicroStrategy 9. Select Category and Quarter from the Available attributes list and click > to add them to the Selected attributes list. Each type is described below: . By choosing Automatic, if the largest table is >= 1M rows, MicroStrategy will choose the attribute. Open the dossier you want to modify. The Compound Grid is a new visualization introduced in the MicroStrategy 2020 release. For example, you create an attribute called Customer to represent customers in your. 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. Once you have the group made, then just drag in the original attribute under it. 4. The attribute level follows a consecutive order from. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. In the pane, begin typing the metric formula. MicroStrategy recommends to have only one child at the lowest level. In Microstrategy, the lookup tables represent the attributes. DaysBetween(DIM_RELEASE_DATE. Attribute elements, or the actual data values for an attribute, dictate the relationships that you define between attributes. Split Hierarchy with M-M relationships: Explanation. ; Dossier authoring enhancements, including: New context menu options to move, copy, or duplicate images, text boxes, and HTML. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Related articles from the Community: Knowledge Base: How to create a derived metric in MicroStrategy Developer 9. x? Number of Views 6. Since by changing the ID form of the attribute (compound to single key), the attribute has become a new attribute, personalizations based on that attribute may no longer continue to work and should be recreated. Type the number of elements to display at one time and click OK. I'm working on a dossier and I have a dataset that includes customer types. Create a Report Services Document 2. Attribute name:XXXX" is thrown after attempting to map a compound key attribute to SAP properties in MicroStrategy Analytics Enterprise. It causes the SQL Engine to calculate for only the attribute elements that exist in both the lookup and fact tables. 1 - 10. Go to Smart Attribute blade on the Attributes Editor. You cannot change the join types of. Click More in the top right of the heat map and choose Create Contextual Link and select. Create a report with the attributes Region and Promotion Type as seen below: 2. 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. For example, the form expression for the Customer First Name attribute form is CUST_FIRST_NAME. x . 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). There's a reason we're at the top of the list. Incident update and uptime reporting. performance and data integrity=2E. Define the statistics and enterprise warehouse database. Therefore, if a base metric appears in the template, Metric. Each graph appears in a separate row, one for each element in the attribute. The attribute editor allows users to create attribute forms, connect attributes to logical tables in the schema, and edit form expressions. This implies that more than one ID column is needed to uniquely identify the elements of that attribute. The MicroStrategy Advanced Reporting Help provides comprehensive information on advanced topics for using the MicroStrategy query and reporting products. A compound attribute is defined as an attribute with more than one column specified as the ID column. In summary, when Metric Join type or Formula Join Type for a compound metric is set as Outer, a full outer join would happen between temporary tables for base metrics. 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. Click "Prepare data" to enter Data Preview page. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. This design may look strange, but in most cases there are sound. This article notes a limitation of MDX data sources for filters on different levelsStarting in MicroStrategy 10. Relate tables store information about the relationship between two attributes when one a parent of the other or vice-versa. 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. x. The only solution that I can think of is to create a FreeForm SQL Report. Drag an attribute from the Datasets panel to the Rows area of the Editor panel. 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. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. In the visualization's Editor panel, right-click the attribute to group and choose Create Groups. When the attribute used as a selector has a compound key, i. 09%) is another ROIC powerhouse with rock-solid demand stability and a balance sheet that supports continued dividend growth. 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. 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. The Limit dialog box opens. Create Dossier and Chapter Filters. A compound attribute is an attribute with multiple columns specified as the ID column. Create a compound metric called B with expression "RunningSum(A)" as shown below. KB4641: How to set up a Compound Key for an attribute in MicroStrategy Developer 9. 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. There are no restrictions on the names for the columns used in the expressions of a given attribute form. 4. 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. J2EE environment:A metric is a compound metric if it consists of two or more existing metrics joined by an arithmetic operator (+, -, *, and /). Compound attributes. Therefore, its ID form maps to a combination of columns. Drag an attribute or metric from the Datasets panel to the Columns Set area in the Editor Panel. April 28, 2009 Architect, MicroStrategy Compound Attribute Sorin Suciu. Here is the workaround to achieve the attribute left outer join on MicroStrategy Web. There are no restrictions on the names for the columns used in the expressions of a given attribute. For example:By adding simple dummy attributes you are able to arrange the columns in a much more tidy form without even touching the original data. This article notes a limitation of mapping MDX attributes to schema mapped attributesFor example: Simple or Compound Metrics . (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. Enter a Form name and Description. A compound attribute is a Microstrategy thing, enabling the MSI=. STEPS TO REPRODUCE: 1. In addition, this release introduces new features across the analytics, mobility, and security platforms—making it easier for users to build applications faster. Count of Parents in Platform Analytics: There is an OOTB metric called Objects, which calculates the parents of a component object. These privileges are part of OLAP Services. Recommendation. 1 and 10. Open the dossier you want to modify. Compound Attribute: A compound attribute is an attribute whose primary key is made up of the combination of two or more columns. In MicroStrategy Web 2020, create a dossier with a Compound Grid visualization. In simple words, Metadata could be considered as the heart of MicroStrategy environment. The MicroStrategy 8 - Advanced Reporting Guide provides comprehensive information on advanced topics in the MicroStrategy query and reporting products. Choose Grid > Compound Grid . In MicroStrategy, attributes are identified by the column headers of reports. Passing prompt answers for an element prompt when the attribute has a compound ID. What are Configuration Objects? Configuration objects are MicroStrategy objects which can be re used in multiple projects and they. What is a compound attribute in MicroStrategy? A compound attribute in Microstrategy is where more than one column is made the ID column. database column=2E Its a relational database thing, enabling high=. Upgrade to MicroStrategy 11. The two fundamental parameters are the evt (short for “event”) parameter and the src (short for “source”) parameter. Quite often these attributes have automatic mapping for one ID and manual mapping for the other one. 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.