0 if there are multiple join paths between two or more One-to-Many relationship tables in a multi-table data import cube, rather than using the first available table join path, the analytical engine will look for the path with the least number of tables and the smallest table base on the following order/criteria:Beginning in MicroStrategy 11. Edit the evaluation order for the report: set Total to 1, metric. Update:1 Answer. Generally, you build a compound attribute when your logical data model reflects that a. Count Compound Attribute is an advanced property that is hidden by default. Also, you add both attribute IDs, in this case Item_ID and Color_ID, to the fact table as shown in the following diagram. This article describes why an attribute with a compound ID may fail the execution of a dossier if the compound ID has locale sorting that is inconsistent with the order by the. intermediate object}. 1. The Metric Editor opens in either Function Editor mode or Formula Editor mode, depending on the type of metric you chose to edit. These units are part of an attribute, for example, Customer. Relate tables contain the ID columns of two or more attributes, which will define associations between them. Count of Parents in Platform Analytics: There is an OOTB metric called Objects, which calculates the parents of a component object. 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. These types of qualifications restrict data based on the value, rank, or percentage of a metric, or based on the relationships between the attributes on the report. This guide assumes and continues to build on a basic understanding of information provided in the Basic Reporting Guide. In MicroStrategy, attributes are identified by the column headers of reports. desired view using MicroStrategy, without DBA involvement. Users can also create compound attributes, define attribute relationships in the system hierarchy and modify display and sort forms. After adding the table, a MicroStrategy partition-mapping object has to be defined (File > New > Partition menu). For example, the form expression for the Customer First Name attribute form is CUST_FIRST_NAME. A set qualification first produces a set of attribute elements. x-10. Automatic recognition is enabled by the VLDB property Engine Attribute Role Options at the database instance level. The metric can also show a total by page, show a total for each value of the attribute, or show the grand. Relate tables store information about the relationship between two attributes when one a parent of the other or vice-versa. You. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in one. To uniquely identify a distribution center, one must know two details about the distribution center: the ID of the distribution center and the country in which it exists. Open a dossier. Formula: Is a mathematical expression using one or more functions, applied to the data to be used in the calculation (facts, attributes, constants, or metrics). The attribute editor allows users to create attribute forms, connect attributes to logical tables in the schema, and edit form expressions. In the Datasets panel, double-click attributes and metrics to add them to the visualization. There's a reason we're at the top of the list. 3. Creating a grid report. Attribute forms are displayed incorrectly in the view filter element browser when the attribute has compound ID in MicroStrategy Developer 9. 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. 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. Modify the Address form so that it has a descending report sort order. A compound key attribute is an attribute whose primary key is made up by the combination of two or. In the MicroStrategy Tutorial project, Distribution Center is an example of a compound attribute. You must create a compound attributes when an attribute requires two or more columns to uniquely identify its elements. The Metric Options dialog opens. Attribute forms contain additional descriptive information about a given attribute. Hover over the Properties column and click Open Intelligence Server Administration Portal . Generally, you create a compound attribute when your logical data model reflects that a compound key relationship is present. SUMMARY: This technote describes a current defect in MicroStrategy Web 9. Generally, you create a compound attribute when your logical data model reflects that a compound key relationship is present. Visit the MicroStrategy download site to download the latest supported version of this product. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. 0. For example, the Customer attribute in the MicroStrategy Tutorial project has the five attribute forms shown below: Of these five attribute forms, only Last Name has a default report sort order defined. Enable the Source Visualization to Update the Target Visualization. The ApplySimple function is used with simple operators and functions. For example, you create an attribute called Customer to represent customers in your. However, for compound ID attributes specifically, MicroStrategy only stores the elements based on the sort order from the ID form without considering locale. Creating attributes with multiple ID columns: Compound attributes • Modifying how to use attributes to browse and report on data • Specifying attribute roles: Attributes that use the same lookup • Supporting data internationalization for attribute elements Modifying attributes with the Properties pane A compound key attribute is an attribute whose primary key is made up by the combination of two or more columns. x and 10. In the report, the attribute with the compound key is Distribution Center. In MicroStrategy, create an attribute that can return all the location data for each entry. Join Specifications. Hi All, I have a problem regarding metrics in MSTR. x. Create Dossier and Chapter Filters. A derived metric is a calculation based on metric data included in the report definition. 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. You can type arithmetic operators (such as + and -) and comparison operators (such as < and >) directly in the metric expression. In MicroStrategy Workstation, architects can create and edit attribute objects. If you know of better/faster ways, please share. Mode. Separate attribute forms should be created for latitude and longitude, and should also support the numeric data of these values. The Group Editor opens. MicroStrategy pushes the calculations for the following built-in basic functions down to Teradata using the associated SQL patterns. 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. Each attribute form must have at least one expression. In the visualization's Editor panel, right-click the attribute to group and choose Create Groups. x: Create a metric called A with expression "Min(1){~}" as shown below. Filtering Compound Attributes. Allows you to choose whether you want to use the metric name as the column alias or whether to use a MicroStrategy- generated. The attributes and metrics appear as filters. To uniquely identify a distribution center, one must know two details about the distribution center: the ID of the distribution center and the country in which it exists. What are Configuration Objects? Configuration objects are MicroStrategy objects which can be re used in multiple projects and they appear in the. Plus, it connects business apps while integrating data. MicroStrategy needs to be explicitly told that there is a Many-1 relationship between Location and Airport, which can only be done by creating them as two separate attributes. 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. J2EE environment:Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformEven though a metric qualification depends on the result of an aggregation, it still must apply before template metrics, or metrics used in compound metrics. Check other tables and select/deselect correct tables. . This URL executes a report with one prompt. This happens with compound attributes. Passing prompt answers for an element prompt when the attribute has a compound ID. Learn how to create compound project attributes in MicroStrategy Developer, an advanced environment providing a complete range. In the list of categories on the left, click Subtotals. create 2 similar region prompt ( call it region 1 & region 2) now create 2 revenue metric , region1 revenue ( with region 1 prompt in filter) and region 2 revenue ( with region 2 prompt in filter) in custom group band could be like following YY - region1 revenue > 0 AND region 2 revenue > 0. Enter a Form name and Description. PepsiCo ( PEP 0. 1 : In the Project Creation Assistant, click Create attributes. A compound key attribute is an attribute that has two or more IDs. Create an Attribute Open the Workstation window with the Navigation pane in smart mode. 3. You can use the AppleSimple function to insert database-specific functions and simple operators directly into SQL. 176. This technote describes a current defect in MicroStrategy Distribution Services 9. 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. Dataset DS1 with attribute 'Year' and metric 'Profit'. Composite Key. A sample report is: Attributes: Metadata, Project, Object, Object Type, Component Object Type. 0:50. 4. Example for this can be a database of airports around the world. Hierarchy 2: 4. The derived metric aggregates at the level of the attributes on the visualization by default. Multiple elements are highlighted when using an attribute with compound key as a selector in Visual Insight and MicroStrategy Web 9. Relate tables are often used to create relationships between. . : 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. If a user maps a Data Import column to an attribute that has compound ID formsIn MicroStrategy Workstation, architects can create and edit attribute objects. Create a Default Dynamic Selection Filter. In MicroStrategy Workstation, architects can create and edit attribute objects. You can use derived metrics to. 2, the selector will not work if using the Include option for the selector. a) Attribute form qualification Filters data related to a business attribute’s form(s), such as ID or description. 4. MicroStrategy download site to. It is. It uses Business Scenarios to provide examples of each concept. 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. I have a metric A = Avg(0. 11 a change is being made to the default value of the use lookup for attributes function parameter when making metrics. SUMMARY: This technote describes a current defect in MicroStrategy Web 9. There are three basic logical operators: Union behaves as the inclusive term OR does in grammar. Attribute qualification filter These types of qualifications restrict data related to attributes on the report. In short, an inner join includes only the data common to all the elements in the join, whether that data is tables or metrics. I'm working on a dossier and I have a dataset that includes customer types. The multiple columns are joined with other attributes, typically in a many-to-many. These privileges are part of OLAP Services. 4. Now to fix this create a new Derived metric on Category attribute first with formula as Max (Category) {~ } and calling Books. Currently the DIM_DATE. A compound attribute is one that uses two or more columns as its ID. . 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: . x?; Knowledge Base: How to concatenate two. Click Insert Visualization . This article describes an issue in MicroStrategy where SQL will not be generated correctly when using an attribute with a compound ID in a metric without specifying a form. This article does contain a solution. Surrogate Key. Mapping is required only if you want to display areas on your map on a local server. Create a Report Services Document 2. If you know of better/faster ways, please share. Automatic attribute role recognition, where you create multiple attributes that have the same lookup table and allow MicroStrategy to automatically detect the multiple roles. In the Hierarchy Editor or Architect, click Save and. HyperWeb surfaces cards on a web browser based on a keyword that matches the underlying criteria set by the card author. Generally, you create a compound attribute when your logical data model reflects that a compound key relationship is present. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Update:Multi-Metric KPI is best when you have several important indicators that you want to display in one, responsive visualization together. In addition, this release introduces new features across the analytics, mobility, and security platforms—making it easier for users to build applications faster. In this case, enter 'Date@ID'. DATE and DIM_DATE. 32. A compound key attribute is an attribute that has two or more IDs. 1/10. Follow the steps below. In the Actions column, select the Edit icon for the user to modify. ; Dossier authoring enhancements, including: New context menu options to move, copy, or duplicate images, text boxes, and HTML. You can quickly create multiple element groups at the same time. For the Time hierarchy, the offset can. intermediate object}. This is a single-value function. Click More in the top right of the heat map and choose Create Contextual Link and select. In the list of categories on the left, click Subtotals. 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. Attribute having more than one ID from category. April 28, 2009 Architect, MicroStrategy Compound Attribute Sorin Suciu. In this case, you would create a dummy derived attribute. For example, for the Customer attribute, Customer Email, Customer First Name, and Customer Last Name are examples of attribute forms. How to create a conditional attribute in MicroStrategy Desktop. . 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. MicroStrategy Internal Reference number for this technical note is KB483638 and US144497. You are returned to MicroStrategy Developer. You are returned to MicroStrategy Developer. April 28, 2009 Architect, MicroStrategy Compound Attribute Sorin Suciu. It is used with database-specific OLAP functions such as Rank(). If the Region attribute is removed from the grid, the metric value is dynamically aggregated to the Day level. It is used to apply database (row-level) security to a MicroStrategy user. Creating Compound Attributes MicroStrategy Community 3. HistogramMedian. There's a reason we're at the top of the list. The graph legend or axes can be formatted as well. Add a compound attribute, For instance "Seasons", to Page-by and enable subtotal for the report. STEPS TO REPRODUCE: 1. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. On each column set, add at least one. Follow the steps below. 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. 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. 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. For information on how to display this property, see Viewing and Changing Advanced VLDB Properties. Temporary policy. xml, contains the information used to map ESRI geo attributes to the corresponding attributes in the MicroStrategy metadata. All the forms for the selected attribute will be displayed. 4. It is now possible to format column groups differently, freely alternate the placement of metrics and attributes in the column headers for each group of columns, or choose which columns of the Grid should show the subtotal value or all values. NOTE: The 'Refresh' option assists in frequent updates to the interface for end user objects such as metrics, filters, prompts, etc. Create the following objects: a. Under 'Source tables', select a table and click 'Set as Lookup'. Select a Form category, Display type and Default sort from the lists. Go to Data > VLDB Properties > Joins > "Preserve all final pass result elements. An attribute form on the parent attribute also appears on the child attribute. The multiple columns are joined with other attributes, typically in a many-to-many relationship. compound attributes. MicroStrategy's default technique is to write description form expressions into the SQL Max() function. For examples of joining datasets, see Defining a dataset as primary or secondary and Joining multiple datasets: Examples. MicroStrategy AI is here. Reports are now available to use and interact with in MicroStrategy Library: View standard reports in MicroStrategy Library to get a simple, grid view of data. A metric is a compound metric if it consists of two or more existing metrics joined by an arithmetic operator (+, -, *, and /). Arithmetic operators are +, -, *, and /; non-group functions are OLAP and scalar functions such as running sum or rank. 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. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. Published: Sep 19, 2019Report will display result as below. To view the various properties of an attribute in Architect, from the Attributes tab of the Properties pane, select the attribute from the drop-down list. x and 10. Select the check box for any smart attribute that needs to be created. In MicroStrategy Web, click the metric for which you want to enable a grand total or subtotals. 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. The use of compound attributes in a non-aggregatable metric is not supported in MicroStrategy Developer 9. In MicroStrategy Web 2020, create a dossier with a Compound Grid visualization. xOnly attributes in the WHERE clause are considered true filters, in the sense that they restrict the data set prior to producing the aggregated data. For example, consider the relationship between three attributes: Promotion, Item, and Quarter. The formula of a compound metric is based on arithmetic operators and non-group functions. It supports interactive dashboard, highly detailed reports, ad-hoc query, automated report dispute, and Microsoft Office integration. The operators and functions of a compound metric can be applied to facts, attributes, or metrics within the compound. Metrics can be either simple or compound. Using this grid, you can have multiple unrelated attributes and metrics in different sets of columns that are stitched together. This URL executes a report with one prompt. A data warehouse is an integrated set of data, derived basically from operational data to use in decision making strategy and business intelligence using (OLAP) techniques. Compound Key Attribute A compound key attribute is an attribute whose primary key is made up by the combination of two or more columns. An additional modeling convention is to add unique identifiers for each attribute and fact. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. All articles. Quite often these attributes have automatic mapping for one ID and manual. 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. (The use of brackets around compound object names is standard for many objects in MicroStrategy and is not restricted to custom expressions and Apply. In this article, we clarify your questions regarding Pattern Matching and how it is different from the standard Keyword Matching. In MicroStrategy Developer, open the folder that contains the attribute to modify. 4. You can connect MicroStrategy reporting tool with any data, including big data, flat files, social media data, and. This tutorial shows how to create derived attributes and metrics in a dossier. To create a compound key, users must create multiple attribute forms, group them together and set the form group as the key. 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. g. How to include an attribute form in a compound or derived metric in MicroStrategy Developer 9. Configuration Objects:. The Profit metric is a simple sum of the Profit fact. Like other visualizations, a Compound Grid can be used as the target of a selector. Compound Grid visualizations. The form expression for the Customer Last Name attribute form is CUST_LAST_NAME. Compound Attributes: Microstrategy Related Tutorials; Informatica Tutorial: IBM Cognos Tutorial: Teradata Tutorial: Adv Java Tutorial: Cloud Computing Tutorial: SQL Database Tutorial:How to include an attribute form in a compound or derived metric in MicroStrategy Developer 9. The resulting SQL will contain just the Metric Alias. Navigate to the Schema Objects folder, open the Attributes folder, and then the Geography folder. 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. A compound attribute has its value resolute by an expression that join two or more columns in a database to make a new column. 0: Profit/Revenue. How to create a conditional attribute in MicroStrategy Desktop A user may want to create an attribute with an alternating expression depending on a certain condition, a. We use MicroStrategy Tutorial tables that have the Month Id attribute and alter them. In the top toolbar, click Insert Visualization . The hyperlinks based on an attribute form compound by Applysimple no longer work when exporting to MHT in MicroStrategy 9. WORKAROUND: There are a couple of options to workaround this limitation. 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. In MicroStrategy Workstation, architects can create and edit attribute objects. This knowledge base article documents the process of creating compound keys for attributes in MicroStrategy Developer 9. 4. Answer / nadia sheikh. 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. VLDB properties allow you to customize the SQL that MicroStrategy generates. To create a derived metric. The Year - Define a new member attribute. A compound key attribute is an attribute that has two or more IDs. Using this grid, you can have multiple unrelated attributes and metrics in different sets of columns that are stitched together. Compound Attribute Date ID forms do not format correctly when ran correctly in Flash in MicroStrategy Web. A percent-to-total shortcut metric displays the percent in relation to a selected total of each item affected by the metric. The formula of a compound metric is based on arithmetic operators and non-group functions. 939 views 3 years ago. A compound attribute is defined as an attribute with more than one column specified as the ID column. There's a reason we're at the top of the list. 4. For information on training metrics and creating predictive. (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. The Compound Grid is a new visualization introduced in the MicroStrategy 2020 release. You need the Create Derived Metrics (MicroStrategy Developer) and/or the Web Create Derived Metrics and Derived Attributes (MicroStrategy Web) privileges to create derived metrics. Metrics made up of metrics: Compound metrics. (In this cube, Product Hierarchy Level 00 corresponds to the MicroStrategy Tutorial Category attribute; Product Hierarchy Level 01 corresponds to Subcategory. Using this grid, you can have multiple unrelated attributes and metrics in different sets of columns that are stitched together. x-10. Dataset DS2 with attribute 'Year' and metrics 'Revenue', 'Profit', 'Profit Margin' (this is a compound smart metric calculated from metrics Revenue and Profit). Rather than creating attributes by manually creating an attribute expression, you can allow Architect to automatically create simple attributes defined on one column. You can also apply a set of color and shading schemes to all the objects on a graph report. Usually this is the attribute to which the form belongs (i. Click OK. MicroStrategy HyperIntelligence is the next step in the future of data analytics. In order to have a derived metric that can source from the join of multiple datasets a simple compound metric can be. attr_elementsApplySimple. Select Manual from the Aggregation and Subtotal Behavior drop-down. This visualization allows you to create a grid that analyzes different aspects of data. This case is also explained with an example based on the MicroStrategy Tutorial project. Workaround / Solution. In Visual Insight in MicroStrategy Web 9. Result for new metric is blank. Smart metrics calculate subtotals on individual elements of the compound metric. multiple attribute forms conform the ID form, any element that matches at least one of the ID's will become highlighted, like shown below. The compound join saves memory space and processing time on the Intelligence Server executing the document. Important: Parts of a compound attribute cannot be omitted. 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. In Microstrategy, the lookup tables represent the attributes. Click here to view help for the latest version of this product or search MicroStrategy Community. Click All Objects View. Users can also create compound attributes, define attribute relationships in the system hierarchy and modify display and sort. Choose Grid > Compound Grid . compound attributes. A compound key attribute is an attribute whose primary key is made up by the combination of two or more columns. Create a compound metric defined as the division of the two metrics created previously, and configure it to be a smart metric, leaving the 'Dynamic aggregation function' as 'Default' as shown below: Create a report with the attributes Region, Month of the Year, and Category and the compound metric created before. Arithmetic operators are +, -, *, and /. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. What are Configuration Objects? Configuration objects are MicroStrategy objects which can be re used in multiple projects and they. This condition may be implemented through an ApplySimple statement such as the following: The user will find that the CASE statement. KB6669: How to create dynamic date filters on time attributes other than Date using custom SQL. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. The attribute's forms can also be displayed. In the relational database. The metric formula defines the data to be used and the calculations to be performed on the data. 3. This means you can have multiple unrelated attributes and metrics in different sets of columns that are then stitched together in one. Click the Options icon . 2, the selector will not work if using the Include option for the selector. Open the dossier you want to modify. Users can also create compound attributes, define attribute relationships in the system hierarchy and modify display and sort forms. Related articles from the Community: Knowledge Base: How to create a derived metric in MicroStrategy Developer 9. Only two leading objects are defined in the query language. Starting in MicroStrategy 11. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. MSTR uses lots of components like attribute, metric, facts, Logical Tables etc to build a report. A sample URL that answers an element prompt when the attribute has a compound ID is shown below. Therefore, it is possible to have the attribute specified at the metric dimensionality level and only have Category in the report template. Steps to Reproduce on a Compound Grid. The dynamic aggregation itself is highlighted in red. Use the Object Browser on the left to locate the prompt to add to the metric's definition. From the Insert menu, select New Training Metric to use derived metrics as part of Data Mining Services to create training metrics. 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. Right-click the table, point to Recognize, and then select Attributes. 2. SYMPTOM: In Visual Insight in. In simple words, Metadata could be considered as the heart of MicroStrategy environment. A sample URL that answers an element prompt when the attribute has a compound ID is shown below. When evaluating compound metric expressions in SQL, a null value from one of the component metrics may cause the entire expression to evaluate as null -- NULL. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence; Multi-Cloud. 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. Compound attributes. In the pane, begin typing the metric formula. Generally, you create a compound attribute when your logical data model reflects that a compound key relationship is present. MicroStrategy recommends to have only one child at the lowest level. In the pane, begin typing the metric formula. 4 Basic Functions are supported by the MicroStrategy Analytical Engine: First. more columns. A derived attribute has its value determined by an expression which combines two or more columns in a. A compound attribute is an attribute with multiple columns specified as the ID column. A sample report is: Attributes: Metadata, Project, Object, Object Type, Component Object Type. multiple attribute forms conform the ID form, any element that matches at least one of the ID's will become highlighted, like shown below.