A compound attribute is one that uses two or more columns as its ID. For the Time hierarchy, the offset can. 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. II. 4. Drag at least one attribute to the top. It is a very popular BI tool since it allows organizations to analyze their data in-depth and make better decisions. x-10. Most of the creation of data multidimensional data warehouses is done manually, but it is a very complex and takes a long time and usually has a risk of fail. Create and Edit a Visualization-Based Filter. Filtering Compound Attributes. In MicroStrategy Workstation, architects can create and edit attribute objects. The first value in each attribute is added to the list. Types of filters in Microstrategy Below are the types of filters: 1. MicroStrategy provides ETL, data warehousing and data mining for data analysis. 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. 8K views 4 years ago n this brief video tutorial, Stephen Goodson, a senior instructor. A compound attribute is defined as an attribute with more than one column specified as the ID column. MicroStrategy recommends to have only one child at the lowest level. Arithmetic operators are +, -, *, and /. There's a reason we're at the top of the list. Attribute name:XXXX" is thrown after attempting to map a compound key attribute to SAP properties in MicroStrategy Analytics Enterprise. A Compound Grid stitches multiple simple Grid visualizations together to provide a more holistic grid view with richer data insights. To create a compound key (composite key), users. Click Transformation on the Metric component pane (located under the heading "Metric (metric name) is defined as"). Follow the steps below. Select Category and Quarter from the Available attributes list and click > to add them to the Selected attributes list. 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. Only two leading objects are defined in the query language. Incident update and uptime reporting. A metric is a compound metric if it uses a non-group function, which includes OLAP functions and scalar functions. The formula of a compound metric is based on arithmetic operators and non-group functions. Create a Default Dynamic Selection Filter. 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). Click here to view help for the latest version of this product or search MicroStrategy Community. You can connect MicroStrategy reporting tool with any data, including big data, flat files, social media data, and. 4. 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. MicroStrategy ONE introduces new features that provide better performance and scalability to enhance the overall user experience. This article does contain a solution. The attribute editor allows users to create attribute forms, connect attributes to logical tables in the schema, and edit form expressions. Published: Sep 19, 2019Report will display result as below. PepsiCo ( PEP 0. 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. 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. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a red "X" as shown below: However, the images in the report display properly when the report is. The Metric Names attribute automatically appears in the Editor panel. 13. The only solution that I can think of is to create a FreeForm SQL Report. Also, you add both attribute IDs, in this case Item_ID and Color_ID, to the fact table as shown in the following diagram. Each custom format can have up to four. It is derived based on a count against the fact_object_component table. 3. 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. By default, the metrics Compound Profit and Profit Margin do not use a dynamic aggregation function. 1 where when a Compound Attribute containing a Date Format ID is used as a dynamic textbox on a Flash document, the exporting does not format correctly when exported to. Create 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. Select the check box for any smart attribute that needs to be created. multiple attribute forms conform the ID form, any element that matches at least one of the ID's will become highlighted, like shown below. The Results Preview dialog box opens. Attributes give users context for reporting on and analyzing data. MicroStrategy Command Manager automates maintenance and other administrative operations using simple text-based commands. An implicit expression is required for creating such an attribute. This article describes how to create derived metrics to show previous row data in MicroStrategy. Compound Grid visualizations. It's. . In the report, the attribute with the compound key is Distribution Center. Attribute forms. A metric is a compound metric if it uses a non-group function, which includes OLAP functions and scalar functions. 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. 4. e. MicroStrategy Web provides a wide range of parameters that can be used in combination to achieve different types of requests. 4. Attribute forms are identifiers or descriptors of an attribute, such as ID, Name, and Address. 2. Use a percent-to-total shortcut metric to show cell-level values as percents of an accumulated row or column total. 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. Datasets define which information the Intelligence Server should retrieve from the data warehouse or cache. The implicit attribute has its own expression. On the Security Filter tab, select a project under which you want to assign a security filter to the user or group. In fact. The Compound Grid is a new visualization introduced in the MicroStrategy 2020 release. 0: Profit/Revenue. The Year - Define a new member attribute. In MicroStrategy, users can create compound metrics belonging to MDX Cubes imported from multidimensional data sources such as SAP BW, Microsoft Analysis Services, or Hyperion Essbase. e. x-10. Click OK. 10869 views | September 04, 2020 01:10. Double-click the attribute to edit. Creating attributes with multiple ID columns: Compound attributes • Modifying how to use attributes to browse and report on data • Specifying attribute roles: Attributes that use the same lookup • Supporting data internationalization for attribute elements Modifying attributes with the Properties pane A compound key attribute is an attribute whose primary key is made up by the combination of two or more columns. The use of compound attributes in a non-aggregatable metric is not supported in MicroStrategy Developer 9. In the right corner of the dashboard, change the. An attribute form expression defines what columns in the warehouse are used to represent the attribute form in SQL. Add a compound attribute, For instance "Seasons", to Page-by and enable subtotal for the report. The operators and functions of a compound metric can be applied to facts, attributes, or metrics within the compound metric. Double-click the attribute to edit. An additional modeling convention is to add unique identifiers for each attribute and fact. A compound attribute is defined as an attribute with more than one column specified as the ID column. In MicroStrategy Developer, from the File menu, point to New, and select Transformation. 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. 2, the selector will not work if using the Include option for the selector. In this case, Promotion has a many-to-many relationship to both Item and Quarter. An attribute form expression defines what columns in the warehouse are used to represent the attribute form in SQL. 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. Featured on Meta Update: New Colors Launched. 1, an attribute in a grid can be used as selector to target other grids in the same dashboard. 4. Add an attribute and a metric to both Column Set 1 and Column Set 2. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. This condition may be implemented through an ApplySimple statement such as the following: The user will find that the CASE statement. You can apply an inner or outer join, which are described in more detail below. The dynamic aggregation itself is highlighted in red. Heterogeneous mapping allows the engine to perform joins on unlike column names. Attributes are MicroStrategy objects that represent the business concepts reflected in your stored business data in your data source. 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. Result for new metric is blank. compound attributes. You can use derived metrics to. In its most basic form it consists of two parts: A report template (usually simply called a template), which is the underlying structure of the report. x where all hyperlinks based on Applysimple no longer work when exporting to Flash, generating a MHT file. The metric formula defines the data to be used and the calculations to be performed on the data. You cannot change the join types of. There's a reason we're at the top of the 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. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. A compound attribute is an attribute with multiple columns specified as the ID column. Multiple elements are highlighted when using an attribute with compound key as a selector in Visual Insight and MicroStrategy Web 9. . This technote describes a current defect in MicroStrategy Distribution Services 9. 4. Click the Add icon to the right of the Element list. A sample report is: Attributes: Metadata, Project, Object, Object Type, Component Object Type. Go to Smart Attribute blade on the Attributes Editor. Also, you add both attribute IDs, in this case Item_ID and Color_ID, to the fact table as shown in the following diagram. The Allow URLs to Export setting allows administrator's to specify the only URLs and URL paths that can be exported to PDF or Excel. To create a compound key, users must create multiple attribute forms, group them together and set the form group as the key. Users can also create compound attributes, define attribute relationships in the system hierarchy and modify display and sort. In MicroStrategy Developer, open the folder that contains the attribute to modify. 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. Heterogeneous mapping allows the engine to perform joins on unlike column names. For information on training metrics and creating predictive. Mapping is required only if you want to display areas on your map on a local server. SUMMARY: This technote describes a current defect in MicroStrategy Web 9. On each column set, add at least one attribute. An in-line many-to-many relationship involves an attribute with at least one parent and one child. 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. Any time you type an attribute whose name contains one or more spaces, the attribute must be enclosed in square brackets. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. 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. This version of the product is no longer supported in accordance with MicroStrategy's support lifecycle. In MicroStrategy Developer, go to File > New > Metric. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. In MicroStrategy Web, click the metric for which you want to enable a grand total or subtotals. Compound Metrics. Syntax . 4. Open a dossier. attr_elementsApplySimple. The purpose of filtering these tables is to obtain datasets that have a common attribute, but different values for it to ensure no overlap. In this article, we clarify your questions regarding Pattern Matching and how it is different from the standard Keyword Matching. These settings affect how MicroStrategy Intelligence Server manages joins, metric calculations, and query optimizations, among other options. 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. MicroStrategy is an enterprise BI application software. A sample URL that answers an element prompt when the attribute has a compound ID is shown below. Surrogate Key. This article notes a limitation of mapping MDX attributes to schema mapped attributesFor example: Simple or Compound Metrics . Scenario: Attribute1 is a compound key attribute with a. The operators and functions of a compound metric can be applied to facts, attributes, or metrics within the compound. Like other visualizations, a Compound Grid can be used as the target of a selector. 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. For example, in a schema where Store is a compound attribute with Region-Market-Store, and the. Most attributes have at least two forms, ID and description (Desc). The attributes that are single in definition but the instances of the attribute can behave differently according to the role they take. Double-click the Column Set name to rename the set. x: Create a metric called A with expression "Min(1){~}" as shown below. This implies that more than one ID column is needed to uniquely identify the elements of. The MicroStrategy 8 - Advanced Reporting Guide provides comprehensive information on advanced topics in the MicroStrategy query and reporting products. 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. 11) Describe Implicit Attribute? Answer: An implicit attribute is a practical or same attribute that does not actually exist in the database because it is made at the application level. 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. Visit the MicroStrategy download site to download the latest supported version of this product. Consider the sales figures of your company. Compound attributes are usually counted by concatenating the keys of all the attributes that form the key. The database repository where definitions of all MicroStrategy objects are stored. Arithmetic operators are +, -, *, and /; non-group functions are OLAP and. 10 : If you have additional descriptive information that you want to make available for display. This implies. Under 'Source tables', select a table and click 'Set as Lookup'. Each type is described below: . xml, contains the information used to map ESRI geo attributes to the corresponding attributes in the MicroStrategy metadata. Join Specifications. Report R contains attribute T. )Create a new compound metric in Tutorial in MicroStrategy 10. 1. In the relational database. This function is an OLAP function. performance and data integrity=2E. It uses Business Scenarios to provide examples of each concept. A derived attribute has its value determined by an expression which combines two or more columns in a. The attribute editor allows users to create attribute forms, connect attributes to logical tables in the schema, and edit form expressions. x-10. When the attribute used as a selector has a compound key, i. To create a derived metric. 4. 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. 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. Compound Metric; Steps to Reproduce. However, on editing the attribute, this form appears only once as. After adding the table, a MicroStrategy partition-mapping object has to be defined (File > New > Partition menu). 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. 0 or above. Once you have the group made, then just drag in the original attribute under it. This article notes a limitation of MDX data sources for filters on different levelsStarting in MicroStrategy 10. Alternate Key. 4. Steps to Create Smart Attributes. Open the dossier you want to modify. Creating attributes with multiple ID columns: Compound attributes. Attribute forms are defined by at least one expression, and these expressions act on column data and can contain functions. In this case, MicroStrategy would know to aggregate Airport level fact data up to the Location level in when for example, only Location and Revenue need to be displayed. Click Add, select the elements, then click OK. To enable totals or subtotals for a metric. 4. Select Add an Advanced Qualification and click OK. Right-click the attribute to limit, point to Element Display, and then select Limit. Function. A compound attribute has its value resolute by an expression that join two or more columns in a database to make a new column. It is used with database-specific OLAP functions such as Rank(). A compound key attribute is an attribute whose primary key is made up by the combination of two or. The hyperlinks based on an attribute form compound by Applysimple no longer work when exporting to MHT in MicroStrategy 9. The operators and functions can be applied to facts, attributes, or metrics. 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. The multiple columns are joined with other attributes, typically in a many-to-many relationship. This technote describes a current defect in MicroStrategy Distribution Services 9. Let’s look at each of the keys in DBMS with example: Super Key – A super key is a group of single or multiple keys which identifies rows in a table. In MicroStrategy Desktop/Developer 9. By ManishaGupta that reached out to me via. The Metric Editor opens in either Function Editor mode or Formula Editor mode, depending on the type of metric you chose to edit. You can use derived metrics to. 0:50. What are Configuration Objects? Configuration objects are MicroStrategy objects which can be re used in multiple projects and they. ApplyAgg() Accepts facts, attributes, and metrics as input. The attributes Customer City and Call Center are enclosed in brackets. x. This property is used to indicate when this occurs. This is the essence of a joint child relationship. In MicroStrategy SQL Generation Engine, when simple Period to Date (PTD) reports are needed, there is no need to create a transformation table. The implicit attribute has its own expression. Click Create on any page, and select New Metric. The derived metric aggregates at the level of the attributes on the visualization by default. 4. For examples of joining datasets, see Defining a dataset as primary or secondary and Joining multiple datasets: Examples. 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. xattributes (list or None, optional): ID numbers of attributes to be included in the filter. Compound Attribute: A compound attribute is an attribute whose primary key is made up of the combination of two or more columns. You treat one attribute as a child of the other and have a compound key for the lower level attribute. 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. 3. The boolean datatype should be seen as "Unknown"; it is not natively supported by MicroStrategy 9. Click OK. The multiple columns are joined with other attributes, typically in a many-to-many relationship. Steps to Reproduce on a Compound Grid. 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. Whenever the attributes in Report Objects are not the same as the attributes on the grid, dynamic aggregation has occurred. Set the qualification type to 'Custom'. (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. (In this cube, Product Hierarchy Level 00 corresponds to the MicroStrategy Tutorial Category attribute; Product Hierarchy Level 01 corresponds to Subcategory. Quite often these attributes have automatic mapping for one ID and manual mapping for the other one. 1. The multiple columns are joined with other. 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. By default, the Partition Attribute pull-down menu is set to Automatic, which allows MicroStrategy Web to set the number of partitions. The attribute editor allows users to create attribute forms, connect attributes to logical tables in the schema, and edit form expressions. An attribute form is a descriptive aspect of an attribute. The Profit metric is a simple sum of the Profit fact. Open a report in MicroStrategy Developer. A compound attribute is an attribute with multiple columns specified as the ID column. Click All Objects View. Use the Object Browser on the left to locate the prompt to add to the metric's definition. 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. ApplyAgg() Accepts facts, attributes, and metrics as input. 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. In MicroStrategy 2020, the metric guide is supported and will guide the Engine to retrieve the metric from the correct table. The Promotion attribute is related to a particular Item-Quarter pair, as opposed to it being related to Item and Quarter separately. 0 if there are multiple join paths between two or more One-to-Many relationship tables in a multi-table data import cube, rather than using the first available table join path, the analytical engine will look for the path with the least number of tables and the smallest table base on the following order/criteria:Beginning in MicroStrategy 11. Rather than creating attributes by manually creating an attribute expression, you can allow Architect to automatically create simple attributes defined on one column. This section focuses on the VLDB properties that are set at the metric and report level. DATE and DIM_DATE. In the Editor Panel, right-click the attribute in Column Set 1 and select Display Attribute Forms. If the database platform does not support COUNT on concatenated strings, this property should be disabled. April 28, 2009 Architect, MicroStrategy Compound Attribute Sorin Suciu. 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. 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. Compound Key Attribute A compound key attribute is an attribute whose primary key is made up by the combination of two or more columns. There's a reason we're at the top of the list. 2. (The use of brackets around compound object names is standard for many objects in MicroStrategy and is not restricted to custom expressions and Apply. Go to Data > VLDB Properties > Joins > "Preserve all final pass result elements. 4. x and 10. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Example:. STEPS TO REPRODUCE: 1. multiple attribute forms conform the ID form, any element that matches at least one of the ID's will become highlighted, like shown below. The Transformation Editor opens with the Select a Member Attribute dialog box displayed. Each graph appears in a separate row, one for each element in the attribute. In this case, enter 'Date@ID'. Create a new dataset DS1:In MicroStrategy Web 9. Want to learn more? Check out my Architect co. You can type arithmetic operators (such as + and -) and comparison operators (such as < and >) directly in the metric expression. 11 hours ago · 2. When trying to use a selector based in a compound attribute, in MicroStrategy Mobile 10. Select Add an Attribute qualification and click OK. You can quickly create multiple element groups at the same time. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. In MicroStrategy Developer, open the folder that contains the attribute to modify. To create a last year transformation based on an expression. Therefore, it is possible to have the attribute specified at the metric dimensionality level and only have Category in the report template. Configuration Objects:. Depending on your MicroStrategy product and licensing, this function may not be available. 939 views 3 years ago. To Create a Metric Using the Formula Editor. Hover over the Properties column and click Open Intelligence Server Administration Portal . x and 10. 1, users can map attributes during Data Import to existing attributes. Open the dossier you want to modify. 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. Primary Key – is a column or group of columns in a table that uniquely identify every row in that table. 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. Attribute name:XXXX" is thrown after attempting to map a compound key attribute to SAP properties in MicroStrategy Analytics Enterprise. In this case, enter 'Date@ID'. By choosing Automatic, if the largest table is >= 1M rows, MicroStrategy will choose the attribute. A compound attribute is defined as an attribute with more than one column specified as the ID column. Enter a Form name and Description. Click the visualization to add the group to. A normal attribute represents a single hierarchy level (for example, Month). Related articles from the Community: Knowledge Base: How to create a derived metric in MicroStrategy Developer 9. Now to fix this create a new Derived metric on Category attribute first with formula as Max (Category) {~ } and calling Books. it was very disappointing to find out mid-way that it is so limited (and the option to create a "multi-form" attribute from data import exists for 3 years or saw from the web interface. If the Object Browser is not displayed, from the View menu select Object Browser. Compound Attribute Date ID forms do not format correctly when ran correctly in Flash in MicroStrategy Web. Using a combination of filters and metric dimensionality, the same results can be achieved. The Group Editor opens. Total (profits/unit sold) Smart Metrics: Total (profit)/ Total (sold) 8) Mention what types of testing can be carried out over the Microstrategy reports? Microstrategy can carry out test like • Naming convention tests • Total calculations test • SQL query validations • Attribute and metric. Create Dossier and Chapter Filters. MicroStrategy requires compound ID form attributes to have all source tables for all of the ID forms in the ID form group. The new grouped attribute appears in the Attribute Name field as. 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. Attributes provide a context in which to report on and analyze business facts or calculations. 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. In SQL, the formula commonly becomes part of the SELECT clause of the SQL command. 4 Basic Functions are supported by the MicroStrategy Analytical Engine: First. Drag the Metric Names attribute to the Rows or Columns areas to display metrics on the rows or columns of the grid. These privileges are part of OLAP Services. database column=2E Its a relational database thing, enabling high=. Find the attribute Ship Date in the Object Browser (in the Customer hierarchy) and drag it to the Attribute field. You can connect MicroStrategy reporting tool with any data, including big data, flat files, social media data, and. You treat one attribute as a child of the other and have a compound key for the lower level attribute. 1 and 10. Click OK. In MicroStrategy Web 2020, create a dossier with a Compound Grid visualization. In the Datasets panel, double-click attributes and metrics to add them to the visualization. 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. When they do appear, report designers have some degree of control over the subquery syntax using the Very Large Data Base (VLDB. xThis results in the error: “Engine Logic:Cannot get the column reference of a join attribute from the associated table”. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence; Multi-Cloud. 3. VLDB properties allow you to customize the SQL that MicroStrategy generates. Metrics made up of metrics: Compound metrics. Any of the lookup table columns can be set as the attribute key by using 'Set as key' feature, but only the forms that are actual primary keys in the lookup tables should be used. In-line M-M Relationships: Explanation. Compound attributes are usually counted by concatenating the keys of all of the attributes that form the key. A compound attribute is an attribute with multiple columns specified as the ID column. Each attribute form must have at least one expression. Usually this is the attribute to which the form belongs (i. Form groups in Microstrategy - Form groups in Microstrategy courses with reference manuals and examples pdf. Use "Access External Data" feature in MicroStrategy Web 10 to import data. For example, consider the relationship between three attributes: Promotion, Item, and Quarter. By design, Joint Element Lists will only qualify on attribute ID's. Some of the main features offered by MicroStrategy are Advanced Analytics, Data Discovery, Data Visualisation, Embedded BI, and detailed reports and statements. You are returned to MicroStrategy Developer. Important: Parts of a compound attribute cannot be omitted. A hierarchical attribute represents an entire hierarchy and its levels (for example, Time includes levels of Year, Quarter, Month, and Day). Automatic attribute role recognition, where you create multiple attributes that have the same lookup table and allow MicroStrategy to automatically detect the multiple roles. Only two leading objects are defined in the query language. 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. Calculate each attribute individual weight according to the level in the hierarchy (level in hierarchy/number of levels in hierarchy * 10).