Skip to Content

Here are various approaches that we can use to connect Xcelsius 2008 to BW Infocubes. First we need to create universe in universe designer on top of BW data.

Prerequisites to create universe using SAP BW:

       1. Business Objects Integration Kit for SAP is installed.

       2. SSO (Single Sign On) is enabled so that you can logon to Designer using your SAP credentials.

For detailed procedure please refer: http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/903a7fc7-19e8-2d10-fa95-b050de946b61?QuickLink=index&overridelayout=true

Now we can connect to this universe that we created on BW data to Xcelsius 2008 through one of the following two techniques:

Using QAAWS:

QAAWS is a Business Objects client tool that creates a web service, based on a query that connects directly to a universe.

Steps:

1.           1. Create a BO Universe on the BW Infocube using Universe Designer.

1.           2. Create a web URL for that universe using QAAWS.

1.           3. Connect to that query as a web service from Xcelsius using the URL generated above.

1.           4. Now we can create the dashboard in Xcelsius based on that BW Infocube data.

For detailed procedure please refer: http://scn.sap.com/docs/DOC-21225

Using Live Office:

Live Office is a Business Objects tool that is installed as an add-on to Microsoft Office Excel. This allows you to connect the Excel spreadsheet within your dashboard to a Webi or Crystal Report, which in turn connects to your data source (Universe).

Steps:

1.           1. Create a BO Universe on the BW Infocube using Universe Designer.

2.           2. Create a Webi/Crystal report on that universe.

3.           3. Create a Live Office object using that report.

4.           4. Go to Xcelsius, import the Excel sheet created above & open data manager, add the live office connection & enter the web service URL.

5.           5. Now we can create the dashboards in Xcelsius.

For detailed procedure please refer: http://scn.sap.com/docs/DOC-21188

We can also connect directly to BW data through SAP NetWeaver BW Connection:

Direct SAP NetWeaver BW connection is also available in Xcelsius Enterprise 2008 Service Pack 02 onwards. We can use this connection to connect to BW Infocubes. Following are the prerequisite for this to work:

1.          1. SAP NetWeaver BW 7.01 (SAP enhancement package 01), Service Pack 05.

2.          2. SAP Business Objects Xcelsius Enterprise 2008 Service Pack 02.

3.          3. SAP Frontend 7.x installed on the client with BI Add-Ons.

For detailed procedure please refer: http://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/10ad2489-8956-2d10-f8ab-ed4cce2766da?overridelayout=true&quicklink=index

🙂 🙂 🙂

1.

1.

1.

To report this post you need to login first.

Be the first to leave a comment

You must be Logged on to comment or reply to a post.

Leave a Reply