9, there was an active focus on making it easier to build dashboards for the widest audience of end users. Several crypto-related shares also rose, with Coinbase Global recently. CAUSE: One scenario is that the MicroStrategy 10. Open up those tables in the Table Editor by navigating to the Schema ObjectsTables folder, and double-clicking the tables. The goal is to create an image link that is used to export the grid, like shown below: Document in Edit Mode Follow the steps below: 1. The Intelligence Server will enforce the "User Freeform SQL. For example, these functions can aid in the creation of attribute forms by combining. Once data flows into the interface, the dashboard will come to life. 11K KB6178: How to use the pass-through expression ApplyComparison in MicroStrategy SQL. MicroStrategy introduced HyperCards, a new object that is built, managed, and deployed using MicroStrategy Workstation(Not by using Developer or Desktop as far as I know). x and 10. microstrategy. 2. String Functions. . In order to exclude the values, create another filter expression which will always be TRUE and. The Filter Editor is displayed. In some circumstances, it may be desirable to edit the definition of a security filter on the fly. The ApplySimple function is used with simple operators and functions. Overall, more than 87. An example of a business case in which this could be useful is using a filter-based slider selector to target a grid/graph object in Web in order to filter it down to a user's. Click Certify. Select the Logical View Tab of both tables to see all the logical objects mapped to the table. Type: Company - Public (MSTR) Founded in 1989. Using the Metric Editor, create a new metric expression. Apply the custom expression filter as shown in the image below: ApplyComparison ("exists (select 'a' from Table_1 a2 where #0 like '%' + a2. Joint child relationships are really another type of many-to-many relationship where one attribute has a many-to-many relationship to two otherwise unrelated attributes. After that only thing you have to do is to press finish button. ) The above example used an Apply function, ApplySimple. Then use this report in a filter along with the advanced qualification which says'ApplyComparison ("#0 in (select distinct fiscal_mo_nbr from days where day_dt=trunc(sysdate-1))", [Fisc Mth Nbr]@ID)'. MicroStrategy is a strong contender in the enterprise BI market that its customers praise for a multitude of reasons: its robust drag-and-drop reporting tool, strong data visualizations and dashboards and accessibility through web and mobile apps. Syntax. The functionality of Apply functions is provided by wrapping the expression, as a string, inside a dedicated (Apply) function call. x, select 'Project Documentation' from the Tools menu to. ApplyComparison is used to define a filter by populating the WHERE clause in the. Depending on your MicroStrategy product and licensing, this function may not be available. Here is the workaround to achieve the attribute left outer join on MicroStrategy Web. 5. Quick connections to any data source are combined with one-click sharing of any insight. To extend this flexibility to you, MicroStrategy offers 5 functions which allow you to directly supply the SQL you want for a specific piece of the Query: ApplySimple, ApplyAgg, ApplyComparison, ApplyOLAP and ApplyLogical. Joao Paulo "mahendra_patel via microstrategy-l" 07/07/2006 11:19 Favor responder a microstrategy-l@Groups. MSTR has evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories. MicroStrategy Web is an interactive, easy to use interface for all Business Intelligence (BI) reporting, analysis, and monitoring. 2. The syntax is: FileLocation is the path to the saved test file. With advanced qualifications enabled, double-clicking on the last line in the filter editor or report filter panel reveals the radio button to add an advanced qualification to the filter. x: Open the Filter Editor to define a new filter. As a MicroStrategy developer, and a SQL programmer, I pick and choose my battles, and as much as it’s recommended in MicroStrategy to make complex metrics with “Last” or different Level Dimensionality, there’s also situations where you want to make the database do the work…such is the Case with the ApplyComparison filter. Create an empty MD shell in Microsoft Access. Populate and Evaluate: Fill report data required for display. If all conditions are false, a default value is returned. The overall sort order is evaluated and stored in the attribute definition when the attribute is saved. This is a single-value function. Populate & Evaluate Stage. Dossiers can be created by using the new Desktop product or Workstation or simply from the Web interface which replaces Visual Insights. The next example uses ApplyComparison. The Delete unused managed objects option is found under. ApplySimple() Accepts facts, attributes, and metrics as input. Drag an attribute from the Datasets panel to the Rows area of the Editor panel to add attributes to the rows. Form Type. In MicroStrategy Web, open the document in Design or Editable Mode. With MicroStrategy, you can deploy data on-premise, in the cloud, or with the hybrid of both. Schema objects include facts, hierarchies, and custom groups; application objects include reports, documents, and metrics; and configuration objects include project sources, database instances. Right-click the dossier you want to certify. Once you have subscribed to MicroStrategy, you will be able to download the MicroStrategy virtual appliance. Go to the Editors section and select Filter. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. We are active contributors to solutions on the MicroStrategy Community site. Now when both the prompts are answered,the above subquery is generated by the Microstrategy . 02K. This is a single-value function. How to implement attribute form expression using Apply Functions in MicroStrategy Developer Apply functions can be used in the attribute editor to provide access to functionality that is not standard in MicroStrategy, but available from the Relational Database Management System (RDBMS), such as the special functions or syntactic. Double click on your Report Filter and you’ll now have the option to add an Advanced Qualification: You can then provide the code for the ApplyComparison. Description. The recursive hierarchy table has to be split into several tables, one for each level in the hierarchy (turning it into a traditional snowflake schema). In this quick tip, I show you how to filter MicroStrategy reports using a custom SQL query using ApplyComparision and ApplySimple. Number of Views 3. To enable a visualization to filter or highlight the data in another visualization. While this feature is similar to using an ApplySimple in a filter, the difference is that you can customize both sides of the condition, whereas with the ApplySimple you can only customize one side to be equal to a single Attribute Form. Select the 'Advanced' tab, as shown. x. KB35312: Attribute sorting does not get applied correctly on a selector when viewing a Report Services Document in DHTML mode in MicroStrategy Web 9. For details, see Comparison Operators. MSTR will assign a weight based on the level of the attribute in the hierarchy. Drag objects from the Datasets panel to the Editor panel to add the corresponding data to the visualization. In this quick tip, I show you how to filter MicroStrategy reports using a custom SQL query using ApplyComparision and ApplySimple. Select types of files you want to be considered and press next. As a suite of applications, it offers Data Discovery, Advanced Analytics, Data Visualizations, Embedded BI, and Banded Reports and Statements. A physical snapshot of the solution is: Each attribute has a 1-M relationship with its child. ApplyComparison("#0 not like '-%'"; [InductLine]@ID). Enterprise Analytics Business Intelligence; HyperIntelligence; Cloud; Product Innovation; Education; ConsultingInvoke the MicroStrategy Integrity Manager executable MIntMgr. If you have a joint child relationship in your data, it is important for you to define it in MicroStrategy so. Click Qualify. MSTR has evolved dashboards to the point that. 5% of users said that the platform is easy to use, with a user-friendly drag. The filter on this will be "where <> '-' " and there is no need to use. Create a new filter using a custom expression with POST /api/model/filters. MicroStrategy provides ETL, data warehousing and data mining for data analysis. 4. From the Visualizations panel, select Grid . ) The above example used an Apply function, ApplySimple. S. The ApplyComparison function is used with RDBMS comparison operators such as >, like, and In. ITtoolbox. AMPERE blog on Microstrategy development and issues faced during development, deployment and maintenance. In order to exclude the values, create another filter expression which will always be TRUE and. A report requires to show the bottom 10 unit prices per item. In SQL View look at where the cross join appears, and between which tables the cross join appears. ApplyComparison is a 'pass-through' function that builds a SQL comparison expression based on the input string of database-specific SQL syntax. If you are looking to learn. Joint child relationships are really another type of many-to-many relationship where one attribute has a many-to-many relationship to two otherwise unrelated attributes. Select any project that is in the project source that. Create a new filter in MicroStrategy Developer; Choose the 'Add an advanced qualification' option and click on the 'OK' button. Using this function and given the format in which the column is stored in the MicroStrategy Tutorial (Vmall) warehouse (integer, YYYYMM), the formula will extract the year from the date prompt, multiply it by 100 and add the day number to it, giving it the desired format. The report execution process is a three-step process: 1. . x-10. Follow the simple steps below to create a datamart report: 1 In MicroStrategy Developer, create a new report or select an existing report to use as the data mart table. ApplySimple ("case when #0 contains 'As Is' then 'As Is' when contains 'New' then 'New' ELSE 'Other' END", [NAME]) case. 3. This is a single-value function. 4. The next example uses ApplyComparison. 5. MicroStrategy is a Business Intelligence software, which offers a wide range of data analytics capabilities. The menu also provides features to connect to a server if required, view the data sets available, the visualization gallery, and data filtering options, etc. . 4. Level Metrics. 1. Note: To create custom expression qualifications, the advanced qualification option must be enabled in the report designer's preferences in MicroStrategy Desktop 8. EXAMPLE. It has a simple menu to import data for analysis and export the result of analysis. How to create a custom expression filter in MicroStrategy Developer 9. The issues with many-to-many relationships, including loss of analytical capability and multiple counting, also apply to many-to-many joint child relationships. likes. the Administration menu -> Projects in MicroStrategy Developer as shown. Go to My Preferences > Editors > Filter Options. We will also learn sapply (), lapply () and tapply (). CAUSE: One scenario is that the MicroStrategy 10. I've looked at % column settings in other % metrics in our. If DHTML is disabled, click the Go icon . There is no functional difference between the two symbols. Filter Reports using SQL with ApplyComparison and ApplySimple. Syntax Common to Apply Functions. Create a report R1 with Month, Revenue and filter which contains the first 6 months in 2008. Cross-tab: Pivot and display sorting and page-by Each of the engines plays an important part in the report execution process. Example. If DHTML is disabled, click the Go icon . You must use the ApplyComparison and when you create the filter use Advanced Qualification. Use the individual editors inside Developer to create and edit various model objects. ApplyComparison is commonly used to create custom filters. 62K. An object is a basic building block in MicroStrategy. With an OLAP Services license, user can perform additional OLAP analysis, using the following features: Displaying data on the fly: dynamic aggregation, page. Go to Tools -> My Preferences -> Filters and check the box for Show Advanced Qualifications. Microstrategy Dossiers With the release of MicroStrategy 10. This metric divides the sum of VOL fact at report level by [Net Weight] after applying it a character replace at BBDD level with ORACLE's replace function (it seems that the BBDD is ORACLE), and breaks it down by product. 1. 4. Review your choices at the summary screen and click Finish. See the syntax below forward can. There's a reason we're at the top of the list. KB6178: How to use the pass-through expression ApplyComparison in MicroStrategy SQL Generation Engine. To create a custom expression filter, the Advanced Qualification Editor must be enabled in the user's project preferences in MicroStrategy Developer 9. I have a filter and in it is the ApplyComparison function doing a simple query. 1. Article Reference Number: KB39231. Select Show advanced qualification. 2. Connect to a database instance and drags tables into the canvas. Open the report’s subscriptions in MicroStrategy Web: Scroll down to the Email subscription and click the option to “Add email subscription”: Choose the schedule by clicking the drop-down and selecting the required schedule. (The use of brackets around compound object names is standard for many objects in MicroStrategy and is not restricted to custom expressions and Apply functions. x and 9. Dossiers can be created by using the new Desktop product or Workstation or simply from the Web interface which replaces Visual Insights. From the Tools menu, make sure that View Filter section is enabled. Create a report R1 with Month, Revenue and filter which contains the first 6 months in 2008. It leverages data connectivity, machine learning and mobile access to offer. x. From the Project menu, select Compare Projects. The definition of the shortcut filter (East Coast) is displayed. You will see that R2 still displays the first 6 months data. Patent Information This product is patented. This article covers how to use passthrough expressions to write custom SQL inside of MicroStrategy. In the Visualization Gallery, click Combo Chart to create a combination graph. The elements of a metric level are described below: •. From creating basic objects to building complex reports and analyzing data, you have the ability to create custom expressions using a. The next example uses ApplyComparison. The My Preferences dialog box opens. In addition to creating, editing, and consuming content, users can also share personalized content via email, folders, or. 1) Adding a view filter to the report where Sum Metric != 0 which will bring only non zero values. While string functions can be used to create metrics, a more common use case for these functions is in the creation of attribute forms. Today, I’ll talk about ApplyComparison, which allows you to provide custom SQL in the WHERE clause of. Or we can jsut had code the filter Sum Metric >0 if we want to pre-filter the report with non zero rows for. ApplyComparison. Dashboard performance troubleshooting in MicroStrategy 10. ApplyComparison is used to define a filter by populating the WHERE clause in the SQL passed to your RDBMS, and can take facts, attributes, and metrics as input. Category = 1/4 *10 = 2. In the layout tab, click "Allow multiple selections". Wherever you can define an expression, you can use a function. It was acquired by Google on June 6, 2019, for $2. Most data on a document is from one or more underlying datasets. 0. Follow the steps below: Right-click on the project and select 'Project Configuration. The Report SQL indicates that the filter has not been applied. Click Filter Options. Choose the Light Theme from the drop down menu and click the Apply button. To use # as a character rather than a placeholder, use four # characters in a row. Create three reports named A (with attribute A), A&B (with attribute A and B),A&C (with. About Us. Use the MicroStrategy built-in apply (pass-through) functions; Freeform SQL; Apply (pass-through) functions. e. The Apply functions are not meant to take. There's a reason we're at the top of the list. 4. For basic information and examples of the ApplySimple function, see the Functions Reference. Hint. CONTENTS 1. This can be achieved in multiple ways, but this Tech Note will focus on creating a Year to Date metric using a Month or Quarter attribute without using a transformation table. All the existing visual Insights dashboards will be converted to Dossiers With MicroStrategy 10. Using Prompts and ApplySimple Statements. 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. Logical operators: These operators provide basic comparisons and return TRUE or FALSE values based on the evaluation of the formula. In your Datasets panel, hover over the name of your dataset. Right-click the project for which to activate the advanced qualification option and choose My Preferences. Go to File > New >. , >, =, Like, In ApplyComparison is commonly used to create custom filters. , in search results, to enrich docs, and more. To make Apply functions, to must have the Use FreeForm SQL Publications privilege. Export a Report Services document to Excel with formatting using URL API in MSTR Web. UnderstandingFunctionsinMicroStrategy 5 TheBasicsofMicroStrategyObjects,ObjectDefinitions,andFunctions 6 FunctionSyntaxandFormulaComponents 9 Open a project source in Object Manager. The ApplyComparison function allows users to bypass the MicroStrategy SQL parser and create an expression where comparison operators (e. MicroStrategy OLAP Services allows view filters, which are a filter that can be applied by the user dynamically after the report has been executed and displayed. g. The index. 4. This tutorial aims at introducing the apply () function collection. Populate and Evaluate: Fill report data required for display. The Grouping Properties dialog box opens. The easiest is probably to create an attribute of only the first character using the substring function. Users may want to create a metric that displays 'NEW' when the display date is later or equal to the selected date and 'OLD' when the display date is earlier than the selected date in MicroStrategy Developer 9. In Teradata, the Extract function returns the month, day or year from a date field. They act as containers for non-standard SQL expressions that MicroStrategy does not support. . Click Qualify. (The use of brackets around compound object names is standard for many objects in MicroStrategy and is not restricted to custom expressions and Apply functions. In MicroStrategy, you can choose to allow or disallow joins across datasets based on unrelated common attributes. Cross-tab: Pivot and display sorting and page-by Each of the engines plays an important part in the report execution process. Ap plySimple (microstrategy. Creating metrics on-the-fly: derived metrics, Defining attribute elements on-the-fly: derived elements, Filtering data on the fly: view filters and metric filters, Importing data as an. Drive revenue growth with memorable app workflows and AI features that really speak to the user. The following steps demonstrate how to use the comparison operator prompt in an ApplySimple function with a Case statement. Choose attribute Call Center and use the Region Filter created in the previous step. Example: Customer City = Call Center Using ApplyComparison An object is a basic building block in MicroStrategy. x, with the Intelligence Server running on Linux, the image in the exported PDF report appears as a red "X" as shown below: However, the images in the report display properly when the report is. For example: ApplyComparison ("#0>#1", Store@ID, Month@ID) You can use the ApplyComparison function to define custom filters. x using an Oracl… Number of Views 6. ApplyComparison is used to define a filter by populating the WHERE clause in the SQL passed to your RDBMS, and can take facts, attributes, and. The Lead function can be used in the same way. all to no avail. Enter the following expression: ApplyComparison("{Current Month function} > #0", Month@ID ) A prompt is a question the system presents to a user when a report is executed. Dossiers can be created by using the new Desktop product or Workstation or simply from the Web interface which replaces Visual Insights. Overall, more than 87. Run Repository Translation Wizard from the Start Menu -> Programs -> MicroStrategy-> Object Manager. For example, today is 10/15, the user would like to get the latest 2 days data while there is only data between 10/1~10/10 available in the. Drag an attribute from the object browser into the text box next to the qualification type or enter the attribute name and its form according to the following format: attribute_name@form_name. In MicroStrategy Workstation, right click on any cube created via Data Import and select Properties. {&GROUPLABEL} Name of the graph. The ID is distinct. Item = 3/4 * 10 = 7. Create a file subscription in MicroStrategy Web. The report execution is typically a 3 step process process of the below: Query Stage. ) The above example used an Apply function, ApplySimple. To provide a reasonable level of generality, the feature is based on a 'pattern and arguments' scheme. This type of operator includes And, Or, and Not. The fuel for business dashboards is data, so each one needs to have one or more data sources. Ragged Hierarchies in Microstrategy. If you can use an Oracle 'function' instead of a stored procedure, you could setup a filter containing the function inside a MicroStrategy ApplyComparison (). With MicroStrategy Web, business users perform any of or all the major styles of BI - Scorecards and Dashboards, Enterprise Reporting, OLAP Analysis, Predictive Analysis, and Alerts and Proactive Notification - within a single,. But, DESC has repeating values. Returns TRUE if the value is NULL; otherwise returns FALSE. Hover over the visualization to use as the source and click More in the top right and choose Select Target. 1. ApplyComparison ("#0 in (SELECT MAX(WK_IDNT)FROM TIME_DAY_DM WHERE. Transformations allow you to apply an attribute-element based offset to compare metric data. In the Subtotal tab, select AVG in the Dynamic Aggregation option. Schema objects include facts, hierarchies, and custom groups; application objects include reports, documents, and metrics; and configuration objects include project sources, database instances. How to implement attribute form expression using Apply Functions in MicroStrategy Developer Apply functions can be used in the attribute editor to provide access to functionality that is not standard in MicroStrategy, but available from the Relational Database Management System (RDBMS), such as the special functions or syntactic constructs. Then use this report in a filter along with the advanced qualification which says'ApplyComparison ("#0 in (select distinct fiscal_mo_nbr from days where day_dt=trunc(sysdate-1))", [Fisc Mth Nbr]@ID)'. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. Right click on your project and click “Project Configuration…”. Compare all the important BI vendors with our 100% independent Business Intelligence tools comparison. The ApplyComparison function is used with comparison operators such as >, Like, and In, which accepts facts, attributes, and metrics as input. Click Add Condition in the View Filter section to add your filter. 2. Select. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Enter the values to use as arguments. Now your connection f. Workaround / Solution. Using system prompts, users can use. In the User Manager, grant the 'User report filter editor' privilege to the user facing this issue. This is a comparison function. 1. KB20022:. To Access an Advanced Filter Qualification. It leverages data connectivity, machine learning and mobile access to offer users comprehensive control over their insights. 1. The syntax for the If function is IF (Condition, TrueResult, FalseResult) where:The MicroStrategy Desktop environment is very intuitive. From the left, click Document. g. '. Continue with the previous Steps 2 and 3 above. Therefore, users must use the ApplyComparison function to ignore the SQL parser as shown below: NOTE: KB5700-007-0107 describes the ApplyComparison function in detail as well as other functions that bypass. How to create a MicroStrategy connection file (. If I understand right, create a report using the above SQL to generate a single value (it does). To solve this problem, the ApplyComparison. Syntax. mstrc) Open Workstation. For the second filter, create an advanced qualification. If I select name1 from the prompt, I do need to show all the occurances of. Our Team; Careers: work as a company intelligence consultant; ServicesKB20306: How to create dynamic date based on 'Last Month' in MicroStrategy SQL Generation Engine 9. This is a filter which contains a prompt on an attribute element list. ApplyComparison where comparison operators (>=, <, Like, etc. The Report SQL indicates that the filter has not been applied. Review your choices at the summary screen and click Finish. The screen shot below shows the F1 filter which returns the dates between the first date prompt minus the number of different days between the two date prompts. Click Insert Visualization . Notice that a joint child relationship can be one-to-many or many-to-many. Sometimes it’s easier to push the functions to the database level. In the bottom left corner, click on the button "Generate Connection File". All metric expressions must have an aggregation function. ApplyComparison is a 'pass-through' function that builds a SQL comparison expression based on the input string of database-specific SQL syntax. About Us. 11 a new optimization is available for metrics with complex custom logic SQL filters using applycomparison. cc Assunto [microstrategy-l]. Uninstall all the MicroStrategy and related products from Control Panel: Any MSTR Hotfixes applied. 9, there was an active focus on making it easier to build dashboards for the widest audience of end users. Labels: #Recursive hierarchies microstrategy #Recursive Hierarchy. Follow the steps below. ApplyComparison ("Upper (#0) like. Number of Views 2K. The Pattern: The string pattern is similar to the ones used internally by the engine for. exe using the command line. This is usually ID. ApplyComparison. No doubt MicroStrategy has powerful filtering capabilities but if you are familiar with SQL, somtimes you might find that you feel a bit constrained in certain situations and thinking you could do things easier with a simple query and there may come a time where you need to filter a. MicroStrategy ONE introduces new features that provide better performance and scalability to enhance the overall user experience. In the Grouping panel, right-click the grouping field to display horizontally, and select Grouping Properties. This is a. To create a MicroStrategy Environment connection file . The following report sample displays all of the options, including the view filter, in the report details. ApplyComparison is commonly used to create custom filters. Apply conversely Pass-through functions in Microstrategy. Save the report as “Email Bursting”. mstrc) Open Workstation. When used inside a string comparison statement they are a. This article explains an enhancement available starting in 10. The same attribute is modified so the forms are now: Form Name. Enable the 'Show Advanced Qualification' box, as shown below. In this example, the filter compares a user-entered date to see if it is between the Order_Date and the Ship_Date. Create another report R2 with Year, Month, Revenue and use R1 as filter. x, select 'Project Documentation' from the Tools menu to start the wizard. In the MicroStrategy Developer File menu, point to New > Filter. Here are the detailed steps on how to install MicroStrategy using the MicroStrategy virtual appliance: Go to the MicroStrategy website and create a MicroStrategy account. EXAMPLE. Click the Editors tab. No doubt MicroStrategy has powerful filtering capabilities but if you are familiar with SQL, somtimes you might find that you feel a bit constrained in certain situations and thinking you could do things easier with a simple query and there may come a time where you need to filter a report based on the results of a SQL query. Comparison operator prompts can be used in ApplySimple functions with Case statements using the metric, (@nameofprompt(M1, M2)). A icon appears in the upper left corner of the source visualization. Cross-tab stage. Example 1. x, select 'Project Documentation' from the Tools menu to start the wizard. 11 where metrics with complex custom SQL logic filters can be combined into a single pass of SQL through global optimization when a feature flag is enabled. In the bottom left corner, click on the button "Generate Connection File". xApplyComparison ("ComparisonFunction (#0, #1)", attribute1@ID, attribute2@ID) You can use five pre-defined Apply functions to replace regular, predefined functions of the same type. Visit the data visualization and data dashboard galleries for inspiration. Query Stage: Retrieve data from the warehouse. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. The example below shows the basic structure of an ApplySimple statement to create metrics. For example: ApplyComparison ("#0>#1", Store@ID, Month@ID)You can use the ApplyComparison function to define custom filters. How the user answers the question determines what data is displayed on the report when it is returned from your data source. Create 2 attribute filters in the report. . This metric divides the sum of VOL fact at report level by [Net Weight] after applying it a character replace at BBDD level with ORACLE's replace function (it. In this article, we raised two workarounds to help. While each Apply function has its own syntax, the Apply functions share several syntactic features: The "#n" code in Apply function syntax serves as placeholders for the MicroStrategy objects being passed to your database. For basic information and examples of the ApplySimple function, see the Functions Reference. For details, see Comparison Operators. 2. Do one of the following: To apply the selections as a filter, select the Apply selections as a filter for all new targets check box.