How to make a drop down Prompt, in a Report based on an Analysis, work?
I've created the Analysis.
Which is used as the Datasource for a Dataset in a Datamodell.
The Datamodell is used in a Report.
I want to create a Prompt on this Report.
In the Document https://docs.oracle.com/cd/E36909_01/fusionapps.1111/e26386/create_data_sets.htm#T527103
I found the following Instruction:
Parameters and list of values are inherited from the BI analysis and they display at run time.
The BI Analysis must have default values defined for filter variables. If the analysis contains presentation variables with no default values, it is not
supported as a data source by BI Publisher.