No SQL sources are optimized for large information storage and transactional queries. If all conditions are false, a default value is returned. When these reports are used in a Report Services document, the same 'Metrics' column is displayed, as shown below:To insert and define panels, follow the high-level steps below: Insert a panel stack (the holder for the panels). Click on 'Finish' and save the prompt. Is there any other way of calling the Stored Procedure where I can pass parameters to it - before the report SQL is executed. Use grids in reports that require numeric details. Create a panel stack. In the list of categories on the left, expand Grid, then select General. You can narrow the list of functions displayed in the pane by doing one of the following: To search for the function by name, type the. You can change the order that prompts are presented when the document is executed. Additonally, this procedure does not always work on dashboards that are based on multiple cubes. 9) Arrange the prompts on the grid as you see fit. Users can also choose to display each filter in a different style as shown below, Users can select how each filter selector can target other filter selectors in the filter panel using the following three modes. When using any of the Apply statements in conjunction with prompts used to select attribute element values, it is necessary that a value be returned as an argument into the function of the statement. x. Derived metrics in View Reports would be aggregated two times: once from Cube to View Report and then from View Report to document grid. It is used to insert any single-value, database-specific functions and simple operators directly into SQL. Data Exploration: With MicroStrategy, users can drill down into data, perform ad-hoc analysis, and interact with visualizations to discover hidden insights and trends within their data. The MicroStrategy analytics platform is a cloud-based and on-premise self-service business intelligence platform that supports both data mining and visualization. MyAttributeEqual2. A single panel is automatically added to the panel stack. Here we have compiled a set of MicroStrategy interview questions asked in top organizations around the world. "System Prompt" is a system object that was introduced back in version 8. Rank. A derived element allows us to group on the basis of: – List of elements. KB309808: How to create a new Enterprise Manager 10. The target visualizations only display data that also appears in the source. To add a prompt to the Template definition pane in the Report Editor Using the following prompt types, you can create a prompt for nearly every part of a report. When you use the cube directly in the Dossier. Modules are organized around the business intelligence concepts, tools, and applications, and the use of data warehouse for business reporting and online analytical processing, for creating visualizations and dashboards, and for business performance management and descriptive analytics. Create a filter on the date attribute. The prompt wizard will be launched. Case ( [Metric Selector]="Rebates", Discount, [Metric Selector]="Sales", Revenue, 0) Add the "Generic Metric" attribute in the filter panel. Do one of the following: To apply the selections as a filter, select the Apply selections as a filter for all new targets check box. Click Create on any page, point to New Prompt, and select Object. Remember that you are telling a story with your data. MicroStrategy is a Business Intelligence (BI) and On-line Analytical Processing (OLAP) software which allows reporting and analysis of data from a variety of sources, including data warehouses, Excel files, and Hadoop distributions. Filter definition prompt – Allow a user to decide how the attribute element filter filters the report’s data. This feature is only implemented for element list prompts. A document designer can create a Transaction Services-enabled document to allow analysts to approve requests, track business activity, and execute business decisions by editing their business data in the document and sending those interactions back to the data sources. consider using MicroStrategy for your analytics needs: Time to market – Developing analytics capabilities in-house can be a lengthy process, taking months or even years to complete. As described in the "filter another selector" example above, the same selector can target both a Grid/Graph report and another selector. Enter the basics: Select the measurement interval that applies to the level of aggregation that you want in your result set. These modifications are implemented by applying certain. A cloud-native, open architecture platform, it is built on a scalable, future-fit semantic layer designed to inject AI-powered Intelligence Everywhere™. Run report and. The condition can contain metrics, comparison and logical. The Menu icon appears as an "ellipses" icon or three dots within a square. "System Prompt" is a system object that was introduced back in version 8. Choose Add Data > Existing Dataset to add data. On the upper right of any page, click your user name, and then select Preferences from the drop. Right-click an object in the Grid/Graph and select Edit Links, as shown below: Click New to create a new link. Finally in version 9. KB31016: How to display object prompts on grid reports in MicroStrategy 9. While this code may apply to other releases directly, MicroStrategy Technical Support makes no guarantees that the code provided will apply to any future or previous builds. KB46894: How to directly email a link to a report and dashboard in MicroStrategy Analytics Enterprise 9. MicroStrategy ONE empowers companies worldwide to seamlessly. Clear the Use Default check box under Null Display settings. To determine whether personal answers can be saved for this prompt, select one of the following options from the Personal answers allowed drop-down list: None: No personal answers can be saved. Users can also choose to display each filter in a different style as shown below, Users can select how each filter selector can target other filter selectors in the filter panel using the following three modes. Thanks in advance. The graph legend or axes can be formatted as well. Supports multiple element selections. Once you’ve created one or more views on different sheets in Tableau, you can pull them into a dashboard in two simple steps: Step 1: Open a dashboard sheet: select Dashboard from menu, then New Dashboard. For example, you can include metrics or attributes in a single object prompt, but not both. To apply default formatting and behavior to grid reports project-wide. 2 – In the Form Expression window, select a Source table, in this case I am using the calendar dimension (LU_DAY). You can only use objects of one type in an object prompt. The MicroStrategy Library can be accessed via the MicroStrategy Library App available on the Apple Store (for iOS) and Google Play Store (for Android). In addition to building dossiers and HyperIntelligence cards, you can now use Workstation to easily complete a variety of legacy architect and administrative tasks, such as creating attributes and metrics, executing Python scripts from your metadata, and monitoring and managing. Example: In the database warehouse, there is a table called SecurityRegion, with two columns, Region_ID and User_ID. Use a percent-to-total shortcut metric to show values as percents of an accumulated row or column total. The link can pass parameters to answer any prompts that are in the target. A hyperlink is functional in PDF View in MicroStrategy Developer and in Express Mode in MicroStrategy Web. Visit the data visualization and data dashboard galleries for inspiration. Grouping. SYMPTOM: When a document defined with at least one nested prompt and a link to another document with prompt answer to be carried on, incorrect document result may come back when there is a dataset cache already existing. " Select "Use a filter to reduce the number of elements" and select the "YEAR FILTER" created in the previous step: Save this filter as "QUARTER FILTER:" Follow the same basic procedure as above to create a Month filter. For attribute qualification, metric qualification, and hierarchy prompts, you can configure how the user can define the attribute or metric qualification in the prompt when the. Strong semantic layer to define all the business rules and tightly coupled. ACTION: Currently this issue is being reviewed by MicroStrategy for a potential code fix on an upcoming MicroStrategy release. 3% of resumes. From the Show search box drop-down list, select one of the following options: To display the search box, select True. – Filters. May be convert this into freeform sql report with required prompt. With MicroStrategy Web, business users perform any of or all the major styles of BI - Scorecards and Dashboards, Enterprise Reporting, OLAP Analysis, Predictive Analysis, and Alerts and Proactive Notification - within a single,. Prompt-in-prompt is a feature in which the answer to one prompt is used to define another prompt. it should display 'Shortcut to: Date Prompt) Custom: AddMonths(?, -1) Add the filter to a report to get dynamic date functionality. The different kinds of value prompts are: Date prompt: Users enter a specific date for which to see data. Unlike a security filter which applies to all reports/prompts in a project, this method allows a developer to dynamically control the information seen by relating the User Login to relevant data. This can alert you if objects are removed from a report used as a dataset. SYMPTOM: When Filters are added to MicroStrategy Visual Insight Dashboard with multiple visualizations, the filter applies to all the visualizations in a. A screenshot of the VI Dashboard in Design Mode; A Screenshot of the Diagnostics and Configuration Tool on the Diagnostics Configuration tab. An object prompt for one or more attributes placed on the rows. The second most common hard skill for a microstrategy developer is bi appearing on 5. It also provides resources to add functionality such as controlling navigation, retrieving and applying filters, setting properties, and managing events, and supports several different authentication environments. With MicroStrategy Mobile, you and other business users receive the same reports and documents on your mobile device as you do in MicroStrategy Web. Also, it enables them to keep the data confidential and private without doing much. For "Choose from All Attributes in a Hierarchy," "Qualify on an Attribute," and "Qualify on a Metric" prompts, you can also configure how the user can define the attribute or. The prompt wizard will be launched. You have now seen two different ways to navigate. Run the following. MicroStrategy Web is an interactive, easy to use interface for all Business Intelligence (BI) reporting, analysis, and monitoring. View the orange Certified ribbon on the dossier. The value from of visualizationKey is necessary to specify which single. At Customers Bank, we believe in working hard, working smart, working together to deliver memorable customer experiences and having fun. Enter the replacement value (such as 0) in the text box below the check box. You can determine how a prompt appears when it is executed in MicroStrategy Web, by selecting a display style, and then updating the style properties associated with it. You can. Step 3. SYMPTOM: Reports and Dashboards no longer display one of the two attributes that have been linked together in a VI Dashboard from cubes that are used as datasets. Custom URLs for passing prompt answers from one dashboard to another report or dashboard. While privileges are assigned to users (either. In Interactive Mode, Editable Mode, and Flash Mode in MicroStrategy Web, a user can flip between the panels, quickly replacing one Grid/Graph with the other. Q24. For example, the user can answer the Northeast region or 2002, and the appropriate data is returned from the data warehouse. Enter 'Year' as the attribute and click 'Prompt' as shown below. Data Mining. For the reference, when a user defines prompted filters, the report prompt page will be displayed as below, note that there are two prompts to qualify on Day attribute: STEPS: 1. Object Layer. For an introduction to prompts, how prompts save the report designer time, and how prompts work with MicroStrategy security filters, see the. Documents and dashboards allow you to display your business data in a user. Ritinder Kaur Business Intelligence 1 comment. Please post your code so that we can help you :) – Toma. ; In the Configure Selector window,. MicroStrategy, a longtime independent analytics vendor, already offers some augmented analytics capabilities, such as natural language processing (NLP), and supports AI. Published: Jun 13, 2017; Last updated: Apr 12, 2019;. . After all filter qualifications are added to the report filter, the report creator can now execute the report and receive only one prompt. In a filter or custom group, the value prompt is used within a metric qualification or an attribute qualification. Custom URLs for passing prompt answers from one dashboard to another report or dashboard. Answer: a) It enables organizations to make informed business decisions. Prompts in documents limit the data that is displayed, thus acting as a filter. Each resulting fact view should have a USER column. Select a prompt answer and click Apply. Data quality. Dossier offers element/value selectors, attribute/metric. Build a User attribute that maps to this column in each fact table and define a security filter User = ? so that each query will qualify on User to restrict access to data. With system prompts, it is possible to use database security tables to build MicroStrategy security mechanisms. x-10. Notice that the filter appears as only a line. Choose a project to contain your filter and click Select. This metric divides the sum of VOL fact at report level by [Net Weight] after applying it a character replace at BBDD level with ORACLE's replace function (it seems that the BBDD is ORACLE), and breaks it down by product. This article details the behavior differences of an object prompt report when creating a visual insight dashboard through the web folder browser versus the tools menu in the prompted report. Qualify on ID; Operator changed to between; Simple prompt: ? (immediately click finish and drag prompt onto filter. For filters, the ApplyComparison and ApplySimple functions are most useful, although you can also use Apply functions to create metrics and prompts. 3 can take advantage of this feature following this steps: 1. Microstrategy is actively being used by multiple departments within our organization. You can add a prompt to a report to determine what data is displayed on the report based on how the user answers the question. You can determine how a prompt appears when it is executed in MicroStrategy Web, by selecting a display style, and then updating the style properties associated with it. Selector: The objective of a summary page is to design a dashboard that meets 80% of user needs, and at the same time, provides enough flexibility for the viewer to explore more. 2. This function evaluates multiple expressions until a condition is determined to be true, then returns a corresponding value. For example, you can create a prompt that allows users to choose from a list of existing stand-alone filters to apply to the report. STEPS TO REPRODUCE: Create a document in MicroStrategy Developer or Web 10. If for example, the user enters 10/08/08, the report will display the month of October 2008. Fundamentals of Customization: ShortcutsA document or dashboard can contain data from one or more MicroStrategy reports. Number of Views 3. Metric definition: Sum (IF (Employee@ID In (1,2,4,5),Revenue,0)){~+} This is good as a quick solution, since. In MicroStrategy Developer, choose File > New > Prompt. Passion, attitude, creativity, integrity, alignment, and execution are cornerstones of our behaviors. This week I bring a very useful functionality in MicroStrategy: Pass-through functionalities, which allow us to add by hand a query (or, rather, part of the query) to give a little more flexibility to the query. How the user answers the question determines what data is displayed on the report when it is returned from your data source. Where to use value prompts. Single: Only one personal answer can be saved for this. Controlling Access to Objects: Permissions. @Iulian Lixandru (MicroStrategy Community Master) (Empower BI) -Can we achieve this functionality through user defined custom subtotal? We have a request for a prompted report and need to calculate distinct customers where we have report exist at lower level than customer and subtotal needs to happen on distinct customers like the. 10. A Value prompt allows you to pass a single value as in input to a MicroStrategy Report. For any Apply function, the attribute form in the arguments should be a single form—not a form group. Choose the option to create a 'Value prompt' in the. WORKAROUND: Create data import cubes as standalone objects instead creating in VI, and the cube can be located from file system and able to be scheduled refresh. WORKAROUND: This issue only occurs when unchecking the “Show option for All” setting when (All) is selected. Or embed self-service capabilities for users to visualize key drivers or what-if scenarios. The box represents the second and third quartile (50%) of data points and the line within the box represents the median. You can choose the appropriate graphs and images to highlight specific data, trends, and deviation from certain trends. A stand-alone prompt can then be used on many different reports, as well as on filters,. Click within the Dataset Objects area to add datasets for the document. When there are multiple prompt answers,. An enhancement request has been logged to increase the range of what the trace can do in such a situation. This is a pixel perfect dashboard design tool and has been created specifically. Click Next. 1. ) Once your filter containing the prompt (s) is created, see Adding a. This feature is only implemented for element list prompts . When we place some common attribute or metric in multiple visualization, it is easy to study the variations among them. The two lines extending outside the box are called whiskers and represent the first and fourth quartile, along with the minimum and maximum value. A prompt is a question the system presents to a user during report execution. Navigate to a prompted report and click Insert. Yes. Date prompt: This Value prompt type asks users to type or select a date, and returns data that has the date data type assigned to it and that matches the user's entered date. 1 Answer. To Scale a Graph Report in MicroStrategy Web. We will obtain this information using the MicroStrategy APIs. From the left, click Document. 0. After applying the filter, click some of the values of the product category visible in the top bar filter section. 5/62. Create Dashboard B with the above report with three value prompts for each attribute above. If feasible you may try prompt on view report created from cube and use that view report. Shape file which holds all the data of the image layouts available. Number of Views 989. x - 10. Choose attribute Call Center and use the Region Filter created in the previous step. After you find the microstrategy. In this. A selector isn't the same as a prompt. 11 will support prompts for end users. But it’s nipping at the heels of leading BI software with cutting-edge capabilities and wins in a close MicroStrategy vs. 1. This section provides information on the page execution flow within MicroStrategy Web, along with examples for common processes such as folder browsing and report execution. Observe the selection box next to the text box is automatically changed to "Simple Prompt". Example: It should be like 2nd dossier should be selected as Year=2017 and Month=Feb (as we have selected the same in Dossier 1) but we should also get the other elements in. All of these prompts will reveal themselves at report execution time, but the origin of the prompt can be within any of the objects. About prompts. The prompt lets users select a specific date within the year of the. On the report you configured as a map, or on any grid that is a secondary datasource for the map, right-click on the column header for the attribute that you want to use as the selector, and click Use as Selector. Example: In the database warehouse, there is a table called SecurityRegion, with two columns, Region_ID and User_ID. You can: View the results of the document. It is used to insert any single-value, database-specific functions and simple operators directly into SQL. 963. You can then deploy the dashboard using Desktop, Web, or deliver it via e-mail using the. Numeric prompt: Users enter a specific. You can also specify the interval or steps to use. Data. Value prompts – Allow a user to type a value, which can be used along with metrics. Therefore, prompts allow report designers to create reports that let users change the report content at run time. Report builders design parameters into views when the report is created in Tableau Desktop. Display Mode. By using MicroStrategy, you can rapidly deploy analytics capabilities, allowing you to focus on developing your core products and services. Interactive dashboards in MicroStrategy. Create Dashboard A with the above report as the dataset. If you unset the filter, the icon disappears. Next, select an operator from the Operator list. If for example, the user enters 10/08/08, the report will display the month of October 2008. KB419483: How to create a comparison operator prompt and use it in an applysimple. Click Test to ensure the URL is correct. 1576. 4 MicroStrategy renamed Visual Insight MicroStrategy Dashboard. In MicroStrategy Web, log in to the Tutorial project. Non-administrative users can only view and use the objects from the public folder, but they cannot delete or create new objects under the public folder. Description. For example, the Date prompt can be useful when added to a filter that screens data based on Year=2006. Users can use the animation features on-the-fly using toolbox which can be enabled by small icons in right-top in the chart. In the illustration below, the user has not been assigned the Web export privilege. A stand-alone prompt is a prompt that is created as an independent MicroStrategy object. In MicroStrategy Developer, go to File > New > Metric. 3. "KB11113: How to use prompts to return attribute element values within an Apply statement in MicroStrategy Developer and Web When using any of the Apply statements in conjunction with prompts used to select attribute element values, it is necessary that a value be returned as an argument into the function of the statement. You can only use objects of one type in an object prompt. Transformational Retail Analytics. Enter a Form name and Description. KB20395: How to Answer Prompts in a Custom Report Event Handler Using Prompt Answer XML in MicroStrategy Java Web SDK 9. Below are some recommendations for offline dashboard use with MicroStrategy Mobile. Perform your critical workflows with Workstation. Create a blank dossier or open an existing one. Place the nested prompts into the report filter. The My Preferences dialog box opens. In the Dashboard A, create three selectors: Selector one selects Category element. This course is intended for business and. It is important to remember that prompts can be used in many objects including reports, filters, metrics, and custom groups. Value Prompt. Prompts in MicroStrategy Developer are used to enable metric, filter, template, custom group or report modification. Locate the "ID" field and copy the unique identifier for the report:create a derived metric named "Metric Selector". Suppose I have a dashboard with a report embedded in it in Microstrategy. It supports interactive dashboard, highly detailed reports, ad-hoc query, automated report dispute, and Microsoft Office integration. For example, a date value prompt will yield TO-DATE ('08-MAY-74') for Oracle and "1974-05-08" for DB2. Create a panel stack. Watch the MicroStrategy team show you how to get started by using MicroStrategy for Power BI. From the Graph Sub-type drop-down list, select one of the following:1. To apply the selections as a slice,. In this case, you would need to create a user connection mapping within MicroStrategy for the CEO. MicroStrategy Mobile is an application for mobile devices that allows analysts to view, refresh, and analyze MicroStrategy reports and Report Services documents. These objects include attributes, custom groups, consolidations, and metrics. To ensure this prompt requires an answer, select the 'Prompt answer is required' check box. ) Once your filter containing the prompt (s) is created, see Adding a. To Resolve Unanswered Prompts in MicroStrategy Web. For example, you want a report that lists all employees whose age. Now leverage trusted data to build a Power BI dashboard and even schedule dataset refresh cadence. KB10296: Users see duplicate values when creating an element list prompt in MicroStrategy Developer 9. – Calculations. For example, an LU_CUSTOMER table includes two columns: CUST_FIRST_NAME and CUST_LAST_NAME. From the list of document templates, click Blank Document. 10. Open the document in Design or Editable Mode. How to Execute a Prompted Report Services Document and Automatically Use the Default Prompt Answers using the MicroStrategy Web 8. 4. What is an implicit attribute in MicroStrategy? Answer: The sample prompt is as show below. On the dataset "Revenue & Discount by Category, Country, Month" create a new derived metric "KPI" defined as follows. Users can select prompt answers from one or more attribute elements from one or more attributes. MicroStrategy Intelligence Server provides one centralzed architecture for all users' monitoring, reporting and analysis requirements. 3. The Create New Attribute Form dialog box now appears. Right-click the metric sales, and we get the option to choose the threshold as shown in the following screenshot. The link can also pass selector values from the source to the target. The major usage of the tool is for analytical purposes (reporting) by interacting with Hadoop, Microsoft SQL Server Tables, and SSAS MDX. Data Analytics and Visualization MCQs: This section contains multiple-choice questions and. By designing dossiers with prompted datasets, end users will now be able to proactively limit the data load prior to running a dossier. x warehouse and project while retaining an existing warehouse and project. Askingforuserinput:Prompts 280 Designingareport'sstructure:Templates 343 Creatingagridreport 345 Addingfeaturesforusers 378 Modifyinganexistingreport 401Start. Users can link the dossier to the following elements: • Any external URL. Displaying a list of selected elements in a Document or Dashboard can be easily accomplished using the ConcatAgg function. For filters in the filter panel, after the dynamic default selection is defined, an icon and text ('First N'/'Last N') appear indicating dynamic selection is ON. These objects include attributes, custom groups, consolidations, and metrics. SYMPTOM: In MicroStrategy 10. Choose Format > Graph. Every time a user sees the prompt, he must answer it manually (if it is required) or ignore it. Introduction to Dossiers. The engine will use the text string to find all attributes that have that text within its description. If you are editing the Case function, use the values in step 8. Number of Views 3. To access the public folder, login to MicroStrategy developer as administrator and go to option Public Objects. If you single click on the icon, or make any manual selection on the filter, the icon is grayed out, indicating dynamic selection is OFF. Filters in MicroStrategy are built from Attributes. 8) Create an object prompt for the report using the objects within the cube. Each conditional metric contains a copy of employee list (in an IF statement) Employee list filter is moved to a separate metric (Flag metric) Employee list filter is moved to a Filter object. I joined the dossier authoring team in 2018. Note: You can select more than one value as your prompt answer (see below). From the Tools menu, select View Filter. Express Mode (formerly named View Mode) Intended for document analysts that need to view information rather than create and edit documents. On the General tab, from the Graph Type drop-down list, select Budgeting. In a filter or custom group, the value prompt is used within a metric qualification or an attribute qualification. We can see that the whole time period in the data is divided into years and years into months. The prompt wizard will be launched. 26 2. add column sets within the compound grid, and a simple use case for leveraging this new visualization type. Yon can use an object prompt in your report to select attributes on. Click on 'Modify' to determine how the prompt will appear in MicroStrategy Web. g. You can then apply an Element / value selector to the grid as a drop-down. MicroStrategy Visual Insight was included with the standard user licenses, had a flash based engine and it was working only on web (and mobile). 4. Uncheck ‘Apply selection as filter’. Click the name of a prompted report or document to run it. However, reports that access Intelligent Cubes can use prompts that access only data included in the Intelligent Cube. It is important to remember that prompts can be used in many objects including reports,. In addition, object prompts can be created as stand-alone prompt objects and then added to the report using the Insert Prompt option under the Template menu. Selector two selects Region element. KB30925. Documentation platforms like Microsoft. CAUSE: This is an identified defect in MicroStrategy Web 10. I need to pass the Username to the SP. Splitting the fraction: Numerator: Sum (VOL) {~} Denominator: Max ( ApplySimple ("replace (#0, ',', '. 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. Enter a title and a description for the prompt. !o inserts the report name (can be used in all Pre/Post statements). To prompt for multiple object types in the same report, you must create an object prompt for each. x and. We will highlight the various benefits Library offers, including prompt application deployment, a streamlined user experience, uniform designs across all devices, and much more. MicroStrategy Technical Support case. By default, it is enabled, so that once a user clicks an object (button, link, and so on) in the selector, the change is automatically applied to the target of the selector. For any Apply function, the attribute form in the arguments should be a single form—not a form. Non-administrative users can only view and use the objects from the public folder, but they cannot delete or create new objects under the public folder. Right-click on a dossier. This calculation can be aggregated from the Employee level to the Region level. )Use. You need to know the type of prompt when. Hi @Bharat Bhushan(Inactive) (Customer) , As command SQL cube created by user have to be published first before they can be used as result prompts are not supported just yet. The report should contain the attributes, metrics, and other objects that you want to use as columns in the data mart table and which will populate the data mart table. Hierarchy Qualification. Target the grid report and the child panel stack. Execute the document in Web, and set the selector value you want. Compare a link to a hyperlink, which is a connection in a document to a web page. Add a comment. Using system prompts, users can use. Filters within the filter panel can be expanded, collapsed and re-arranged. Sorted by: 1. KB237469: How to define a Metric using text based value prompt in. A prompt allows a user to provide an answer to restrict or filter data during report execution. MicroStrategy Web is an interactive, easy to use interface for all Business Intelligence (BI) reporting, analysis, and monitoring. 4. User will be prompted to enter a date. (You can add more than one prompt to a filter. This is a part of MicroStrategy. It is important to remember that prompts can be used in many objects including reports, filters, metrics, and custom groups. install and configure MicroStrategy Collaboration so that your users can interact with each other in real time directly within your Dossiers. ACTION This is an expected behavior in MicroStrategy. If you are editing the If function, use the values in step 7. No Filtering – Selectors do not target each other. The key features of MicroStrategy platform are –. Enter the URL for the baseline project's Web server in the URL for Base connection field. How the user answers the question determines what data is displayed on the report when it is returned from your data source. Later versions, including MicroStrategy 9. In the Dashboard A, create three selectors: Selector one selects Category element.