Skip to Content
author's profile photo Former Member
Former Member

SAP BI vs. Xcelsius

Hello,

sould you please comment, what SAP parts should be installed to let Crystal Xcelsius use BEx reports as their data sources? Have anyone tried to do it this way? Is it a good idea in general, does SAP have any nice dashboards tool equivalent to Crystal Xcelsius?

Add a comment
10|10000 characters needed characters exceeded

Related questions

6 Answers

  • Best Answer
    Posted on Feb 05, 2008 at 11:19 AM

    Hi,

    Xcelsius is using our product Live Office or Web Services or a Excel file as a datasource.

    For sure a BEx Analyzer is also a Excel file but the workbook navigation status can change over time.

    What I would suggest is that you look at our products and how Xcelsius works (will create a blog pretty soon). Xcelsius can - as one example - use a Crystal Report object via Live Office as a data source.

    Crystal Reports can use BW queries, BW cubes and several R/3 data sources.

    hope this helps

    Ingo

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Feb 07, 2008 at 06:40 PM

    You can get some more information on Xcelsius on the Xcelsius product portal. It include information on how it can connect to Web Services as well as connecting to Crystal Reports, etc. http://diamond.businessobjects.com/product-portal/5

    You can also find information on the different data connectivities that The business Objects Products have to SAP on the SAP area of SDN.

    https://www.sdn.sap.com/irj/sdn/businessobjects

    Take a look at the [getting started|https://www.sdn.sap.com/irj/sdn/businessobjects?rid=/webcontent/uuid/f09d7884-9da2-2a10-1998-8a7d572f01c7] [original link is broken]; section there you will find information on the Integration Kit.

    Tim

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Mar 04, 2008 at 09:32 AM

    hi

    sap has a tool in SEM - CPM.Component i.e. Management Cockpit w.r.t. Xcelsius.

    Srin

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Apr 10, 2008 at 03:10 PM

    Hello,

    I want to use Web Services as datasource for Xcelsius.

    In Xcelsius, in the Data Manager, I copy a SAP NetWeaver WebService in the WSDL URL field, click on "Submit" button and then there appears the error message "Unable to load WSDL".

    I tried different NetWeaver Webservices, but there always appears this error message.

    Then I try another WSDL I found in the internet "http://www.thomas-bayer.com/axis2/services/BLZService?wsdl" and it works.

    Could anyone tell me, what's the matter with these WebServices? Perhaps Xcelsius has a problem with WSDL-Imports within the WSDL-URL?

    Is there any test-webservice, which I can try?

    Nadja

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 01, 2008 at 02:40 PM

    Hi,

    Xcelsius is expecting a resultset in a Row / Column structure which is right now not the case of the BI web services.

    BusinessObjects and SAP are working towards a solution

    Ingo Hilgefort

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 13, 2008 at 08:21 PM

    What is the solution if we want to use variables and calculated KFs and Navigational attributes?

    Do we build queries using Query Designer?

    Will we have this capability directly through the BO suite of tools? which one?

    Also, if I am reading this correctly, I need to build queries in Crystal before I can use Xcelsius. Is this true?

    Thanks

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Irwin,

      It seems your post is not necesarily in response to the topic of Xcelsius integration with BI, but here's a brief answer.

      If you wish to leverage Variables, Calc Key Figures, and Nav Attributes defined in your BEx Query, you must create a Universe on a BEx Query. In order to do this you must first turn ON the 'Allow External Access to this Query' (Release for OLE DB for OLAP) option in the Query Properties (it is on the advanced tab). In XI 3.0 you can leverage these query features if you create a Universe on a Query rather than directly on an InfoCube or MultiProvider. Refer to support.businessobjects.com for specific product documentation on the SAP Integration Kit.

      Yes, you will still need to define the Query in the BEx Query Designer (in order to leverage the functionality mentioned above), however you can create Universes directly on a InfoCube or MutliProvider. Also, a Voyager Connection could be created directly on an InfoCube or MultiProvider if Voyager is the frontend tool of choice. For more details on connectivity options for Business Objects frontend tools with SAP NetWeaver BI, please refer to the Blog series on this topic by Ingo Hilgefort.

      For your Xcelsius question... No, you do NOT have to create a Crystal Report in order to populate data in Xcelsius from BI. That is one of many options.. to summarize you can leverage the Query As A Web Service functionality, Live Office connectivity, or direct Web Service connectivity from Xcelsius. For more information on each of these, I would suggest referring to support.businessobjects.com for product specific documentation, this Forum as well as the Blogs for topic Business Objects, and/or the Diamond community forums.

      I hope that answers your questions..

      Regards,

      Tanner Spaulding

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.