This is a filter which contains a prompt on an attribute element list. g. The only solution that I can think of is to create a FreeForm SQL Report. Compound Key attribute; How to create a derived attribute in MicroStrategy? A derived attribute in Microstrategy has a value that is decided by the combination of two or more columns. There are several ways to create and apply filters to individual chapters, multiple chapters, or across an entire dossier. By ManishaGupta that reached out to. Drag an attribute from the Datasets panel to the Columns area of the Editor panel to add attributes to the columns. Any time you type an attribute whose name contains one or more spaces, the attribute must be enclosed in square brackets. Visit the data visualization and data dashboard galleries for inspiration. Drag an attribute or metric from the Datasets panel to the Columns Set area in the Editor Panel. 5. Shorter data types are faster to join than longer. Enter a name to use for the new attribute in New Attribute Name. The key icons are not intended to reflect the warehouse table's physical keys, but rather which logical attributes in the MicroStrategy schema should function as lowest-level join attributes for this table. Simultaneously creating multiple attributes. Create a filter on the attribute "Year. But in reality, many of these dimensional relationships change over time. An input box will be displayed with a list of recommended questions based. x-10. x and 10. For instance, the attribute City may be defined in the data model as a combination of COUNTRY_ID and CITY_ID. Select 'Yes or 'No' from the drop down list. To access the Date Editor to create dynamic dates, execute the following steps: In the Filter Editor, choose to add an attribute qualification. Create Multiple Element Groups. 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. It is used to insert any single-value, database-specific functions and simple operators directly into SQL. For example, given a report with Revenue and Cost, the custom subtotal will return total Profit, as shown below:The Profit metric is a simple sum of the Profit fact. This example uses 'AliasMonth' to build the filter as shown in the image below: Build a report using the filter created above. Create a Compound Attribute. Type the following for the name: "Total for the #P #0". Open up the same document in MicroStrategy Web 10. Slowly changing dimensions (SCDs) are a common characteristic in many business intelligence environments. • For example, the attribute Customer has the forms ID, First Name, Last Name, Address, and Birth Date. The following steps describes how to create such derived metric. compound attributes. Do not set any additioMicrostrategy Dossiers With the release of MicroStrategy 10. multiple attribute forms conform the ID form, any element that matches at least one of the ID's will become. x-10. Get the instant response experience with new features unique to the app such as Smart Download and Automatic Refresh that predict and proactively download the content you need both online and offline. Select the Logical View Tab of both tables to see all the logical objects mapped to the table. If these three columns are mapped to attributes in MicroStrategy, then the primary key is represented correctly. This is a filter which contains a prompt on an attribute element list. There are no restrictions on the names for the columns used in the expressions of a given attribute. Advanced topics include the following: Introduction to Advanced Reporting, reviews the tasks and objects to create a basic report and previews advanced reporting concepts. Press and hold the Ctrl key to select multiple attributes or metrics. Generally, you create a compound attribute when your logical data model reflects that a compound key relationship is present. The following procedure describes how to achieve this: Create the highest level filter. After migrating to MicroStrategy 9. Logical Views allows application architects to create any desired view using MicroStrategy, without DBA involvement. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. OrgChartVisPlugin. The Compound Grid is a new visualization introduced in the MicroStrategy 2020 release. Consider the following example from MicroStrategy Tutorial: Create a custom group called "Category" which has two group elements, 1 and 2. location_path is the folder where the attribute is to be placed, of type string,. Important: Most MDX Cube providers include functionality to create the analogue of MicroStrategy derived metrics, such as SAP's Calculated Key Figures or Microsoft Analysis Services' Calculated Members. To uniquely identify a distribution center, one must know two details about the distribution center: the ID. How to start. 2 From the Schema menu, select Architect. The derived metric's value is 12. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. The Attribute element prompt is the most restrictive, allowing users to choose from the fewest number of attribute elements to define their filter criteria. An example showing a control key value of F59 is shown below: Follow the URL syntax in KB38841 to create the hyperlink for passing selections. The 'Set as key' option is used for defining the lookup table primary key for the attributes when generating SQL with MicroStrategy Engine. A setting in MicroStrategy Web 9. In this case, only one form exists for each, as shown below:Natural Language Query (NLQ) allows end users to build dossiers and get insights just by typing questions. ” icon to expand it: All page-by attributes will. Right-click the selected columns and select Create Multi-form Attribute. xThe following procedure describes how to achieve this: Create the highest level filter. Create a report with Attribute "Year", custom group "Category" and Metric Revenue; Click in the Metric Revenue in Report Object and go to Insert Tab; Percent to Total; Total for each;A derived attribute has its value determined by an expression which combines two or more columns in a database to create a new column. The Input Metric Formula dialog box opens. This issue is being investigated by the MicroStrategy Technology team. STEPS TO IMPLEMENT. (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. Create a filter on the attribute "Year. This calculation can be aggregated from the Employee level to the Region level. primary key or a composite primary key. To Create an Attribute-To-Attribute Qualification that Compares the Call Center and Customer City Attributes In MicroStrategy Web, log in to a project. To create a list of attribute elements from which users can choose, select Use a predefined list of elements. Super Cubes are simply a renaming of what was previously referred to as MTDI (Multi Table Data Import) Cubes. In MicroStrategy Developer, open Architect. Create a report with Category, and Revenue; 2. On the toolbar, click the drop-down arrow on the Create a New Object icon, and select the type of object to create. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. In MicroStrategy Developer, go to File > New > Metric. Create and Edit a Visualization-Based Filter. Open any folder page. All Files. , the New York store is part of the Northeast Region. A compound attribute is an attribute with multiple columns specified as the ID column. Use the Ctrl key to select multiple attributes and metrics. This attribute join type is the default setting. Place attributes Country and Distribution Center on report template, and the above metric either on report template, or in Report Objects window if you have an OLAP license. . NOTE: If the above drop down list is disabled, the metric is not a compound metric and so smart totaling does not apply. Press and hold the Ctrl key to select multiple attribute elements. An empty filter appears in the dossier. In the relational database. Also, you add both attribute IDs, in this case Item_ID and Color_ID, to the fact table as shown in the following diagram. To add a parent attributes, drag the appropriate attributes from the Candidates list into the Parent drop zone under Directly Related Attributes. They are therefore all logical keys for that table. You cannot change the join types of. 2. Save the new metric as "Sum of Compound Metric". How to set up a Compound Key for an attribute in MicroStrategy Developer 9. Difference between Facts and Attributes. 1. Create a new consolidation with three elements - Winter, Spring and Winter + Spring, as illustrated below: Create a report with the above created consolidation and three metrics - 'Revenue',. 1 and 10. The resulting SQL will contain just the Metric Alias. Choose one of the following: Save the metric. Microstrategy follows an algorithm to calculate the logical size of a table, which depends on the no of attributes and facts based on the table and also the position of those attributes in the system hierarchy. Compound Key Attribute. How to create an attribute in MicroStrategy What are attributes? Attributes are groups of related data, such as table columns. How to convert a . x and add a derived attribute, right clicking an. The Input Metric Formula dialog box opens. Click Add Column Set to create another column set. 4. Metrics are completely reusable - they can be added to different reports or even other metrics. " Click. For Compound Profit to be dynamically aggregated correctly, you change the dynamic aggregation function to Sum. ApplyAgg. The examples below describe how to drill on these compound metrics on both grid and graph reports. " Click "prompt on attribute element list" and click "Next" through the rest of the screens to accept the default values. Actually, multivalued attributes violate First Normal Form. " Click "prompt on attribute element list" and click "Next" through the rest of the screens to accept the default values. x? Number of Views 6. Launch the Prompt Generation Wizard in MicroStrategy Developer by going to File menu > New and choosing 'Prompt'. You can also create new attributes, based on existing attributes in your dataset, while viewing a dossier. Add one of the following rows to change your AE version to either. " Click "prompt on attribute element list" and click "Next" through the rest of the screens to accept the default values. Adding attributes with the Attribute Editor. To Create a Combination Graph. 2. By default, the metrics Compound Profit and Profit Margin do not use a dynamic aggregation function. Now to fix this create a new Derived metric on Category attribute first with formula as Max (Category) {~ } and calling Books. Add 'AliasMonth' to the report template as shown in the image below: Create a. The Count function in MicroStrategy does have a parameter to include or exclude nulls, but including nulls can only count rows that exist in the result set. Notice the only level available under the 'Across level' option is the attribute 'Region'. Remember that P displays the parent attribute and 0 (the number zero, not the letter o) displays all the forms of the parent attribute. The only solution that I can think of is to create a FreeForm SQL Report. Attribute name:XXXX" is thrown after attempting to map a compound key attribute to SAP properties in MicroStrategy Analytics Enterprise. 4. Here the many-to-many relationship is converted into a compound attribute relationship. Do not set any additio Use the same steps as specified in the help menu: Open attribute editor (right-click on attribute and select 'Edit') Select the forms that will make up the compound key. Click in “Add new data”. In this case, from the Table Editor's Layout tab, you. In the Create New Form Expression window in the Attribute Editor, select the above table as the source table and use the following ApplySimple statement to define the expression: Applysimple( "#0 '-' #1 '-' #2", ID, Quarter, Year)Here the many-to-many relationship is converted into a compound attribute relationship. In the Visualization Gallery, click Combo Chart to create a combination graph. an integer number) for your main table and link each set of D values to the necessary record. Attribute_ID2= “,B1,”)”). To create an Attribute Qualification prompt. Each custom format can have up to four. The Group Editor opens. The multiple columns are joined with other attributes, typically in a many-to-many relationship. To create an attribute using Architect 1 In MicroStrategy Developer, log in to a project. The hyperlinks based on an attribute form compound by Applysimple no longer work when exporting to MHT in MicroStrategy 9. 16K KB41943: How to create a metric that calculates the distinct count of an attribute. 9/10. 4. " Click "prompt on attribute element list" and click "Next" through the rest of the screens to accept the default values. An attribute form expression defines what columns in the warehouse are used to represent the attribute form in SQL. 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. the attribute definition window. Continue with the previous Steps 2 and 3 above. This is a filter which contains a prompt on an attribute element list. Go to Data > VLDB Properties > Joins > "Preserve all final pass result elements. 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:If it is desired to have SQL generated that specifies a distribution key on all columns that are used in the intermediate table (and not just attribute ID columns), the same combination of VLDB settings may be used as above, except for replacing the wildcard !a by !!! as below: Create Post String = DISTRIBUTE ON (!!!)This issue is being investigated by the MicroStrategy Technology team. In Web 2020 you can only use attributes in rows. Click Attribute Qualification Prompt. A. 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. For example, a warehouse table's primary key is defined using the columns CUSTOMER_ID, PRODUCT_ID, and ORDER_ID. 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. Click Add, select the elements, then click OK. Choose File > New Attribute. KB20000: How to create dynamic dates using MicroStrategy Developer 9. The only solution that I can think of is to create a FreeForm SQL Report. Multivalued attributes cannot work as primary keys. Uncheck the 'Use default inherited value' box and set the option 'Create composite index for temporary table column indexing'. After choosing the attribute, choose to qualify on the ID, as in shown below: The user will now be able to access the. After choosing the attribute, choose to qualify on the ID, as in shown below: The user will now be able to access the. Compound keys add complexity to SQL. Create a metric that is defined as Max(Promotion Type @ DESC). Create and Edit a Visualization-Based Filter. You must create a compound attributes when an attribute requires two or more columns to uniquely identify its elements. Right-click and select New > Attribute. Click Insert Visualization to add a new, blank visualization to the dossier. Open a new or existing dossier. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. To uniquely identify a distribution center, one must know two details about the distribution center: the ID. Obviously, you create the table, load it into the Warehouse Catalog, create the new fact and update the schema. Workaround 4: Create a metric based on the attribute Country, for example Max (Country). All articles. x. In this case, only one form exists for each, as shown below: Natural Language Query (NLQ) allows end users to build dossiers and get insights just by typing questions. desc is the description of the attribute, of type string, between double quotes ("). From the 'Edit' menu,. So the good idea is to create a separate table and push multivalued attribute into it. " Click "prompt on attribute element list" and click "Next" through the rest of the screens to accept the default values. You can create a stand-alone prompt, or you can create a prompt that is embedded in a filter. Do not set any additional conditions. Contact MicroStrategy Technical Support for assistance with the issue. In MicroStrategy Developer, choose File > New > Report. A screen appears where users can choose to create a specific type of value. To display this property, enable 'Show Advance Settings' from the Tools menu in the VLDB properties editor. " Click "prompt on attribute element list" and click "Next" through the rest of the screens to accept the default values. 1. Create a filter on the attribute "Year. Microstrategy - MSTR - Find the Lineage information from Table/Column to. The attributes and metrics appear as filters. This is often confused with a composite key whereby even though this is also a key that consists of 2 or more attributes that. The cursor is positioned between the parentheses in the Definition pane. MicroStrategy is as follows: 1. 1. Select the check box for any smart attribute that needs to be created. The three dialog boxes are New Attribute, Create New Attribute Form, and Create New Attribute Form Expression. The table now appears in bold as shown below. Type RunningAvg in the Definition pane. From the Insert menu, select New Metric. Save the filter as "YEAR FILTER:" Knowledge Base: How to create a metric to calculate the difference for a same metric but two different attribute elements in MicroStrategy Visual Insight? Knowledge Base: How to create a Derived Transformation Metric using the MicroStrategy Java Web SDK 9. Use the Ctrl key to select multiple. Using the MicroStrategy Project Tutorial, create a report with the attributes Category, Subcategory and the metric Revenue. The metric can also show a total by page, show a total for each value of the attribute, or show the grand. In the visualization, select the attribute elements to use in the group. Go to Data > Subtotals > Total, and click on the advanced tab. Compound Metrics. Create an attribute with a compound key In the metric editor, drag the attribute to the metric definition Consider the following: if the attribute you created is. Consolidation can not be used as Sort key from MicroStrategy Web 10. Advanced Metrics, explains level metrics, conditional metrics, transformation. The designed behavior is explained using an example consolidation and compound metric based on objects in the MicroStrategy Tutorial project. x-10. The Year - Define a new member attribute. How to create an attribute that masks data elements in MicroStrategy Developer (formerly Desktop). Click Insert Visualization . In the Gallery, click Compound Grid . This is a filter which contains a prompt on an attribute element list. In the Navigation pane, click , next to Objects. Create the highest level filter. Right-click, choose Calculation, and the type of calculation to create the derived element based on. The attribute level follows a consecutive order from. 6. An in-line many-to-many relationship involves an attribute with at least one parent and one child. Save the filter as "YEAR FILTER:"Knowledge Base: How to create a metric to calculate the difference for a same metric but two different attribute elements in MicroStrategy Visual Insight? Knowledge Base: How to create a Derived Transformation Metric using the MicroStrategy Java Web SDK 9. " Click "prompt on attribute element list" and click "Next" through the rest of the screens to accept the default values. On the Freeform Sources tab, select Create Freeform SQL report. ACTION: Ensure that there is another attribute that has a common column in their lookup table with the attribute you are working with. This calculation can be aggregated from the Employee level to the Region level. ; On the Freeform Sources tab, select Create Query Builder report. For example, consider the relationship between three attributes: Promotion, Item, and Quarter. This URL executes a report with one prompt. The steps below use objects from the MicroStrategy Tutorial project as an example. In Visual Insight in MicroStrategy Web 9. During your initial project design effort or later in a project's life cycle, you can create multiple attributes using the Attribute Creation Wizard. Drag an attribute or metric from the Datasets panel to the Columns Set area in the Editor Panel. Filtering a Metric When the Filtering attribute is Not on the Template The general syntax to filter a metric when the filtering attribute is not used on the template is to place the metric and the attribute element together in parentheses:Click the Attribute Relationships tab. I want to create an index for efficient lookup when 3 or more values are specified in the "where" clause. when you define attributes you set a lookup table. Compound key requires multiple columns to identify a unique record. Double-click the Column Set name to rename the set. Select the chapter that contains the visualization to filter. Calculate each attribute individual weight according to the level in the hierarchy (level in hierarchy/number of levels in hierarchy * 10). Browse to the Platform Analytics Cube in the Platform Analytics Project and select the option to create a new dossier. Click Advanced, then New to create a custom subtotal. The following SQL demonstrates that by having all the keys from the fact table on the report template, the setting "The key specified is the true key for the warehouse table" allows the metric to return the values straight from the fact table without aggregation. When you create a form expression using a custom expression or multiple columns (as discussed in Attribute form expressions), the column alias for the attribute. Attribute_ID1 = “,A1,” AND a11. To open a document in Editable Mode, from a folder, right-click the document, point to Run as, and select Editable. Although transformations can be applied to any attribute hierarchy, the Time hierarchy is used most often. 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. From the File menu, select New, and then Attribute. Note: The two IDs must come from multiple source tables, and one of them should have the format type of Text. Find centralized, trusted content and collaborate around the technologies you use most. Slowly Changing Dimensions. Consider the following scenerio: A user wants to create a metric which ranks the Regions according to Revenue at a company-wide level. Open MicroStrategy Web. 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. A compound report displaying multiple grids and graphs. The derived attribute can be a string, number, or date. Drag from the middle of the attribute to an. Click the visualization to add the group to. Here's what you would need to do in your code: public class MyTable { [Key, Column (Order = 0)] public string SomeId { get; set; } [Key, Column (Order = 1)] public int OtherId { get; set; } } You can also look at this SO question. " Click "prompt on attribute element list" and click "Next" through the rest of the screens to accept the default values. The attributes and metrics appear as filters. In MicroStrategy Web, on the Home page, click New Prompt. You can also access the Attribute Creation Wizard at any time in the development of a project from the Schema menu in MicroStrategy Developer. This design may look strange, but in most cases there are sound. Defining the partition for Super Cubes. Create a Default Dynamic Selection Filter. English Deutsch Français Español Português Italiano Român Nederlands Latina Dansk Svenska Norsk Magyar Bahasa Indonesia Türkçe Suomi Latvian Lithuanian česk. x and 10. In MicroStrategy Agent, go to Schema Objects > Attributes. Several non-group functions that are. 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. 2. To create a compound key, users must create multiple attribute forms, group them together and set the form group as the key for the attribute. Can you apply themes to MicroStrategy Web? How to create a one? After a bulk. An input box will be displayed with a list of recommended questions based. Derived Attributes A derived attribute has its value determined by an expression which combines two or more columns in a database to create a new column. The steps to create such an attribute: The primary key is made up of the lowest level attributes. In general, ApplySimple can be used to create the following objects: •. Double-click the security role you want to assign to the user or group. Click Save and Update Schema. Create your metric's formula. This is a filter which contains a prompt on an attribute element list. Shorter data types are faster to join than longer. This type of passthrough can be used to create flexible filters. In the Gallery, click Compound Grid . 4. The types of keys that can be assigned to a table include: •. Continue creating the metric (for example, adding levels or conditionality) . To change the order of the transformations, select a transformation and use the directional arrows to re-position it. Creating attribute form expressions • Creating and modifying attribute data types: Column aliases • 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 • Part 2 of the MicroStrategy Advanced Architect series where I demonstrate how to create compound attribute keys. Dynamic dates are created in MicroStrategy Developer by using the Filter Editor. In the visualization, select the attribute elements to use in the group. Important: Most MDX Cube providers include functionality to create the analogue of MicroStrategy derived metrics, such as SAP's Calculated Key Figures or Microsoft Analysis Services' Calculated Members. Open the Workstation window with the Navigation pane in smart mode. This is a filter which contains a prompt on an attribute element list. Actually, multivalued attributes violate First Normal Form. Metric Guide; Compound Metric; Steps to Reproduce. Click Save and Update Schema. Support for Standard, LDAP, Kerberos, and Integrated Authentication. Click on 'OK' and save the. Composite Key: A composite key is made by the combination of two or more columns in a table that can be used to uniquely identify each row in the table when the columns are combined uniqueness of a row is guaranteed, but when it is taken individually it does not guarantee uniqueness, or it can also be understood as a primary key made by. Follow the steps below. Define the advance sort on the derived. 'Customer Birthdate' is used in this example. How to Create a Derived Attribute or Metric. In some cases, it may be preferable to define multi-level calculations as cube objects, rather than as metrics in MicroStrategy. For instance, the attribute City may be defined in the data model as a combination of COUNTRY_ID and. Once an attribute has been selected, the button is replaced by the. x and 10. Might need to play with formatting to make sure. 4. Basically how. The primary key should be compact (avoid the use of long data types). Click All Objects View. The following steps can be used to concatenate two attribute forms. x. So the good idea is to create a separate table and push multivalued attribute into it. Glossary. Implicit attribute; Derived attribute; Compound Key attribute; How to create a derived attribute in MicroStrategy? A derived attribute in Microstrategy has a value that is decided by the combination of two or more columns. KB39189: How to create a count of different attribute element values using subtotals in MicroStrategy Desktop 9. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched. Open the registry key at HKEY_LOCAL_MACHINE]\SOFTWARE\MicroStrategy\DSS Server\Castor. When the attribute used as a selector has a compound key, i. Click the visualization to add the group to. From the Insert menu, select New Metric. Simultaneously creating multiple attributes. Learn how to create compound project attributes in MicroStrategy Developer, an advanced environment providing a complete range of analytical functionality designed to. The primary key should contain the fewest possible number of columns (limit the use of compound keys). Beginning in MicroStrategy 11. To do this: a. Here the many-to-many relationship is converted into a compound attribute relationship. Drag attributes or metrics from the Datasets panel to the Filter panel. •. Workaround Since the Offsets are handled by the MicroStrategy Services Broker, you should reset the Broker List ID to make all newly submitted transactions unique from the transactions existing in the ecosystem. x allows users and administrators to decide if the attribute titles are displayed using the attribute name or the attribute form name: The setting to control the appearance of the attribute title is located under Preferences - Grid Display: Show Attribute Form Names. 1, an attribute in a grid can be used as selector to target other grids in the same dashboard. Here is the workaround to achieve the attribute left outer join on MicroStrategy Web. When the attribute used as a selector has a compound key, i. This condition may be implemented through an ApplySimple statement such as the following: The user will find that the CASE statement. MicroStrategy Web automatically creates attributes when you import data. The key attributes are determined solely by attribute mappings to the table and attribute relationships, where the logical table keys. Forms other than key and relationships are removed if this setting is enabled. Create the relationships and hierarchies. Create a metric with the formula Max(Month Duration) {~} (metric max month) called 'max month'. Select the correct Form Category, such as ID. The following procedure describes how to achieve this: Create the highest level filter. Composite keys are constituted of two or more columns which together act as unique identifier. x Product Suite, all the application, schema and configuration object definitions and other project-related settings are stored in the metadata. 3. The implicit attribute has its own expression. This article notes a limitation of mapping MDX attributes to schema mapped attributesLet’s say you need to create a new table that should contain the compound key attribute and a new fact. However, before changing the way MicroStrategy products look or behave, it is helpful to understand how the application is built. Select the function to use to calculate data in the metric. For example, in the MicroStrategy Tutorial project, for the 'Month' attribute, instead of seeing the description as 'September 2007, users might prefer to see 'Sep'. Create a new metric based on the OLAP function RunningCount: 3. You can also create multiple attributes using Architect, which is described in Adding and modifying attributes. In the top pane of the Preview dialog, click the columns you want to use as attribute forms to select them. When columns are added to the Selections pane, Query Builder automatically maps the column to an attribute or metric object, based on the column name. This is a filter which contains a prompt on an attribute element list. Turn off the Platform Analytics Consumer. Number of Views 5.