For the OBIEE prompts to be used for BIP reports and to pass (All Column Values) and also multi select you can use the following SQL in the datamodel
In this, you can lease the prompts defaulted to 'Null' or blank and the variable will pass this null values to the BIP report and will return all the available results
In this, you can lease the prompts defaulted to 'Null' or blank and the variable will pass this null values to the BIP report and will return all the available results
Hope this help some of you folks..
0 comments:
Post a Comment