on 09-18-2014 8:31 AM
Hi ,
For my report List of Values are taking long time to load.
Can you please help me how we can tune that List of values at Universe or report level.
Thanks
Siva
HI
The following possible options you could think of for performance improvement.
If LOVs are more, you should consider using cascading prompts.
http://dwbicastle.com/2013/12/09/cascading-prompt-cascading-list-of-values-universe-designer/
Create an INDEX on that table column that you are going to use for LOV (Create an index-aware prompt) Find the below link for more info.
http://scn.sap.com/docs/DOC-45263
Check with DBA on indexing it, Other alternative is Cache the LOV file on Lov server.
If the List of Values are to be retrived from database and the table is huge. Create a a table with only required list of values (LOVs) and then define the LOV query based on the new table.
If the LOVs are huge, you could probably restrict the number of LOVs to be shown to users in CMC.
Find the below links for more info
http://events.asug.com/2012BOUC/0609_The_Undervalued_List_of_Values.pdf
http://scn.sap.com/docs/DOC-20222
http://www.dagira.com/2007/10/26/index-awareness-part-i-the-basics/
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Shiva,
Are there lots of prompts in the report? If yes, make sure that "Automatic refresh before use" option is unchecked in the object properties at universe level.
With this, the prompts will pop up quickly without loading the LOVs.
Users can refresh the LOVs in case required using Refresh option present in the prompt window.
Hope it will help.
Regards,
Yuvraj
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
81 | |
24 | |
11 | |
9 | |
7 | |
5 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.