Skip to Content
Author's profile photo Former Member

Connecting SAP BI Directly with Xcelsius 2008

There are different types of connecting SAP BI to Xcelsius 2008.

1.  Using Query As A Web Service

2.  Using Live Office

3.  Direct connectivity to SAP BI

The blog is already available for first two connection types.  Please refer to following link for further details.

http://www.sdn.sap.com/irj/boc/index?rid=/library/uuid/0047b9a9-8397-2b10-5e9c-9d963c20e1e7

This blog explains the connectivity of SAP BI directly with Xcelsius 2008, the third type of connectivity.

Follwoing are the detail step by step approach for connecting SAP BI with XCelsius-

Pre-requisite:

  1. New SAP GUI Frontend
  2. Service Pack 2
  3. NetWeaver Version 7.02 (Enhancement Pack 1)

Link to get Xcelsius SP2

https://websmp130.sap-ag.de/sap(bD1lbiZjPTAwMQ==)/bc/bsp/spn/bobj_download/main.htm

 

Sart XCelsius -> Manage Connectivity -> Add

 

 

image

 

Connect to desired SAP BI system –

 

image

 

Click on Browse to select the name of the query on which the dashboard needs to be created –

 

image

 

Once the query is selected, it will get displayed as given below –

 

image

 

We need to specify the range where the data will be inserted in and if there is any filter value as given below –

 

image

 

Drag & Drop the objects in Canvas Area to prepare a dashboard.

 

Publish this dashboard by clicking on SAP -> Publish

To preview this dashboard click on SAP -> Launch

 

Start Xcelsius -> SAP -> Open -> it will ask for logging to system.  Login to desired SAP BI System with your credentials.

 

 

Note: 

 

1. If you select multiple range for plant, then the filter will be applied for those plants only.

 

2. You cannot preview the dashboard with “Preview” button in the task bar.  You need to “Publish” and then “Launch” this dashboard to view it.

3. Each time you try to launch the dashboard, it will ask for user credentials. 

4. In XCelsius, you will get “SAP” option beside “File” option on the task bar.  If this option is not visible, then you cannot get direct connectivity to SAP BI & XCelsius

Assigned Tags

      6 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Ingo Hilgefort
      Ingo Hilgefort
      Hello Rashmi,

      you mentioned the pre-requisites:

         1. New SAP GUI Frontend
         2. Service Pack 2
         3. Hot Fix 2.1
         4. BO Enterprise

      Item 3 and Item 4 on your list (FixPack 2.1) and BusinessObjects Enterprise are not mandatory elements. The Xcelsius connectivity towards SAP NetWeaver BI does not require BusinessObjects Enterprise.

      we did a webinar for the connectivity:
      SAP Mentor Monday Webinar Ingo Hilgefort: Hands-On Xcelsius for SAP

      regards
      Ingo

      Author's profile photo Former Member
      Former Member
      Hi Rashmi and Ingo,

      What version of Netweaver BW is required. I understand at least Enhancement Pack 1. Is that incorrect?

      Thanks,
      Quack

      Author's profile photo Ingo Hilgefort
      Ingo Hilgefort
      Hi,
      you need SAP NW BW 7.0 Enhancement package 01 SP05

      Ingo

      Author's profile photo Former Member
      Former Member
      Rashmi and Ingo, Is there a way to enable Single Sign-on for NW BI Direct Integration to SAP BW? Currently, the users are experiencing single-signon through LiveOffice-BOE- for Xcelsius.

      Thanks
      Gopal

      Author's profile photo Ingo Hilgefort
      Ingo Hilgefort
      HI,
      yes the integration comes with SSO.

      Ingo

      Author's profile photo Former Member
      Former Member
      To help consultants understand the newest Integration kit for BW and help you understand SNC,  SAP Education developed an excellent new course BO100 "BW Integration Kit for BO"
      This course include lots of Integration exercises for each BOBJ solution with BW. This advanced course is a must for BW consultants.
      Link to the course description - http://tiny.cc/tVQAq