Sort drop-down list descendingly in Table Prompts in Analysis

Jonathan Chan gmg

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

Christian Berg-0racle

Add the proper sort order column to the column you want sorted in the RPD.

https://imgur.com/hXE0oyt

Jonathan Chan gmg

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.

 

Christian Berg-0racle

In the RPD, the metadata repository. Not in the frontend.

Jonathan Chan gmg

I do not have access to the RPD.  Does that preclude myself to perform sort?  Are there other ways around it?

Thank you.

 

 

Christian Berg-0racle

You can write a query using LSQL in the prompt itself.

Do you have access to that?

Jonathan Chan gmg

Where in the prompt will I be able to access LSQL editor panel?

 

 

Christian Berg-0racle

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.

Jonathan Chan gmg

No problem.

Turns out the prompt is right-click friendly, and doing so open a "Sort" option.

Thank you very much.