design of xcelsius dashboard

[Former Member]

can any body tell me which is best way to design xcelsius dashboard. is it from query as webervice or Live office and why?.

when source is SAP BW query.

[Former Member · Accepted solution]

Hi,

Using LiveOffice Connection:

1 Intuitive what you see is what you get interface with Excel

2. Utilization of cross tabs (gain control over data formatting and layout)

3. Use sub/combined queries and multi-cubes in Universe

4. Fetch data from multiple reports and Universe within single dashboard

Query As A Web Service:

Connect to multiple Universe(s)

More info: http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/c0ecd052-ec2f-2c10-a89b-9be7c89e1f33&override...

Othewise use Xcelsius SP2 for direct SAP BI connection, no need Liveoffice and Query As A Web Service

More Info: /people/rashmi.gurjar/blog/2009/11/18/connecting-sap-bi-directly-with-xcelsius-2008

Regards,

Senthil k

[hai_murali_here]

Hi,

Since your source is SAP BW Query,you can directly pull the data into Xcelsius dashboard by simply connecting the SAP Backend using "SAP BI Netweaver connection" which is availablew with Xcelsius 2008 SP2.

If you pull the data from SAP BW using "SAP Netweaver BI connection",the whole set of data from SAP BW Query will be available through Cross Tab Data under "Output values" of "Definition" tab.

So just Put one Spread sheet table or List View item in the Workspace and simply map the Cross tab data into some Excel cells range and then map the same range of Excel cells into the Design component(Spread sheet table or List View).

This will show the complete data (chars and KFs) which comes from SAP BW Query into the design component at runtime.

Here we are direcly pulling the data from SAP BW.No BOE,nothing else is required.

The Prerequisites for this to work are...

Front End Patch 901 (since we use BEx Open,Save dialog in Xcelsius)

701 SP5 backend

You can refer this PDF which shows detail steps....

http://www.sdn.sap.com/irj/scn/index?rid=/library/uuid/f0b71921-9fb5-2c10-06a9-91b4842a712e&override...

Hope this helps you!

Rgds,

Murali

[Former Member]

Hi,

I did exactly what you wrote but my list is totaly empty. I missed something ?