Adding Variable Prompts in AnalyticsA variable prompt allows users to select a value from a set of values that you specify in the prompt. There are two types of variable prompts:
A variable prompt is not dependent upon a column, but can use a column. The set of values in a variable prompt can be one of the following:
As an example of a variable prompt that uses custom values, you might want to allow users to see the revenue values after applying various levels of discount. To do this, you can create a presentation variable prompt and specify the values as 10, 15, and 20 percent. Then you create a new column in the analysis and enter the formula Revenue multiplied by the variable that you specified. As an example of a variable prompt that uses values from column, you might create a presentation variable prompt that uses the values of the Sales Stage column, and then create a filter in the analysis that uses the variable to filter on the selected sales stage. A variable prompt that uses the values of a column acts in the same way as a column prompt. However, variable prompts have the advantage that you can create multiple variable prompts using the values of the same column, whereas you can create only one column prompt for a given column. To add a variable prompt
|
Published 6/21/2021 | Copyright © 2005, 2021, Oracle and/or its affiliates. Legal Notices. |