Skip to Content
avatar image
Former Member

Xcelsius Dashboard Performance-Taking long time to load data for prompt selection

Hi All,

I have a SAP BW BEx query which has 1 mandatory prompt and 2 optional prompts.

Developed a Dashboard from the above query using BICS connectivity. In the dashboard for prompts, I used "Query Prompt Selector" component shown in the below screenshot.

When selecting from the drop-down list of each prompt, the time taking to load the data on the dashboard for that selection is taking more than 80 seconds which is not being accepted by the user. (The BEx query is responding within 5 sec when checked with DB Stats time in BW system.)

Pls. Suggest me the ways I can reduce the data loading time into the dashboard for selection of a value in the respective prompt.

Regards

Ram


prmt.PNG (4.5 kB)
prmt2.PNG (9.0 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jan 05, 2015 at 11:28 AM

    Hi

    1st> try to use a combo-box instated of query prompt selector

    2nd>


    pastedImage_0.png (20.1 kB)
    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      Just to add, you need to break this query, and only load the query (check with refresh query on load option) for queries which is populating the graphs on the first look, un check the refresh components before loaded option for all queries not used in the components which don't display at first load.

      However in this case it will be important to have a trigger cell binding to a cell which has a formula

      1. simple case

      =concatenate(a1,b1,c1) where a1= sales org combo destination cell, b1= cal month combo destination cell, c1 =division combo destination cell (this will make sure any of the prompt changes in any of the sales org, cal month, division refreshes the query and populates the data

      i can help you with more complex trigger condition for query if this sounds relevant to you.