Difference BICS connection Xcelsius 2008/2011 and BOE 4.0

Since Xcelsius 2008 SP2 it is possible to connect to a Bex-query through a BICS connection. You could publish your dashboard on the SAP portal (with at least Netweaver 7.01 SP5 installed). As the BOE 3.1 platform does not know the BICS connection, it is not possible to publish your dashboard with BICS to Infoview.

In the new BusinessObjects 4.0 platform it possible to connect a WebI report directly to a Bex-query through a BICS connection (thus no need to place a universe in between as in 3.1).

Hey now we have a BICS connection in Xcelsius AND the platform knows also BICS connection, stands to reason that now we can publish a dashboard with BICS connection to Infoview as well then, right?

WRONG!

The BICS connection defined in Xcelsius 2011 is a different one then the BICS connection used in the BOE 4.0 enviroment.

So leave it to the SAP to release 2 different connections with the same name. :-(

Recent Related Posts
Femke Kooij is a dashboard and report designer, developer and educator specializing in SAP | BusinessObjects Dashboards (better known as Xcelsius) and Crystal Reports. She has also a lot of experience with other SAP | BusinessObjects toolings like, Web Intelligence (WebI), Information Design Tool (Universe Designer), BusinessObjects Data Services (BODS) and the overall server platform BusinessObjects Enterprise (Launchpad, CMC). She spends a lot of her time thinking about and sharing her knowledge of Xcelsius to others through her own blog. Lately she is exploring other visualization tools like Qlikview and Tableau. On the later she is also posting some experiences. Currently she is in the employment of Cognizant Technology Solutions. Her blog only contains her personal views, thoughts and opinions. It is not endorsed by Cognizant Technology Solutions nor does it constitute any official communication of Cognizant Technology Solutions.

This entry was posted in Connection, Xcelsius and tagged , , , , , . Bookmark the permalink.

2 Comments to Difference BICS connection Xcelsius 2008/2011 and BOE 4.0

  1. Have you tried the new WebI to BW/BICS connectivity? How is it?

    • Anessa Guinea says:

      Hi Donald, I have tried the new WebI BICS connection. There is better support for hierarchies and there is an improvement in performance when running the report. I found out that WebI uses a ‘Transient Universe’ to connect to the BEx query. As far as I can see, this just means that it is no longer necessary for the developer to create a Universe in the Universe Design tool (now called the IDT) to connect to BW as these Transient Universes are leveraged.