cancel
Showing results for 
Search instead for 
Did you mean: 

LOV's Tuning

former_member587467
Participant
0 Kudos


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

Accepted Solutions (0)

Answers (3)

Answers (3)

former_member4998
Active Contributor
0 Kudos

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/

http://scn.sap.com/community/semantic-layer/blog/2014/06/11/how-to-sort-the-list-of-values-in-the-pr...

Former Member
0 Kudos

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

former_member203850
Contributor
0 Kudos

How many LOVs are available for this object ?

And check below documents to tune BO reports :

1.

2.

Let me know how it goes ..

Regards,

Pranay