Although transformations can be applied to any attribute hierarchy, the Time hierarchy is used most often. If you creating a prompt for a filter, click OK to save the prompt in the filter. This technical note describes how to successfully implement this functionality. We are fixing the user and user security filter but how we can prevent this in future. x, users will notice that this is not possible due to the mouse pointer changing into a "not allowed" symbol. Database Does the Scoring: The database scores records in response to queries. Filters data related to a business attribute’s form (s), such as ID or description. The report displays derived elements defined using. In datasets, you can create the following types of filters: Text filters. The metric calculates only for the elements found in the filter definition. To determine how the selector is used to filter data, click the arrow icon at the top right of the title bar to display a list of options, then select one of the following: Prompt-in-prompt is a feature in which the answer to one prompt is used to define another prompt. First, you open a blank document and select a report to use as the document's dataset. Import table into MicroStrategy using data import in web > save as an In-Memory. Grouping. x, if a security filter is present on an attribute then any level metrics defined on related attributes with filtering set to ignore will behave as though the filtering was set to standard. The following requirements must be met: The filter is an attribute qualification. To apply a filter to an attribute in a hierarchy. In the context of an Enterprise application, Cascading Pattern would tend to fit in the diagram shown below. For an introduction to filters, see the Basic Reporting Help. Types of qualifications. 5. Create your selections (WTD, MTD etc) on a spreadsheet and import that into the dossier as a new data set. MicroStrategyA view filter is a qualification that is applied to the report data set in the memory of the Intelligence server, and therefore does not have to be re-executed against the data warehouse. Dimensional Modeling (DM) is a data structure technique optimized for data storage in a Data warehouse. Select text filters. A view filter restricts the amount of data displayed on the report, providing you with a different view of the data. For more information on all types. 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. The default mechanism for matching cascading values to parameters is based on type. 0. Filters specify the conditions that the data must meet to be included in the report results. You can connect MicroStrategy reporting tool with any data, including big data, flat files, social media data, and. Clear the Filter setting: uncheck to exclude attributes absent in report or level (dimensionality) check box. Cognos Training In Chennai. In the right side of the Security. NOTE: Data is correct when download the Data Engine version to 10. A Document Autostyle is a collection of formatting properties saved in a document for various control types (sections, text fields, lines, etc. 4. Drag attributes or metrics from the Datasets panel to the Filter panel. Select Add aShortcut to a Filter and click OK. Action This issue has been fixed in MicroStrategy 2021 Update 6. The view filter above is based on an attribute form qualification defined as Year ID equals 2011. OR, to convert an existing filter into a security filter, click Import. Apply selections as a filter is unavailable, the selector is either: metric condition selector, which filters metric values and ranks. From the Home menu, select Design mode. In contrast, the view filter is applied to the report dataset without altering. Example: It should be like 2nd dossier should be selected as Year=2017 and Month=Feb (as. If two users with different security filters run the same report, they may get different results. The first thing to know about this Microstrategy version 10 is that it contains an essential piece called Desktop. Community & Support Search Discussions Open A Case View My CasesCascading filter. Open up those tables in the Table Editor by navigating to the Schema Objects\Tables folder, and double-clicking the tables. Answer: When attempting to add a prompt directly to an Intelligent Cube in MicroStrategy Developer 9. A dossier is an interactive display that you can create to showcase and explore business data. Typically, dimensional hierarchies are presented as independent of time, e. It all starts with the Enterprise Semantic Graph – the building blocks of your business that can be quickly created, and easily re-used, accelerating collaboration and development of your suite of BI applications. Select the heat map visualization. Select the name and scores columns as shown below. By designing dossiers with prompted datasets, end users will now be able to proactively limit the data load prior to running a dossier. like 'Book' 'Contains'. 3K KB33862: How to create nested or cascading selectors and avoid getting blank selections in MicroStrategy Web 9. The Attribute Editor opens three dialog boxes, if the cascading dialog box option is enabled in the Developer Preference (as it is by default). A filter must contain at least one qualification, which is the actual condition that must be met. If you like the video, please subscribe to my channel. This allows users to progressively refine their data analysis by selecting values in a series of connected filters. Open the document in Design or Editable Mode. Press and hold the Ctrl key to select multiple attributes or metrics. These conditions can be set to include or exclude the data that satisfies the filter conditions. HistogramMedian(Revenue, 5) {~+} <[Select a Month]; @2; +> Make sure that all desired conditional metrics have this changed if regular filter panel filters should always. An empty selector appears in the dossier. 0. The purpose of dimensional modeling is to optimize the database for faster retrieval of data. ‘sort’ command sorts out the content of a file alphabetically. Creating a stand-alone filter. From the Schema menu, select Architect. The settings are copied from the database. 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. This stores the values of the lookup tables of the attributes, and allows to optimise the navigation, mainly when we want to select the values for some. 33 (or 33%). When expaning the filters, the attribute elements may overlap the area of the filter below: STEPS TO REPRODUCE: create a Dossier with Brand, Catalog and Supplier as dataset; drag all the attributes to the filter pane and make them display as check boxI have a sample data showing Region wise profit and sales . Use that column to create a filter that targets the visualization you want to filter. Cascading Style Sheet (CSS) Files. MicroStrategy Web designed with a new CSS infrastructure to conform to the latest cascading style sheets standards, as well as to improve performance by reducing the amount of HTML necessary to download to the client. Aboutthisbook. Heterogeneous mapping allows the engine to perform joins on unlike column names. Plus, it connects business apps while integrating data. In addition to creating, editing, and consuming content, users can also share personalized content via email, folders, or. In the Data Source dialog, select Reports. NOTE: Data is correct when download the Data Engine version to 10. Select the heat map visualization. The Security Filter Sequence represents order the security filter was applied, when multiple security filters are applied during an execution. the dimensionality of the filter or attribute on which the filter is based) is not related to the fact of the SQL pass, the level of the filter must be raised to the level of the output (i. 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. However, this filter will apply to the entire. 3. here I have 5 hierarchy filters. In this video, I show 7 easy ways to filter data in MicroStrategy, from chapter filters to the newly released visualization filters. The following is a quick reference table for this MicroStrategy Object: There are different types of Filters depending on what are they made of and where they can be used. There are no restrictions on the names for the columns used in the expressions of a given attribute. The Project-Level Very Large Database (VLDB) Property setting, found in Joins > Preserve All Lookup Table Elements, 'Preserve lookup table elements joined to final pass result table based on template attributes with filter' is not turned on, which results in. In the View filter, click Add Condition. 3. 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. It visualises interactive dashboards, charts and graphs and improves analytics and predictive modelling capabilities. This article details Attribute Filter creation:MicroStrategy - Attribute Qualification Filters - Online Training Video by MicroRooster. You use the authorization token returned during login as the value for X-MSTR-AuthToken and provide the project ID, dossier ID, dossier instance ID, and filter definition. 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 optional element prompt. If a customer only ordered a Movie item only the second grid will be populated. The panel stack is the target of the selector. Because the logic used to generate the final report is clearer, MicroStrategy recommends using it rather than the metric qualification. Metric with an IF Function. MicroStrategy Reference number for this technical note is DE218479, DE224798 and KB485575. For Compound Profit to be dynamically aggregated correctly, you change the dynamic aggregation function to Sum. Enter “ja” and click on “OK” button. The following procedure describes how to achieve this: Create the highest level filter. This is a source column for the Parent Action attribute. 4. Create a blank dossier or open an existing one. Enable document caching. A stand-alone filter is a filter created as an independent MicroStrategy object. Add the filters to the view. Select Any other prompts to configure a default "Answer prompt" option for any additional prompts added to the target dossier in the future. For example, this is helpful if the end user is looking at specific data within a region. These metrics can be created in MicroStrategy Agent as follows: Consider the following example values for Sales and Cost. From the Data menu of the Document Editor, select Edit View Filter. A Filter in AngularJS helps to format the value of an expression to display to the user without changing the original format. Click Save and Close to save the metric and close. This function is similar to database views and row level security. Note that the field doesn’t have to be in use in the view at the time. For detailed information on report filters, see the Advanced Reporting Guide. There's a reason we're at the top of the list. This article notes an interaction between derived metrics and view filters. This technical note describes how to successfully implement this functionality. In order to get closer and closer to the ideal shape, we just cascade multiple filters together and get a tighter curve. These reports, too, use filters with custom expressions, but instead of using built-in MicroStrategy functions, these filters use the functionality of your particular Relational Database Management System (RDBMS). Filtering data is a very important part of data analysis and visualization. Because element prompt answers are matched with prompts using the AttributeID, the order of the prompt answers does not determine the order in which prompts are answered. The ApplyComparison function allows users to bypass the MicroStrategy SQL parser and create an expression where comparison operators (e. Create Filters Open the Workstation window. This can be seen in the screenshot below. . MicroStrategy provides ETL, data warehousing and data mining for data analysis. 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. Or embed self-service capabilities for users to visualize key drivers or what-if scenarios. From the Format menu, select Document Properties. The user double-clicks an object to add it to the Selected list. Prerequisite. A description of the options available to create and edit a metric. The General preferences page lets you personalize your MicroStrategy Web settings, including the language in which reports are displayed and whether to display Save options that let you save a report as static or prompted. Freeform SQL reports can be used to filter other standard reports in MicroStrategy. Filters created this way will be local to the report and cannot be reused. This article notes an interaction between derived metrics and view filters. Creating drill-through reports and using cascading prompts. In this quick tip, I show you how to filter MicroStrategy reports using a custom SQL query using ApplyComparision and ApplySimple. Select the Security Filters tab. The MicroStrategy 9. x. Cascading filters in Tableau allow for the selections in the first filter to change the options in the second filter. It raises it to the level of the target, if possible. 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. Click on the Name Filter. The filter criteria for the report is found in the WHERE clause of the SQL statement which calculates the metric in question. Help your customers get more out of the app experience with an engaging AI assistant that provides automatic answers or outputs in real time. MicroStrategy. The Metric Function Editor allows you to quickly and easily create and edit a metric, which is a calculation performed against the data in the data warehouse. There are no restrictions on the names for the columns used in the expressions of a given attribute form. "Cascading" in this context means that because more than one stylesheet declaration could apply to a particular piece of HTML, there has to be a known way of determining which specific stylesheet rule applies to which piece of HTML. 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. 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. This custom SQL can be used in the fact, attribute form expression, filter and metric editors. The MicroStrategy SQL Generation Engine uses correlated subqueries found in the WHERE clause of a SQL statement when the relationship between one or more filtering attributes in the template attributes is more complex than. The common approaches for incorporating data mining within MicroStrategy are described below: Scoring the Database: Records are scored in batches and saved as tables or columns. A Relationship filter allows certain attributes to be filtered by their relationship to other attributes. GGraph and formatting nodes. Apply the security filter to a test power user account that was applied the security filter 3. 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. Select the filter or prompt to apply to the metric using one of the following methods: To type the filter or prompt directly, begin typing the name of the filter or prompt in the field in the Condition area. In the Actions column, select the Edit icon for the user to modify. Choose options of. 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. 320 views | June 08, 2022. A selector can change panels, another selector, the focus of a Grid/Graph, or dynamic text fields (a text field that is a reference to an object on a report) in a panel stack, as described below. You can import filter elements into the Filter Editor from sources other than MicroStrategy. Click the name of a report to execute it. a) Attribute form qualification. Seamlessly Switch Between App Workspaces in Library Web. 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. This not only allows for dossiers to have personalized information, but also improves performance by processing only the necessary data. 4. Security filters in MicroStrategy restrict a user's ability to access or view certain objects within a given MicroStrategy project. There's a reason we're at the top of the list. Click on DATA tab on the ribbon. For background information on search objects and steps to create them, see the MicroStrategy Developer help. From the Answer prompt drop-down, select how your selected prompt is answered. Select the filter or prompt to apply to the metric using one of the following methods: To type the filter or prompt directly, begin typing the name of the filter or prompt in the field in the Condition area. Choose a prompt. The DBMS level is set whenever a new project is created. the attribute present in the report template). i have a Cascaded prompts where i have to display companies based on regions. BasicReportingGuide vii ©2017,MicroStrategyInc. 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. Selectors allow a MicroStrategy Web user to flip through the panels in a panel stack. Cascading filters in Tableau allow for the selections in the first filter to change the options in the second filter. A project is the highest-level of intersection of a. The panel stack is the target of the selector. A report is a MicroStrategy object that represents a request for a specific set of formatted data from your data source. In MicroStrategy Developer 9. You can use the URL API to pass certain types of prompt answers to the page being executed. In the intelligent cube report, the prompt is treated as a view filter and the data for all of the years are returned in the SQL. Create two datasets. The main difference between report filters and view filters is how they are evaluated by the system. In addition to creating, editing, and consuming content, users can also share personalized content via email, folders, or. I want to add the date attribute to filter. x and open the project where a security filter should be created. Filter interactions is disabled if the Disable Interaction in Library setting was enabled for a filter. How to Create Context Filters in Tableau. In MicroStrategy Developer, open the document in Design View. This is a known behavior before MicroStrategy 2020. . It is a. 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. MicroStrategy - Creating Filters. The MicroStrategy architecture is a meta-driven type where metadata is the central repository of all the objects and can be used by all of the MicroStrategy products. Filters . Cascading filters are. 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. For information on how to. 37 4. •. A filter screens data in your data source to determine whether the data should be included in or excluded from the calculations of the. x, prompted text cannot be displayed in a Report Services document unless the prompt is in the dataset of the document. Choose Add Data > Existing Dataset to add data. Filter down data across the dossier page by selecting specific elements of a visualization. Hover over the Properties column and click Open Intelligence Server Administration Portal . Save and close the filter. In the pane on the left, navigate to the attribute with the date data type on which you want to qualify. It is important to design the correct filter to retrieve the desired data. Case functions Microstrategy. This section builds on information in the Basic Reporting Help by describing how filters are handled along with other report features during report execution, to impact the resulting report display. Embedded Filters; This section does not include information about security filters, which are discussed in the System Administration Guide, or creating multiple filters at the same time by using a Command Manager script. Pipe is a command in Linux that lets use two or more commands such that output of one command serves as input to. Run the report in Grid View. Filters and Order of Calculation on Reports About Filters. In the left side of the Security Filter Manager, in the Security Filters tab, browse to the security filter that you want to apply, and select that security filter. There's a reason we're at the top of the list. Consider “India” and the “Country”; so, Filter2 should display only the states of India. Navigate to a prompted report and click Insert. Specify a name and location for the new security filter and click Save. From the Tools menu, select View Filter. Community & Support Search Discussions Open A Case View My CasesThese changes may impact upgrade from existing MicroStrategy 10. 1. And when we cascading 3-4 filters in lab, we got a better cumulative filter than just a standalone filter. Creating hard coded and parameterised filters. Then modify each selector’s targets, one by one, in hierarchical order. The selections are used to filter the underlying. These options are described below. Open a new or existing dossier. 1. 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. MicroStrategy is a data analytics platform that delivers actionable intelligence to organizations of all sizes. The stand-alone filter can then be used on many different reports, as well as on metrics and other objects. When you analyze a report, it is important to understand the filter conditions that are being applied to the report. When you use the cube directly in the Dossier, the definition is applied to the cube directly and the MicroStrategy AE saves time since it doesn’t have to search and fetch an extra report definition. Intelligence Everywhere. Click "Prompt", choose "Use a filter to reduce the number of elements" option and select Country Filter created in last step, as shown below. MicroStrategy Version 10. For a table of where to use all prompts, see Adding a prompt to a report, metric, filter, or custom group. Enter “ja” and click on “OK” button. Selecting a metric allows you to create a metric-to-metric qualification, which are described in Filtering on metric-to-metric comparisons. x. The following steps will create a set of 3 nested selectors. Since report filters are evaluated by querying the data source, report filters can perform various types of advanced. microstrategy. The security filter applies to all reports and documents, and all attribute element requests, submitted by a user. Saylor, Sanju Bansal, and Thomas Spahr, the firm develops software to analyze internal and external data in order to make business decisions and to develop mobile apps. Alternately, Intelligence Server checks the Template ID, Template Version ID, Filter ID, and Filter Version ID in the requested report/document against the ones in the cache. In MicroStrategy Web, a user expands the levels to navigate to an object. Date filters. Return Value. In shiny, how to link the filter to part of the data to change some of the charts and not others? 0. If the user defines more than one expression for a given form, heterogeneous mapping will automatically take place when tables and column names require it. In the Filter Options pop up window, select the 'Show advanced qualification' option and click the OK. By changing the final entry from - to + the setting for removed related report filter elements is changed to include all filters. In this example the Month attribute will be used to create a rolling six month filter. In other words, an application’s business logic is contained. The attributes and metrics appear as filters. , the New York store is part of the Northeast Region. 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. As you type, matching objects are displayed in a drop-down. 4. As of MicroStrategy 2020, you can use dossier linking to navigate between different dossiers within the same project while preserving filtering criteria. By default, the style of the selector is a drop-down list. Discover MicroStrategy – the modern, open, enterprise platform that connects every user and every application to all your data. Create a simple warehouse table with 4 columns (3 attributes and a metric). Since report filters are evaluated by querying the data source, report filters can perform various types of advanced. MicroStrategy Integrity Manager is an automated report comparison tool designed to streamline the testing of MicroStrategy projects. In the right side of the Security. Types of filters in Microstrategy Below are the types of filters: 1. Add the filters to the view. Posted by previous_toolbox_user on Jun 28th, 2007 at 6:18 PM. To add a filter to the report's Filter pane, do one of the following: Drag and drop the filter on the Report Filter pane. Object layers contain and store the objects created in MicroStrategy. Insight into. This tool was introduced in MicroStrategy 8. Depending on the type of object you are filtering on, a different set of choices appears. 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. If the Auto-Apply Changes check box is cleared, click Apply to apply the view filter to the report. It also has features to create complex features, which willSuppose a user wants to create the filter 'Yesterday'. In the left side of the Security Filter Manager, in the Security Filters tab, browse to the security filter that you want to apply, and select that security filter. To build a context filter follow the given steps below; Select Add to Context option from the Context menu of an existing categorical filter. From the Filter On drop-down list, select the object (attribute or metric) on which you want to base your filter. x-10. A view filter is similar to a report limit in that it can also be applied at the report level. The advanced options for the conditional metric establish this interaction. The main difference between report filters and view filters is how they are evaluated by the system. It permits users to create a set of elements from an attribute based on their relationship to another attribute. 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. Report filters are a standard MicroStrategy reporting feature that enable you to filter the data retrieved from the data source. The filter definition prompt encompasses four different prompt types, all of which allow the user to define the filtering criteria: attributes in a hierarchy, attribute forms, attribute element lists, and metrics. 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. Create your selections (WTD, MTD etc) on a spreadsheet and import that into the dossier as a new data set. Users can select prompt answers from one or more attribute elements. Create a Lag of Sum of Revenue with these settings:. You can also access the Advanced Metric Assistant by first selecting metrics. Command Manager is a MicroStrategy tool designed. Click Advanced in the Definition window. A project also represents the intersection of a data source, metadata repository, and user community. An object prompt allows you to select which MicroStrategy objects to include in a report, such as attributes, metrics, custom groups. Prompts and security filters. I have been using the FilterMathCalculations. If the Report Filter panel is not displayed above the report, click the Filter icon . Select Level (Dimensionality) in the breakdown window (under the heading Metric is defined as). Prompted Filters: Asking for User Input for Filter Conditions; Shortcut vs. A prompt is a question the system presents to a user when a report is executed. To add a filter: Open the dossier with the heat map visualization you created in How to Create Your Heat Map Visualization. Select text filters. Follow the same steps you just did on the 2nd order filter with R 1 = R 2 = R 3 and C 1 = C 2 = C 3, and again with R 1 = 1KΩ, R 2 = 10KΩ, R 3 = 100KΩ and C 1. Attribute Qualification Prompt, which allows users to determine how the report's data is filtered, based on an attribute filter. Double-click the Northeast Electronics Revenue -- cleared metric. You can create a view filter by defining a condition that is based on any attribute or metric on your report. A Relationship filter allows certain attributes to be filtered by their relationship to other attributes. It permits users to create a set of elements from an attribute based on their. 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 Derived Elements Editor opens. Click Add Condition in the View Filter section to add your filter. The slicer feature is available in Microstrategy Dossier. ApplyLogic is a. Use that column to create a filter that targets the visualization you want to filter. a) Attribute form qualification. Trick here is that, if you use “TEXT” Box – the. OR, to convert an existing filter into a security filter, click Import. Overview and Introduction to MicroStrategy. Filter Editor contents. This is analogous to a MicroStrategy Tutorial report with Category and Unit Sales on the template, and a report filter defined as Year in (2005, 2006). MicroStrategy Tutorial. STEPS TO REPRODUCE: On visualization A, specify a set of 2 or more filters. By default, the style of the selector is a drop-down list. Create a filter on the attribute "Year. Open the report you want to create a filter for. To save the prompt. Examples of qualifications are "Region = Northeast" and "Revenue > $1 million". The item cache is a cache that is stored in the memory of the Intelligence server. Click on Sort & Filter drop down list as shown in the image below. In this video I demonstrate how to use Cascading Filters in Tableau. 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. 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. . Lists are no different. If DHTML is disabled, from the View menu, select View Filter and click the Go icon . Interacting with a Document: Selectors. For example, the attribute Customer has the forms ID, First Name, Last Name, Address, and Birth Date. By default To date must be current date. Then, select the following filter and choose only the relevant values to. This defect is under. To add a filter: Open the dossier with the heat map visualization you created in How to Create Your Heat Map Visualization. In the Properties pane, double-click the Cascade source property. A derived element is a grouping of attribute elements on a report. For more information on all types of advanced filters, refer to the Advanced Filters chapter of the Advanced Reporting Guide. If you created a new dossier, you must save the dossier before adding an existing dataset. Working to report specifications. Autostyles can be either saved based on an existing document or they can. Prompts. Log into a project in MicroStrategy Web. Object Layer. Click + Panel to add new. MicroStrategy project. Following is the architecture of MicroStrategy: 1. You must have added a panel stack to the document, to use as the target of the selector. You can also apply a set of color and shading schemes to all the objects on a graph report. So, right-click on the data source and add data source and configure. 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. 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. 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. MicroStrategy is a Business Intelligence software, which offers a wide range of data analytics capabilities. g. Users can use the Filter Panel in MicroStrategy Web, to take advantage of a few settings that affect the selectors inside of it, such as Expand all, Collapse all, Auto-apply changes, or Clear all Filters. This is useful where reports contain prompts on only some attributes that need security filters to be applied. Choose a prompt. This leads to the next best practice recommendation. Drag the attributes and metrics to use as selectors from the Datasets panel to the empty selector.