There are several ways to create and apply filters to individual chapters, multiple chapters, or across an entire dossier. 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. Learn how to switch to a compound grid, add column sets in this new visualization. MicroStrategy SQL generation engine uses COALESCE in two principal ways: to merge attribute ID columns in full outer joins, and (in some database platforms) for metric null checking. Today, we are covering how to create derived attributes and metrics in MicroStrategy. In the relational database. An attribute form expression defines what columns in the warehouse are used to represent the attribute form in SQL. A derived attribute has its value determined by an expression which combines two or more columns in a. To display a title bar, do the following: Set Show title bar to True. A derived metric is a calculation based on metric data included in the report definition. Important: Parts of a compound attribute cannot be omitted. 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). Even though all the ID forms of a compound key attribute do not exist on the fact table, that attribute is seen in the fact entry level of that fact table. In-line M-M Relationships: Explanation. compound attributes. The compound join saves memory space and processing time on the Intelligence Server executing the document. In the list of categories on the left, click Subtotals. Example: Creating compound attributes. Several non-group functions that are. Apply Filter Changes. Study with Quizlet and memorize flashcards containing terms like Metadata, Metadata Components, heterogeneous mapping and more. In MicroStrategy Web 2020, create a dossier with a Compound Grid visualization. 11. Double-click Time to open the folder, then double-click Year. Compound Key Attribute A compound key attribute is an attribute whose primary key is made up by the combination of two or more columns. A compound attribute is defined as an attribute with more than one column specified as the ID column. Syntax . The Create New Attribute Form dialog box now appears. Open the dossier you want to modify. 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. Click Insert Visualization . You cannot change the join types of. Prompt-in-prompt is a feature in which the answer to one prompt is used to define another prompt. ) In the metric formula, the desired output dimensionality is given. x . 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. Compound Key Attribute A compound key attribute is an attribute whose primary key is made up by the combination of two or. In MicroStrategy Workstation, architects can create and edit attribute objects. The presence of a compound key relationship is. x and 10. For. SYMPTOM:The attributes Customer City and Call Center are enclosed in brackets. Metrics: Component Objects. Upgrade to that version to take advantage of this fix. Users can also create compound attributes, define attribute relationships in the system hierarchy and modify display and sort. There are no restrictions on the names for the columns used in the expressions of a given attribute. Select Manual from the Aggregation and Subtotal Behavior drop-down. In MicroStrategy 2020, the Compound Grid was introduced in dossier authoring. Each attribute form must have at least one expression. 4. 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. 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. Drag at least one attribute to the top of the Vertical area. One advantage of compound metrics compared to simple metrics is that compound metrics can use smart totals. Press and hold the Ctrl key to select multiple attributes or metrics. Click "Prepare data" to enter Data Preview page. Click Create on any page, and select New Metric. Click Create on any page, and select New Metric. In the MicroStrategy Tutorial project, Distribution Center is an example of a compound attribute. Scenario: Attribute1 is a compound key attribute with a. This article describes the purpose of the Sub Query Type VLDB property in MicroStrategy. Click the check mark symbol on the right of the drop-down. Multiple elements are highlighted when using an attribute with compound key as a selector in Visual Insight and MicroStrategy Web 9. Click Add, select the elements, then click OK. 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. There are three basic logical operators: Union behaves as the inclusive term OR does in grammar. In the relational database. Transformations allow you to apply an attribute-element based offset to compare metric data. You can type arithmetic operators (such as + and -) and comparison operators (such as < and >) directly in the metric expression. By default, the name of. 939 views 3 years ago. Usually this is the attribute to which the form belongs (i. Smart metrics calculate subtotals on individual elements of the compound metric. 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. In this case, Promotion has a many-to-many relationship to both Item and Quarter. Drag an attribute or metric from the Datasets panel to the Columns Set area in the Editor Panel. Click All Objects View. Like other visualizations, a Compound Grid can be used as the target of a selector. In MicroStrategy Desktop/Developer 9. Insert an HTML container (and not an image) and insert the script below. In this case, enter 'Date@ID'. Compound Keys - Advanced Architect Part 2 - MicroStrategy - YouTube Part 2 of the MicroStrategy Advanced Architect series where I demonstrate how to create compound attribute. Click the Options icon . Right-click the table, point to Recognize, and then select Attributes. Companies of all sizes use this platform to assess, visualise, and build dashboards. Set Data Engine Version setting to 11 or above. Select the Repeat attribute column checkbox to display the attribute. In MicroStrategy Web, click the metric for which you want to enable a grand total or subtotals. These privileges are part of OLAP Services. Quite often these attributes have automatic mapping for one ID and manual. If list is empty, no attributes will be selected and metric data will be aggregated. 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. The attribute editor allows users to create attribute forms, connect attributes to logical tables in the schema, and edit form expressions. What is a compound attribute in MicroStrategy? A compound attribute in Microstrategy is where more than one column is made the ID column. Ans: Statistics tables contain data on the MicroStrategy system’s usage and performance and are populated by all projects that are configured to log statistics. In MicroStrategy Web 2020, create a dossier with a Compound Grid visualization. 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. x-10. 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. Mode. 04), a simple metric B and a Date Attribute E There is Another compound metric C= (Avg(A*B) where E > specific date) (The averge is kept there cause we cannot put a filter condition directly on a compound metric unless we hae a Sum,Avg, Count etc on the. A sample URL that answers an element prompt when the attribute has a compound ID is shown below. Compound Key Attribute. 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. 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. A derived metric is a calculation based on metric data included in the report definition. On the Security Filter tab, select a project under which you want to assign a security filter to the user or group. To enable totals or subtotals for a metric. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Here is the workaround to achieve the attribute left outer join on MicroStrategy Web. Let’s get started. Custom number formatting symbols. It returns the base attribute that contains this form. Compound Metrics. ACTION: This issue has been addressed in MicroStrategy 10. By default, the metrics Compound Profit and Profit Margin do not use a dynamic aggregation function. 4. Like other visualizations, a Compound Grid can be used as the target of a selector. Once you have the group made, then just drag in the original attribute under it. 4. Solution. 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. For example, in a schema where Store is a compound attribute with Region-Market-Store, and the. The use of compound attributes in a non-aggregatable metric is not supported in MicroStrategy Developer 9. Users can also create compound attributes, define attribute relationships in the system hierarchy and modify display and sort. Primary Key – is a column or group of columns in a table that uniquely identify every row in that table. microstrategy; or ask your own question. your project, enabling drilling. Automatic attribute role recognition, where you create multiple attributes that have the same lookup table and allow MicroStrategy to automatically detect the multiple roles. You are returned to MicroStrategy Developer. Here the many-to-many relationship is converted into a compound attribute relationship. You can also apply a set of color and shading schemes to all the objects on a graph report. In the Gallery, click Compound Grid . 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. 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. In this case, enter 'Date@ID'. The Metric Editor opens. What is compound and smart metrics?. a compound key is a primary key consisting of more than one=. Heterogeneous mapping allows the engine to perform joins on unlike column names. 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. Create the statistics database instance. . 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. Arithmetic operators are +, -, *, and /. We use MicroStrategy Tutorial tables that have the Month Id attribute and alter them. 1 and 10. A compound key attribute is an attribute that has two or more IDs. Attribute name:XXXX" is thrown after attempting to map a compound key attribute to SAP properties in MicroStrategy Analytics Enterprise. In the pane, begin typing the metric formula. Heterogeneous mapping allows the engine to perform joins on unlike column names. 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. e. An attribute form is a descriptive aspect of an attribute. intermediate object}. Create your metric's formula. MicroStrategy requires compound ID form attributes to have all source tables for all of the ID forms in the ID form group. Attribute qualification filter These types of qualifications restrict data related to attributes on the report. This technote describes a current defect in MicroStrategy Distribution Services 9. Every request to a MicroStrategy Web product corresponds to a specific event or action, which is. A Compound Grid stitches multiple simple Grid visualizations together to provide a more holistic grid view with richer data insights. Consider the sales figures of your company. Add the metric from Step 2 to the report shown above. MicroStrategy recommends to have only one child at the lowest level. 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. 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. MicroStrategy's default technique is to write description form expressions into the SQL Max() function. In Visual Insight in MicroStrategy Web 9. 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. Using this grid, you can have multiple unrelated attributes and metrics in different sets of columns that are stitched together. The metric values roll up to the new attribute level of the grid. Workaround / Solution. The ESRI configuration file, mapConfig. Foreign Key. Generally, you build a compound attribute when your logical data model reflects that a. Now to fix this create a new Derived metric on Category attribute first with formula as Max (Category) {~ } and calling Books. Want to learn more? Check out my Architect co. The multiple columns are joined with other attributes, typically in a many-to-many relationship. Find the attribute Ship Date in the Object Browser (in the Customer hierarchy) and drag it to the Attribute field. One-to-one: Each element in the parent attribute corresponds to one and only one element in the child attribute, and each child attribute. 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. You are returned to MicroStrategy Developer. Follow the steps below. A compound attribute is an attribute with multiple columns specified as the ID column. The intersection of two sets yields a TRUE value only when both sets of filtering. 1 and 10. Create compound attributes. x doesn't have mapping between boolean type and MicroStrategy internal datatype. This is a single-value function. For example, for the Customer attribute, Customer Email, Customer First Name, and Customer Last Name are examples of attribute forms. Create a Report Services Document 2. 4. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. e. Including attribute forms in your logical data model can help you get a more complete view of all of the information that is made available in your project. It is used with database-specific OLAP functions such as Rank(). In MicroStrategy 2020, the metric guide is supported and will guide the Engine to retrieve the metric from the correct table. Count of Parents in Platform Analytics: There is an OOTB metric called Objects, which calculates the parents of a component object. The Compound Grid is a new visualization introduced in the MicroStrategy 2020 release. The metric formula defines the data to be used and the calculations to be performed on the data. A compound attribute is one that uses two or more columns as its ID. The metric can also show a total by page, show a total for each value of the attribute, or show the grand. Count Compound Attribute. : ToString("Coal") Then add this attribute to the compound grid Columns group:A compound attribute is defined as an attribute with more than one column specified as the ID column. xattributes (list or None, optional): ID numbers of attributes to be included in the filter. Here the many-to-many relationship is converted into a compound attribute relationship. 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. Attributes give users context for reporting on and analyzing data. The Promotion attribute is related to a particular Item-Quarter pair, as opposed to it being related to Item and Quarter separately. These privileges are part of OLAP Services. Hi All, I have a problem regarding metrics in MSTR. Create an Attribute Open the Workstation window with the Navigation pane in smart mode. Select Joint Element List from the Option pull-down list. This calculation can be aggregated from the Employee level to the Region level. Generally, you build a compound attribute when your logical model reflects that a compound key relationship is present. This condition may be implemented through an ApplySimple statement such as the following: The user will find that the CASE statement. Select Custom as the Category and create the format using the number format symbols listed in the table below. 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. There's a reason we're at the top of the list. The examples below describe how to drill on these compound metrics on both grid and graph reports. This design may look strange, but in most cases there are sound. 4. 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. 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. Select a Form category, Display type and Default sort from the lists. What is a compound attribute in Microstrategy? A compound attribute has its value determined by an expression which combines two or more columns in a database to create a new column. Right-click the attribute to limit, point to Element Display, and then select Limit. MicroStrategy Web. Metrics made up of metrics: Compound metrics. This visualization allows you to create a grid that analyzes different aspects of data across a common dimensions or attributes in rows. To specify a transformation, double-click it in the Object Browser to add it to the Transformations definition pane. We're sorry. Ensure that the project schema for your new attribute is available for editing. The attributes that are single in definition but the instances of the attribute can behave differently according to the role they take. Dynamic aggregation happens on the fly, in memory. The ApplyAgg function itself is a group-value function and accepts facts, attributes, and metrics as input. Update:Multi-Metric KPI is best when you have several important indicators that you want to display in one, responsive visualization together. 71K subscribers Subscribe 2. Relate tables are often used to create relationships between. MicroStrategy recommends to have only one child at the lowest level. Click the Options icon . Enter a Form name and Description. Attributes can have many descriptors, or forms, shown as distinct columns that are. A compound key attribute is an attribute whose primary key is made up by the combination of two or more columns. Visit the data visualization and data dashboard galleries for inspiration. To create a compound key, users must create multiple attribute forms, group them together and set the form group as the key. In order to have a derived metric that can source from the join of multiple datasets a simple compound metric can be. This online help builds on a basic understanding of information provided in the Basic Reporting Help. MicroStrategy is a business intelligence tool, that supports interactive dashboards, highly formatted reports, scorecards, alerts, ad hoc queries, automated report distribution, thresholds, etc. x. For instance, the attribute City may be defined in the data model as a combination of COUNTRY_ID and CITY_ID. In Visual Insight in MicroStrategy Web 9. Click User Manager . Attributes are the business concepts reflected in your data. 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. Define the statistics and enterprise warehouse database. Steps to Create Smart Attributes. Once these Logical views are created, they are available to. To add a filter: Open the dossier with the heat map visualization you created in How to Create Your Heat Map Visualization. In the list of categories on the left, click Subtotals. Navigate to the Schema Objects folder, open the Attributes folder, and then the Geography folder. Use the Object Browser on the left to locate the prompt to add to the metric's definition. 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. 12. The two fundamental parameters are the evt (short for “event”) parameter and the src (short for “source”) parameter. Dataset DS2 with attribute 'Year' and metrics 'Revenue', 'Profit', 'Profit Margin' (this is a compound smart metric calculated from metrics Revenue and Profit). 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. more columns. In SQL, the formula commonly becomes part of the SELECT clause of the SQL command. 4. 2987. It causes the SQL Engine to calculate for only the attribute elements that exist in both the lookup and fact tables. For example, if sales data is stored in the data warehouse at the day level, a month attribute allows users to. This calculation can be aggregated from the Employee level to the Region level. 09%) is another ROIC powerhouse with rock-solid demand stability and a balance sheet that supports continued dividend growth. Make B and C parents of a new compound attribute using both columns as its ID with A B and C as its parents. This tutorial shows how to create derived attributes and metrics in a dossier. A compound attribute is defined as an attribute with more than one column specified as the ID column. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. KB6669: How to create dynamic date filters on time attributes other than Date using custom SQL. Incident update and uptime reporting. These settings affect how MicroStrategy Intelligence Server manages joins, metric calculations, and query optimizations, among other options. To uniquely identify a distribution center, one must know two details about the. The form expression for the Customer Last Name attribute form is CUST_LAST_NAME. Create a report with the attributes Region and Promotion Type as seen below: 2. Creating a grid report. Create a new dataset DS1:In MicroStrategy Web 9. Compound Attribute Date ID forms do not format correctly when ran correctly in Flash in MicroStrategy Web. Check other tables and select/deselect correct tables. Create or edit reports with authoring functionality. In the Gallery, click Compound Grid . Type the number of elements to display at one time and click OK. You cannot change the join types of. Is there any easy way to find the lineage information from Report to the actual Warehouse table ?. How to include an attribute form in a compound or derived metric in MicroStrategy Developer 9. On the template, the month attribute, A - NORMAL SUM, C - DATA PREVIOUS ROW (B - A) and D - % CHANGE ((A-C)/C) are. By ManishaGupta that reached out to me via. Attributes are defined by these properties: •. In the Datasets panel, double-click attributes and metrics to add them to the visualization. The prompt displays the related attribute elements for users to select their filter criteria from. Also, you add both attribute IDs, in this case Item_ID and Color_ID, to the fact table as shown in the following diagram. STEPS TO REPRODUCE: 1. Open the dossier you want to modify. MicroStrategy AI is here. Only two leading objects are defined in the query language. In the Actions column, select the Edit icon for the user to modify. The only solution that I can think of is to create a FreeForm SQL Report. These units are part of an attribute, for example, Customer. Select a Form category, Display type and Default sort from the lists. Users can also create compound attributes, define attribute relationships in the system hierarchy and modify display and sort. Most attributes have at least two forms, ID and description (Desc). 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. This implies. 2. What is MicroStrategy? MicroStrategy is a Business Intelligence software that can be connected with any data including data files, big data, social media data, and so on to create and modify highly detailed reports and dashboards. SUMMARY: This technote describes a current defect in MicroStrategy Web 9. Writing the WHERE block should be no problem, as you can generate it in MS Excel based on the two columns… something like =CONCATENATE(“OR (a11. A dataset is a MicroStrategy report that is used on a document and all of the report's elements–attributes, custom groups, consolidations, and metrics. Select Add an Attribute qualification and click OK. or. Creating calculated expressions. Use a Comparison KPI to indicate the progress towards an objective, like sales and goal. Select Add an Advanced Qualification and click OK. Learn how to switch to a compound grid, add column sets in this new visualization. For example, consider the relationship between three attributes: Promotion, Item, and Quarter. The Metric Editor opens in either Function Editor mode or Formula Editor mode, depending on the type of metric you chose to edit. Creating Compound Attributes MicroStrategy Community 3. Following examples uses MicroStrategy Tutorial project to demonstrate the problem and solution. This implies, of course, that more than one ID column is needed to uniquelyidentify the elements of that attribute. 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. To ensure consistency between the metadata and the object cache, remember to update the schema after schema object modifications (i. 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. If you were informed that your company had sales of $100,000, you can gather. Enable the Source Visualization to Update the Target Visualization. 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. A report is a MicroStrategy object that represents a request for a specific set of formatted data from your data source. The operators and functions can be applied to facts, attributes, or metrics. For example, in the image below the document level global lookup table uses two-key (or two-ID) sorting, while the lookup tables use a single key (ID) sorting. Using a combination of filters and metric dimensionality, the same results can be achieved. Create the following objects: a. Attributes provide a. Set the qualification type to 'Custom'. Last. MicroStrategy is a business intelligence tool, that supports interactive dashboards, highly formatted reports, scorecards, alerts, ad hoc queries, automated report distribution, thresholds, etc. With MicroStrategy HyperIntelligence, organizations can inject Zero-Click Intelligence about customers, products, people, and more directly into websites or web applications. By default, the Partition Attribute pull-down menu is set to Automatic, which allows MicroStrategy Web to set the number of partitions. Quite often these attributes have automatic mapping for one ID and manual mapping for the other one. 12 String Functions are supported by the MicroStrategy Analytical Engine; however, the following functions can push down: Char. If ReportLevel includes all the attributes on the template and in the report objects window, and ViewLevel includes only the attributes on the template, then the following is an example of how dynamic aggregation would apply to a smart metric. A compound attribute is an attribute with multiple columns specified as the ID column. Metadata could be hosted on most databases. How to create a conditional attribute in MicroStrategy Desktop. DATE ie. To create a compound key (composite key), users. This attribute join type is the default setting. If the user defines more than one expression for a given form, heterogeneous mapping will automatically take place when tables and column names require it. The Compound Grid is a new visualization introduced in the MicroStrategy 2020 release. 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. UnderstandingFunctionsinMicroStrategy 5 TheBasicsofMicroStrategyObjects,ObjectDefinitions,andFunctions 6 FunctionSyntaxandFormulaComponents 9Consider the following scenerio: A user wants to create a metric which ranks the Regions according to Revenue at a company-wide level. The derived metric aggregates at the level of the attributes on the visualization by default. HyperIntelligence allows you to add various, or alternate, forms of the keyword attribute for matching. 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. Drag an attribute from the Datasets panel to the Rows area of the Editor panel. ; Dossier authoring enhancements, including: New context menu options to move, copy, or duplicate images, text boxes, and HTML. The attribute editor allows users to create attribute forms, connect attributes to logical tables in the schema, and edit form expressions. the report designer in a way similar to any other table. The purpose of filtering these tables is to obtain datasets that have a common attribute, but different values for it to ensure no overlap. 1 - 10. Join Specifications. Users can also create compound attributes, define attribute relationships in the system hierarchy and modify display and sort. You can type arithmetic operators (such as + and -) and comparison operators (such as < and >) directly in the metric expression. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence; Multi-Cloud. Visit the data visualization and data dashboard galleries for inspiration. This implies that more than one ID column is needed to uniquely identify the elements of that attribute. Select Category and Quarter from the Available attributes list and click > to add them to the Selected attributes list. Create compound attributes. MicroStrategy pushes the calculations for the following built-in basic functions down to Teradata using the associated SQL patterns.