Comparison operator prompts can be used in ApplySimple functions with Case statements using the metric, (@nameofprompt(M1, M2)). On the other hand, ApplySimple is more related to defining indicators or attributes. 3. MicroStrategy is a data analytics platform that delivers actionable intelligence to organizations of all sizes. Uninstall all the MicroStrategy and related products from Control Panel: Any MSTR Hotfixes applied. Example: Customer City = Call Center Using ApplyComparison An object is a basic building block in MicroStrategy. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. The URL parameter reportviewmode determines how reports are displayed in the view mode through the URL API in MicroStrategy Web 10. It allows users to customize data visualizations and build personalized real-time dashboards. Comprehensive analytical capabilities and Automated reporting: MicroStrategy offers wide range of analytical features including data visualizations, advance analytics, data discovery and predictive modeling. 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. A user tries to create a custom filter expression in MicroStrategy Desktop 8. The MicroStrategy SQL Generation Engine uses the COALESCE function to ensure correctness and consistency in full outer join results. Navigate to the Layout Tab. Use a table with zero values in the fact table in the Customer Level (users can add a zero to the Unit Sold Table. Click OK. 41. There's a reason we're at the top of the list. 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. To create a rolling month transformation filter, which will allow a user to select a month and will then filter values based on the the inputted number of months before it, do the following: 1. 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. The Intelligence Server will enforce the "User Freeform SQL. After that only thing you have to do is to press finish button. 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. Plus, it connects business apps while integrating data. Hint. Depending on your MicroStrategy product and licensing, this function may not be available. If you are looking to learn. Note: To create custom expression qualifications, the advanced qualification option must be enabled in the report designer's preferences in MicroStrategy Desktop 8. 2. the Administration menu -> Projects in MicroStrategy Developer as shown. Visit the data visualization and data dashboard galleries for inspiration. See the syntax below forward can. This article covers how to use passthrough expressions to write custom SQL inside of MicroStrategy. x, select 'Project Documentation' from the Tools menu to start the wizard. The following example shows the steps to create the report above: Create an attribute mapped to key2 column on Table_2. Number of offices 3. If you have a joint child relationship in your data, it is important for you to define it in MicroStrategy so. 62K. The Apply functions are not meant to take. This type of operator includes And, Or, and Not. Accept the other default values. The two fundamental parameters are the evt (short for “event”) parameter and the src (short for “source”) parameter. Go to Tools -> My Preferences -> Filters and check the box for Show Advanced Qualifications. All the existing visual Insights dashboards will be converted to Dossiers. The following report sample displays all of the options, including the view filter, in the report details. For example, ApplySimple ("#0 * #1", [col1], [col2]) indicates that two items, col1 and col2, referenced. Our Team; Careers: work as a economic news consultant; Our. The Delete unused managed objects option is found under. If you are editing the If function, use the values in step 7. Companies of all sizes use this platform to assess, visualise, and build dashboards. From the next drop-down menu, select the operator that describes how you want to filter data. Click the name of a report to execute it. Blocklist of project. The elements of a metric level are described below: •. In MicroStrategy Developer, it may be necessary to create a report that will calculate the year to date total of a metric. ApplyComparison is used to define a filter by populating the WHERE clause in the. Item = 3/4 * 10 = 7. Syntax. We’re here to help you align the future of AI/BI technology with your company vision. KB20000: How to create dynamic dates using MicroStrategy Developer 9. The difference in using Lead rather than Lag is that the Lead function would display information by going forward in time rather than backward. If all conditions are false, a default value is returned. ')"; [Net Weight. The report execution process is a three-step process: 1. To define a specific subtotal displays for a report like the one shown above, follow the steps below: Select Subtotals from the Data menu. ) The above example used an Apply function, ApplySimple. In the Navigation pane, click Dossiers. 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. The Pattern: The string pattern is similar to the ones used internally by the engine for. Article Reference Number: KB39231. The functionality of Apply functions is provided by wrapping the expression, as a string, inside a dedicated (Apply) function call. In short, some attribute elements don't have a relationship with their parent/child attribute. How to create a dynamic custom group to display a set of date ranges in Microstrategy Developer. 62K. . 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. The syntax is: FileLocation is the path to the saved test file. To solve this problem, the ApplyComparison. Filter Reports using SQL with ApplyComparison and ApplySimple. 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. Right click and "Run as Administrator" to. To use previously defined in Db2 function in MicroStrategy, you can use the MicroStrategy built-in Apply (Pass-Through) Functions or use Freeform SQL. Specify whether to compare all objects or just objects in a specific folder, and what types of objects to compare. mstrc”. The attribute form should use the same column as the ID attribute form, but it should only be sourced from the lookup table for the attribute. Define the advance sort on the derived. Use the MicroStrategy built-in apply (pass-through) functions; Freeform SQL; Apply (pass-through) functions. (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. KB7294: How security filters work in. Example 1 Using an attribute ApplySimple ("Datediff (YY, #0,getdate ())", [BIRTH_DATE]) Example 2 Using an attribute ApplySimple ("Months_between (sysdate,#0)",. 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. Click Insert Visualization to add a new, blank visualization to the dossier. x and newer Loading × Sorry to interruptIn some scenarios, it is necessary to use a database passthrough function (ApplySimple, ApplyComparison, ApplyAgg) to achieve specific query syntax that is not natively generated by the MicroStrategy SQL Generation Engine. In your Datasets panel, hover over the name of your dataset. Right-click on an existing environment and choose Properties. Create an attribute element prompt for Month. The next example uses ApplyComparison. But, DESC has repeating values. To enable a visualization to filter or highlight the data in another visualization. From the next drop-down menu, select the operator that describes how you want to filter data. 2. Populate & Evaluate Stage: Fill report data for display. CAUSE: One scenario is that the MicroStrategy 10. The user should enter two double-quote marks in succession, as shown. For details, see Comparison Operators. It was acquired by Google on June 6, 2019, for $2. By default, 'Custom Expression' is the option selected for a new Advanced Qualification. Double-click the security role you want to assign to the user or group. By default, this executable is located in C:Program FilesMicroStrategyIntegrity Manager. This is a single-value function. To begin, the architecture for dashboard execution is. SecurityRegion table defines from which region a user is allowed to view data. Example: Customer City = Call Center Using ApplyComparisonAn object is a basic building block in MicroStrategy. There is no functional difference between the two symbols. All metric expressions must have an aggregation function. Go to the Editors section and select Filter. ittoolbox. Min (Ttime) {~+, <|Ttime+} < [date filter]; @2; ->. 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. The ApplyAgg function is used to define simple metrics or facts by using database-specific, group-value functions. 1 comment. 11K KB6178: How to use the pass-through expression ApplyComparison in MicroStrategy SQL. There are two symbols which can be used interchangeably and are recognized by MicroStrategy as wildcards, * and %. 4 and later. , >, =, Like, In ApplyComparison is commonly used to create custom filters. Prompt-in-prompt is a feature in which the answer to one prompt is used to define another prompt. A space where we get together to see curiosities, share experiences and pass tips to be the coolest and most knowledgeable consultants. Cross-tab Stage: Pivot and display sorting and page-by. Considerations for the use of star schemas with MicroStrategy SQL Generation. Choose one of the following: Save the metric. ) are used. 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. Retrieve a list of user groups and the associated users in MicroStrategy Developer Follow the steps below to create a list of all groups and the users in each group: In MicroStrategy Developer 9. likes. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. It can connect to data warehouses, relational systems, flat files, web. Create a FreeForm SQL Report and add this nested prompt into it. All articles. But, DESC has repeating values. Accordingly, this section focuses on how to use transformations in metrics and reports, and provides only an overview of. Competitors: Oracle, SAP, IBM Create Comparison. The definition of the shortcut filter (East Coast) is displayed. How to write Pass-through filters using ApplySimple, ApplyAgg and ApplyComparison functions. There are three types of objects: schema objects, application objects, and configuration objects. 5. 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. Go to Tools -> My Preferences -> Filters and check the box for Show Advanced Qualifications. ) The above example used an Apply function, ApplySimple. This type of operator includes And, Or, and Not. Tuning Suggestions on Db2 database. Select the 'Advanced' tab, as shown. 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. Create three filters (F1, F2, F3) using Applycomparison statements. The next example uses ApplyComparison. xThe steps below describe a method of double-filtering a grid/graph object in Web 9. 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. Starting in MicroStrategy 10. (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. I've looked at % column settings in other % metrics in our. The next example uses ApplyComparison. Intelligence Everywhere. 3. Create a tie-breaker / unique-ranking metric using the [running count] analytical function: Right-click on the RunningCount function name and choose 'parameters': Set the sorting order to be [UNIT PRICE] and [UNIT COST]. They act as containers for non-standard SQL expressions that MicroStrategy does not support. 5% of users said that the platform is easy to use, with a user-friendly drag. Overall, more than 87. Visit the data visualization and data dashboard galleries for inspiration. (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. You can achieve what you want if you build the metric with: A filter to ignore your specified "NULL-Date". One common way to do this is to compare the date information you have stored to the current date. Select any project that is in the project source that contains the users and groups and click Next. 1 and 10. g. Dossiers can be created by using the new Desktop product or Workstation or simply from the Web interface which replaces Visual Insights. MicroStrategy desktop provides some functionality to compare the values of two metrics using the filtering functions. ApplyComparison where comparison operators (>=, <, Like, etc. ApplyComparison. ” icon to expand it: All page-by attributes will. 11 a new optimization is available for metrics with complex custom logic SQL filters using applycomparison. In this example, the filter compares a user-entered date to see if it is between the Order_Date and the Ship_Date. If you want to use a data range in your filter, select Between. Syntax. The ApplyComparison function is used with RDBMS comparison operators such as >, like, and In. 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. 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. Syntax Common to Apply Functions. The Document Properties dialog box opens. In MicroStrategy 2021 Update 5, in order to achieve better performance, for selected Gateways, the SQL Engine will push down the case function to calculate in the databases. ApplyComparison("#0 not like '-%'"; [InductLine]@ID). ApplyComparison. Syntax Common to Apply. Stand out in a crowd. Joao Paulo "mahendra_patel via microstrategy-l" 07/07/2006 11:19 Favor responder a microstrategy-l@Groups. Once data flows into the interface, the dashboard will come to life. The following steps demonstrate how to use the comparison operator prompt in an ApplySimple function with a Case statement. for each successive object passed. 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. How to Create a Filter within a Report: Embedded Filters. Adding an existing D3 Visualization;. 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 the SQL parser in MicroStrategy Desktop. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. Click the “Burst. ApplyComparison() Accepts facts, attributes, and metrics as input. The Report SQL indicates that the filter has not been applied. In the User Manager, grant the 'User report filter editor' privilege to the user facing this issue. Project and schema locking prevent multiple users sessions. If DHTML is disabled, click the Go icon . In Microstrategy I am trying to create a new fact that returns a specific name depending on the type of text contained in the field NAME. 00% Whether there are values or not. . See side-by-side comparisons of product capabilities, customer experience, pros and cons, and reviewer demographics to. {&GROUPLABEL} Name of the graph. MicroStrategy Developer allows expressions to be created where an element list prompts is one of the arguments to a passthrough function; however. 7K KB6178: How to use the pass-through expression ApplyComparison in MicroStrategy SQL Generation Engine2. Next, navigate to the Theme tab. The syntax for the If function is IF (Condition, TrueResult, FalseResult) where:The MicroStrategy Desktop environment is very intuitive. If all conditions are false, a default value is returned. The ApplyComparison function is used with comparison operators such as >, Like, and In. ) The above example used an Apply function, ApplySimple. When exporting a report containing an image attribute form (using an ApplySimple statement) to PDF in MicroStrategy Web 9. 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. Select the source and destination projects. 2. Example: Customer City = Call Center Using ApplyComparisonSet the qualification type to 'Custom'. Click Insert Visualization . ApplyComparison ("Upper (#0) like. . mtc is the name of the saved test file. From the Tools menu, select Grouping. Now when both the prompts are answered,the above subquery is generated by the Microstrategy . General hardware recommendations. Note that for the first row, the data from the previous row is 0 since the analysis is limited to the data retrieved by the report. How to use the pass-through expression ApplyComparison in MicroStrategy SQL Generation Engine. To create Metrics - use ApplyAggregate 3. 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. How to create a comparison operator prompt and use it in an applysimple function in MicroStrategy Developer. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. x, select 'Project Documentation' from the Tools menu to start the wizard. In this article we will discuss the ApplySimple function. The ApplySimple function is used with simple operators and functions. The report execution is typically a 3 step process process of the below: Query Stage. 4. This article explains how to use the applycomparison function in MicroStrategy INTRODUCTION Pass-through expressions, also called Apply functions, provide access. Run Repository Translation Wizard from the Start Menu -> Programs -> MicroStrategy-> Object Manager. Use the limit comparison test to determine whether the series ∑ ∞ n = 1 5n 3n + 2 converges or diverges. The script inside the " " always depends on the type of database used and can. 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. This type of passthrough can be used to create flexible filters. 1) Adding a view filter to the report where Sum Metric != 0 which will bring only non zero values. If excutionMode is not provided in the URL, by default PDF will be used as executionMode. Follow the steps below. Some of the main features offered by MicroStrategy are Advanced Analytics, Data Discovery, Data Visualisation, Embedded BI, and detailed reports and statements. Enter the values to use as arguments. Enterprise Analytics Business Intelligence; HyperIntelligence; Cloud; Product Innovation; Education; ConsultingInvoke the MicroStrategy Integrity Manager executable MIntMgr. A simple application of this technique is to use a constant value prompt in your project as a multiplier of metric data: ApplySimple (" ( [Measures]. Execute the report and add a Subtotal (Average). 1. This is usually ID. For more details, click the link corresponding to each function. EXAMPLE: Create a filter using the ApplyComparison expression with "like" function embedded. Example: Customer City = Call Center Using ApplyComparison To use Apply functions, you must have the Use FreeForm SQL Editor privilege. 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. If you are looking to learn. In MicroStrategy, you can choose to allow or disallow joins across datasets based on unrelated common attributes. 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. " How to create a custom expression filter in MicroStrategy Developer 9. This will enable the option to use ApplyComparison’s in Filters. The following procedure describes how to achieve this: Create the highest level filter. Syntax. x-10. You can only certify dossiers in the Dossiers area of the Navigation pane. 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 . 4. mstrc file created before and click Continue. MicroStrategy strongly advises against using Apply feature at standard MicroStrategy functions can be used to achieve the same goal, because using RDBMS additional effectively bypasses the validations also other benefits about MicroStrategy products. 3. Salesforce (Tableau) has a rating of 4. Skip on content. How to create a MicroStrategy connection file (. Follow the steps below to access the Project Comparison Wizard: From the Start menu -> Programs -> MicroStrategy -> Administrator -> Object Manager. 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. If you’re a Power BI user, you’ll be pretty much at home with MicroStrategy since both use similar analytics tools and share a common semantic layer. Category = 1/4 *10 = 2. Apart from using the VLDB properties to create the left outer join, article describes how to use the Logical View to specify an outer join between two attribute lookup tables when only attributes are on a report. 2. Example 1 Using an attributeWildcards are special characters which when used in a string comparison such as "like" change its behavior. KB6178: How to use the pass-through expression ApplyComparison in MicroStrategy SQL Generation Engine. The ApplyComparison function is used with comparison operators such as >, Like, and In, which accepts facts, attributes, and metrics as input. It leverages data connectivity, machine learning and mobile access to offer users comprehensive control over their insights. From the Tools menu, select View Filter. The next example uses ApplyComparison. ApplySimple() Accepts facts, attributes, and metrics as input. The following schema shows which setting takes precedence when set at different levels. String Functions. Pass-through expressions, also called Apply functions, allow use of special functions or syntactic constructs beyond what MicroStrategy can create on its own, but can be obtained through the relational database. This is a single-value function. The name of the source visualization. 2. 4. MicroStrategy has a rating of 4. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. MicroStrategy is a data analytics platform that delivers actionable intelligence to organizations of all sizes. A ragged hierarchy is the one in which the parent or child attribute element of one or more attribute elements are not present in the level immediately above or below the attribute. x using the ApplyLogic function, as illustrated below. Today, I’ll talk about ApplyComparison, which allows you to provide custom SQL in the WHERE clause of. The Report SQL indicates that the filter has not been applied. 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. The next example uses ApplyComparison. The tooltip will show the dataset type listed as a Super Cube. Last updated: Apr 12, 2019. MicroStrategy helps business people make faster, better business decisions, empowering them with self-service tools to explore data and share insights in minutes. 0. Interact with the engaged MicroStrategy Community to get answers to all your questions and collaborate for solutions. 1. Example: Customer City = Call Center Using ApplyComparisonTo use Apply functions, you must have the Use FreeForm SQL Editor privilege. . Overall customer rating 9. Open the document in Design or Editable Mode. By using relationship filters, MicroStrategy SQL Generation Engine's automatic filter conversion can be replaced with a manual filter conversion, and the manual conversion can be targeted to specific attributes that avoid the combination of multiple attributes in the same subquery. To determine how MicroStrategy hides null and zero metric values in the grid, on the General tab, select the Hide Null/Zero Toggle Behavior. If you are looking to learn. ) The above example used an Apply function, ApplySimple. Joao Paulo "mahendra_patel via microstrategy-l" 07/07/2006 11:19 Favor responder a microstrategy-l@Groups. 1. This article will not discuss the hardware. In the layout tab, click "Allow multiple selections". The Filter Options dialog box opens. This can be proven using the MicroStrategy Tutorial project against a SQL Server warehouse. One of the MicroStrategy-provided transformations answers our needs for the following example. In order to exclude the values, create another filter expression which will always be TRUE and. 4. While string functions can be used to create metrics, a more common use case for these functions is in the creation of attribute forms. September 06, 2018. Go to File > New >. String functions perform various actions that modify the characters returned for a string of characters. Microstrategy Dossiers With the release of MicroStrategy 10. Cheers. ApplyComparison ("#0 in (SELECT MAX(WK_IDNT)FROM TIME_DAY_DM WHERE. 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. Query Stage: Retrieve data from the warehouse. The Filter Editor is displayed. exe using the command line. CONTENTS 1. 2987. KB35312: Attribute sorting does not get applied correctly on a selector when viewing a Report Services Document in DHTML mode in MicroStrategy Web 9. In this example, the filter compares a user-entered date to see if it is between the Order_Date and the Ship_Date. It visualises interactive dashboards, charts and graphs and improves analytics and predictive modelling capabilities. To resolve this issue, follow the steps below: Log into the project source as a user with System Administrator privileges. There's a reason we're at the top of the list. As you can imagine, the SQL Engine. 1. Populate and Evaluate: Fill report data required for display. Example: Customer City = Call Center Using ApplyComparison You can use the AppleSimple function to insert database-specific functions and simple operators directly into SQL. This article describes how to use the applycomparison function to use like with text prompts in MicroStrategy(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. Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. A security filter can be assigned to a user or group to narrow the result set when they execute reports or browse elements. 1) Create Metric 1 which is the sum of the fact that is to be in the columns. Now your connection f. 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. In this article, we raised two workarounds to help. There are two symbols which can be used interchangeably and are recognized by MicroStrategy as wildcards, * and %. The expression parser fails to validate the expression, with a message under the expression editor reading "Invalid Expression. In MicroStrategy Web, open the document in Design or Editable Mode. The definition of the shortcut filter (East Coast) is displayed. This function evaluates multiple expressions until a condition is determined to be true, then returns a corresponding value. The next example uses ApplyComparison. ApplyComparison("#0 not like '-%'"; [InductLine]@ID). From the Visualizations panel, select Grid . 6 stars with 694 reviews. x. 4. Every request to a MicroStrategy Web product corresponds to a. CASE 2. Ap plySimple (microstrategy. mstrc) Open Workstation. The overall sort order is evaluated and stored in the attribute definition when the attribute is saved. When evaluating different solutions, potential buyers compare competencies in categories such as evaluation and contracting, integration and deployment, service and support, and specific product capabilities. To Create a Combination Graph. To Access an Advanced Filter Qualification. x-10. The following examples illustrate the URL parameter reportviewmode and the corresponding view of the report that will display: When reportviewmode is set to 1, the report is displayed in grid mode: When. The primary characteristic of star schema is its use of dimension tables rather than single-attribute lookup tables. With an OLAP Services license, user can perform additional OLAP analysis, using the following features: Displaying data on the fly: dynamic aggregation, page. The Filter Options dialog box opens. Create 2 attribute filters in the report. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning.