Skip to Content

LOV's Tuning


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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Sep 18, 2014 at 07:55 AM

    How many LOVs are available for this object ?

    And check below documents to tune BO reports :

    1. Performance Tuning of BO reports

    2. Universe Optimization Techniques

    Let me know how it goes ..

    Regards,

    Pranay

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 18, 2014 at 05:49 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 18, 2014 at 07:47 PM

    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-prompts-screen

    Add comment
    10|10000 characters needed characters exceeded