The ApplyLogic function is used to define custom filters. To set Data Engine Version, refer to How to set Date Engine Version. Only one level of nested panel stacks is supported. It can connect to data warehouses, relational systems, flat files, web. Create Filters Open the Workstation window. This section describes the different types of filters available in MicroStrategy and shows you how to create a simple filter of each type. Till now I have seen the developers were using prompt to pass the value from one dossier to another. promptAnswerMode *. The Document Properties dialog box opens. This method uses filter design design tables to realize higher order filters by cascading 1st and 2nd order active stages. Create a second report with the following: "Region" as attribute "Sales" as metric; Add Regions to the report filter then below that qualification add the filter created in Step 2. Open the report you want to create a filter for. The purpose of dimensional modeling is to optimize the database for faster retrieval of data. From the MicroStrategy Developer File menu, point to New > Attribute. The Security Filter Sequence represents order the security filter was applied, when multiple security filters are applied during an execution. Numeric filters. MicroStrategy - Creating Filters. The filter is qualified on an attribute form, not elements. 2. BasicReportingGuide vii ©2017,MicroStrategyInc. Click Save and Close to save the metric and close. As you type, matching objects are displayed in a drop-down. Answer: When attempting to add a prompt directly to an Intelligent Cube in MicroStrategy Developer 9. How to create and use an attribute qualification filter in MicroStrategy. Somehow the user or the filter got corrupted looks like. MicroStrategy - Attribute Qualification Filters - Online Training Video by MicroRooster. Get inspiration at the MicroStrategy data visualization gallery. Discussions and overview/introduction to more complex tools within report studio. As noted earlier, filter qualifications apply prior to metric aggregation. It also applies to reports with attribute element list prompts, hierarchy. September 18, 2018. From the Schema menu, select Architect. For information on how to. It visualises interactive dashboards, charts and graphs and improves analytics and predictive modelling capabilities. 0. 11, however, the issue can seemingly only be reproduced with Tomcat. Choose a prompt. If a user enters more than 15 digits for a. By altering the design to a series of 4-panel dashboards and replacing the quick filters with filter actions, the load time for each dashboard was reduced to less than eight seconds. Object Layer. By default, the first prompt from your prompted dossier is selected. This article notes an interaction between derived metrics and view filters. Tile grid map is an abstraction of the map data to solve the issue of difference in sizes causing issues with shading and making it difficult to compare geographic information. Prerequisite. Attribute Qualification Prompt, which allows users to determine how the report's data is filtered, based on an attribute filter. MicroStrategy Integrity Manager is an automated report comparison tool designed to streamline the testing of MicroStrategy projects. Select Level (Dimensionality) in the breakdown window (under the heading Metric is defined as). Object layers contain and store the objects created in MicroStrategy. Answering all prompts ( promptsAnswerXML parameter) Generating the XML to answer all prompts (including nested prompts) Answering element list prompts ( elementsPromptAnswers parameter) Passing prompt answers for an unanswered. Case. Click Advanced. This article details Attribute Filter creation:MicroStrategy - Attribute Qualification Filters - Online Training Video by MicroRooster. 4. Filter interactions is disabled if the Disable Interaction in Library setting was enabled for a filter. Or embed self-service capabilities for users to visualize key drivers or what-if scenarios. From the Answer prompt drop-down, select how your selected prompt is answered. By changing the final entry from - to + the setting for removed related report filter elements is changed to include all filters. In MicroStrategy 9. Security filters in MicroStrategy restrict a user's ability to access or view certain objects within a given MicroStrategy project. Community & Support Search Discussions Open A Case View My CasesThese changes may impact upgrade from existing MicroStrategy 10. DssXmlNodeConstant. the attribute present in the report template). This prompt is used in a filter. x, prompted text cannot be displayed in a Report Services document unless the prompt is in the dataset of the document. 2. But today I am going to show you how to pass a selector value from one dossier to another without using the prompt option and also without any custom SDK. If the Grid/Graph is a shortcut, you cannot create a view filter because the Grid/Graph is. Right-click the attribute and select Add to Filter. MicroStrategy is an enterprise-level tool with multiple usages in the software world or other words; it is an enterprise business intelligence application and data warehousing reporting tool. Solution To fix the data issue, upgrade to MicroStrategy 2021 Update 6 and set the Data Engine Version to be 2021. If it is cleared, filter attributes that are not on the report or in the level. Quick filters are added to a view by right-clicking on a field and selecting “Show Quick Filter”. It is a different way to achieve the same results as a metric qualification. 3 Select. Please check attached image for reference. There are no restrictions on the names for the columns used in the expressions of a given attribute form. Filters ensure that the report results contain only the data that answers the specific business query the report was designed to answer. In SQL View look at where the cross join appears, and between which tables the cross join appears. OR, to convert an existing filter into a security filter, click Import. Create a blank dossier or open an existing one. If the selector slices rather than filters the data, by default the first item in the target is selected in the selector, and its target displays data for that item (for. The filter on option adds a view filter to the report but since only data for 2008 has returned, that is the only attribute element in filter on. Create a cascading prompt to use values from one prompt to filter values in another prompt. For example, the attribute Customer has the forms ID, First Name, Last Name, Address, and Birth Date. There are built-in filters such as ‘lowercase’, ‘uppercase’, which can retrieve the lowercase and uppercase. MicroStrategy Report Services Dynamic Dashboards Training;. Workstation Filter Editor Improved Data Label, Format,. This is a guest blog post co-written by Amit Nayak at Microstrategy. The most common use for a choice filter is to construct what is known in XLSForm jargon as a cascading select, where a selection in a list (for example countries), controls the. less ,pg and more commands are used for dividing a long file into readable bits. The attributes and metrics appear as filters. One of the advantages of view filters is that it retrieves information quickly. A Filter in AngularJS helps to format the value of an expression to display to the user without changing the original format. It can connect to data warehouses, relational systems, flat files, web. Create a blank dossier or open an existing one. x, prompted text cannot be displayed in a Report Services document unless the prompt is in the dataset of the document. This calculation is used to build the framework of the cascading menu. Different scenarios will be explored throughout this article to. GGraph and formatting nodes. This not only allows for dossiers to have personalized information, but also improves performance by processing only the necessary data. For more information on all types. Element Caches: For those who have not yet registered, the elements are the objects represented by the red cube. This new view can provide a new business perspective for analysis, without having to re-execute the report's SQL against the data warehouse. First, you open a blank document and select a report to use as the document's dataset. Select the appropriate options to define each qualification to add to the view filter, as described in the introduction. Procedure. Report filters are a standard MicroStrategy reporting feature that enable you to filter the data retrieved from the data source. Get inspiration at the MicroStrategy data visualization gallery. In its most basic form it consists of two parts:. A filter screens data in your data source to determine whether the data should be included in or excluded from the calculations of the report results. A project is where you build and store all schema objects and information you need to create application objects such as reports in the MicroStrategy environment, which together provide a flexible reporting environment. Select Filter definition prompt -> Choose from an attribute element list as shown below. Case. Even though a metric qualification depends on the result of an aggregation, it still must apply before template metrics, or metrics used in compound metrics. The main difference between report filters and view filters is how they are evaluated by the system. For example, you have a report with Region, Category, and Profit displayed, as shown in. Command Manager is a MicroStrategy tool designed. Select Enable document caching. Choice filters let you leverage user-entered values in your form to dynamically control which elements of a list are shown or hidden. A filter can also be a metric qualifier created using custom expressions employing functions. Level dimensionality in a metric interacts differently with different features such as view filters, report filters, other metrics and certain VLDB properties. 2) What does Model-View-Controller represent in an MVC application? In an MVC model, Model – It represents the application data domain. Go to the Tools menu and select My Preferences as shown below: In the My Preferences window, select the Editors tab and click on the Filter Options. g. less ,pg and more commands are used for dividing a long file into readable bits. For more information on all types of advanced filters, refer to the Advanced Filters chapter of the Advanced Reporting Guide. Click on DATA tab on the ribbon. here I have 5 hierarchy filters. Attribute Qualifications can have many forms, we discuss all of them in this short video. Once a security filter is created for users or groups. They may. Save the filter as "Region Filter". When you analyze a report, it is important to understand the filter conditions that are being applied to the report. create (props); This method creates an iFrame on the web page (in the location specified by the placeholder property) and inserts a link to the URL (specified by the url property) where the dossier to be embedded is located. However, in MicroStrategy, filters can also be created as part of a given report, at the same time the report itself is being created. As you type, matching objects are displayed in. Creating a stand-alone filter. Click User Manager . Cascading analog Op-Amp filters is far more complex than you are making out in this post, especially if you add gain: You make no mention of Miller-Effect, capacitive inter-stage coupling. Choose Add Data > Existing Dataset to add data. The multi-select means an end user can choose items in different groupings of the date; for example multiple sub. The Filter Editor enables you to create and modify filters for use on reports. Customers that order Music and Movies will have both grids populated. Select a metric or metrics to combine with filters to create conditional metrics. You can also create:Step 1 – To create the new report right-click on the report and add the new item and rename it as ‘CascadeParameter’ as shown in below the screenshot. EnumDSSXMLNodeType. A Relationship filter allows certain attributes to be filtered by their relationship to other attributes. The following code sample modifies a view filter based on attribute form qualifications:Users notice that when switching elements on cascading or nested Attribute selectors, the lower level selectors turn blank and the grid shows ‘No data returned for this view’ in several versions of MicroStrategy Web 9. Narrowing the focus of a report to the data that is of interest of you enables another level of report analysis that can highlight business trends and figures. Filters created this way will be local to the report and cannot be reused. Each MicroStrategy Web page uses several cascading style sheet (CSS) files. In the right side of the Security. It has simple filters, which get the data based on the values selected by the user. Advanced Filters. For example, you include high-level. With the Allow Smart Metric setting not enabled for Profit Margin. MicroStrategy Creating Filters - Filtering data is a very important part of data analysis and visualization. (2) However, there is another strategy called "direct synthesis". GGraph and formatting nodes. ACTION: To take advantage of this new feature upgrade to MicroStrategy 10. Using view filters based on metrics, you can view a subset of report data that focuses on the data values and ranges you are interested in. The security filter applies to all reports and documents, and all attribute element requests, submitted by a user. General Preferences. Create a document and add above 2 reports as dataset. In the Filter Panel, users can set Dynamic Date filters. A filter is used to select the data for. Save and close the filter. For example, if you want your string in either lowercase or uppercase, you can do it using filters. This function is similar to database views and row level security. This is a known behavior before MicroStrategy 2020. x Flash M… Number of Views 1. This shortcut applies to all filters and limits in reports. You can import filter elements into the Filter Editor from sources other than MicroStrategy. Select the Security Filters tab. MicroStrategy Desktop provides a variety of options to filter data in a report. But in reality, many of these dimensional relationships change over time. To build a context filter follow the given steps below; Select Add to Context option from the Context menu of an existing categorical filter. The selections are used to determine which slices. The following steps demonstrate how to reproduce the issue in tutorial project: M1=Count<Distinct=True ,. The graph legend or axes can be formatted as well. Usually assigned by administrators, security filters control what warehouse data users can see within MicroStrategy. Select text filters. A project is the highest-level of intersection of a. Select the Security Filters tab. MicroStrategy Reference number for this technical note is DE218479, DE224798 and KB485575. This setting is placed in the metric editor, condition section, advanced button. The slicer feature is available in Microstrategy Dossier. For descriptions of the different types. The type of prompt and the display style determine the style properties that are displayed; not all the properties in the following procedure will apply in every case. Absolute filtering changes the filter on descendents of the target. This calculation can be aggregated from the Employee level to the Region level. Filters are helpful in clarifying large quantities of data and only displaying subsets of that data, so reports show users what they really need to see. Cascading filters in Tableau refer to the concept of creating a hierarchical relationship between multiple filters, where the selection in one filter affects the available options in subsequent filters. Granting the same permissions to a MicroStrategy user directly through the User Editor interface allows for the Security Filter Manager option to show up. In contrast, the view filter is applied to the report dataset without altering. Apply the security filter to a test power user account that was applied the security filter 3. Cascading Style Sheets and Layouts. On the Security Filter tab, select a project under which you want to assign a security filter to the user or group. Step 2 – Now, Empty report will be created next part we will be using embedded data source or shared data source. 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. I have been using the FilterMathCalculations. This is a filter which contains a prompt on an attribute element list. MicroStrategy Advanced Reporting Guide provides comprehensive information on advanced topics for using the MicroStrategy query and reporting products. Typically, dimensional hierarchies are presented as independent of time, e. Click + Panel to add new. The default values that MicroStrategy supplies for the DBMS objects are optimized for the database type and version and they have been thoroughly tested. Double-click the Northeast Electronics Revenue -- cleared metric. Prompt 1 : Region Prompt 2 : Companies Based on the selection of the first prompt the second prompt should get populated with the companies in that region. , the New York store is part of the Northeast Region. MicroStrategy Web generates HTML pages which use several cascading style sheet (CSS) files. Limiting your data – Filters. In MicroStrategy Developer, open a hierarchy using either the Hierarchy Editor or Architect, as described below: Locate a hierarchy in the Folder List, right-click the hierarchy, and select Edit. Using this approach you can transfer a passive RLC reference ladder network of any order into an active circuit (active L-simulation, FDNR-technique). Create the new dataset DS1:Hi, I am looking for a quick clarification on how to calculate the frequency response of a given crossover filter. To create a filter with a condition on metric qualification. Select the Logical View Tab of both tables to see all the logical objects mapped to the table. Navigate to a prompted report and click Insert. Analytics work in the back office typically is where predictive modeling gets performed -- using SAS, R, SPSS, Microstrategy, Teradata, etc. Enable users to interact with personalized chat for further product discovery. Till now I have seen the developers were using prompt to pass the value from one dossier to another. It also has features to create complex features, which will filter out. The type of prompt and the display style determine the style properties that are displayed; not all the properties in the following procedure will apply in every case. In MicroStrategy 10. Select the formats to cache. 0. Then modify each selector’s targets, one by one, in hierarchical order. ). Log into a project in MicroStrategy Web. From the Tools menu, make sure that View Filter section is enabled. When a User Group is configured with a System Prompt Security Filter including 'User Login' the MicroStrategy environment will generate and access caches on a User basis even if the User Login does not have an effect on the final result set. NOTE: Data is correct when download the Data Engine version to 10. In MicroStrategy Developer 9. To create, modify, or delete a view filter. ‘sort’ command sorts out the content of a file alphabetically. Plus, it connects business apps while integrating data. Best Institute for Cognos Training in Chennai offers Job Oriented Hands-on Cognos Training, Datawarehouse Training, Business Intelligence Training with Placement by well experienced IBM Cognos professionals having 12 years of Datawarehouse experience. The Document Properties dialog box opens. These objects are reusable for all products. There's a reason we're at the top of the list. Matching is successful if the value and parameter have the same type. MicroStrategy 2020 Update 2 delivers more than 180 capabilities for business users, analysts, and architects with a new MicroStrategy desktop application, enhancements to Dossier and HyperIntelligence, Expert. There are several different ways to create and apply filters or selectors to visualizations:Filters: A filter sifts the data in your data source to bring back the information that answers exactly what you require. Spotfire Filter applies to all visualizations of a dataset. Open MicroStrategy Desktop 9. In the above example, though the two sub-filter to choose “Month Of Year” in list 1,2,3 are the same, the temporary results for both of them need to be generated. Select one: To create a new security filter, click New. Click Prompt. Since the level of the filter (i. In this example, the query filters on years 2005 and 2006, and then aggregates (sums) the unit sales over Category. 3. Tile grid map is an abstraction of the map data to solve the issue of difference in sizes causing issues with shading and making it difficult to compare geographic information. Click on DATA tab on the ribbon. This function evaluates multiple expressions until a condition is determined to be true, then returns a corresponding value. Choose a project to contain your filter and click Select. Then create a new metric that has a case statement that chooses alternative metrics based on the value of the new attribute in the filter. " Click "prompt on attribute element list" and click "Next" through the rest of the screens to accept the default. Cause This is a known issue with MicroStrategy Data Engine 12 and 13. A word of warning, be careful if you assign a security filter to an attribute and then you show data for a parent attribute, in that case the SQL engine will not apply the filter. In the Intelligence Server Configuration, the administrator must select the History List database instance in the "Content Server Location" field. Introduction to Filters. In the View filter, click Add Condition. Expand the art of the possible with new dossier design options such as enhanced vertical scrolling options and the ability to lock filter. Absolute filtering - changes the filter on descendents of the target. As a suite of applications, it offers Data Discovery, Advanced Analytics, Data Visualizations, Embedded BI, and Banded Reports and Statements. Cascading filters can also be thought of as giving priority to one filter and then using other filters on a data source that has already been filtered. This article describes how to use relationship filters to control filter and subquery logic in MicroStrategy. Filters . Ranked #1 for Enterprise Analytics in 2022 Gartner Critical Capabilities Report. The Profit metric is a simple sum of the Profit fact. x. If a user needs to display data for a period of time based on the current date, then the user can make use of a rolling time filter. In the Properties pane, double-click the Cascade source property. In the MicroStrategy Tutorial project, for instance, if a report includes only the Category attribute, report level metrics could use the YR_CATEGORY_SLS table. Selectors allow a MicroStrategy Web user to flip through the panels in a panel stack or display different elements or. This article notes an interaction between derived metrics and view filters. Selectors allow a MicroStrategy Web user to flip through the panels in a panel stack. 134. From the Tools menu, select View Filter. Cascading filters are filters that let you drill into a specific selection to decide what to include or exclude. Select the object you want to base your filter on: To base your filter on an object that is part of the report's definition, use the Report Objects pane on the left and. x, users will notice that this is not possible due to the mouse pointer changing into a "not allowed" symbol. The attributes and metrics appear as filters. If you like the video, please subscribe to my channel. The intuitive approach is to separate each criterion with commas ',' but this will create a string that qualifies on all characters at the same time. Click OK to return to the Metric Editor. Through the use of the ApplyComparison function, create a custom expression filter to select the desired rows from the desired table. It is important to design the correct filter to retrieve the desired data. Filter down data across the dossier page by selecting specific elements of a visualization. MicroStrategy interfaces include desktop (for developers), web, Microsoft Office integration as well as Mobile Applications. The DBMS level is set whenever a new project is created. In addition to creating, editing, and consuming content, users can also share personalized content via email, folders, or. The grep command can be used to find strings and values in a text document. 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. From the Filter On drop-down list, select the object (attribute or metric) on which you want to base your filter. This leads to the next best practice recommendation. A filter specifies the conditions that the data must meet to be included in the report results. MicroStrategy project. Cascading filter. We provide Cognos 10 Training, Cognos TM1 training,. For example, if you want your string in either lowercase or uppercase, you can do it using filters. 9. for instance, if the selector's source is Region). OR, to convert an existing filter into a security filter, click Import. Attribute qualification filter These types of qualifications restrict data related to attributes on the. Answer is, yes with an workaround on the MicroStrategy Dossier. A stand-alone filter is a filter created as an independent MicroStrategy object. Create the report with 3 attributes and 1 metric. Previously, panel stacks could not target elements outside of the stack. Filter push down is not applied; Changes in data; Changes in the Cube Setting Instruction (CSI) Steps to reproduce The following example uses MicroStrategy Tutorial attributes and metrics: Open MicroStrategy Web. 1 and it can determine how a given change in a project environment, such as regular maintenance changes to metadata objects or hardware or software upgrades, affects the. In datasets, you can create the following types of filters: Text filters. 4, if "Auto-apply changes" is disabled, when clicking on the "Clear" button on the Filter Panel, the. Click Filter in the toolbar. Create a report based of the cube and no data is returned. Creating a stand-alone filter. Click on Sort & Filter drop down list as shown in the image below. Dimensional Modeling (DM) is a data structure technique optimized for data storage in a Data warehouse. The example formula with the change is below. Filters specify the conditions that the data must meet to be included in the report results. x and open the project where a security filter should be created. In order to get closer and closer to the ideal shape, we just cascade multiple filters together and get a tighter curve. Examples of qualifications are "Region = Northeast" and "Revenue > $1 million". Users notice that when switching elements on cascading or nested Attribute selectors, the lower level selectors turn blank and the grid shows ‘No data returned for this view’ in several versions of MicroStrategy Web 9. A filter sifts the data in your data source to bring back the information that answers exactly what you require. The selections are used to filter the underlying. Apply selections as a filter is unavailable, the selector is either: metric condition selector, which filters metric values and ranks. However, the report limit and the view filter are not interchangeable. com Filter types include the following: You can also create advanced qualifications such as attribute-to-attribute qualifications and prompted filters. An attribute form qualification might filter on the form Last Name, the operator Begins With, and the letter H. Report filters are a standard MicroStrategy reporting feature that enable you to filter the data retrieved from the data source. To have all the same filters apply to visualization B, users will need to specify the filters again. Action Type: Defines the type of selector. These options are described below. Region, state, city, category, Sub-category. MicroStrategy OLAP Services lets MicroStrategy Developer, Web, and Office users slice and dice data in reports without having to re-execute SQL against the data source. Users may want to know what the difference is between 'Contains' and 'Like' qualification operators when defining filters in MicroStrategy Developer. The MicroStrategy Intelligence Server provides an attribute level setting to allow or disallow element browse requests and the element cache to ignore the security filter in the cache. User filterApply the security filter to a user or group. I want to add the date attribute to filter. This method returns a promise, which is resolved when the dossier instance is created. MicroStrategy Web relies heavily on this rule, enforced by the browser, for making sure that the proper style rules are applied for every page in the MicroStrategy Web application. Qualifications are the actual conditions that must be met for the data to be included on a report. These changes are reflected in the form of SQL, CSI (Cube Subsetting Instruction), and Data changes. For example, the attribute Customer has the forms ID, First Name, Last Name, Address, and Birth Date. Step 4: Create a Placeholder Level 1 and 2 Calculation. ApplySimple: ApplySimple is a function that allows users to send direct input to the warehouse without any assumption or special handling of what is inside the custom SQL by MicroStrategy. The Prompt Generation Wizard opens. Follow the steps below to create a prompt-in-prompt. Ca se functions Microstrategy Case functions return specified data in a SQL query based on the evaluation of user-defined conditions. An important step in designing a report is ensuring that the correct data is returned from your data sources to be displayed on the report. Object Layer. It is important that the OLAP Cube data for the ID form match the warehouse IDs precisely. A Filter in AngularJS helps to format the value of an expression to display to the user without changing the original format. In MicroStrategy Developer, open the document in Design View. You can add visual representations of the data (that is, called visualizations) to the dossier to make your data easier to interpret, perform manipulations on the data to customize which information to display, and organize. You should be aware of this rule so that you can import your own custom CSS files effectively, knowing when and where the definitions specified should override more. The operator must be In list or Not in list. P rompts allow report designers to create reports that let users change the report content at run time. The metric has been set to ignore the filtering criteria that have been specified. In this example, the Year attribute is used. Creating hard coded and parameterised filters. You'll find everything from waterfall charts to word clouds in our community. Filters are most commonly used on reports, to filter all the data the report would otherwise retrieve from the data source and display. The panel stack is the target of the selector. A Relationship filter allows certain attributes to be filtered by their relationship to other attributes. x can either filter or slice the selector`s target: Slicing. Browse to the filter you want to convert and click Open. The three dialog boxes are New Attribute, Create New Attribute Form, and Create New Attribute Form Expression. OR, to convert an existing filter into a security filter, click Import. This technical note describes how to successfully implement this functionality. In MicroStrategy 10. To Add a Stand-Alone Filter to a Report. Run the document -The document should display as expected. The. If the Report Filter panel is not displayed above the report, display it by clicking the Filter icon on the toolbar. Data displayed in MicroStrategy Viewers can be filtered by different criteria. The Level (Dimensionality) definition pane displays below the Metric component area. From the Filter On drop-down list, select the object (attribute or metric) on which you want to base your filter. Flip. Filters data related to a business attribute’s form (s), such as ID or description. Check available Attributes OR; Use View Filter grid > [+Add Condition] to open a list of. Working to report specifications. In MicroStrategy Developer 9. The child components declare cascading parameters with different names, but they are share the same type - string. Select Caching. The types are described below: Select Attribute Element: When the document is displayed, the selector displays a list of the elements from the attribute, custom. When a report contains a filter and a conditional metric, the report filter and the filter contained in the metric (the metric filter or metric condition) interact to produce the data for the conditional metric. Selectors provide dashboards with interactivity, allowing each user to change how he sees the data. If DHTML is disabled, from the View menu, select View Filter and click the Go icon . . The Security Filter Editor opens. (MicroStrategy AE) spends more time searching and fetching the report definition and then applies that definition to the intelligent cube. 1. Tableau Version in Video: 2020. MicroStrategy Web relies heavily on this rule, enforced by the browser, for making sure that the proper style rules are applied for every page in the MicroStrategy. Import table into MicroStrategy using data import in web > save as an In-Memory. A user with a security filter on Call Center. Case functions Microstrategy. The Document Properties dialog box opens.