Skip to Content

In the previous parts we created the first part of our Xcelsius visualization model which is leveraging a Live Office document to retrieve SAP BI data. The underlying SAP BI query contains a SAP variable and we created a OLAP Universe on top of a BI Query to create a List Box in Xcelsius.

 

In this part we will leverage the web service to create the list box and we will configure the interactivity between the list box and our chart.

We going back to Xcelsius and open our existing visualization model with the chart.

 

I then select the menu Data > Connections and..

 

Click Add to add a new connection for our Query-as-a-WebService.

 

 

I select Query as a Web Service from the list and click on the new entry to finalize the configuration.

 

I paste the URL from the created QaaWS web service into the field WSD URL and click Import.

 

 

The web service is only returning one column. I select the entry “row” from the Output Values and then select the icon next to “Insert in” to mark the range in Microsoft Excel for the returned values.

After I am finished with that I navigate to the Usage tab and…

… set the Refresh on Load property.

 

Now I return to the Xcelsius canvas and Add a list box component to it. With a double-click on the list box component I open the properties.

 

I set the Insert Type option to Value and…

 

 

… select the range for the Source Data and point it to the previous marked cells for the web service.

I also select the range for the Labels and point it to the previous marked cells for the web service.

Now I need to configure the Destination to the cell in the spreadsheet that I used previously in Live Office as input cell for the parameter from the underlying Crystal Reports.

 

As next step I select the menu Data > Connections and go back to the existing Live Office connection that we did add previously and navigate to the Usage tab.

 

 

I select the icon next to the Trigger Cell and select the identical call that I used as the Destination cell (and as input cell for the parameter in Live Office).

 

I then select the option When Value Changes to make sure every time I select a different year from the list box the Live Office document is being refreshed with data from the SAP BI system.

 

I save everything and click Preview to take a look at my Xcelsius canvas.

 

So now the chart is being refreshed via LiveOffice and Crystal Reports towards the SAP BI System every time I select a different year from the listbox.

 

For those that missed the installation parts, here are the links to the blogs:

BusinessObjects and SAP – Installation and Configuration Part 1 of 4

BusinessObjects and SAP – Installation and Configuration Part 2 of 4

BusinessObjects and SAP – Installation and Configuration Part 3 of 4

BusinessObjects and SAP – Installation and Configuration Part 4 of 4

BusinessObjects and SAP – Configure SAP Authentication

BusinessObjects and SAP – Publishing of Crystal Reports Part 1 of 3

BusinessObjects and SAP – Publishing of Crystal Reports Part 2 of 3

BusinessObjects and SAP – Publishing of Crystal Reports Part 3 of 3

BusinessObjects and SAP Part  1 of 4 – Creating a Xcelsius Dashboard on top of SAP BI

BusinessObjects and SAP Part 2 of 4 – Creating a Xcelsius Dashboard on top of SAP BI

BusinessObjects and SAP Part 3 of 4 – Creating a Xcelsius Dashboard on top of SAP BI

To report this post you need to login first.

