Working with Prompts
Prompts enable users to specify criteria that determines the content of the view that they are inserting. Oracle Smart View for Office supports both prompts and page prompts. See Working with Page Prompts for information on page prompts.
Prompts in Smart View are the equivalent of prompts in Oracle Analytics Cloud. Smart View only supports column prompts.
Prompts are defined at the analysis level in Oracle Analytics Cloud. Users are prompted to enter values for these prompts each time a view is inserted in Smart View.
If prompts are defined on an analysis in Oracle Analytics Cloud, then when you insert a table, pivot table, or graph view from the analysis into Smart View, you are prompted to select the data to be displayed for that view. When inserting a compound view from an analysis that has prompts defined, you are prompted to enter values only one time for all the views in that compound view.
For example, a prompt on Year is designated for an analysis, and the years 2010, 2011, and 2012 are available to choose from. When you insert a table, pivot table, or graph, you are prompted to select which year's data to display: 2010, 2011, or 2012. Or, you can choose to insert the compound view, and the prompt selection you make is applied to all the views inserted. After insertion, you can edit the prompts on each individual view to select another year's data to display.
Views can only be edited individually. The edit operation will prompt you for the values to be selected for each view that is being edited.
You may edit prompts in views that were inserted, or copied and pasted.
Note:
Prompts defined on hierarchical columns in Oracle Analytics Cloud are not supported in Smart View.
To edit prompts: