Dashboard - Live office Approach

[Former Member]

Hi Friends,

I am making a Dashboard using live office through web intelligence report. My idea is to schedule the web intelligence report at night and use the latest instance in the Dashboard. By this way, the results will be displayed instantly rather than making it execute at runtime which could take ages to get the desired results. My problem is with Authorization. Using latest instance method, It seems that SAP user authorization would not work. It is only possible at runtime. Can you pease guide me what should be the right approach to design this dashboard as performance is the major criteria here

Thanks,

Gaurav

[Former Member]

Hi Gaurav,

Bi web services (BIWS) is way better in performance compared to Live Office connection, read below to see the advantages of BIWS over Live office.

http://blog.davidg.com.au/2011/04/live-office-vs-qaaws-vs-bi-services.html

You can go with approach of publishing BIWS over the existing webi report and consume them through  Qaaws connection to the dashboard. You would schedule the webi report and ensure your web service is pointing to latest instance while consuming data. refer to below for details

http://everythingxcelsius.com/xcelsius-training/xcelsius-and-business-intelligence-web-services-biws...

http://scn.sap.com/docs/DOC-31217

http://scn.sap.com/docs/DOC-30356

http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/40cbcb2b-d719-2f10-6197-ed0605020...

Note: you should have been Xi 3.1 or above versions to use BIWS

Thanks

Mallik

[Former Member]

Hi Mallik,

Thanks for the reply. Can you please also let me know the authorization part? Will the authorization work for the users?

Thanks,

Gaurav

[arijit_das]

The authorization will work. But make sure:

1. You publish the report as wid format.

2. Select Inbox as destination.

3. You have at least one scheduled instance of the report in users inbox.

4. Set Latest User Instance to TRUE and Refresh to FALSE in QaaWS connection input section.

[arijit_das]

Better to use Publishing to users' Inbox in wid format and use BIWS to connect to latest user instance. It will serve your purpose.