Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 34 Oracle Analytics and AI Sharing Center
- 22 Oracle Analytics and AI Lounge
- 276 Oracle Analytics and AI News
- 47 Oracle Analytics and AI Videos
- 16.1K Oracle Analytics and AI Forums
- 6.3K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 99 Oracle Analytics and AI Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Sort drop-down list descendingly in Table Prompts in Analysis
Summary
How to sort drop-down list descendingly in Table Prompts in Analysis
Content
In OBIEE Analysis, how can table prompts value (per enclosed screenshot) be set to sort descendingly?
Thank you.
Version
Oracle Business Intelligence 11.1.1.9.0
Answers
-
Add the proper sort order column to the column you want sorted in the RPD.
0 -
Hello Christian,
Thanks for reaching out.
Could you help show how I can access the sort order column panel per your imgur link please?
Per enclosed 2 screenshots I have not been able to find where I can enter formula to perform the sort function.
If I access the "New Calculated Item" panel, which Oracle function could I enter to perform sort function to a column?
Best.
0 -
In the RPD, the metadata repository. Not in the frontend.
0 -
I do not have access to the RPD. Does that preclude myself to perform sort? Are there other ways around it?
Thank you.
0 -
You can write a query using LSQL in the prompt itself.
Do you have access to that?
0 -
Where in the prompt will I be able to access LSQL editor panel?
0 -
Sorry I just now realized that you're talking about an in-line prompt inside the table view and not a real dashboard prompt. In that case you're pretty much limited to what the analysis can give you. Set a sort order for in the criteria tab on "Calendar Month Code".
Sadly with no RPD access and using an in-line prompt you have very limited possibilities.
0 -
No problem.
Turns out the prompt is right-click friendly, and doing so open a "Sort" option.
Thank you very much.
0