dashboard Automation

[Former Member]

Hi Team,

We have many dashboards updating manually like below

1. Will get data from crystal reports in excel format then will copy and paste in dashboards.
2. We are doing this for many dashboards.
3. We want to automate it.So that dashboard can pull updated data when ever user clicks it

So what is the best approach

[former_member182541 · Accepted solution]

Using Live office you can create Live dashboards, so that every time you open the dashboard you can have the recent data.

Crystal reports --> Live Office(Connection) --> Dashboard.

[Former Member · Accepted solution]

Hi Suman,

Where we have the live office option ? Under dashboards ?

[former_member182541 · Accepted solution]

Live office doesn't comes with dashboard, its a seperate plug-in need to download from market place. You need run the run live office file so that it will added into the MS-Excel, then configure the BO Server details into that plug-in. Finally when you open the dashboard at the bottom part in excel you can find the live office is enabled.

SAP BusinessObjects Live Office 4.1 – SAP Help Portal Page

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/b02e31fb-3568-2e10-e78f-92412c3c0...

[Former Member · Accepted solution]

Hi Suman,

Thank you for your information.

Currently I am getting data from crystal reports which runs on Stored Procedures.

So now how I will get data to refresh dashboards automatically.

from crystal reports ? or  from universe ?

How the connection will be

Please suggest

[former_member182541 · Accepted solution]

There are two ways you can achieve this.

1. DB-->Universe-->Dashboard.(QAAWS,Query browser Connection)

2. Crystal Reports-->Dashboard.(Using Live Office connection)

For crystal reports, complete the report and save it the BOE Repository from there you can call the report inside the dashboard using the excel through live office connection. The refresh is based on the input what you are passing to the report, typically how you handle the crystal report for analysis. But check about scheduling the report or refreshing the report while opening the dashboard at the time of invoking you need to make a call.

[Former Member · Accepted solution]

Hi Suman,

But check about scheduling the report or refreshing the report while opening the dashboard at the time of invoking you need to make a call.

Can you please explain above point.

[former_member182541 · Accepted solution]

1. Schedule the crystal report in BOE server, so that you can get the latest records with the latest instance, so whenever you open the dashboard it will refer the latest instance.

2. Keep the dashboard as "refresh on open" so that whenever you open the dashboard it will hit the report and provides the latest data. But make note of the report response time, if its takes so long then refresh on open will affect on the waiting time.

Hope this helps!!!

[Former Member · Accepted solution]

Okay Suman,

Do you have any document like how to setup LiveOffice to Dashboards

Could you please provide

[former_member182541 · Accepted solution]

For installation and configuration you can use the below document.

http://help.sap.com/businessobject/product_guides/boexir4/en/xi4_liveoffice_user_en.pdf

For creating a sample dashboard using crystal report, use the below pdf. Instead of webi report you can use the crystal report.

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/b02e31fb-3568-2e10-e78f-92412c3c0...

[Former Member · Accepted solution]

Hi Suman,

I have few questions

Can you please answer

• does the liveoffice allow for the importing of multiple reports or only one as we have the dashboards with multiple tabs using multiple reports
• Also where the reports get stored in crystal server ?

[former_member182541 · Accepted solution]

You can call multiple reports as different connections. You have to save the reports in the BOE repository, live office will be picking the report from the repository.

[Former Member · Accepted solution]

Hi Suman,

The Server has limited space

the crystal install alone took up half the space we have

Any suggestions ?