Using the MicroStrategy Java Web SDK 9. 4. Please refer to TN 30086 for generating prompt answers in XML format using MicroStrategy Office 8. Thereafter, click "Apply" and the default prompt answer will be passed (not the empty prompt answer)Parameters Description; General Parameters. Create a blank dossier or open an existing one. The resolution server will go through the prompt as following sequence: document level, dataset level, prompt level. Create an integrity test. In the source dossier, hover over a data point in the visualization and click the tooltip. WORKAROUND: A possible workaround is to select the default prompt answer from MicroStrategy Developer. For information on how required prompt answers, default answers, and schedules interact, see Prompts in scheduled reports. 1. 4. To pass the prompt answer for an element prompt when the attribute has a compound ID, you separate each ElementID with a colon. Using the MicroStrategy Tutorial project data, you might define the default answer for the prompt to be Revenue > $1,000,000. This happened with the introduction of support for creating subscriptions of prompted reports with answers as a new feature in 9. Save the prompt as "Call Center Prompt". ). The option is now displayed. To select the metric (s) for which users can define their filters, on the Definition tab, choose one of the following options: Choose a metric: Browse to and select a specific metric to use. x-10. Any report can contain prompts. When a Report Services document with a prompt is delivered using MicroStrategy Narrowcast Server 9. The metric can show only value prompt answers. Every time a user sees the prompt, he must answer it manually (if it is required). If you want the report to use default prompt answers, select the answers that you want to save as default prompt answers. For instructions, see Using non-default personal answers for prompts. This customization scenario showcases how to use JavaScript to validate prompt answers once they are submitted. 1 and 10. Create a filter on attribute "Month" and click "Prompt. Applies to object prompts and. Select different prompt answers such as with Year 2008 and 2009. Next to the prompt for which the personal answer has been saved, click Load Answers. Sub Button_Answer_Prompt () Dim PSName, prjName, reportID As String. The syntax is: FileLocation is the path to the saved test file. The 'Choose a Prompt Style' dialog box opens. Remove deletes the selected default prompt answer. This is a filter which contains a prompt on an attribute element list. To delete all the default prompt answers, click Clear. How to Change the Default Saved Prompt Answer in MicroStrategy How to Rename or Delete Saved Prompt Answers in MicroStrategy How to Use Saved Prompt Answers in MicroStrategy How to Use Hierarchy Prompts in MicroStrategy How to Save Your Personal Prompt Answers in MicroStrategy. Reselect the prompt answers and then save and close the report once it has run. Open up MicroStrategy Web and sign in as the administrator. To use the default prompt answers defined in the prompt, clear the Set the current prompt answers to be the default prompt answers check box. A prompt is created that lists all the project's reports when the report is run, with the selected report as the. x will use the saved default prompt answers when executing the report. x: From the Prompt Generation Wizard, select the 'Filter definition prompt' radio button, then select 'Choose from attribute element list' as shown. Execute the report again > `Books` is still displayed as default prompt answer in the prompt resolution. Why MicroStrategy Why MicroStrategy; Customer Stories; Platform Products; MicroStrategy ONE; AI & Augmented; Dossier; Library; Workstation; HyperIntelligence; Multi-Cloud; Embedded Analytics. From the Personal answers allowed drop-down, select one of the following:. 12) Re-prompt the report, remove "Books" as the prompt answer and choose "Music" as the unique prompt answer. SUMMARY: In MicroStrategy Web SDK 10. Here is a sample workflow for using REST APIs to answer prompts: Create an instance of a dossier, document or report. To do this, you can switch to PDF View, which opens the Prompt Answer Wizard. Click the General tab. This technical note documents the steps to create a required prompt that will be hidden from users without permission to use the prompt. We have found that educated users are more likely to use the product on a daily basis. Description. Answering a prompted report differently each time it is executed is one way to ensure that a report is executed against your data. From the toolbar, select Run Report. With Navigation Bar: Without Navigation Bar: enableCollab – If the value is set to false, the Collaboration. These components include the following: Answer requirement: This component lets you determine whether users will be required to answer the prompt or an answer will be optional. Enter the answers in the dialog box and click Close. Select the Keep report prompted checkbox. Stage 3: Run a test in Integrity Manager and check the prompt answer source in the result details. save the report and choose to save as Prompted and Set the current prompt answers to be the default prompt answers as shown in the image below Edit the object prompt created in Step 2 and remove the attribute Customer_ID from the pre-defined list of objects . From the Choose a Permission Level drop-down list, select the predefined set of permissions, or select Custom to define a custom set of permissions. To delete the selected default prompt answer, click Remove. Dossiers with MicroStrategy 10. Set Freeform SQL and MDX objects default security. Answer For Each oElement In oElements answerList. Filename. The prompt is answered by the default prompt answer for the prompt in the target report. Selecting a data point acts as a prompt answer. config. Platform Analytics is the new monitoring tool in MicroStrategy 11. It will prompt for Country, Region and Call Center one by one in different pages. You have now selected your prompt answer. Choose Add Data > Existing Dataset to add data. Execute the report and answer the prompt. How to Execute a Prompted Report Services Document and Automatically Use the Default Prompt Answers using the MicroStrategy Web 8. Execute a report that already contains a prompt that is using a Default personal prompt answer. Update application badge with the value of this metric: Select this option to update the badge next to the. The default prompt answer can be found at the bottom of the value prompt if the prompt has a default answer in MicroStrategy Web Universal 8. In above example the default prompt answers of the underlying dataset of the document remain and are the one that are displayed. 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. In MicroStrategy Web, there is a option in sys_defaults. Choose Value prompt -> Text prompt. Click Save and Close to save your filter and close the Filter Editor. Southeast, Southwest, and South are displayed as the default prompt answers, since they were defined as the default above. Prompts in a document provide rich interactivity, allowing each user to display the data relevant to him. If you created a new dossier, you must save the dossier before adding an existing dataset. This article describes a workaround to defining dynamic default prompt answers. 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. Southeast, Southwest, and South are displayed as the default prompt answers, since they were defined as the default above. 0, it is possible to programmatically access the default answer expression embedded in a prompt of a report definition. Since the second prompt is optional, make the related SQL query dependent on the. Step 2. Click More Options. The prompt selection page will not be displayed to users. Then click "Run Report". Then make changes on the report as needed, such as: Change sorting; Add View Filter; Add or remove attributes/metrics from the report; Step 2. The saved file must be a . In the Name box, enter a meaningful name for your saved prompt answer. Click the name of a prompted report to run it. To Answer a Prompt by Selecting Answers From a List. All articles. Add the prompt to the local Report Filter area. Click Add, select the elements, then click OK. You provide answers to a metric expression prompt in the body parameter of the request. 2. Stage 3: Run a test in Integrity Manager and check the prompt answer source in the result details. When you execute the document, the. MicroStrategy Developer answers the prompts on the first report; then, answers the prompts on the second report and so on. The prompt is answered by the default prompt answer for the prompt in the target. The prompt and default answer are ignored since the prompt is not required; the report is not filtered by the prompt. KB46695: In MicroStrategy Web, default prompt answers continue to be displayed after saving a document with the "Display p… Number of Views 3. The report is saved with active prompts. Dim status As EnumMOIErrorStatus. KB18540: How to automatically answer nested prompts in. To prompt for multiple object types in the same report, you must create an. Users can store prompt answers and use them the next time they execute a report or define them as the default answer. Next to the prompt for which the personal answer has been saved, click Load Answers. WebObjectSource wos = webObjectFactory. To require that the user answer the prompt at run time, select the Prompt answers required check box. Click the Load Answers folder icon, then click More Options… at the bottom of the pop-up window. Finally, you can choose whether to include unused prompts. Here's a link to MicroStrategy's documentation on the topic. exe using the command line. The reuse property of the prompt answer. opReuse. By default, this option is selected, as shown below: After customization: Follow these steps to achieve this customization: In the Web Customization Editor,. Interact with the engaged MicroStrategy Community to get answers to all your. Add one attribute to the rows and one attribute to the columns. On the New JavaScript Wizard, click Next and Finish. In the Run Modes area, select the format (s) in which the document can be exported: •. The report is not executed. You can use REST APIs to perform the following action on value prompts: Answering a value prompt. Select the folder in which to save the new prompt, enter a name, and. If the prompt is required, the prompt is still executed when a user clicks this link, since a prompt answer must be. STEPS TO REPRODUCE: In MicroStrategy Desktop, create an attribute prompt on the Day attribute. Create a FreeForm SQL Report and add this nested. Select different prompt answers such as with Year 2008 and 2009. In MicroStrategy Web, while creating a prompt, you can allow personal answers for the prompt, if the administrator has enabled personal answers in the default settings for. Ignoring Target Prompts: Using the Empty Answer Method. If you select Prompt answer required without providing default answers, the report cannot execute on a schedule. In the Options dialog, open the General -> Diagnostics folder. This filter, which will be used on the report, returns the dates between the date selected in the prompt and one month before the prompt answer. 8. Right-click oivmCustomPrompt and choose Create new JavaScript. Call oRes. Execute one of the following options: To specify default prompt answers, click on 'Add'. Execute the report > `Books` is displayed as default prompt answer. After the prompts are answered, the document executes and displays the information according to the answers. Dim reportLocation As reportLocation. To do this, you can switch to PDF View, which opens the Prompt Answer Wizard. Click the a|b button to rename the selected answer or click the X button to delete the. For more information, see How to Save a Report. Click 'OK'. The demo is introducing the structure but you can get very creative with these URLs. Using URL API to re-run the current document does not preserve the previously selected prompt answers and displays the default prompt answers instead. KB287356: Unchecking 'Set the current prompt answers to be the default prompt answer' does not clear the default prompt an… Number of Views 2. To create a Metric Qualification prompt. Execute the report to see the prompt again. Hierarchy prompted reports show the default prompt answers instead of the current prompt answers in MicroStrategy Mobile 9. In an environment where the majority of reports are prompted and each prompt is likely to receive a different answer each time it is used, the probability of matching an existing cache is low. 94K KB46695: In MicroStrategy Web, default prompt answers continue to be displayed after saving a document with the "Display p…Advanced Prompts: Enabling User Input. xSUMMARY: This Technical Note explains how a user can develop an add-on for the report page that will to programmatically pre-populate the prompt answers for a nested prompt that has an underlying report as a filter then retrieve the new prompt answer XML with MicroStrategy Web SDK 9. Use. This issue is due to the selected prompt answers section being set to auto width by default, so it expands to accommodate the lengthy and/or numerous prompt selections. Set this personal answer as the default (select the Set as default checkbox). A user can keep the personal answer, or add or delete selections. The URL parameter to answer value prompts should appear in the format below:4. Your default personal prompt answer will automatically be selected as your prompt answer. For example, you can include metrics or attributes in a single object prompt, but not both. x, it is possible to programmatically create subscriptions for report and documents, answer prompts and save the subscriptions as personalized. (Highly recommend for understanding your exported data). Set the default run mode to be "Export to Excel", like shown below. If it does, a default answer appears in the far right pane of the prompt window. To Allow Personal Answers for Prompts. If you select Prompt answer required without providing default answers, the report cannot execute on a schedule. All the report prompt details auto text codes in the document: Select Document Properties from the Format menu. Often, the default prompt answers made available to end users change. If the prompt answer is invalid, no data is returned. " Click OK. The objects are added to the default prompt answer table, with standard filtering and grouping. Click Create on any page, point to New Prompt, and select Metric Qualification Prompt. Sample: See the following MSDL link for a guideline of how this custom addon code can be implemented on the exportBinary page. No. 4Watch free 3-5 minutes tutorial videos, with subtitles available in 9 languages, to build product fluency! Start learning. About prompts. For example, you can include metrics or attributes in a single object prompt, but not both. The Default Prompt Value page opens. These custom prompts give you more control than the default edit links and can come in handy when advanced developers want to get creative. By default, MicroStrategy merges related security filters with OR and unrelated security filters with. Whenever a Freeform SQL report is created, a shortcut is placed in that schema folder by default. For steps to include a prompt on a report, see Reports: Adding prompts to a report, metric, or filter. The prompt is not answered. Click Save. This prompt answer method answers the prompt using the object selected in the source (in this case, region). (See How to Use Hierarchy Prompts in MicroStrategy for more information. If it does, the. To delete all the default prompt answers, click Clear. x URL APIReturn a prompt answer from the collection by index number in the range 1-->Count. The prompt is not answered. x: "Filtered element. By default, MicroStrategy creates value prompts for each imported input parameter (since parameters are answered by providing only one value, whether it is numeric, date, text, etc. Click it to select additional default answers. The resolution server will go through the prompt as following sequence: document level, dataset level, prompt level. To delete the selected default prompt answer, click Remove. This parameter can provide a single value prompt answer, or it can provide multiple value prompt answers by separating the prompt answers with a caret character ("^"). Prompt answer xml is generally useful to have for debuging or developing new features. If the prompt is required, the prompt is still executed when a user clicks this link, since a prompt answer must be. A prompt is a question the system presents to a user when a report is executed. 2. The example given will allow you to select a date, and the report will bring back all dates between the date selected and 1 month before. Click the name of the prompted report to run it. 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 New Prompt page opens. Create the Filter. 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. The. (A value prompt is a type of prompt that requires the user to type an entry in a field). Click on 'Modify' to determine how the prompt will appear in MicroStrategy Web. '. The following URL API link will provide access to the MicroStrategy Web 10. Your default personal prompt answer will automatically be selected as your. This is due to the date value prompt having a default value set as a dynamic date when created from MicroStrategy Developer. Select a prompt answer and click Apply. Determine whether the prompt contains saved personal answers, which allow a user to save prompt answers for a specific prompt, and then reuse the answers on any report that the prompt is used on. The New Prompt page opens. 1, duplicate emails a…In MicroStrategy 9. x and above, the interface offers a search option followed by a Match Case check box. Click Export. For steps, see the Basic Reporting Guide. Step 2. Select the Save this answer when report is run checkbox. Save the report. Dim config As ConfigOptions. 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. The "One month" prompt used in the above example permits exactly one answer. A prompt is a MicroStrategy object that allows user interaction at report run time. Now offering. This not only allows for dossiers to have personalized information, but also improves performance by processing only the. To rearrange the display order, select the object to move and click the Up or Down arrow. promptAnswerMode *. . For example, the user can answer the Northeast region or 2002, and the appropriate data is returned from the data warehouse. This happened with the introduction of support for creating subscriptions of prompted reports with answers as a new feature in 9. This area gives the user the ability to rename the report from the prompt screen. handleDefaultRequest(keys); default: System. The General Information page opens. 4. The option is now displayed. 11) Open the same Report in MicroStrategy Web and choose "Books" as the prompt answer. To create a list of attribute elements from which users can choose, select Use a predefined list of elements. Dim prompts As prompts. Select the Save this answer when report is. Click Add, select the elements, then click OK. Choose a prompt. Number of Views 10. println("other event called:" + event. 1 and above. "The prompt is ignored; the report is not filtered by the prompt. You can create a stand-alone prompt, or you can create a prompt that is embedded in a filter. Reselect the prompt answers and then save and close the report once it has run. It allows the caller to provide a list of attribute elements from which a selection is made. 1. 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. Open the static report in Design View mode. Using the MicroStrategy Tutorial project data, you might define the default answer for the prompt to be Revenue > $1,000,000. Empty answer. If the document contains a prompt that is in more than one report, it will ask for it on the first report. When there are multiple prompt answers,. Click Cancel, then return to Design View. To Allow Personal Answers for Prompts. An Attribute Qualification prompt can be used in an Attribute form qualification. Step 3. For steps to include a prompt on a report, see Reports: Adding prompts to a report, metric, or filter. For example, users can define a level prompt at the country level and apply it to a cost fact, as shown below, to generate a new Cost_Level_Prompt metric that aggregates the sum of Cost at the country level. It is possible to programmatically export a document containing default prompt answers to a Microsoft Excel file using the MicroStrategy Intelligence Server SDK 9. You can set this personal answer as the default, so that it displays when you are presented with this prompt again, either on this report or another. The Prompt Ordering dialog box opens. Then it presents this data to the administrators, developers, and analysts to help them optimize the performance of. Under Export Header and Footer section, click the Edit Custom Settings button. 3. Optional: Select the Save this answer when the report is run checkbox. Create a new search object. In the layout tab, click "Allow multiple selections". 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. ) next to Run this report or document to find and select the target report or. Select the users or groups that you want to add to the object's ACL. The New Prompt page opens. Metric details: Display the names of the objects on the report and the definitions of the metrics on the report. xThe MicroStrategy Web JAR files can be found under: MicroStrategy Web Universal (JSP): {web_root}/WEB-INF/lib directory. The prompts, which contain the default answers, are displayed as in any standard MicroStrategy report. Single: Only one personal answer can be saved for this prompt. Click Next and for the Select Default Prompt Qualifications, click the Add button. MicroStrategy Integrity Manager 10. x-10. When you execute the report in the future, you are prompted for answers again. The following procedure describes how to create a dynamic date filter based off of a prompt answer. promptAnswerMode *. The Prompt Ordering option is displayed after a prompt has been answered at least once. For steps, see How to Determine If a Report Uses Default Prompt Answers. x - 10. Navigate to the prompts (This page is used for answering prompts in the Mojo OIVM page) page, right-click, and choose Duplicate -> by making a copy of this page. Dim prompt As prompt. Click on 'Finish' and save the prompt. 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. Select a prompt answer and click Apply. 94K KB46695: In MicroStrategy Web, default prompt answers continue to be displayed after saving a document with the "Display p…To create an object prompt. Run the report. A prompt allows a user to provide an answer to restrict or filter data during report execution. From the Answer prompt drop-down, select how your selected prompt is answered. &showPrompts=2 represents executing a dashboard showing the prompt page with the default answers chosen. It's ok if there is already a prompt answer in the collection that corresponds to the same prompt but there can only be one prompt answer per prompt that is designated as the default answer. Select the item, and use the right-pointing. For steps to specify default prompt answers, see How to Determine If a Report Uses Default Prompt Answers. Create an integrity test. These components include the following: Answer requirement: This component lets you determine whether users will be required to answer the prompt or an answer will be optional. If the prompt already has an answer (a filtering condition) in the right pane, you can do one of the following:Create a list element prompt for Distribution Center. Click the name of the report to run it. Create the first prompt and make the prompt answer required. Under Tools -> Options, select "Display. Instructions: Step 1. Step 1. You can specify a minimum value even if you do not specify a maximum value. Why MicroStrategy Why MicroStrategy; Customer Stories; PlatformSteps to import prompt values from a file. If you do not want this dialog box to be shown in the future, select Don't show. By default, the General preferences page is displayed. For information on how required prompt answers, default answers, and schedules interact, see Prompts in scheduled reports. 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. Create and save the prompt. x. Select the personal answer to delete, then click the Delete icon . ; In Answer restrictions, set the minimum and maximum values that can be entered by the user. 1, users can specify prompt answers at the report level by saving the prompts as default answers in MicroStrategy Developer or Web. When a prompted document is executed via an URL-API link containing prompt answers, MicroStrategy Web will send a “run document” request first and an “answer prompt” request second. 1 iOS Update 4. Keep the default value for the end. From the Home menu, select Export, and then select one of the following export formats: PDF: Export the report to an Adobe PDF file. This parameter may also take the values of 1 and 0, for more information refer to KB35782 "How to force the prompt to be displayed on iPad devices when executing prompted document when using MicroStrategy Mobile App. Full control. Minimum number of qualifications – set the minimum number of answers required for this prompt 5. 4. Click. Click Save. The Document Properties dialog box opens. Once you have finished renaming personal answers and. Therefore, prompts allow report designers to create reports that let users change the report content at run. 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. The default prompt answer can be found at the bottom of the value prompt if the prompt has a default answer in MicroStrategy Web Universal 8. If it's a text file (. This technical note describes an issue in which a prompt still shows a deleted element as the default answerThis Knowledge Base article describes a known issue that has been classified as a defect by MicroStrategy. You can also set a default prompt answer, which allows the user to complete report execution quickly, as they do not need to answer the prompt but can. 1. ) Step 2. dll for COM development (located in the Program Files/Common Files/MicroStrategy folder) on the Windows Environment. To clear the default prompt answers, reprompt the report, remove all the answers, run, and save the report keeping the option ' Set the current prompt answers to be the default prompt answers' enabled. If the New Filter dialog box is displayed, click the Empty Filter icon. prompt, MicroStrategy retrieves data for every Fund L5. In the warehouse change the attribute ID from `Books` = 1 to `Books' = 2. 6. To allow users to save and reuse a single personal answer, select Single. If you require an answer, it is a good idea to also provide a default answer, otherwise a subscription to this report will fail. 2 - Closes all optional prompts with an empty answer. To Answer a Prompt by Defining a Filter Based on a Metric. You can use REST APIs to perform the following action on attribute element prompts: Closing a. The answers from the list are used in the order that they are listed in the table. MicroStrategy SDK provides a plug-in (ZIP file) that can simply be extracted to the plugins folder to view the customization in MicroStrategy Web. Adobe Analytics widget. Place the attribute, 'Month,' the filter, 'Revenue limit,' and metrics, 'Revenue' and 'Prompt answer' in the report. The report is exported in.