SAP BEST PRACTISE BI-Purchasing Volume Dashboard issue

[Former Member]

Hello,

I am working on Purchasing Volume Dashboard (from SAP BEST PRACTISE BI package), I adapted Crystal Reports sources of this dashboard so that they connect to our local database and successfully generated the Export.xls, I Imported this Export.xls file into Purchasing Volume Dashboard.xls, added and configured Live Office Connections (ticking"Refresh before components are loaded" for each Live Connections.

The issue is that when I click on PREVIEW the four components (Charts and Scorecard) don't refresh simultaneously.

I have to click once on REFRESH button to have the first component refreshed with data then to click again to have the second component refreshed then click again and again !

I don't understand why those components don't refresh in the same time !!

Did one of you ever encountered this issue ?

many thanks for your help,

Regards

Christiane

[Former Member]

Hi,

Make sure your web service URL correct in Live Office connection and also in Xcelsius data manager.

Did you check all connection in refresh button proprties? you may try selecting "Refresh after component are Loaded" in Refresh button properties Behavior tab.

I think Xcelsius refresh are serial refresh so it may be possible that first component refresh is still in progress but you are expecting other component to refresh.

Click on "Enable Load Cursor" in data manager's Usage tab, it will give you visibility of refresh. If anything refreshing you will see hour glass.

Cheers

[Former Member]

Hello !

Thanks for your answer.

My web service URL is correct in Live Office connection and also in Xcelsius data manager.

"Refresh after component are Loaded" in Refresh button is enabled for each connection.

I still encounter this issue !!!

Regards,

Christiane

[Former Member]

Hi,

When your xcelsius data manager properties is set as "Refresh before components are loaded" then try deselecting Refresh button properties "Refresh after components are loaded", refresh will still work.

Also refresh is serial process(not parallel) in Xcelsius so make sure components in your landing pages are refreshed first, you can achieve this by moving up and down connection in data manager.