30 Comments

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

  1. Alexander Schuchman
    If we aren’t concerned about real-time access to data and our primary concern is stability…which would you say is more stable long-term in production, QaaWS or Live office?

    So far we have seen that Live Office is rock solid.

    -Alex

    (0) 
  2. Anesh Boddapati
    Hi Ingo –

         Your articles are very impressive. Thanks a lot for sharing this information. I have a small question. Can you explain how to bring SAP BI Userexit Variable values(Variable values are restricted as per back end logic SAP ABAP Customer Exit)  into XCelsius dropdown. Thanks!

    Anesh B 

    (0) 
    1. Ingo Hilgefort Post author
      Hi Anesh,

      in case the User Exit is not an actual input prompt the user exit variable would just getting processed in the background.

      In case it is an actual prompt (ready for input) you could use the QaaWS tool to make a WebService on top of a Universe (or use LiveOffice) and then expose the prompt in that way.

      Ingo

      (0) 
  3. soniya kapoor
    Hello Ingo. I highly appreciate your bolgs which are very helpful. I will be thankful from bottom of my heart if you kindly help me resolve the below.

    I created a universe on top of BI query. but none of Query variables like for Company code and fiscal period are showing up in Filter tab or any where else in Universe BO XI3.0

    SAP Statement
    since For characteristic variables, Designer creates a mandatory filter in the
    universe. A mandatory filter is a pre-defined query filter object which is hidden
    to Web Intelliegence users, but is applied systematically and transparently
    to all Web Intelligence queries built on the universe.

    But none of the variables are showing up in Universe.

    2. Also when I try to drag and drop any of the Query restricted key figure available in universe to webi it will fail the Webi REPORT

    3. Also there is no customer exit variables showing up in the universe designer

    Please help if we are missing some patch on BO Universe software  or I am missing some thing

    Thanks

    Soniya

    (0) 
  4. bhavna verma
    As mentioned in the Blog data gets refreshed on selection of Calender Year. How do we handle the situation when there are more then one variables for data refresh. i.e. calender year, city and country.
    (0) 
  5. bhavna verma
    Hi Ingo,
    I m using Xcelsius 2008 Engage enterprise.I dont find the option for Query as a Webservice in Data->Connction path.Web Service conncection is available I tried using that for QasaWs but gives no result on execution.let me know if some setting or some installation has to be done before Xcelsius.

    Thnaks in advance.
    Bhavna V.

    (0) 
  6. bhavna verma
    Hello Ingo,

    I want my Xlf file to get deployed on Web.just as in case of WAD we get a URL generated,can I get a URL to link to the Xcelsius document.

    Thanks in advance.
    Bhavna.

    (0) 
    1. Ingo Hilgefort Post author
      Hi,
      you need to export the XLF to a SWF file and then you can use it on the web.
      You can either use BusinessObjects Enterprise or Edge for the distribution or you can buy additional viewing licenses in case you not want to use the backend.

      ingo

      (0) 
      1. bhavna verma
        Hi Ingo
        Thanks for your immediate responses so far.
        I have created Xcelsius application with BI as backend and have exported to BOE as swf.now I want to provide the client with an URL to directly view the swf(URL wd ask for BO logon) without need to go to favourites and then clicking on the swf file and so on.how do I construct such URL.
        Thanks in advance.

        Bhavna.

        (0) 
        1. Ingo Hilgefort Post author
          Hi Bhavna,

          there is an application called OpenDocument that you can use to call content from your BusinessObjects system via URL.

          Search here on SDN with the word OpenDocument and you will find some articles.

          Ingo

          (0) 
  7. bhavna verma
    Hello Ingo,

    I have created a Xcelsius application with BI data being pulled into it through Query as a Webservice.Now the apllication works well but gets timmed out if it remains untouched for more than 10 min. I want to increase this time out to say 1 hr.where do i do the setting for this.

    I have already set the:pool timeout” and “Login Timeout” parameter for connection to 1 hr.
    Also the parameter in universe “Limit Execution Time to ” is set to 1 hr.

    m surely missing some setting for the time out.kindly suggest me the right solution.
    thanks in advance.

    Bhavna.

    (0) 
    1. Ingo Hilgefort Post author
      Hi,
      the Query as a web service has a timeout setting itself.

      Perhaps you can put those type of questions into the Forums for the SAP Integration so that other people can learn from it as well.

      thanks
      Ingo

      (0) 
  8. Sam Lu
    Dear Expert,
    This’s a great, great blog of BO & SAP and very helpful.
    Referring to your example,I configured a xcelsius on our BOE & BI platform. I could get data correctly from both data connection(Live Office and Query Webservice) on initial load, but I got a error when I changed the year in the listbox. The error message was as below,
    ‘Database logon failed. (LO 26603)’.
    It seems like that when the trigger lead to an access to the BW query and this access logon failed.
    Could you please help me? Thanks a lot!
    (0) 
    1. Ingo Hilgefort Post author
      Hi Sam,

      could you open this in the forum for the SAP Integration Kit ? Its easier to respond and everyone can see the discussion there.

      On the situation:
      – make sure you are using the SAP Authentication in all the layers (CR, Universe, QaaWS, Live Office, InfoView)

      Ingo

      (0) 
      1. Sam Lu
        Hi Ingo,
        I met a problem when configured SAP authentication. I referred to your blog of SAP authentication step by step, but when I login system by SAP option, a error message like below occured,
        ‘Account information not recognized:logon failed, because user xxxxxx is not assigned any roles needed’
        Thank you very much!
        Do you mean I just post a topic in the ‘SAP Integration Kit’ forum and you take care of the forum ?
        (0) 
          1. Sam Lu
            HI Ingo,

            I’ve post the SAP authentication error message in the forum. Please give some comments about this error in forum.

            Thank you!

            (0) 
          2. Sam Lu
            HI Ingo,

            I have configured SAP authentication and built CR report and Xcelsius with SAP user. Only Live Office file was built by entreprise user, because there was not a SAP logon option.

            I have post a tread in the SAP integration kit forum and you can give me suggestion in the forum.

            Thanks a lot!

            (0) 
            1. Sam Lu
              HI Ingo,
              I have configured SAP authentication and built CR report and Xcelsius with SAP user. Only Live Office file was built by entreprise user, because there was not a SAP logon option. Now I still got the orror ‘Database logon failed. (LO 26603)’.

              I have post a tread in the SAP integration kit forum and you can give me suggestion in the forum.

              Thanks a lot!

              (0) 
  9. bhavna verma
    Hi Ingo,

    Thanks for your immediate responses so far.I want the Infoview application to be configured with my SAP Portal.The Client wants the SAP Portal to access the BO Applications as well.I have the URL for my Xcelsius Application ,now I want this URL to be configured in the SAP Portal.is this possible.If yes, then can You provide with some documents.

    Thanks in advance.
    Bhavna.

    (0) 
    1. Ingo Hilgefort Post author
      Hello Bhavna,

      You can use the BusinessObjects iView template and use the ID of the Xcelsius object that is stored in BOE or you can use a URL iView where you specify the complete URL and you can then use the application OpenDocument to surface the Xcelsius document.

      hope this helps
      Ingo

      (0) 
  10. glen spalding
    hi ingo,
    i am struggling to see any information as to what is required on a production server.
    for example, if i were to have an xcelius dashboard sitting inside the bobj server, and this dashboard is to be fed via live office, which will also be fed via crystal reports, must i have crystal reports v1 2008 also sitting on the bobj production environment, as what about live office, and dare i say excel. are all these software products/components necessary on a live environment. ? thanks in advanced
    (0) 
    1. Ingo Hilgefort Post author
      Hi,

      Crystal Reports and Live Office are client products but for sure your SAP BusinessObjects Enterprise environment needs to corresponding
      server components.

      In general I would suggest you post those kind of questions into the SDN forums.

      regards
      Ingo Hilgefort

      (0) 

Leave a Reply