In OBIEE 11g direct database requests has a limitation that,
it cannot be used for the prompts. To achieve that we can create an analysis
with the DDR, create a pivot view and drag the required columns to the prompts
area which will act as prompt for the report
Create direct database request
Enter connection pool and query
Click on Results. Result looks like below, we need a prompt
for this report.
Edit the report and add Pivot
Table view
Click on the column properties which you want to add as
prompt and select Duplicate Layer
Example:- JOB
Move JOB column to the Pivot Table Prompts Section
Click results now
No comments:
Post a Comment