Now, create an hierarchy prompt but before saving , save/overwrite them on top of “Qualification Prompt” that is being used in the Cube – ensure, the hierarchy objects exists within cube. 1. Value prompts are typically used in filters, but they can also be part of a metric formula or a custom group. Create a report with: a. Request free demo. Step 2: Add views to your dashboard by dragging sheets onto the dashboard. 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. KB419483: How to create a comparison operator prompt and use it in an applysimple function in MicroStrategy Developer. From the MicroStrategy home page, click New Metric . x Report Service Documents. x. See the finestfoods dashboard in action. To ensure this prompt requires an answer, select the 'Prompt answer is required' check box. When applied to a language object, allows users to edit and save translations, and to select the language for. That is, we will not be able to create these elements using the. Enter 'Year' as the attribute and click 'Prompt' as shown below. Click on Dossiers in the left panel of Workstation. Excel: This allows the user to export the document to Microsoft Excel in . In the Data Source dialog, select Reports. Now, create an hierarchy prompt but before saving , save/overwrite them on top of “Qualification Prompt” that is being used in the Cube – ensure, the hierarchy objects exists within cube. To create a static label, type text: a. Enable users to interact with personalized chat for further product discovery. 1. 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 data into multiple chapters and pages to provide a. A dashboard is made up of multiple visualizations. Data can be connected through an API, flat file, or database. Once data flows into the interface, the dashboard will come to life. Only two types of prompts can be used: value prompts and element list prompts. We will obtain this information using the MicroStrategy APIs. The calculation can restart based on attributes identified in the parameter settings. Microstrategy Dossiers With the release of MicroStrategy 10. 2 – In the Form Expression window, select a Source table, in this case I am using the calendar dimension (LU_DAY). 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. It returns the value to compare the attribute or metric to. No SQL sources are optimized for large information storage and transactional queries. Q24. Qualify on ID; Operator changed to between; Simple prompt: ? (immediately click finish and drag prompt onto filter. Create an integrity test. The object can be found under Public Objects > Prompts > System prompts, as shown below: Unlike ordinary prompt objects, system prompts don't require any answers from the user. PREREQUISITES: Established connectivity to MicroStrategy. 1 introduces a new feature - the ability for users to define a freeform condition in a Freeform SQL or XQuery report that can be targeted by a Unit Condition selector on a grid in a Report Services document or dashboard in MicroStrategy Web. An enhancement request has been logged to increase the range of what the trace can do in such a situation. Wireframing and diagramming tools like Microsoft Visio, Balsamiq and Lucidcharts. For any Apply function, the attribute form in the arguments should be a single form—not a form. Create filters qualifications for other attributes in the same way. Prompts are not supported on RSDs via the Library in 10. Give the link a name. Accept the other default values. Prompts users to choose from all attributes in a hierarchy. 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. Predictive analytics is a powerful tool to forecast trends within a business, industry, or on a more macro level. To find Filter names in MicroStrategy: . Webinar; Tips and Tricks;Connect and share knowledge within a single location that is structured and easy to search. Click Add Condition in the View Filter section to add your filter. This will help authors of dossiers embed workflows that provide consumers with options for guided analyses. Experience how MicroStrategy empowers users via HyperIntelligence, Mobile Analytics, Dashboards & Dossiers, Visualizations, Geospatial Analytics, and Enterprise Reporting. By using MicroStrategy, you can rapidly deploy analytics capabilities, allowing you to focus on developing your core products and services. 27K. Run the report. Tableau faceoff. MicroStrategy 9. Can I use System Prompt inside VLDB properties. 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. 0This "How to" technical note describes a way to hide the metrics columns from a document grid in MicroStrategy 10. "System Prompt" is a system object that was introduced back in version 8. Experience how MicroStrategy empowers users via HyperIntelligence, Mobile Analytics, Dashboards & Dossiers, Visualizations, Geospatial Analytics, and Enterprise Reporting. Object prompts enable you to provide versatile reports to users. 1. User will be prompted to enter a date. 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. September 22, 2023. Therefore, prompts allow report designers to create reports that let users change the report content at run time. When this user opens a report in MicroStrategy Web, the export button does not appear on the toolbar. Connect and share knowledge within a single location that is structured and easy to search. Click on 'Modify' to determine how the prompt will appear in MicroStrategy Web. " 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. This course is intended for business and. See all healthcare & pharma solutions. MicroStrategy AI is engineered to transform the way organizations interact with data. 1. A hyperlink is functional in PDF View in MicroStrategy Developer and in Express Mode in MicroStrategy Web. If DHTML is disabled, from the View menu, select View Filter and click the Go icon . The targets only display data that also appears in the source. Workstation. Finally in version 9. Number of Views 797. We also added an Advanced Properties panel, SQL view in pause mode, more formatting options, customized subtotals, and support for transformations, consolidations and custom groups. To add a Date prompt to a filter in the Filter Editor. If you unset the filter, the icon disappears. A space where we get together to see curiosities, share experiences and pass tips to be the coolest and most knowledgeable consultants. 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. This function evaluates multiple expressions until a condition is determined to be true, then returns a corresponding value. A prompt is a question the system presents to a user when a report is executed. Add the filter to the Report Filter of the report. x. The ApplySimple function is a single-value function. Then click on New Document. The character # is a reserved character for MicroStrategy and precedes the number of the argument, which starts at 0 and increases in increments of 1. By default, the metrics Compound Profit and Profit Margin do not use a dynamic aggregation function. 11+, MicroStrategy 2019) Next Steps Starting with MicroStrategy 10. 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. Microstrategy multiple filtered metrics based on same attribute. KB30925. Dealing with Complex Layers. Using the following prompt types, you can create a prompt for nearly every part of a report. You can set whether Y-axis values display on the graph and, if so, what minimum and maximum values to use on the scale. You can then apply an Element / value selector to the grid as a drop-down. An object prompt for one or more attributes placed on the rows. Now leverage trusted data to build a Power BI dashboard and even schedule dataset refresh cadence. The different kinds of value prompts are: Date prompt: Users enter a specific date for which to see data. A dossier is an interactive display that you can create to showcase and explore business data. x and. 2. Each button can be configured differently and. This prompt is used in a filter. Create a blank dossier or open an existing one. MicroStrategy Mobile is an application for mobile devices that allows analysts to view, refresh, and analyze MicroStrategy reports and Report Services documents. The MicroStrategy analytics platform is a cloud-based and on-premise self-service business intelligence platform that supports both data mining and visualization. Open the document in Design or Editable Mode. Enter the replacement value (such as 0) in the text box below the check box. With system prompts, it is possible to use database security tables to build MicroStrategy security mechanisms. When to use: You want to see the distribution of one or more datasets. Then you add that filter containing the prompt to a report. Create a FreeForm SQL Report and add this nested prompt into it. In other words, a prompted qualification in a filter allows you to dynamically modify the. Several workarounds for this issue have been provided below for use in current releases. Changing the prompt order. To address this requirement, use logical views (or database views) to apply a different security rule for each fact table. Create Dashboard A with the above report as the dataset. Views 1543. Documents and dashboards allow you to display your business data in a user. Create a Value Prompt To create a Value prompt from the MicroStrategy desktop: From the MicroStrategy Desktop, right click and select. Companies that use MicroStrategy may need skilled professionals to fill the following roles: MicroStrategy developers: Create and maintain tools that simplify business data analysis within MicroStrategy. Easy to Use and Maintain: MicroStrategy is surely a very advanced BI tool. When using a Value prompt, you first set up the prompt, and then set up a filter to use the Value prompt. All of these prompts will reveal themselves at report execution time, but the origin of the prompt can be within any of the objects. When there are multiple prompt answers,. Select. The 'Choose a Prompt Style' dialog box opens. An overview of designing and creating documents. ) Once your filter containing the prompt (s) is created, see Adding a. SYMPTOM: In MicroStrategy 10. 9% of resumes. When we place some common attribute or metric in multiple visualization, it is easy to study the variations among them. Using URL to answer prompts. Hierarchy Qualification. Please post your code so that we can help you :) – Toma. Shape file which holds all the data of the image layouts available. MicroStrategy Technical Support case. Follow below steps to achieve that : Create Elements Prompt and add them into Report coming from Intelligent Cube. 1; Product Documentation: How to Create a Derived Metric from an AttributeEmbedding Dashboards: Learn how to embed Dashboards from the MicroStrategy platform into external applications. It returns the value to compare the attribute or metric to. Object Layer. The two lines extending outside the box are called whiskers and represent the first and fourth quartile, along with the minimum and maximum value. 1 – In MicroStrategy Developer, navigate to the folder where you wish to create the attribute, right-click in it and select New > Attribute. Advanced Prompts: Enabling User Input. 3% of resumes. Click Add New Qualification. Define if Dataset should be searchable. MicroStrategy does a quick search for the entered information and can't find a single object that lines up with it. Depending on the type of object you are filtering on, a different set of choices appears. The major usage of the tool is for analytical purposes (reporting) by interacting with Hadoop, Microsoft SQL Server Tables, and SSAS MDX. The third most common microstrategy developer skill is templates on 5. Create a Report Services Document from data set 1 (source) 4. Ritinder Kaur Business Intelligence 1 comment. Input a descriptive phrase in Name. Select a prompt answer and click Apply. Edit the Parent selector. To do this: Create a new database login definition for the CEO in MicroStrategy so it matches their existing login ID on the data warehouse; Create the new connection mapping in MicroStrategy to specify that the CEO user uses the new database loginGeneral Preferences. Create a filter on attribute "Quarter" and click "Prompt. !o inserts the report name (can be used in all Pre/Post statements). , argument_n) The placeholders are represented by #0, #1, and so on. In this. Create a Prompt using Prompt Generation Wizard in MicroStrategy Desktop/Developer. We’ve evolved dashboards to the point that they are more than dashboards - they are interactive, collaborative analytic stories. Click the name of a prompted report or document to run it. Auto apply selector changes: Applies to all selectors in the document. Launch the Prompt Generation Wizard in MicroStrategy Developer by going to File menu > New and choosing 'Prompt'. Create a Target data set with the same prompt from step 1. Change the formatting of the percent to total with the appropriate settings (decimal places, negative value formatting, etc). Use the object when creating or modifying other objects. For an introduction to prompts, how prompts save the report designer time, and how prompts work with MicroStrategy security filters, see the. From the Insert menu, select Text. Human. Click OK. Enter a title and a description for the prompt. For example, an analyst can view a list of employees with time off requests. It shows many attributes grouped into separate visualizations. The object can be found under Public Objects > Prompts > System prompts, as shown below: Unlike ordinary prompt objects, system prompts don't require any answers from the user. WORKAROUND: This issue only occurs when unchecking the “Show option for All” setting when (All) is selected. To add a Text prompt to a report, you first add the prompt to an attribute qualification in the Filter Editor. This will change the diagrams, depending on the value selected. Numeric prompt: Users enter a specific. They can be paired effectively with the Multi-source option or the data blending option in MicroStrategy so that. Check other tables and select/deselect correct tables. The reports use the hierarchies, metrics, attributes, prompts, details, and filters that are defined in the CX Insights Project. For steps to create an Object prompt, see Filtering data based on metrics, attributes, or other objects: Object prompts. )Use. How to Execute a Prompted Report Services Document and Automatically Use the Default Prompt Answers using the MicroStrategy Web 8. Using the following prompt types, you can create a prompt for nearly every part of a report. In general, ApplySimple can be used to create the following objects: Attribute form. A sales team might use a business dashboard to connect data from their customer relationship management system (CRM) and their website to gain insight into what products prospects are interested in. MicroStrategy 2 min #17 - Embed Dashboard into Sharepoint. Visualization with Multiple Datasets. From the Tools menu, select View Filter. The Profit metric is a simple sum of the Profit fact. 1 these privileges can be found in the MicroStrategy Supplemental Reference for System Administration guide. Browse and incorporate these templates into your own data dashboards. No. 3. Case can be used for categorizing data based on multiple conditions. The prompt wizard will be launched. You can format a graph report by adjusting colors, and applying a variety of graphical effects, including gradients, transparency, patterns, pictures, textures, and bevel effects. Next, select an operator from the Operator list. 9) Arrange the prompts on the grid as you see fit. Accept all the defaults and save the prompt and the filter. Number of Views 3. KB309808: How to create a new Enterprise Manager 10. Enter 'Year' as the attribute and click 'Prompt' as shown below. (See How to Save Your Personal Prompt Answers in MicroStrategy for more information. Permissions define the degree of control users have over individual objects in the system. It supports interactive dashboard, highly detailed reports, ad-hoc query, automated report dispute, and Microsoft Office integration. Target the grid report and the child panel stack. Whenever you use a view report instead of the intelligent cube, the MicroStrategy Analytical Engine (MicroStrategy AE) spends more time searching and fetching the report definition and then applies that definition to the intelligent cube. Make any changes and click OK. Views 1543. In this example, the filter is named 'Year = 1997, 1998'. If the limitation is exceeded, Developer will show the following two warning messages:. This feature is only implemented for element list prompts. . An online search reveals that MicroStrategy has less market penetration than Tableau. Create a report named R2 that has the Item attribute and Profit and Revenue metrics. 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. Is there any way by which I could let the user vary a single attribute while the dashboard is running. Scaling a Graph in MicroStrategy Web. Prompts can be the following varieties: PROMPT TYPES Hierarchy Qualification Prompt – This type of prompt allows users to qualify on attributes and elements from a specific hierarchy. Then, select a page from a different dossier that you want to filter as the target. Note: If a user enters more than 15 digits for a. Field Name is called 'Group' There are certain 'Group' names that I want to put in a certain category using the CASE logic. Ad hoc query. To delete a subscription, right-click the subscription and select Delete. Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. In the following example, we have selected multiple values and you can notice how the pie-chart changes as each of the values are selected. Slice and dice features are awesome. it should display 'Shortcut to: Date Prompt) Custom: AddMonths(?, -1) Add the filter to a report to get dynamic date functionality. First, you will need some metadata from your dossier. Data Analytics and Visualization MCQs: This section contains multiple-choice questions and. To Scale a Graph Report in MicroStrategy Web. This Knowledge Base article covers the "Executing Jobs per user" governing set behavior within Documents/Dashboards in MicroStrategy 10. Object layers contain and store the objects created in MicroStrategy. For example, you want a report that lists all employees whose age. Later versions, including MicroStrategy 9. Add the object prompt in the Report Filter. You can create a single attribute form that combines these two columns as described below. xlsx as an example data set. MicroStrategy Desktop 8. 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. For example, your document contains datasets with Region and Call Center prompts, and you want to answer the prompts in that order. You can change this at the project or document level. This type of prompt allows users to determine how the report's data is filtered, based on attributes in a hierarchy, lists of attribute elements, or metrics. Here we have compiled a set of MicroStrategy interview questions asked in top organizations around the world. From the Graph Sub-type drop-down list, select one of the following:1. In such case, we can use the attributes and metrics from both the sources in creating the visualization. There are two ways to display the prompt selections for the object prompt in the document. TL;DR: It's true often you can do a thing in desktop, but you can't do it in MicroStrategy web, or vice versa. 3. Or, you can create a prompt that displays the Day, Month, Quarter, and Year attributes to users, so the user can specify the granularity of the report. d) It is a free tool. Prompts: Prompts cannot be included in Intelligent Cubes. Generate appropriate unit test plans and assure quality of work. This is an OLAP function. The box represents the second and third quartile (50%) of data points and the line within the box represents the median. CAUSE: This is an identified defect in MicroStrategy Web 10. But it’s nipping at the heels of leading BI software with cutting-edge capabilities and wins in a close MicroStrategy vs. With MicroStrategy Mobile, you and other business users receive the same reports and documents on your mobile device as you do in MicroStrategy Web. This type of prompt allows users to determine how the report's data is filtered, based on attributes in a hierarchy, lists of attribute elements, or metrics. Here you can see how to create a 3-level deep nested prompt that will prompt the user to select a year, then a quarter within that year, then a month within that quarter. Use a percent-to-total shortcut metric to show values as percents of an accumulated row or column total. Another benefit is to be able to use a much smaller dataset by filtering data, which can be personalized by using prompts in View reports. In addition to creating, editing, and consuming content, users can also share personalized content via email, folders, or. x, the grid view display limitation for row is 65,536 and for column is 255. To Resolve Unanswered Prompts in MicroStrategy Web. By default, the metrics Compound Profit and Profit Margin do not use a dynamic aggregation function. A prompt is a question the system presents to a user during report execution. Run report and. Compare a link to a hyperlink, which is a connection in a document to a web page. 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. KB237469: How to define a Metric using text based value prompt in. Click Share > Library Access. 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. 8) Create an object prompt for the report using the objects within the cube. Follow the instructions in Creating Subscriptions. The impact is limited to the 'browse all objects' option on dashboard in MicroStrategy Web 10. Passion, attitude, creativity, integrity, alignment, and execution are cornerstones of our behaviors. Our vision, mission, and values guide us along our path to achieve excellence. The value prompt is designed to return report results based on the data type assigned to the data in your data source. Perform your critical workflows with Workstation. Proven in the Enterprise:Once you’ve downloaded the example excel sheet, we will proceed to explain step by step how to import our file. Business analytics platforms can include the following software. Join data visualization specialist Len OToole of InfoCepts for this interactive session, where you’ll learn about:Reviewer Function: Data and Analytics. Select a prompt answer and click Apply. Learn dashboard basics. KB44364: How to build a prompt in a report created from an Intelligent Cube in MicroStrategy Developer 10. In MicroStrategy Developer, choose File > New > Prompt. Method 1: Using the auto text “Prompt Details” Edit the document and go to Insert-> Auto text-> Prompt Details. If you are on a folder page, click Create on the icon bar on the left, then select New Metric. This feature is only implemented for element list prompts . In MicroStrategy Developer, open the folder that contains the attribute to modify. The same selector can control both a grid and dynamic text fields on the same panel. By designing dossiers with prompted datasets, end users will now be able to proactively limit the data load prior to running a dossier. We will highlight the various benefits Library offers, including prompt application deployment, a streamlined user experience, uniform designs across all devices, and much more. The prompt object is incomplete by design. In the View filter, click Add Condition. It is important to remember that prompts can be used in many objects including reports, filters, metrics, and custom groups. To create transformation metrics using the Metric Editor, see the Advanced Reporting Help. Right-click on the dossier once again. Select or multi-select users as recipients of the dossier. 1. To modify a subscription, right-click the subscription and select Edit. The expanded list. MicroStrategy recommends that objects missing from datasets are displayed. Attribute form. This prompt is used in a filter. 4. When the property is disabled, the user can choose when to update the target, by clicking Apply. Setting 'Mapping method' to 'Manual' forces users to manually select the source tables that use the expression. ) Once your filter containing the prompt (s) is created, see Adding a. No answer is provided to the required prompt so MicroStrategy cannot complete the report without user interaction. 0. Drag the prompt onto the Definition pane at the bottom right, as shown in the image below:Create a date prompt to accept the date. 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 target visualizations only display data that also appears in the source. Create a filter on the date attribute. MicroStrategy ONE empowers companies worldwide to seamlessly. x, no data is returned on the grid when a geo-attribute is directly added to a Dashboard via Web using the 'browse all objects' option. Parameters create a pathway for non-technical consumers to conduct ad hoc analysis by changing what and how facts and dimensions are displayed—within the boundaries of the designer’s intended usage. On y-axis, we can see the name of the days and the color gradient shows the amount. The user is asked during the report resolution phase of report execution to provide an answer to complete the information. 11 will support prompts for end users. In MicroStrategy, we can create shortcuts to filters. If a user creates a Date and Time Value prompt and then unchecks 'Allow user to select time for a list', '12:00AM' will be automatically added to the value when the prompt is displayed in a dynamic text box in MicroStrategy Developer 9. By mastering the 4Ws technique, you can present complex data in a more intuitive, clear, and meaningful way. The value from of visualizationKey is necessary to specify which single. User will be prompted to enter a date. This not only allows for dossiers to have personalized information, but also improves performance by processing only the necessary data. ')"; [Net Weight. Locate the "ID" field and copy the unique identifier for the report:create a derived metric named "Metric Selector". Value prompts: include date, numeric, and text prompts: Date and number prompts: are properly formatted to the standards of the database platform that the Freeform SQL report is executed against. you can't use directly the prompt answer (I assume you where trying to use {&PROMPT1&}, because this was also what I tried to do in the past), but you can use the result of a dataset that contains that prompt as condition for your conditional formatting. It offers an intuitive way to create and modify BI. Custom URLs for passing prompt answers from one dashboard to another report or dashboard. x - 10. SecurityRegion table defines from which region a user is allowed to view data. MSTR file) by selecting Share->Export to Dashboard file, which gives a warning message as shown below. Yes. Users can use the animation features on-the-fly using toolbox which can be enabled by small icons in right-top in the chart. SOLUTION:We use MicroStrategy's full set of products, sourcing from an array of database technologies, but mostly from Microsoft SQL Server, Hadoop, Spark, and Storm. The following steps explain the process that users can use to define and use this. Filter definition prompt – Allow a user to decide how the attribute element filter filters the report’s data. Each resulting fact view should have a USER column. Choose the option to create a 'Value prompt' in the. To pass the prompt answer for an element prompt when the attribute has a compound ID, you separate each ElementID with a colon. A sales team might use a business dashboard to connect data. The Profit metric is a simple sum of the Profit fact. Attribute is lost from reports/dashboards that use a cube whose attribute was linked to another attribute in a VI dashboard in MicroStrategy 9. If you are looking for a solution that will cover 80% of your needs when it comes to mobile reporting then seriously consider Microstrategy. The MicroStrategy Library can be accessed via the MicroStrategy Library App available on the Apple Store (for iOS) and Google Play Store (for Android). ) Once your custom group containing the prompt(s) is created, see Adding a custom group to a report for steps to add the custom group to a report. Prompts in MicroStrategy Developer are used to enable metric, filter, template, custom group or report modification. Create a filter on attribute "Quarter" and click "Prompt. 4. • Other pages within the. Comparison operator prompts can be used in ApplySimple functions with Case statements using the metric, (@nameofprompt(M1, M2)). Now. Shortcut-to-a-report qualifications, which use the results of one report as a filter inside another report. If you are editing the If function, use the values in step 7. Prompts in documents limit the data that is displayed, thus acting as a filter. Quoting from that page: The parameter elementsPromptAnswers specifies the answer to a single element prompt or multiple element prompts, with each individual prompt answer in the form of. Choose Format > Graph. A prompt is a question the system presents to a user when a report is executed. some are optional. This prompt is used in a filter. Through an easy-to-use web page, users specify what information they want, when, and how they want to receive it. 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. 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. If you are filtering on a metric, select the operator on which to base the filter. They can be paired effectively with the Multi-source option or the data blending option in MicroStrategy so that the users can be shown higher level information from traditional databases and use the No-SQL source to provide the capability to drill. The dataset report of a document contains the MicroStrategy objects that can be displayed in the document. May be convert this into freeform sql report with required prompt. Read our trends article to know what the future holds. Strong semantic layer to define all the business rules and tightly coupled. Click Create on any page, point to New Prompt, and select Object. 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. Therefore, prompts allow report designers to create reports that let users change the report content at run. The Target icon appears in the upper left corner of these visualizations.