3. Edit the report filter. A screenshot of the report is shown below: 2. Sub Button_Answer_Prompt () Dim PSName, prjName, reportID As String. 2. The ACL you define here is applied as the default ACL for the project and all of the objects within the project, excluding the objects mentioned in the following option. This not only allows for dossiers to have personalized information but also improves performance by processing only the. Click Create on any page, point to New Prompt, and select Object. Every time a user sees the prompt, he must answer it manually (if it is required). The ACL you define here is applied as the default ACL for the project and all of the objects within the project, excluding the objects mentioned in the following option. Create a filter on attribute "Month" and click "Prompt. Whenever a Freeform SQL report is created, a shortcut is placed in that schema folder by default. Edit the report again. 2 HF1, when a user runs a prompted report, any prompt answer can become the default prompt answer if the report is saved with the option 'Set the current prompt answers to be the default prompt answers' enabled. Target. The demo is introducing the structure but you can get very creative with these URLs. x, the prompt on the document displays the default answers even though the user has selected prompt answers in the distribution list. If you want the report to use default prompt answers, select the answers that you want to save as default prompt answers. Run the report. If you select Prompt answer required without providing default answers, the report cannot execute on a schedule. From the list of available objects, select the objects to be used as default values for the prompt and click on '>' to add them to the list of selected objects. To Allow Personal Answers for Prompts. Personal answer: Personal answers are the default prompt answers that are saved for inidividual MicroStrategy logins. Select the prompt to modify and click the up or down arrows to change. x, it is possible to pass in prompt answer xml as a parameter in the request when a specific report is run. 4. 'Display the default page. The report is exported in. The New Prompt page opens. x and 10. Place only the lowest level filter in the filter section of the report. These custom prompts give you more control than the default edit links and can come in handy when advanced developers want to get creative. Set this personal answer as the default (select the Set as default checkbox). In addition, the 'Integrity Manager Internal Answer' option is not selected in 'Advanced Options':. How to Execute a Prompted Report Services Document and Automatically Use the Default Prompt Answers using the MicroStrategy Web 8. Click on the Prompt button: 4. Use a pre-defined list of elements: This option lets you select specific attribute elements to display to the user. The "One month" prompt used in the above example permits exactly one answer. Use a pre-defined list of elements: This option lets you select specific attribute elements to display to the user. To create a list of attribute elements from which users can choose, select Use a predefined list of elements. For example, you can include metrics or attributes in a single object prompt, but not both. x. To allow more flexibility, the check box allows the user to restrict the search results only to those. To use the fonts chosen by the report or document designer, select the Embed fonts checkbox. You have now selected your prompt answer. (See How to Save Your Personal Prompt Answers in MicroStrategy for more information. Select the users or groups that you want to add to the object's ACL. STEP TO REPRODUCE: Follow the steps below to reproduce this issue in the MicroStrategy Tutorial project:To see data filtered in a different way, click the Reprompt icon on the Standard toolbar and answer the prompt again to create a different filter for the report results. Qualify on IDKB31987: A Report Services document using two or more prompted reports based on Intelligent Cubes queries the data warehouse to generate element list prompts instead of reading from the Intelligent Cube in MicroStrategy 9. If it does, a default answer appears in the far right pane of the prompt window. To require users to answer the prompt before running the report, specify whether the prompt requires an answer. If there is no prompt answers in all levels, there will be no default answers displayed. Value prompts are useful when the result desired on the report is a single value, such as a specific date, a number, or a specific word or phrase. Prompts. To require that the user answer the prompt at run time, select the Prompt answer required check box. Select different prompt answers such as with Year 2008 and 2009. If the target prompt does not have a default answer, the Empty answer method is used. 2. No prompt answer is provided from the source and the user is not prompted to provide answers. Second option: 1. 9 and 10. . MicroStrategy has partnered with MobileIron to add an extra layer of security to MicroStrategy Mobile applications running on iOS devices. Set the default run mode to be "Export to Excel", like shown below. Prior to MicroStrategy Update ONE Update 11, this field was named Use the selected objects as the answer. The format of the expression is the same as the JSON Data API's view filter. Create a FreeForm SQL Report and add this nested. x but when accessed through MicroStrategy Office the default answer will display blank like shown below. x users have the ability to save their prompt answers. If the prompt answer is invalid, no data is returned. A possible workaround is to select the default prompt answer from MicroStrategy Developer. Save the report. A default answer can allow users to complete report execution more quickly, since they do not need to answer the prompt but can simply run the report using the default answer. x, it is possible to programmatically create subscriptions for report and documents, answer prompts and save the subscriptions as personalized. Execute the report Specify the type of value prompt to be used (in this example, a text prompt is used) as shown below: It is recommended to choose a default value. The reuse property of the prompt answer. Set a default value for both prompts. Renaming a Prompted ReportAs of MicroStrategy Integrity Manager 8. Step 1 Select your prompt answer from the left-side box to the right-side box. Call oRes. On Parent Document, see image below, there is a text box containing a hyperlink to pass selector answers (Month and Quarter) to a Child Report with Value Prompt (Month. In MicroStrategy Web 10. 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. Step 1 Clear any selection in the right-side box and make your new selection from the left-side box using the arrow buttons between the boxes. The New Prompt page opens. Right-click an object in the Grid/Graph and select Edit Links, as shown below: Click New to create a new link. Prepare file with the answers. In the Data Source dialog, select Reports. Default object answer: A prompted report can have two possible default answers: a default answer saved with the prompt and a default answer saved with the report. The New Prompt page opens. Run the document, answer the prompts, and as seen below, where the auto-text {&PROMPTDETAILS} was, the prompt details will be displayed: Method 2: Using. Use the same answer from the source prompt; Use the default answer; Ignore the prompt; Click Save. Add a title and description and click 'Finish' to complete the filter. By default, all prompt answers are accepted and passed on to the report where the data pertinent to the prompt answer (filter) is displayed. Select the personal answer to rename, then click the Rename icon . Value prompts (available only in MicroStrategy Web) The object selected in the source (for example, the attribute element that the user clicked on) Empty answer. You can only use objects of one type in an object prompt. On the New JavaScript Wizard, click Next and Finish. For example, you want a report that lists all employees whose age. 1. This functionality allows users to search for specific elements within the prompt available answers. The attribute element prompt is one of the most commonly used prompt types. 1. When you apply this prompt to the report and execute the report using the default answer, the report appears as shown in the following image. Right-click oivmCustomPrompt and choose Create new JavaScript. KB442018: In MicroStrategy 10. It is possible to programmatically export a document containing default prompt answers to a Microsoft Excel file using the MicroStrategy Intelligence Server SDK 9. The "One month" prompt used in the above example permits exactly one answer. You provide answers to a metric expression prompt in the body parameter of the request. Export Page-By Information: Selected by default. Click Advanced in the list on the left. Below is a screenshot of the MicroStrategy Web and PDF export with the 'Remove Extra Column' set to unchecked, notice how they both display the 'Metrics'. If there is no default answer, proceed to the next step. Add the prompt to a report. To confirm if the blank selector is tied to an invalid warehouse element, users can search the Definition XML file in the Flash debugger window (CTRL + ALT + SHIFT + D) for the previous attribute. Select the Save as prompted and Filter and template will be prompted radio buttons and the Set the current prompt answers to be the default prompt answers. For an introduction to prompts, how prompts save the report designer time, and how prompts work with MicroStrategy security filters, see the. MANAGE YOUR PROMPT ANSWERS Use these instructions to rename or delete your prompt answers. DssXmlExecutionDefaultPrompt on WebReportSource object, as shown below: Using prompts in documents. out. This can be accomplished by setting execution flag EnumDSSXMLExecutionFlags. No answer is provided to the required prompt so MicroStrategy cannot complete the report without user interaction. If the New Filter dialog box is displayed, click the Empty Filter icon. Step 4. Below is a screenshot of MicroStrategy Web and the PDF export when the 'Remove Extra Column' is checked, notice the top portion of the screenshot contains the word 'Metrics'. However, before changing the way MicroStrategy Web products look or behave, it is helpful to understand how the application is built. The Customize Value Prompt Answers dialog box opens. Click Help in the dialog box for details on each option. To answer only the required prompts with the default answers when all prompts are provided with default answers, follow the following logic. Set both of these prompts as optional by leaving prompt answer required unchecked. You can only use objects of one type in an object prompt. To provide a list of default answers for one of the three types of value prompt, select its check box and then click the Browse (. Select Any other prompts to configure a default "Answer prompt" option for any additional prompts added to the target dossier in. 6. Enter a new name for the personal answer and click OK. To create a prompt that allows the user to select the report, in the pane on the left, perform the following steps: Navigate to the report to use as the default prompt answer. Dim answerString As String. Enabled by default, the Enable caching for prompted reports and documents setting controls whether prompted reports and documents are cached. 4. If it does, the. 1. 2. Under Export Header and Footer section, click the Edit Custom Settings button. Determine whether users can save and reuse their prompt answers, and if so, how many prompt answers they. Dim report As report. Prompt details: Display the name of each prompt on the report, as well as the prompt answer that the user chose before the report was executed. Use the same answer from the source prompt; Use the default answer; Ignore the prompt; Click Save. Dim simpleprompt As PromptSimple. Add a filter on the Day attribute with the operator between and set a date prompt for both the start date and end date. Save and run the report. (See How to Use Hierarchy Prompts in MicroStrategy for more information. This can be accomplished using an Add-on. Excel with plain text: Export the report to Microsoft Excel as plain text. Create an integrity test. In MicroStrategy Tutorial: Create a target document. 1 iOS Update 4. ACTION: This interface can be customized as follows so that only a fixed width is displayed in the Selected prompt section instead of auto width. When this qualification appears, double-click to add a qualification, and select ID for Qualify On. If you clear the default answer for a value prompt and then reprompt the report, the default answer is displayed again. This feature is only implemented for element list prompts. This article shows how to answer prompts in a custom report Event Handler Using Prompt Answer XML in MicroStrategy Java Web SDK 9. PageSelection = EnumPageBy_PAGE_SELECTION_DEFAULT 'Define the page placement option to display all the pages in one worksheet. To avoid the mentioned issue, follow the provided steps for the same report in MicroStrategy Developer : Run the report and remove all the selected prompt answers. x. Select the folder in which to save the report, then type the name of the new report. The default levels that you define here are displayed when the prompt is executed. 4 HF5. x URL API Using the MicroStrategy Web URL API, it is possible to execute a report services document and indicate that the default prompt answers be used automatically. To add new users or groups to the object's access control list (ACL): Click Choose Users/Groups. The following procedure describes how to create a dynamic date filter based off of a prompt answer. Select "Project Defaults" on the left side. Upgrade the metadata to a newer MicroStrategy version. Launch the Prompt Generation Wizard in MicroStrategy Developer by going to File menu > New and choosing 'Prompt'. With Navigation Bar: Without Navigation Bar: enableCollab – If the value is set to false, the Collaboration. xls, . Create a new search object. Save them as a personal answer, naming it Southern Regions. To create a Metric Qualification prompt. An example of this is if the user changes these prompt answers to something other than the default for the subscription, when the prompt defaults are changed, the users would not want the subscriptions personalization to change to the new default. You can determine whether to have prompts in a report automatically answered when the report is run, using default prompt answers. For steps, see How to Determine If a Report Uses Default Prompt Answers. For steps, see How to Determine If a Report Uses Default Prompt Answers. In above example the default prompt answers of the underlying dataset of the document remain and are the one that are displayed. Click Export. x: From the Prompt Generation Wizard, select the 'Filter definition prompt' radio button, then select 'Choose from attribute element list' as shown. This is due to the date value prompt having a default value set as a dynamic date when created from MicroStrategy Developer. A prompt is a MicroStrategy object that allows user interaction at report run time. The prompts, which contain the default answers, are displayed as in any standard MicroStrategy report. Click Yes to confirm your action. The metric, 'Prompt answer' will display the prompt answer on the report, as shown below: If the metric 'Prompt answer' returns as blank, remove and re-add the metric, 'Prompt answer' onto the report in design mode. Re-execute the report. This is different from prompted reports. Its default value is true. KB46695: In MicroStrategy Web, default prompt answers continue to be displayed after saving a. The Attribute element prompt is the most restrictive, allowing users to choose from the fewest number of attribute elements to define their filter criteria. Once you have finished deleting personal answers and answering prompts, click Run Report or Run Document. When the prompt is used again (on this report or a different one), the personal answers are available. Sub Button_Answer_Prompt () Dim PSName, prjName, reportID As String. ) Step 2. Right-click the text box and choose the Edit Links option. In the source dossier, hover over a data point in the visualization and click the tooltip. Create a threshold using this metric to. A prompted report will present a prompt question to be answered before the report data is displayed. The level prompt is one of the most popular prompt types. How to create a filter definition prompt in MicroStrategy Developer The next time the report is run, the saved answers will automatically be used to answer the prompts and run the report. The filter panel prompts will show a blank screen. Select Date and Time, then click Next. Create a blank dossier or open an existing one. Specifies the ID(s), type(s) and name(s) of the object(s) to answer a prompt, or multiple prompts: NOTE: The type of the object is '4' for metric and '12' for attribute. Click More Options. Click More Options. Once you have finished renaming personal answers and. Go to the Data menu and select Re-prompt. You can leave this. Clear the prompt answers, and replace them with the Central region. The MicroStrategy SDK allows you to customize the standard MicroStrategy Web interface, and extend and integrate the MicroStrategy business intelligence functionality into other applications. If you select Prompt answer required without providing default answers, the report cannot execute on a schedule. Give the link a name. Create a report with Customer Age in the rows and the prompt created above in the report filter. Click Cancel, then return to Design View. Click OK. Reselect the prompt answers and then save and close the report once it has run. Select a default project drill map or click Clear to remove the default drill map from the field. Dim answer As String. Click the open folder icon next to “Load Answers” 4. You can add more default prompt answers by clicking Modify, which opens the Select Objects dialog box so you can select additional objects. To do this, you can switch to PDF View, which opens the Prompt Answer Wizard. On the File menu, point to New, and choose Prompt. Prior to MicroStrategy Update ONE Update 11, this field was named Use the selected objects as the answer. '. Click. Run the report. This tech note shows an issue in Prompt answer when using Chinese languageThis technical note describes an issue in which a prompt still shows a deleted element as the default answerTo export a report while viewing it: Click the name of a report to display it. They can be overridden at the report level, by accessing the Export Options dialog box for. On the left, select Export Reports. Configure the Integrity Test to Open the Reports in MicroStrategy Web. For steps to specify default prompt answers, see How to Determine If a Report Uses Default Prompt Answers. xThis document explains how to create value prompts using an attribute qualification in MicroStrategy Developer 9. For a more detailed explanation of the Empty answer prompt answer method, including samples, see the Linking Reports and Documents chapter in the Advanced Reporting Help. Adobe Analytics widget. Optional: Select the Save this answer when the report is run checkbox. Then it presents this data to the administrators, developers, and analysts to help them optimize the performance of. Choose one of the following options: To display all of the attribute's elements to the user when they are answering the prompt, select List all elements (no restriction). The prompt answer is stored in the IS tables ( Prompt answers are stored in stg_is_pr_ans_stats and dataload moves it into is_pr_ans_stats). Determine whether the prompt has a default answer already provided. The Prompt Ordering dialog box opens. Run the report and add both attributes from the object prompt so that they show up in the report objects. Thereafter, click "Apply" and the default prompt answer will be passed (not the empty prompt answer)Parameters Description; General Parameters. MicroStrategy SDK provides a plug-in (ZIP file) that can simply be extracted to the plugins folder to view the customization in MicroStrategy Web. Here's a link to MicroStrategy's documentation on the topic. Dim prompt As prompt. The Prompt Ordering option is displayed after a prompt has been answered at least once. The prompt is answered by the default prompt answer for the prompt in the target. Subtotals opens the Subtotals dialog box, which lists any. Click Up or Down to move selected entries in the list. 1, users can specify prompt answers at the report level by saving the prompts as default answers in MicroStrategy Developer or Web. 3. For information on how required prompt answers, default answers, and schedules interact, see Prompts in scheduled reports. Choose one of the following options: To display all of the attribute's elements to the user when they are answering the prompt, select List all elements (no restriction). Report Viewer menu bar options: Data menu. Users may decide to customize the look and feel of MicroStrategy Web and remove the interface link to access the MicroStrategy Web preferences. He can save his changes as a new. MicroStrategy Integrity Manager 10. For example, the user can enter information such as the. Step 3. exe using the command line. By implementing the security policies and configurations provided by MobileIron, administrators can apply enhanced protections to mobile devices in use across the enterprise. Click the name of the prompted report or document to run it. Select a default project drill map or click Clear to remove the default drill map from the field. KB287356: Unchecking 'Set the current prompt answers to be the default prompt answer' does not clear the default prompt an… Number of Views 2. Enable the "Save Results" and define the folder where the results should be saved. getID()); return. For information on how required prompt answers, default answers, and schedules interact, see Prompts in scheduled reports. xThe MicroStrategy Web JAR files can be found under: MicroStrategy Web Universal (JSP): {web_root}/WEB-INF/lib directory. Selecting a data point acts as a prompt answer. To delete the selected default prompt answer, click Remove. Next to the prompt for which the personal answer has been saved, click Load Answers. On the upper right of any page, click your user name, and then select Preferences from the drop-down list. xml under \WEB-INF\xml\layouts. In the Advanced Prompt Options dialog box, select or clear the check box to enable or disable a type of prompt resolution logic. Select the personal answer to rename, then click the Rename icon . After the prompts are answered, the document executes and displays the information according to the answers. Click the To: button. (A value prompt is a type of prompt that requires the user to type an entry in a field). If the target prompt does not have a default answer, the Empty answer method is used. MicroStrategy Web (. x preferences page: ASPx:When the attribute element is selected and then deselected from the prompt answer, the elements are not alphabetically sorted in MicroStrategy Web 9. Open the new dashboard the prompt is not encountered as expected. You can create a stand-alone prompt, or you can create a prompt that is embedded in a filter. In the Web Options window under Expression Properties, set the Default Qualification Type to "Select" and the Default Operator to "In List. 4. Click Save. 6. Excel: This allows the user to export the document to Microsoft Excel in . On the left, select Export Reports. Identify the prompt by providing the prompt ID, name or key, and specify the prompt type as EXPRESSION. Select the Link to MicroStrategy Web for unresolved prompts check box. The default prompt answer is always displayed when a value prompt is used, even if the default prompt answer was cleared and then the report is reprompted. The user is asked during the report resolution phase of report execution to provide an answer to complete the information. Prompts are a platform capability of MicroStrategy that refine the data displayed in reports, documents, and dossiers. These custom prompts give you more control than the default edit. To allow users to save and reuse a single personal answer, select Single. Create the first prompt and make the prompt answer required. The option is now displayed. 59K KB18529: When sending out a report with a dynamic date prompt in MicroStrategy Narrowcast Server 8. See the links below for steps to. Select the 'Advanced' tab, as shown below: Change the setting for 'Attribute element browsing' (circled in red above) to the limit that is desired for the project. ) Step 2. In General tab, under 'Prompt Details' tag, change the configure for options 'Include Prompt Titles' and 'Show attribute. This method is the default member of the collection. Under Tools -> Options, select "Display. When the prompt is used again (on this report or a different one), the personal answer is displayed. Options in this menu allow you to change the display of report data in a number of ways: Advanced Sorting opens the Sorting dialog box, which you can use to customize the sorting criteria in the report. This is a filter which contains a prompt on an attribute element list. If you do not want this dialog box to be shown in the future, select Don't show. promptAnswerMode *. Clear the prompt answers, and replace them with Central. Click the name of a prompted report to run it. Remove deletes the selected default prompt answer. The pieces that make up a prompt control how a prompt appears and how it functions. The syntax is: FileLocation is the path to the saved test file. This is fixed in MicroStrategy Mobile application 10 for iOSIn MicroStrategy 10. The prompt selection page will not be displayed to users. Community & Support Search Discussions Open A Case View My CasesFirst, MicroStrategy Developer locates the prompts depending on the position of the reports in the document. From the Data menu, choose Prompt Ordering. You can add more default prompt answers by clicking Modify, which opens the Select Objects dialog box so you can select additional objects. Click on Next until the Select default prompt answer(s) option: 5. Select your prompt answer from the left-side box to the right-side box. Execute the document C in MicroStrategy Mobile. dll for COM development (located in the Program Files/Common Files/MicroStrategy folder) on the Windows Environment. The prompt and default answer are ignored since the prompt is not required; the report is not filtered by the prompt. Using the MicroStrategy Tutorial project data, you might use all three regions as default answers for the prompt: Northeast Mid-Atlantic Southeast When you apply this prompt. 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. Give the prompt a default value and a minimum and maximum text length value, as shown in the example below: Click on the 'Next' button. 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. Your default personal prompt answer will automatically be selected as your. You can save prompt answer for a specific prompt and then reuse the answers on any report that uses the prompt; Add title and instructions for the prompt; Set default Web options for the prompt (accessible in MicroStrategy Developer) The following prompt types are. 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 Advanced Options for Exporting to Excel dialog box contains the following sections: This dialog box is accessed from the My Preferences dialog box ( My Preferences: Export category ), and these default settings are applied to all reports in a project. Community & Support Search Discussions Open A Case View My CasesCAUSE: This has been clasified as a defect in MicroStrategy Web 9. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform4. As mentioned in Stage 2, Integrity Manager starts with the answer file, as long as you set an "MSTR_PROMPT_FILE" environment variable. When you apply this prompt to the report and execute the report using the default answer, the report appears as shown in the following image. Providing specific prompt answers. Add the following filter to any report where the user wants to choose a set of values to qualify on the attribute. By default, the General preferences page is displayed. On the upper right of any page, click your user name, and then select Preferences from the drop-down list. 1 - Answers all required prompts and optional prompts with default answers. Make sure that the "Enable report server caching" is checked. Click Up or Down to move selected entries in the list. If both default answers exist, Integrity Manager. Click the General tab. Select a prompt style and click on 'OK. 5. Empty answer. Select the personal answer to rename, then click the Rename icon . xml under WEB. Loading × Sorry to interruptBy default, the element icon is displayed on prompt page in MicroStrategy Web, as shown below:The prompt is ignored; the report is not filtered by the prompt. config. Under Tools -> Options, select "Display Managed Objects" and "Display Managed Objects Only". 31K KB31969: Personal prompt answer is applied to a prompted report that has been saved with a different prompt answers in Mic…A prompt is a question presented to the user who runs the report. Therefore, prompts allow report designers to create reports that let users change the report content at run. By default, the first prompt from your prompted dossier is selected. Add the prompted report to the document as a dataset. A solution/code fix for this issue is available starting in version 10. Optional: Select the. You can add more default prompt answers by clicking Modify, which opens the Select Objects dialog box so you can select additional objects. You must perform the following general steps to add a prompt to a document: 1. This happened with the introduction of support for creating subscriptions of prompted reports with answers as a new feature in 9. When user executes the report, the prompt appears as shown below:The prompt details for the Category prompt display the word "All," meaning that all the categories are included on the report. You can use the URL API to pass certain types of prompt answers to the page being executed. In the Run Modes area, select the format (s) in which the document can be exported: •. For example, you can define a prompt as: 'Choose from a list of elements in Month'. Accept the other default values.