How to Create a Derived Attribute or Metric. Remember that P displays the parent attribute and 0 (the number zero, not the letter o) displays all the forms of the parent attribute. A compound key attribute is an attribute that has two or more IDs. g. In the attributes list, right-click the Commute Distance attribute and then select New Attribute Relationship. including best practices reports, scorecards, and dashboards, key. You then create a new metric based on the new fact and attempt to use it in a report, together with the compound key attribute. Enter the definition of the derived attribute directly into the right pane. It can be set at the project and. x. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. Advanced topics include the following: Introduction to Advanced Reporting, reviews the tasks and objects to create a basic report and previews advanced reporting concepts. Define the advance sort on the derived. Create a filter on the attribute "Year. This example uses 'AliasMonth' to build the filter as shown in the image below: Build a report using the filter created above. EN. x and 10. The primary key should be dataless (a primary key should not be. The implicit attribute has its own expression. 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 following procedure describes how to achieve this: Create the highest level filter. This design may look strange, but in most cases there are sound. 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. Then you also set the parent child relationships in. This join type lets you display only those attribute elements that are common to the lookup tables and the fact tables in your data warehouse. Create and Edit a Visualization-Based Filter. Attribute_ID1 = “,A1,”. The types of keys that can be assigned to a table include: •. To uniquely identify a distribution center, one must know two details about the distribution center: the ID. Attribute_ID1 = “,A1,” AND a11. To create an attribute filter Open the dossier you want to modify. The derived attribute can be developed based on an object. long_description is the long description of the attribute, of type string, between double quotes ("). Drag the attributes and metrics for filtering from the Datasets panel to the empty filter. A dialog used to create and edit MicroStrategy Objects. Upgrade your Web. From there, put the elements into one group that is labeled "Inbound Costs" and make another that is labeled "Outbound Costs". 0. Create a compound key for an attribute; Create a derived attribute; Create and delete a form group for an attribute; Create a joint child attribute; Create a new attribute. You must determine which attribute will be displayed to the user when the user is prompted. Derived Attributes. Open attribute editor (right-click on attribute and select ‘Edit’) Select the required forms to create the key From the ‘Edit’ menu, choose Group as shown below. In the Navigation pane, click , next to Objects. The derived metric's value is 12. Type the following for the name: "Total for the #P #0". This optimizes the SQL generated considerably:Visualizations that can be used in a dossier appear in the Gallery panel. You can also create new attributes, based on existing attributes in your dataset, while viewing a dossier. The only solution that I can think of is to create a FreeForm SQL Report. Do not set any additioHere is the workaround to achieve the attribute left outer join on MicroStrategy Web. MicroStrategy Web automatically creates attributes when you import data. Use fictional primary key (i. 2. 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. You can type arithmetic operators (such as + and -) and comparison operators (such as < and >) directly in the metric expression. In short, an inner join includes only the data common to all the elements in the join, whether that data is tables or metrics. Create a filter on the attribute "Year. 3. Use "Access External Data" feature in MicroStrategy Web 10 to import data. You can use the Custom Visualization API to create tooltip functionality using third-party plotting libraries like D3. To view and edit the parents and children of an attribute. Click the visualization to add the group to. Compound keys add complexity to SQL. For detailed information on attribute roles, refer to Attributes that use the same lookup table: Attribute roles. The Input Metric Formula dialog box opens. e. Simple key requires only one column to identify a record uniquely within a table. 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. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. Learn how to switch to a compound grid, add column sets. Update:To add a filter: Open the dossier with the heat map visualization you created in How to Create Your Heat Map Visualization. " Click "prompt on attribute element list" and click "Next" through the rest of the screens to accept the default values. Also, you add both attribute IDs, in this case Item_ID and Color_ID, to the fact table as shown in the following diagram. It helps to merge or concat two columns in the same group. 0. Update:Projects - MicroStrategy. New user and application. The multiple columns are joined with other attributes, typically in a many-to-many relationship. Ensure that the project schema for your new attribute is available for editing. Select the chapter that contains the visualization to filter. The types of keys that can be assigned to a table include: •. This is a filter which contains a prompt on an attribute element list. In Data Preview page, use ctrl or shift key to select multiple columns, and right mouse click, choose "Create Multiform Attribute" function, as shown below: In the Create Multi-form Attribute window, assign Form. Execute the report. Use the same. Press and hold the Ctrl key to select multiple attributes or metrics. Right-click and select New > Attribute. Double-click the Column Set name to rename. This name change is visible in. The derived attribute can be a string, number, or date. Apply Filter Changes. An in-line many-to-many relationship involves an attribute with at least one parent and one child. The attribute level follows a consecutive order from. Create a filter on the attribute "Year. Create a metric that is defined as Max(Promotion Type @ DESC). Create a filter on the attribute "Year. Any time you type an attribute whose name contains one or more spaces, the attribute must be enclosed in square brackets. On the Background tab in the Format Cells editor and select 'Solid' as background style and choose black as the color for the 'Fill' drop-down. For information on training metrics and creating predictive. Select the chapter that contains the visualization to filter. for that attribute ( say a dimension table). A developer can build simple or compound metrics, apply to them many additional features like conditionality, level, transformation and also specify the formatting. Ans: A Compound key attribute is a primary key that is made up of two or more columns and these columns are joined with other attributes. This visualization allows you to create a grid that analyzes different aspects of data across a common dimensions or attributes in rows. Create the highest level filter. The Attribute Editor opens three dialog boxes, if the cascading dialog box option is enabled in the Developer Preference (as it is by default). The Create New Attribute Form dialog box now appears. Right-click the group and choose Set as key. A compound attribute in Microstrategy is where more than one column is. For Compound Profit to be dynamically aggregated correctly, you change the dynamic aggregation function to Sum. NOTE: If the above drop down list is disabled, the metric is not a compound metric and so smart totaling does not apply. Select the check box for any smart attribute that needs to be created. However, it is recommended that you use the provided tooltip API that is capable of creating the same style tooltips as out-of-the-box widgets. By ManishaGupta that reached out to. Primary Key – is a column or group of columns in a table that uniquely identify every row in that table. Arithmetic operators are +, -, *, and /; non-group functions are OLAP and scalar functions such as running sum or rank. 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). For example, if attribute Region is 'Central' then derived metric value should be 'Profit + Cost'. 'Create Individual Index' VLDB setting is an advanced setting that is hidden by default. Consolidation can not be used as Sort key from MicroStrategy Web 10. Select the function to use to calculate data in the metric. The designed behavior is explained using an example consolidation and compound metric based on objects in the MicroStrategy Tutorial project. Also, you add both attribute IDs, in this case Item_ID and Color_ID, to the fact table as shown in the following diagram. Create a filter on the attribute "Year. ApplyAgg. Multivalued attributes cannot work as primary keys. Then, click 'OK'. Attribute_ID1 = “,A1,” AND a11. You treat one attribute as a child of the other and have a compound key for the lower level attribute. 4. it seems like a small gap to breach to finalize this API endpoint. Schema objects: Schema objects are generally created by a project designer and include such things as facts, attributes, hierarchies, and transformations. There are no restrictions on the names for the columns used in the expressions of a given attribute form. From the MicroStrategy Developer File menu, point to New > Attribute. multiple attribute forms conform the ID form, any element that matches at least one of the ID's will become. For instance, the attribute City may be defined in the data model as a combination of COUNTRY_ID and. Click 'Browsing Options' and check the 'Display hidden objects' checkbox and click OK twice. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Create Multiple Element Groups. The following steps create an attribute-to-attribute qualification filter that generates the list of desired cities. Select an operator, such as Equals or Less Than, from the next drop-down. Drag attributes or metrics from the Datasets panel to the Filter panel. In Workstation 2020 you can only use attributes in rows. To create an attribute using Architect 1 In MicroStrategy Developer, log in to a project. For example, if sales data is stored in the data warehouse at the day level, a month attribute allows users to. Learn how to create compound project attributes in MicroStrategy Developer, an advanced environment providing a complete range of analytical functionality designed to. You cannot change the join types of. Choose one of the following: Save the metric. #Command Manager Scripts in Microstrategy to create a user and add to a group #command manager add user #command manager add group; #Compound Key attribute; #Compound key attribute #Compound key attributemstr #Compound key attributemicrostratey; #compundkeymstr; #Configure Connection Mapping in Microstrategy #configureconnectionmapping #. the logical key gets mapped for a table in. Definition : Max(Day) Condition : nothing; Level : Remove report level and add Day (standard, standard) Create a. Choose File > New Attribute. This is because the key attribute should always be unique in the warehouse table or it should not be used as the key for the table. Once you’ve downloaded the example excel sheet, we will proceed to explain step by step how to import our file. Now to fix this create a new Derived metric on Category attribute first with formula as Max (Category) {~ } and calling Books. This is one of the. Difference between Facts and Attributes. Click Insert Visualization . compound attributes. Select 'Yes or 'No' from the drop down list. Composite keys are constituted of two or more columns which together act as unique identifier. 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. Attribute name:XXXX" is thrown after attempting to map a compound key attribute to SAP properties in MicroStrategy Analytics Enterprise. The table below summarizes a few key modules that commonly consume the most amount of time during a dashboard execution:In the MicroStrategy 9. " Click "prompt on attribute element list" and click "Next" through the rest of the screens to accept the default values. The functionality of MicroStrategy is such that the outer functions of metrics can only calculate to levels that are specified on the report. 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. 16K KB41943: How to create a metric that calculates the distinct count of an attribute. 1, an attribute in a grid can be used as selector to target other grids in the same dashboard. Do not set any additio In the relational database, a compound key is a primary key that consists of more than one database column. The key immediately following this keyword is the selector control key. Press and hold the Ctrl key to select multiple columns. Select the attributes, then click to return to the Prompt Generation Wizard. Create a duplicate of the Month attribute and name it 'AliasMonth' Create a filter that will prompt users to select the Month attribute. •. This is often confused with a composite key whereby even though this is also a key that consists of 2 or more attributes that. Right-click the table, point to Recognize, and then select Attributes. Follow the steps below to reproduce it: Create report with consolidationCreate project models from MicroStrategy Developer Create ad-hoc models from MicroStrategy Web; Workflow. Visit the data visualization and data dashboard galleries for inspiration. This knowledge base article documents the process of creating compound keys for attributes in MicroStrategy Developer 9. " Click "prompt on attribute element list" and click "Next" through the rest of the screens to accept the default values. 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. From the Insert menu, select New Metric. 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. Use fictional primary key (i. The following steps describes how to create such derived metric. Click the “Burst. Do not set any additioMicrostrategy Dossiers With the release of MicroStrategy 10. While knowing your company’s total sales is useful, knowing when and where the sales took place provides the kind of analytical depth that users require on a daily basis. Open MicroStrategy Web. Open the Workstation window with the Navigation pane in smart mode. Create a report named 'Variable Metric': Place the attribute 'Region' on the rows. Drag the attributes and metrics for filtering from the Datasets panel to the empty filter. The following procedure describes how to achieve this: Create the highest level filter. The primary key is made up of the lowest level attributes. Open the dossier you want to modify. On the toolbar, click the drop-down arrow on the Create a New Object icon, and select the type of object to create. The implicit attribute has its own expression. This is a filter which contains a prompt on an attribute element list. When the attribute used as a selector has a compound key, i. Tutorial project is used here. Right-click the selected columns and select Create Multi-form Attribute. The logical keys of a fact table in a data warehouse are any columns on which an attribute has been defined in the project. I want to create an index for efficient lookup when 3 or more values are specified in the "where" clause. To use Natural Language Query, go to the Dossier Authoring interface (Web, Workstation, or Desktop), and click on the insight icon located at the top right corner: . 1. KB17619: How to create a conditional attribute in MicroStrategy Desktop 8. Select the Source Table that contains the desired attribute ID, and drag the attribute ID into the Form Expression window. 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',. Workaround 4: Create a metric based on the attribute Country, for example Max (Country). 1) create a metric of your date value and force it to be at the=. How to create an attribute in MicroStrategy What are attributes? Attributes are groups of related data, such as table columns. We use MicroStrategy Tutorial tables that have the Month Id attribute and. A screen appears where users can choose to create a specific type of value. Double-click the Column Set name to rename the set. Which key structure you use to identify a unique attribute in a table depends on the nature of your data and business requirements. Related articles from the Community: Knowledge Base: Is it possible to expose “Create Personal View” subscription option in. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence; Multi-Cloud. If these three columns are mapped to attributes in MicroStrategy, then the primary key is represented correctly. In Microstrategy Developer, create a new attribute by navigating to File > New > Attribute. This is a filter which contains a prompt on an attribute element list. It causes the SQL Engine to calculate for only the attribute elements that exist in both the lookup and fact tables. But in reality, many of these dimensional relationships change over time. Create a Default Dynamic Selection Filter. Click "Prepare data" to enter Data Preview page. • For example, the attribute Customer has the forms ID, First Name, Last Name, Address, and Birth Date. Click Add, select the elements, then click OK. Open the dossier you want to modify. The New Grid dialog box opens. The cursor is positioned between the parentheses in the Definition pane. Note: The two IDs must come from multiple source tables, and one of them should have the format type of Text. Select 'Region' and click OK. Add 'AliasMonth' to the report template as shown in the image below: Create a. Steps to Create Smart Attributes. Turn off the Platform Analytics Consumer. Drag an attribute from the Datasets panel to the Rows area of the Editor panel. Step 2) Create a metric using the following syntax,. You can create a Year derived attribute from a Date attribute in MMDDYYYY. Attribute T contains a form called "email" whose values are email addresses that will be used in the dynamic subscription in Narrowcast. Workaround / Solution. ApplyComparison. To create a list of attribute elements from which users can choose, select Use a predefined list of elements. Each custom format can have up to four. Create a filter on the attribute "Year. Press and hold the Ctrl key to select multiple attribute elements. If you were informed that your company had sales of $100,000, you can gather. Creating attributes is an important step in the initial project design effort, which comes after creating facts when using the Project Creation Assistant. In the Datasets panel, click More next to the dataset to add the attribute to and choose Create Attribute. 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. Define Attribute Relationships. only specify ONE other attribute as the RANGE. The Compound Grid is a new visualization introduced in the MicroStrategy 2020 release. Create and schedule incremental reports when the cube can be partially. To create an attribute filter Open the dossier you want to modify. How to set up a Compound Key for an attribute in MicroStrategy Developer 9. You must select properties for each form when you create forms in the Attribute Editor or Architect in MicroStrategy Developer. 3. Click Filter . Advanced topics include the following: Introduction to Advanced Reporting, reviews the tasks and objects to create a basic report and previews advanced reporting concepts. This is a filter which contains a prompt on an attribute element list. Attribute form properties are settings that affect the display of the forms. Enter a name for the form. In the Gallery, click Compound Grid . Attributes can have multiple attribute forms. Add the “Component Object” attribute to the filter panel and filter on the metric that is of interest. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. Attribute T contains an element t1. Consider the following scenerio: A user wants to create a metric which ranks the Regions according to Revenue at a company-wide level. To enable or disable Smart Totals in MicroStrategy Developer, follow the steps below: Open the compound metric in the metric editor. 1; Product Documentation: How to Create a Derived Metric from an Attribute To Create a Combination Graph. 4. Do not set any additioHow to include an attribute form in a compound or derived metric in MicroStrategy Developer 9. Hierarchy 2: 4. To add a parent attributes, drag the appropriate attributes from the Candidates list into the Parent drop zone under Directly Related Attributes. So the good idea is to create a separate table and push multivalued attribute into it. Composite Key. Select multiple attribute forms, right-click, and choose Group. From the Insert menu, select New Training Metric to use derived metrics as part of Data Mining Services to create training metrics. " Click "prompt on attribute element list" and click "Next" through the rest of the screens to accept the default values. To create a compound key, users must create multiple attribute forms, group them together and set the form group as the. The Security Role Editor opens. Custom number formatting symbols. A compound key attribute is an attribute whose primary key is made up by the combination of two or. 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. Click Add New Form. In addition to specifying the data type to be used for an attribute form, the column alias also lets you specify the column alias name to be used in the SQL generated by MicroStrategy. 1 and 10. Attribute_ID2= “,B1,”)”). Attribute name:XXXX" is thrown after attempting to map a compound key attribute to SAP properties in MicroStrategy Analytics Enterprise. " Click "prompt on attribute element list" and click "Next" through the rest of the screens to accept the default values. Select "DESC" from the 'Qualify On' drop down options and change the operator to "Contains", as shown below:In MicroStrategy Developer, to create a list of the individual fact entries for an attribute in a scenario where the attribute has a fact table as its lookup table Very Large Database (VLDB) 'Distinct/Group By option (when no aggregation and not table key)', users can create an attribute 'Year' that uses the YR_CATEGORY_SLS fact table in. Select the “File from Disk” option. where: attr_name is the name of the attribute, of type string, between double quotes ("). The following procedure describes how to achieve this: Create the highest level filter. In the Attribute Editor, create a new form expression. Here the many-to-many relationship is converted into a compound attribute relationship. 4. Architect allows you to create and modify attributes in most of the same ways as the Attribute Editor. During our 10+ years of work with MicroStrategy we often encountered overlapping cube and cache questions and what are the best practices in order to manage them. MSTR uses lots of components like attribute, metric, facts, Logical Tables etc to build a report. RMC on Revenue and choose Insert -> Percent to Total -> Grand Total to create the Contribution (%) metric;Passing prompt answers for an element prompt when the attribute has a compound ID. II. Metric Guide; Compound Metric; Steps to Reproduce. Click Insert Visualization to add a new, blank visualization to the dossier. In MicroStrategy Web create a new Visual Insight dashboard with the Year attribute, Region attribute and the Revenue metric. 5. Since by changing the ID form of the attribute (compound to single key), the attribute has become a new attribute, personalizations based on that attribute may no longer continue to work and should be recreated. J2EE environment:To create a derived metric. Set "Join Type" to "Join 92" in menu: Data -> VLDB Properties -> Joins -> Join Type, as shown below:. For attributes used only in freeform SQL reports, this should be the same as the form chosen to be 'Set as ID' from Schema menu > Form Categories in MicroStrategy Developer, as shown: ACTION: Add the form corresponding to the lookup table key for the attribute(s) used in the freeform SQL report. •. Click Advanced, then New to create a custom subtotal. I'm working on a dossier and I have a dataset that includes customer types. An input box will be displayed with a list of recommended questions based. Create a filter on the attribute "Year. To achieve this, the users can make use of an Apply Simple statement through a new attribute form in the attribute form expression editor. 3. Connect to a database instance and drag tables into the canvas. 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. There is a Filter Editor, Template Editor, Attribute Editor, Metric Editor, Report Editor, and so on. 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. 10869 views | September 04, 2020 01:10. Can you apply themes to MicroStrategy Web? How to create a one? After a bulk. " Click "prompt on attribute element list" and click "Next" through the rest of the screens to accept the default values. Defining the partition for Super Cubes. Select the data set and click Prepare Data. A user may want to create an attribute with an alternating expression depending on a certain condition, a conditional attribute. Starting in MicroStrategy 11. On the example above, they are displayed as Report Objects on the left of the Report Viewer. Writing the WHERE block should be no problem, as you can generate it in MS Excel based on the two columns… something like =CONCATENATE (“OR (a11. It causes the SQL Engine to calculate for only the attribute elements that exist in both the lookup and fact tables. 2. 4. For information on compound attributes, see Attributes with multiple ID columns: Compound attributes. A compound key attribute is an attribute whose primary key is made up by the combination of two or more columns. One of the component metrics that makes up the Compound metric is made with the Count() function and has the Metric Guide changed from "Automatic" to an attribute. The following procedure describes how to achieve this: Create the highest level filter. There are several ways to create and apply filters to individual chapters, multiple chapters, or across an entire dossier. In general, ApplySimple can be used to create the following objects: •. This video covers the process of requesting an ESRI License key and applying the license key to MicroStrategy Web. The following procedure describes how to achieve this: Create the highest level filter. After migrating to MicroStrategy 9. Also, you add both attribute IDs, in this case Item_ID and Color_ID, to the fact table as shown in the following diagram. An empty filter appears in the dossier. ; In the Source area, select the database instance for your Excel file. For a New Attribute. Open a new or existing dossier. In Visual Insight in MicroStrategy Web 9. Knowledge Base: Working with Compound Grids in MicroStrategy 2020;. 'Customer Birthdate' is used in this example. For conceptual information on attributes as well as detailed examples, see The Context of Your Business Data: Attributes. Select the attributes and facts from that table. The primary key should be dataless (a primary key should not be based on the content. This example uses 'AliasMonth' to build the filter as shown in the image below: Build a report using the filter created above. This guide builds on a basic understanding of information provided in the Basic Reporting Guide. If these three columns are mapped to attributes in MicroStrategy, then the primary key is represented correctly. Click Save and Update Schema. This video covers the process of requesting an ESRI License key and applying the license key to MicroStrategy Web. Compound Key Attribute A compound key attribute is an attribute whose primary key is made up by the combination of two or more columns. Go to Smart Attribute blade on the Attributes Editor. Create a report that makes use of the metric. " Click "prompt on attribute element list" and click "Next" through the rest of the screens to accept the default values. A compound key attribute is an attribute that has two or more IDs. Open a report in MicroStrategy Developer. To create attributes with the Attribute Creation Wizard, follow the steps outlined in Simultaneously creating multiple attributes. 4. From the MicroStrategy home page, click New Metric . A setting in MicroStrategy Web 9. If you know of better/faster ways, please share. 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. You can apply an inner or outer join, which are described in more detail below. When selecting elements for the key attribute for the table, the SQL generated does not use a "distinct" clause, but when not selecting elements for the key attribute, the SQL generated uses a "distinct" clause. Drag the prompt onto the Definition pane at the bottom right, as shown in the image below:For example, the attributes Year, Quarter, Month of Year, Month, and Day in the MicroStrategy Tutorial project are gathered close together in the Hierarchy View, as shown below. To access the Date Editor to create dynamic dates, execute the following steps: In the Filter Editor, choose to add an attribute qualification. The only solution that I can think of is to create a FreeForm SQL Report. Select the chapter that contains the visualization to filter. Click the Create Filter icon . To select the attribute from which the user can create the filter.