Forum Discussion

SauravSarkar's avatar
SauravSarkar
New Contributor II
8 months ago

Performance of tabbed dashboard vs Index type dashboard.

Hi All ,

I was trying to build a dashboard with a Index or a guided List like below. For the below dashboard these are the steps I took : 

a. Created A Delimited Parameter  with all the reports 

b. Created an embedded dashboard with the value of this parameter 

c. Created a List Box with the delimited parameter. 

So on the Main dashboard when one click on any of the values on the list , the Dashboard opens on the right. 

Although it works , I noticed that the performance of the dashboard is quite bad compared to if I create the same dashboard with tabs .  Both the dashboards are using the same underlying cube view then why is there a difference in Performance ? 

Is there something wrong with my approach ? 

Tabbed dashboard

 

Regards,

Saurav

Dashboards
Reports
  • Henning's avatar
    Henning
    8 months ago

    Hi, yes, that is in line with my expectations without knowing anything else about your solution. Tabbed dashboards (that are not using dynamic dashboards) load all tabs in memory when the dashboard is opened. That is a heavier burden on memory, but as it keeps all tabs in memory, it is faster to display a report when you click on a different tab. 

    Using a combo box does not load all reports to memory, but opens them when a user clicks on a new selection. This one may be slower in opening individual reports, but is less of a drain on the server's memory as it is not keeping all of the tabs in memory.

  • Henning's avatar
    Henning
    Valued Contributor II
    8 months ago

    Hi, what do you mean by "performance is quite bad"? Do you mean when you click on a different parameter, it takes much longer for the report to display? Or do you mean that scrolling and in the report is slow? Or something else?

    • SauravSarkar's avatar
      SauravSarkar
      New Contributor II
      8 months ago

      Hi ,

      On the Dashboard with Index - when you click on one of the reports it takes longer to render and showcase the report rather than when the dashboard is in Tabbed format. For example : The Balance sheet check report takes around 4 secs to display in the Dashboard with Index but in the Tabbed dashboard it displays in 0.3 secs . 

      I have checked the Activity logs to confirm it . 

      • Henning's avatar
        Henning
        Valued Contributor II
        8 months ago

        Hi, yes, that is in line with my expectations without knowing anything else about your solution. Tabbed dashboards (that are not using dynamic dashboards) load all tabs in memory when the dashboard is opened. That is a heavier burden on memory, but as it keeps all tabs in memory, it is faster to display a report when you click on a different tab. 

        Using a combo box does not load all reports to memory, but opens them when a user clicks on a new selection. This one may be slower in opening individual reports, but is less of a drain on the server's memory as it is not keeping all of the tabs in memory.