Blogs

Connecting SAP BI Directly with Xcelsius 2008 RashmiG  Business Card Company: Capgemini Consulting India Ltd Posted on Nov. 18, 2009 11:03 AM in Business Intelligence (BusinessObjects)

Subscribe Print Permalink Share

 

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

 

 

 

Connect to desired SAP BI system -

 

"

 

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

 

"

 

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

 

 

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

 

 

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

 

RashmiG   Rashmi is 'Solution Consultant SAP NetWeaver 2004 – Business Intelligence’ with almost Five years of experience SAP BI. During this tenure, she has worked on BI development and Support projects. She is exploring the knowledge on Business Objects tools and connectivity to BI.

Comment on this weblog

Showing messages 1 through 6 of 6.
Titles Only	Main Topics	Oldest First

• New Integration Kit for BW training available
  2009-12-01 22:47:29 Thierry Siraut  Business Card [Reply]
  
  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

• Single Sign-on
  2009-11-23 05:50:21 Gopal Krishnamurthy Business Card [Reply]
  
  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

  • Single Sign-on
    2009-11-23 07:06:51 Ingo Hilgefort  Business Card [Reply]
    
    HI,
    yes the integration comes with SSO.

    
    Ingo

• Netweaver Version?
  2009-11-19 04:56:50 Ryan Quackenboss Business Card [Reply]
  
  Hi Rashmi and Ingo,

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

  
  
  Thanks,
  Quack
  

  • Netweaver Version?
    2009-11-23 07:08:13 Ingo Hilgefort  Business Card [Reply]
    
    Hi,
    you need SAP NW BW 7.0 Enhancement package 01 SP05

    
    Ingo

• Xcelsius Connectivity for SAP NetWeaver BI
  2009-11-18 15:32:28 Ingo Hilgefort  Business Card [Reply]
  
  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:
  https://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/15131

  
  

  
  regards
  Ingo