Xcelsius with BW Queries taking a lot of time to open/save/publish

[Former Member]

I have recently designed my first Dashboard using Xcelsius 2008(5.3.0.0, Build Number 12.3.0.670) connected to BW queries(we are on 7.01 SP 5) using SAP Netweaver BW Connection. While the file size jumped from 3MB(before connecting to BW Queries) to 88 MB (after the connections to BW queries). I have 10 Bex Queries embedded in the Dashboard and every time I'm trying to open the Xcelsius file, it takes a lot of time(as long as 15 minutes) and even if I make a small change and save it, it takes another 15-20 muntes and while Publishing it to BW role it is taking another 15-20 minutes.

I'm sure we are missing something here and thus running it to this issue. Can someone throw some ideas please?

[Former Member]

All the Queries hardly take few seconds.

[DebjitSingha]

Can u check how many no of rows/ columns that each query is populating. I am doubtful that if you are designing your dashboard on a detailed level data the Excel performance might affect the dashboard performance.

Edited by: Debjit_Singha_86 on Feb 21, 2011 9:32 AM

[former_member142702 · Accepted solution]

Try installing Fix Pack 3.4 on your XCelsius designer. How many rows do your queries fetch?

Regards,

Stratos

PS: 88 MB is not a normal file size. My experience is that the size of a "healthy" dashboard should be less than 1.5 MB

[Former Member · Accepted solution]

All my queries result 20R/30 Columns