So in the case that we need to change multiple columns, we will be executing multiple intermediate useless queries. In this blog article we will show a way of simulating the Column Selector view when we need to change multiple columns in a report. The requirement is to be able to switch between two reports that differ only in some columns in this case, a set of measures. First of all we need to create a Dashboard Prompt that contains the two possible values for the new Presentation Variable.
Then we will need to specify that this Dashboard Prompt is going to set a Presentation Variable. Create both reports separately adding a filter based on the Presentation Variable. Second, we are going to apply a filter condition in each report to force the report to return columns only when the Presentation Variable has a specific value.
Add Navigation to the Dashboard Sections including each of the reports. The goal is to apply guided navigation to a specific Source Request. Each section is going to refer to a particular report. For information about specifying selection steps, see "Working with Selections of Data". Determine which selection step you want to override with a column prompt and click its Edit button.
The New Member Step dialog is displayed. Select the Override with prompt box. Click OK and save the analysis. If needed, create either a named or inline prompt. For information, see "Creating or Editing a Column Prompt". An image prompt provides users with an image that contains sections or areas that they can click to select a specific prompt value.
For example, an image prompt can be a map of the United States with sections that represent the North, South, East, West, and Central sales divisions. Users can then click the divisions that correspond to the sales information that they want to view in the dashboard or analysis.
You can apply image prompts to one or more dashboards, or embed them in analyses. Use the following procedure to create or edit an image prompt. The Select Subject Areas menu is displayed. From the Select Subject Area menu, select the subject area for which you want to create the prompt. To create an inline prompt, either create a new analysis or access an existing analysis for which you want to create a prompt. In the "Analysis editor" , click the Prompts tab. Click the New button in the Definition Pane.
From the list, select Image Value Prompt. Enter a caption for the image prompt in the Caption field. The caption is displayed as the prompt's field label. This description is displayed as tooltip text, which is shown when the user hovers the mouse pointer over the prompt's label in the dashboard or analysis. The descriptions are also displayed when administrators view the stored prompt object from the Catalog Manager. The image file must reside on a web server. Placing the image files with the web resource files prevents a security warning message from displaying when the user accesses the image from the dashboard or analysis.
However, if you are using a web server, such as WebLogic, where the resource files are located in the deploy directory, you must put the image file in the deploy directory and the directory that contains all web resource files. In the map tags, indicate the map region's shape, X and Y coordinates, and region name. For example:.
For each area, in the Column field, enter the name of the column to pass when a user clicks it, and the value to use. If you are creating a dashboard prompt, then click the Save button in the prompt's editor, specify the folder in which you want to save the prompt, and give the prompt a descriptive name. If you want the selected prompt and all other prompts that follow it to be displayed in a new column on the prompt selection page, then click the New Column check box that corresponds to where you want the prompts to be displayed in a new column.
A currency prompt enables users to change the currency type that is displayed in the dashboard or analysis. When applied to a dashboard or embedded in an analysis, the prompt provides users with a list where they can select a currency.
The same list of currencies is displayed in the "My Account dialog: Preferences tab". Use the following procedure to create a currency prompt that you can apply to one or more dashboards, or to create a currency prompt that is embedded in an analysis.
Click the New button from the Definition Pane. From the list, select Currency Prompt. Enter a label for the currency prompt in the Label field. The label is displayed as the prompt's field label. The prompt displays in the "Definition pane". Use the following procedure to create a variable prompt that you can apply to one or more dashboards, or to create a variable prompt that is embedded in an analysis. For more information about variable prompts, see "Other Prompt Types".
For more information about variables, see "Using Variables". Navigate to the Oracle BI Enterprise Edition Home page, locate the global header, hover over the New menu to access the menu, and from the menu select Dashboard Prompt. From the list, select Variable Prompt. In the Prompt for field, select the variable type that you are creating and then enter the name of the variable.
In the Label field, enter a caption for the variable filter prompt. In the User Input field, select how you want the prompt interface to ask the user for input. For example, prompt the user with a radio button to select only one prompt value. If you selected either the Choice List , Check boxes , Radio buttons , and List box user input type, then you must also specify the prompt's list of values.
For more information, see "New Prompt dialog". Within the Options section, select the prompt options. The prompt options vary depending on the user input type that you selected. The prompt options allow you to further specify how you want the user to interact with the prompt for example, whether user input is required. In the Default selection field, select the prompt value that users see initially. If you select a specific value, then the Default Value field is displayed in which you can enter a value.
Create a new dashboard or open an existing dashboard and click the Edit Dashboard button. For more information about creating or editing a dashboard, see "Creating Dashboards". In the Dashboard builder's Catalog pane, locate and drag and drop the analysis onto a section in the dashboard.
In the Dashboard builder's Catalog pane, locate and drag and drop the dashboard prompt onto a section in the dashboard. Hover the mouse pointer over the prompt object in the Page Layout area to display the object's toolbar, click the Properties button, and select Scope. Note the following options:. If you select Dashboard , then the prompt affects all dashboard pages that contain the prompt. The prompt value that the user selects for the dashboard level prompt overrides values for page level dashboard prompts.
If you select Page , then the dashboard prompt affects only the page or pages to which you add the prompt. Use the following procedure to add a hidden dashboard prompt to a dashboard or dashboard pages. At run time, the hidden dashboard prompt sets the default values for all of the corresponding prompts on the dashboard or dashboard page, and the unprotected inline prompts that are located on the analyses on the dashboard or dashboard page.
Create and save a dashboard prompt, which contains specific data values, to use as a hidden prompt. For more information about creating prompts, see "Creating or Editing a Column Prompt". In the "Dashboard builder" , click the Tools button and select Dashboard Properties. The "Dashboard Properties dialog" is displayed. If you want to add the hidden prompt to the whole dashboard, then click the Filters and variables Edit button. The "Dashboard Filters and Variables dialog" is displayed.
If you want to add the hidden prompt to a dashboard page, then select the page from the "Dashboard Pages" table and click the Select a prompt to capture default filters and variables button, which is located above the "Dashboard Pages" table.
The "Filters and Variables - page dialog" is displayed. In the Dashboard Properties page, click the OK button to save the dashboard's properties. What are Column Prompts? Other Prompt Types In addition to column prompts, you can create currency prompts, image prompts, and variable prompts. For information about column prompts, see "What are Column Prompts? Check Boxes The Check Boxes input option provides the user with a visible list of all prompt values where a small, selectable box displays before each value item.
Constrained Prompts Use this method with several columns in a prompt to constrain the user's prompt choice based on subsequent choices. Filter operator is set to is prompted Use this method to build complex prompts that interact with filters. Selection Steps Override with Prompts Option Use this method to use an analysis or dashboard column prompt to provide the data choices for a specific member selection step on a hierarchical or attribute column. Rakesh April 25, at PM.
Sreejith S April 25, at PM. Anonymous March 7, at AM. Unknown March 10, at AM. Unknown June 21, at PM. But, also here some of the differences are matching. Especially important is the difference that you can force the input parameters to be pre-filled and by this you can force the user to pre-select some reporting space to reduce the amount of data pushed to the server.
And here also, in BW there are more consequences on prompts then filters, eg. Filter is working only on one data source. Of course in HANA the behavior is different. Design Studio is not filtering on any result sets by it self. But you can specify the variable in the "default" area right side and then the answer will be 1. I will try to ask or test by myself. I had already a question about filters and prompts - Design Studio 1.
Reset Initial View also brings no result. Skip to Content. Karol Kalisz. May 28, 2 minute read.
0コメント