cancel
Showing results for 
Search instead for 
Did you mean: 

Hierarchy Prompt performance issue

Former Member
0 Kudos

Hi,

  We have used Dashboard Design tool to design Sales dashboard which has selector based on hierarchy LOV

Environment: BO 4.1 SP2 & BW 7.3 on HANA 1.7

Issue:

The overall query performance to fetch the actual dashboard data is quite satisfactory (within 2 secs), however the Query Prompt Selector takes long time to populate hierarchy LOV. (Hierarchy input variable in Bex query can only be binded to Query Prompt Selector). Unfortunately, each time the user selects a  hierarchy node the dashboard executes a call to BW to retrieve the lower node.

In our scenario, there are 7 node levels and each node level has 5-20 values. When a user drills down from Node L1 to L2, a call is made to BW which takes 6-7 seconds to fetch the next level LOV. When they further wish to drill down from L2 to L3, another call is made to BW and so forth until the
lowest node.

 

Is there a way or work around to populate all the node level values  in one go rather than making multiple calls. Due to this Query Prompt Selector behavior the performance has really hindered.

Regards,

Ritesh

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi,

Why don't you create a Universe on top of BW data with LOVs and use query browsers to select the values.

There by it would be faster.

Arun

Former Member
0 Kudos

We are using BICS connection in query browser to call bex query in dashboard. Universe route will further slow it down.

Former Member
0 Kudos

Hi Ritesh,


I guess the way you are implementing the query in Dashboard is the optimum way.
If you go through BICS it will be slow.

There is a way where you can select during the creation of query in Dashboard how may levels to expand and display at the initial load. But again the initial load will be slow.

You could try that and see how it works for you.

Former Member
0 Kudos

I believe you meant universe connection will be slow.

We have already  tried expand options. It further slows down the dashboard.