Number of Views 3. Right-click on the Project name in MicroStrategy Developer 9. Transformations allow you to apply an attribute-element based offset to compare metric data. If you want to use a data range in your filter, select Between. 9, we’ve taken a leap forward in our dashboarding capabilities by simplifying the user experience, adding storytelling, and collaboration. Returns TRUE if the value is NULL; otherwise returns FALSE. For an introduction to prompts, how prompts save the report designer time, and how prompts work with MicroStrategy security filters, see the. Follow the simple steps below to create a datamart report: 1. com) KB6178: How to use the pass-through expression ApplyComparison in MicroStrategy SQL Generation Engine. 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 Filter Editor is displayed. For example, a transformation metric can help a user compare last month's revenue to this month's revenue. Skip on content. 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. There are three types of objects: schema objects, application objects, and configuration objects. MicroStrategy. ApplyComparison ("#0 in (SELECT MAX(WK_IDNT)FROM TIME_DAY_DM WHERE. 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. Number of offices 3. The report execution process is a three-step process: 1. In the last field, type the value (s) or click the calendar to select a. How to define an advanced qualification using a custom expression to filter on months in MicroStrategy Developer 9. 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. After applying the filter, click some of the values of the product category visible in the top bar filter section. The metric calculates only for the elements found in the filter definition. Simple drag-and-drop tools are paired with intuitive visualizations. 2. Target: The target is the attribute level at which the metric calculation groups. Now when both the prompts are answered,the above subquery is generated by the Microstrategy . For the second filter, create an advanced qualification. To resolve this issue, follow the steps below: Log into the project source as a user with System Administrator privileges. From the next drop-down menu, select the operator that describes how you want to filter data. Select. Description. All attributes used to group data in the report or document are shown in the Available Attributes list. Example. id where #1 and #2)", [Date]@Id,? [GTN],? [BTN]) Both the GTN amd BTN are optional prompts. To enable a visualization to filter or highlight the data in another visualization. Use a table with zero values in the fact table in the Customer Level (users can add a zero to the Unit Sold Table. 2 by default. ApplySimple ("cast (#1 as varchar (3)) + ': "" ' + #0 + ' "" ' ", , ) The purpose of this expression (for SQL Server) is to display items with both the ID and description in the same string, quoting the description: When SQL is generated, wherever two double-quotes appear in. An object is a basic building block in MicroStrategy. Go to Tools -> My Preferences -> Filters and check the box for Show Advanced Qualifications. Select only Configuration Objects for documentation. Level: Set grouping to "Beginning Fact" for your date attribute. To Display a Filter's Definition. Or we can jsut had code the filter Sum Metric >0 if we want to pre-filter the report with non zero rows for. MSTR Health Center (if it's not uninstalled) MSTR Office (if installed) DHTML Editing Component (if installed) Restart the machine. x, select 'Project Documentation' from the Tools menu to start the wizard. The filtering setting for a level metric governs the relationship between the report filter and the calculation of the metric. the Administration menu -> Projects in MicroStrategy Developer as shown. All the existing visual Insights dashboards will be converted to Dossiers With MicroStrategy 10. --- mahuamitra via microstrategy-l wrote: > > Thanks for the quick reply. This is a single-value function. It visualises interactive dashboards, charts and graphs and improves analytics and predictive modelling capabilities. Ragged Hierarchies in Microstrategy. Object prompts can be created using. 02K. Notice that a joint child relationship can be one-to-many or many-to-many. For additional information on Null/Zero functions, refer to the MicroStrategy Functions Reference. 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. Follow the steps below to create a list of all groups and the users in each group: In MicroStrategy Developer 9. Ultimately, it was. Back to. Quick connections to any data source are combined with one-click sharing of any insight. For example, a transformation metric can help a user compare last month's revenue to this month's revenue. A product bundle (including Web, Intelligence, Analytics, and Distribution) designed to meet the specific needs of power users who create, design, analyze, share, and save MicroStrategy Dossiers, reports, and documents. exe using the command line. 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. In MicroStrategy SQL Generation Engine, it is not possible to use element list prompts in database passthrough functions, using the default syntax, such as ApplySimple,. 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. In this case, enter 'Date@ID'. This is a filter which contains a prompt on an attribute element list. You will see that R2 still displays the first 6 months data. One filter uses the original ID form of the attributeThis article discusses how to use Edit Links to filter a destination Report by an attribute not present on the destination Report in MicroStrategy Desktop 9. How to create a MicroStrategy connection file (. Example 1 Using an attributeWildcards are special characters which when used in a string comparison such as "like" change its behavior. Salesforce (Tableau) has a rating of 4. Transformations are schema objects and therefore only a project designer with the Create schema objects privilege can create them. Go to Start -> Programs -> MicroStrategy -> Tools, run ScanMD. ApplyComparison. The ApplyAgg function is used to define simple metrics or facts by using database-specific, group-value functions. When they need to use an Apply function, MicroStrategy encourages you to submit an enhancement request for inclusion of of desired feature in one future product release. Using the "Month" attribute as an example, follow the steps below to create a dynamic filter in the Microstrategy Tutorial project: Create a filter from Developer and select "Add an advanced qualification", as shown below: Select "Custom expression" under "option" drop-down list, as shown below:Filter Reports using SQL with ApplyComparison and ApplySimple. This article will not discuss the hardware. The ApplySimple function is used with simple operators and functions. Right-click the project for which to activate the advanced qualification option and choose My Preferences. x, select 'Project Documentation' from the Tools menu to start the wizard. ApplyComparison With system prompts, it is possible to use database security tables to build MicroStrategy security mechanisms. Add "Products" user hierarchy to the metric level and set the grouping option to "None", as shown below:KB14959: How to use stored procedures with Freeform SQL reports in Oracle or DB2 data warehouses in MicroStrategy SQL Gene… Number of Views 9. ApplyComparison where comparison operators (>=, <, Like, etc. 4. ApplyComparison ("ComparisonFunction (#0, #1)", attribute1@ID, attribute2@ID) You can use five pre-defined Apply functions to replace regular, predefined functions of the same. x SQL Engine is ignoring the conditionality at the report level because a metric in the report also contains a related conditionality which has been set to "remove related report filter elements" or "ignore" the filtering criteria at. ApplySimple – Uses simple arithmetic operators. Example 1. Dossiers can be created by using the new Desktop product or Workstation or simply from the Web interface which replaces Visual Insights. This will allow users to select which month to roll back from. com Para jpviva. This is a comparison function. ApplyComparison ("upper(#0)=upper(#1)", Customer@, ?Customer) Note: The SQL query mentioned in this document is specific for Oracle Warehouse and provided as simply an example. 0. In short, some attribute elements don't have a relationship with their parent/child attribute. All articles. Example: Customer City = Call Center Using ApplyComparisonSet the qualification type to 'Custom'. 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. Continue with the previous Steps 2 and 3 above. For example, ApplySimple ("#0 * #1", [col1], [col2]) indicates that two items, col1 and col2, referenced. Enter the values to use as arguments. MicroStrategy Web provides a wide range of parameters that can be used in combination to achieve different types of requests. If SQL is required for another database platform, users need to contact their database administrator to do so. Create three filters (F1, F2, F3) using Applycomparison statements. In the MicroStrategy Tutorial, a report with the Subcategory attribute and the Freight and Discount metrics generates the following SQL (using Microsoft SQL Server): select a13. Logical operators: These operators provide basic comparisons and return TRUE or FALSE values based on the evaluation of the formula. Overall, more than 87. Specify whether to compare all objects or just objects in a specific folder, and what types of objects to compare. 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. Right-click a project in that project source and select 'Compare projects' or select Project. . Open the document in Design or Editable Mode. The Report SQL indicates that the filter has not been applied. This report shows the sum of sales for each month, for the previous row and the % change between them. ApplyComparison. x. However,. Labels: #Recursive hierarchies microstrategy #Recursive Hierarchy. Open MicroStrategy Developer. This type of passthrough can be used to create flexible filters. Drag an attribute from the Datasets panel to the Rows area of the Editor panel to add attributes to the rows. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. The “SQL” portion of your code always come. This type of operator includes And, Or, and Not. The following procedure describes how to achieve this: Create the highest level filter. 3. Once you have subscribed to MicroStrategy, you will be able to download the MicroStrategy virtual appliance. x . CONTENTS 1. 41. However, by taking advantage of the ApplySimple expression, the attribute sorting can get applied correctly in Microstrategy Desktop and Web 9. Select Show advanced qualification. The Security Role Editor opens. In the MicroStrategy Developer File menu, point to New > Filter. This is a comparison function. These two software solutions offer almost similar features. e. Example 1 Using an attribute ApplySimple ("Datediff (YY, #0,getdate ())", [BIRTH_DATE]) Example 2 Using an attribute ApplySimple ("Months_between (sysdate,#0)",. In the bottom left corner, click on the button "Generate Connection File". You can use DateDiff to create a metric or attribute form that lists the length of time between two dates. Syntax. The ID is distinct. 4) Next, change the Theme back to None and click Apply. Apply functions: These functions provide access to functions and syntactic constructs that are not standard in MicroStrategy but are offered by various relational database. IsNotNull(Argument) Argument is a fact or metric. Willingness Team; Careers: work as adenine business intelligence consultantKB17904: How to prompt for a month and show data for the last 12 months using warehouse transformation tables. In some cases, it is possible that a single column does not meet these criteria, in which case either the dataset/application is not a good. Clear the Totals check box to remove the standard subtotals. All articles. 2. Below are the new features exclusive to. Cards can be consumed in a web browser via the MicroStrategy HyperIntelligence Chrome extension and on iOS devices via the MicroStrategy. In MicroStrategy SQL Generation Engine, it is not possible to use element list prompts in database passthrough functions, using the default syntax, such as ApplySimple, ApplyComparison and ApplyAgg. The report execution is typically a 3 step process process of the below: Query Stage. x-10. In some circumstances, it may be desirable to edit the definition of a security filter on the fly. xThe steps below describe a method of double-filtering a grid/graph object in Web 9. Set up the VLDB settings for metric join type and SQL GO. 5. Create a new filter in MicroStrategy Developer; Choose the 'Add an advanced qualification' option and click on the 'OK' button. In SQL View look at where the cross join appears, and between which tables the cross join appears. See side-by-side comparisons of product capabilities, customer experience, pros and cons, and reviewer demographics to. The example below shows the basic structure of an ApplySimple statement to create metrics. Visit the data visualization and data dashboard galleries for inspiration. Here are the series of steps to setup report objects in which metrics and subtotals so only the subtotal field will contain the RunningSum and the regular metric values will be standard sum values. Right-click on an existing environment and choose Properties. In this example, the filter compares a user-entered date to see if it is between the Order_Date and the Ship_Date. Syntax Common to Apply. From the Tools menu, select View Filter. Security filters enable you to control what warehouse data users can see when that data is accessed through MicroStrategy. This prompt is used in a filter. (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. ApplyComparison ("#0 between #1 and #2",? Instead, they are intended to enhance the MicroStrategy product by taking advantage of what the RDBMS platforms can offer. Now your connection f. In the Functions pane, hover over the If or Case function and click Edit. They act as containers for non-standard SQL expressions that MicroStrategy does not support. Create a report R1 with Month, Revenue and filter which contains the first 6 months in 2008. A blank visualization appears in the dossier. See this difference in Joins Across Datasets and Document/dashboard best practice. The next example uses ApplyComparison. 3. 9, there was an active focus on making it easier to build dashboards for the widest audience of end users. 1. Dashboard execution stages can be represented below: MicroStrategy Intelligence Server When an end user makes a Document Execution Request through any client (a web browser via MicroStrategy Web, the MicroStrategy Desktop/Developer client, the MicroStrategy Mobile app, or the MicroStrategy Office client), the request is sent to. Click OK. a. As a MicroStrategy developer, and a SQL. Execute the report and add a Subtotal (Average). Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. The ApplyComparison function is used with comparison operators such as >, Like, and In, which accepts facts, attributes, and metrics as input. A dataset is a standard MicroStrategy report. x, select 'Project Documentation' from the Tools menu to. ApplyComparison. If I select name1 from the prompt, I do need to show all the occurances of. The MicroStrategy ONE platform provides access to AI-powered workflows, unlimited data sources, cloud-native technologies, and unparalleled performance to speed up time from data to action. To Access an Advanced Filter Qualification. 4. From creating basic objects to building complex reports and analyzing data, you have the ability to create custom expressions using a. ApplyComparison("#0 not like '-%'"; [InductLine]@ID). CONTENTS 1. ) Add Customer State and Customer to the report. After that only thing you have to do is to press finish button. 5. 9 billion. How to Create a Filter within a Report: Embedded Filters. Click Advanced, then New to create a custom subtotal. Actually, it can be used anywhere where. Now your connection f. Cross-tab stage. Use the individual editors inside Developer to create and edit various model objects. It will not indicate that the check box is enabled, but this step is mandatory. By default, this executable is located in C:Program FilesMicroStrategyIntegrity Manager. As you can imagine, the SQL Engine. The examples below use the Lag function. In some circumstances, it may be desirable to edit the definition of a security filter on the fly. 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. If an environment does not already exist, an environment will need to be created first. The user should enter two double-quote marks in succession, as shown. Create 2 attribute filters in the report. Query Stage: Retrieve data from the warehouse. com] Sent: Friday, July 18, 2008 10:26 AM To: Karan, Divya Subject: RE:[microstrategy-l] How to create a case sensitive value prompted filter in MSTR Posted by sukumar123 on 07/18/2008 11:29:00 AM I am using DB2. The number of partitions should typically be between the minimum and maximum, and closer to half the number of logical cores. In the layout tab, click "Allow multiple selections". Depending on your MicroStrategy product and licensing, this function may not be available. For example, edit the attributes. ApplyComparison("#0 not like '-%'"; [InductLine]@ID). Save and assign a name to the file like “My_first_connection_file. (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. How to create a MicroStrategy connection file (. Click Qualify. September 06, 2018. This depends on the function we are using (we explain each one below), but, for example, the ApplyComparison, appears mainly when defining filters, either integrated within a report or an indicator or as a filter object per se. Data can be connected through an API, flat file, or database. 9, there was an active focus on making it easier to build dashboards for the widest audience of end users. This document will use the MicroStrategy Tutorial project with a warehouse in SQL Server to demonstrate the concept: Create a numeric value prompt and name it P1. Logical operators: These operators provide basic comparisons and return TRUE or FALSE values based on the evaluation of the formula. To solve this problem, the ApplyComparison. x. Our solutions work to guide towards best practices and provide guidance to the user community. Article Reference Number: KB39231. all to no avail. 4. '. For example, a Time dimension in a star schema may be supported by a dimension table with the following structure: DAY_ID. There are five predefined Apply functions, each belonging to a different function type - ApplySimple, ApplyAgg, ApplyOLAP, ApplyComparison, ApplyLogical. ittoolbox. To Create a Combination Graph. 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. The next example uses ApplyComparison. I've been all over Microstrategy community and have tried possible solutions/formatting etc. Item = 3/4 * 10 = 7. To create a MicroStrategy Environment connection file . Follow the steps below: Right-click on the project and select 'Project Configuration. ) The above example used an Apply function, ApplySimple. Select the attributes and facts from that table. 1001 to 5000 Employees. ApplyComparison ("Upper (#0) like. Select any project that is in the project source that contains the users and groups and click Next. About Us. 62K. In this example, the filter compares a user-entered date to see if it is between the Order_Date and the Ship_Date. 4. How to create a custom expression filter in MicroStrategy Developer 9. 1. Syntax. Example: Customer City = Call Center Using ApplyComparisonTo use Apply functions, you must have the Use FreeForm SQL Editor privilege. If all conditions are false, a default value is returned. ApplyComparison is commonly used to create custom filters. Drive revenue growth with memorable app workflows and AI features that really speak to the user. A user tries to create a custom filter expression in MicroStrategy Desktop 8. the database do the work…such is the Case with the ApplyComparison filter. KB7294: How security filters work in. Metrics are the numerical values on which we can apply mathematical calculations and also compare them numerically. Back to the Report. The next example uses ApplyComparison. There's a reason we're at the top of the list. The Filter Editor is displayed. 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. After installation of this application only thing you have to do is to follow step listed below: Type here text you want to find and press next. 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. Examples of this category are Between, Like, Greater than(>), Less than (<), ApplyComparison, and so on. Case. Create a new filter in MicroStrategy Developer; Choose the 'Add an advanced qualification' option and click on the 'OK' button. Using the Metric Editor, create a new metric expression. You will see that R2 still displays the first 6 months data. Transformations allow you to apply an attribute-element based offset to compare metric data. Overall, more than 87. 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. 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,. Example: Customer City = Call Center Using ApplyComparison You can use the AppleSimple function to insert database-specific functions and simple operators directly into SQL. Right-click on the Project name in MicroStrategy Developer 9. 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. From: sukumar123 via microstrategy-l [mailto:microstrategy-l@groups. From: danielmager via microstrategy-l To: devildreamss Sent: Wednesday, No vember 1, 2006 1:27:45 PM Subject: Re: [microstrategy-l] Microstrategy lo gged in user on report / parameter. Starting in MicroStrategy 10. MicroStrategy is a data analytics platform that delivers actionable intelligence to organizations of all sizes. You can use DateDiff to create a metric or attribute form that lists the length of time between two dates. 2) Creating a filter definition prompt with the Sum Metric, so that when the rpeort is prompted user cans elect Sum Metric value is >0 . Specify whether to compare all objects or just objects in a specific folder, and what types of objects to compare. Enterprise Analytics Business Intelligence; HyperIntelligence; Cloud; Product Innovation; Education; ConsultingInvoke the MicroStrategy Integrity Manager executable MIntMgr. For details, see Comparison Operators. 3. A list of security roles in the project source opens in the main Developer pane. The next example uses ApplyComparison. The different kinds of value prompts are: Date prompt: Users enter a specific date for which to see data. mtc is the name of the saved test file. From the Tools menu, select View Filter. Below tuning suggestion is based on IBM Document on Performance Tuning. A bubble chart (aka bubble plot) is an extension of the scatter plot used to look at relationships between three numeric variables. From the Project menu, select Compare Projects. In the Grouping panel, right-click the grouping field to display horizontally, and select Grouping Properties. 9, there was an active focus on making it easier to build dashboards for the widest audience of end users. Enable the 'Show Advanced Qualification' box, as shown below. 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. Run the report and type in "east" as the. Microstrategy Dossiers With the release of MicroStrategy 10. For information on whether your database supports various date and time functions, see MicroStrategy and Database Support for Functions. With all form sort orders set to none there is no saved sort order, MicroStrategy defaults to sort ascending by ID. com Para jpviva. Enable users to interact with personalized chat for further product discovery. The index. Right click and "Run as Administrator" to. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. Menu. Go to My Preferences > Editors > Filter Options. A MicroStrategy Report Services document displays data coming from multiple reports, with the data laid out and designed in presentation-quality format. MicroStrategy ONE introduces new features that provide better performance and scalability to enhance the overall user experience. Cross-tab Stage: Pivot and display sorting and page-by. 1 and 10. 1. This article covers how to use passthrough expressions to write custom SQL inside of MicroStrategy. 3. Create an advanced filter qualification. Each dot in a bubble chart corresponds with a single data point, and the variables’ values for. Restricting access to data: Security filters. The Select Bursting Criteria options are displayed. From the Tools menu, select Report Options. Only project configured with those setting is applicable for the case in this article. Below are the list of parameters that the URL must. Patent Nos. 5. The tooltip will show the dataset type listed as a Super Cube. 11K KB6178: How to use the pass-through expression ApplyComparison in MicroStrategy SQL. Number of Views 2K. The apply collection can be viewed as a substitute to the loop. 1 and 10. Schema objects include facts, hierarchies, and custom groups; application objects include reports, documents, and metrics; and configuration objects include project sources, database instances. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. exe to this machine. Arguments may be substituted into the specified SQL pattern. 1. 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. Create another report R2 with Year, Month, Revenue and use R1 as filter. Create a FreeForm SQL Report and add this nested prompt into it. cc Assunto [microstrategy-l]. In Step 1, choose a Project Source from the drop down list, and enter a Login and a Passwordthat have administrative privileges to the metadata. How to write Pass-through filters using ApplySimple, ApplyAgg and ApplyComparison functions. cc Assunto [microstrategy-l] ApplySimple function in MSTR. 5% of users said that the platform is easy to use, with a user-friendly drag. Using Prompts and ApplySimple Statements. How the user answers the question determines what data is displayed on the report when it is returned from your data source. Create a report with Region attribute. In order to export a document in excel format using the URL API, the executionMode must be set to 4. EXAMPLE. 4. Right-click on an existing environment and choose Properties. Query Stage: Retrieve data from the warehouse. Create a new filter using a custom expression with POST /api/model/filters. ApplyComparison is commonly used to create custom filters. Here is the workaround to achieve the attribute left outer join on MicroStrategy Web. This is a. There's a reason we're at the top of the list. The index. ApplySimple ("case when #0 contains 'As Is' then 'As Is' when contains 'New' then 'New' ELSE 'Other' END", [NAME]) case. Numeric prompt: Users enter a specific number, up to 15 digits, which is then used as part of a filter, or within a metric, to look for specific numeric data. I have a filter and in it is the ApplyComparison function doing a simple query. Therefore, there are two ways around it; you need to create a view that pre-joins the two tables so the two columns are in the same table; or you can use a subquery to bring one column from one table into the other table. 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. Go to the Editors section and select Filter. 5. 0. Click the name of a report to execute it. The apply () function is the most basic of all collection. The next example uses ApplyComparison. SecurityRegion table defines from which region a user is allowed to view data.