Skip to Content
Author's profile photo Former Member

BO 4.0 Information Design tool : Vol II-Creating a Relational Universe on BW Dataprovider

Author(s)                                            : Abhishek Pal Chaudhuri & Muthukumar R

Date written (MM/DD/YY)            :31/05/2012

Details                                     :

         H/W Platform: Windows

         S/W Environment: Business Objects & SAP BW 7.3

         Application Type: SAP BI 4.0

        

Target readers :

           Business End Users

           BOBJ Developers

           Tech. Architects

Keywords         :

BO 4.0 Information Design Tool and Best Practices, Business Layer, Data foundation,   BW-BO Integration,Relational Universe

Author’s BIO:

Abhishek Pal Chaudhuri:             /wp-content/uploads/2012/05/apc_106609.png                                                            

Is a BOBJ Developer currently working in Infosys on the BOBJ/BI domain having 2 years of experience in this domain. His expertise is in BO 3.x/4.0 tools like Information Design tool, Universe Design Tool, Web Intelligence, Xcelsius Dashboards, Admin activities. He specializes in BOBJ-BI Integration in BI 4.0 and working with the new aspects of integrating BW with BO 4.0 and enterprise reporting and consultancy.

                                                                                                           

Muthukumar Ramanchetty:         

                                          

/wp-content/uploads/2012/05/muthu_106610.png

Is a BOBJ 3.x/4.0 Consultant currently working in Infosys on the BOBJ/BI domain having more than 7 years of experience in this domain. His expertise is in BO 3.x/4.0 tools like Information Design tool, Universe Design Tool, Web Intelligence, Xcelsius Dashboards, Admin activities. He specializes in BOBJ-BI Integration in BI 4.0 and working with the new aspects of integrating BW with BO 4.0 and enterprise reporting and consultancy. He has also worked on integrating BOBJ 3.x/4.0 with Oracle/MS/Access/SAP HANA.

What is MDX?

Multidimensional Expressions (MDX) is a querying language for OLAP databases. It provides a specialized syntax for querying and manipulating the multidimensional data stored in OLAP cubes.

Prior to BO 4.0 MDX connectivity was the only option to connect OLAP cubes and to perform the reporting on them. This approach had its own limitations as follow.

  • Very slow, MDX uses cell by cell approach.
  • Flattening of BW hierarchies when the data from BW is fetched into the report or the query via the MDX interface.
  • Inefficiency in returning complex data sets.
  • Might not expose all the Bex query features in the BO user interface.
  • No further enhancement towards improvement of performance could be done.

    

Workflow for creating Relational Universe/MDX Approachrelational Workflow.PNG

 

Integrating BI 4.0 with SAP BW

Ø  Connecting to SAP BW by building a Universe on Top of the Cube (Relational SAP connection)

In IDT, the biggest advantage is that you can create universe based on multiple data sources. It could be different relational data sources (must be 64-bit), or different SAP BW source or them combined.

You can create universe based of SAP BW. The tables underneath the cube would be extracted, and would be used like any relational database. Since the schema is already present inside the cube, the joins are made automatically once a data foundation is created.

Before creating a relational SAP netweaver BW connection, certain settings have to be made into the BW system.

SAP Netweaver BW uses a callback ID in order to contact the data federation service. A callback is registered automatically when the first query on the connector is executed. But this connector properties can be changed to stick to organization’s security policy.

  • Open SAP logon pad.Enter tcode se37 and execute.

1.PNG

  • Enter the function module RSDRI_DF_CONFIGURE and click execute.This will open the parameter panel.

  2.PNG 

  • Set the parameters as follows and execute the function module.

          a.I_ONLY_CHECK : “(empty)

          b. I_RFC_DESTINATION :DF_JCO_”HOSTNAME”_SID

          c.I_REMOVE_CONFIGURATION:  “(empty)

4.PNG

  • The connector is successfully configured. It is ok to get the message RFD destination already exists.

  5.PNG 

  • Once the Data federator connector has been configured in the BW system, open IDT and login to the central repository and create a Relational Connection.

6.PNG

  • Provide a suitable name to the connection.

  7.PNG 

  • Select the database middleware driver as SAP Java Connector (JCO).

8.PNG

  • Provide the system credentials of the BW server to connect to.

  9.PNG 

  • Once the Java connector connects to the BW system, uncheck the other options and select the Cube/ Multiprovider /DSO you want to connect to.

10.PNG

  • Select the BW object and click ok.

  11.PNG 

  • Once the BW data provider is successfully configured, test the connection to cross check the connectivity.

12.PNG

  • The below snapshot shows “Test Successful” i.e. the Data Federator connector is successfully able to ping the BW server.

  13.PNG 

  • Once the Connection is created in the repository, create a shortcut of the connection in the local projects folder.

14.PNG

  • The Connection shortcut is successfully created in the local projects folder.

  15.PNG 

  • Once the connection is successfully created, create a data foundation on top of the connection to map the default schema in the BW data provider.

16.PNG

  • Provide a suitable name to the data foundation.

  17.PNG 

  • Select the Data foundation type as “Multisource Enabled”.

18.PNG

  • Select the connection shortcut from the local projects folder.

  19.PNG 

  • Click on Finish to create the foundation on top of the connection.

20.PNG

  • Since the BW data provider (Cube/DSO/Multiprovider) already has the schema connected in the BW system, the data foundation automatically picks up the schema and maps the relevant tables.

  21.PNG 

  • Once the data foundation and the schema are created, create a Business layer on top of the Data foundation.

22.PNG

  • Select the Business Layer type as “Relational Data Source” as it is being built on top of a relational connection.

  23.PNG 

  • Provide a suitable name to the Business layer.

24.PNG

  • Select the Data foundation on top of which you need to create the Business Layer.

  25.PNG 

  • To map all the default classes and objects from the BW data provider check the option “Automatically create classes and objects for SAP NetWeaver BW connection”.

26.PNG

  • Click on finish to successfully create the business layer. Once the Business layer is created, you can see all the objects, classes of the BW data provider in the Business layer.

  27.PNG 

  • In order to test the connection, and the validation of the Business layer, a default query can be made in the query panel by pulling a few objects to check if the connection works properly and is it able to fetch data. For this, click on the query panel and Insert new query.

28.PNG

  • Drag and pull a few objects into the result objects panel and click on refresh .Your connection works properly if you’re able to preview data in the result set tab.

  29.PNG 

  • After everything has been setup successfully and once the data model is ready, right click on the business layer and publish it to the central repository.

30.PNG

  • Perform an integrity check to validate the data model.

  31.PNG 

  • Select the repository folder where you want to publish your Universe.

32.PNG

  • Now in order to check and validate the published universe, Login to the Webi rich client and select the data source as universe.

  33.PNG 

  • Select your universe from the list of universes on the central repository.

34.PNG

  • Drag a few objects into the Result Objects tab and click on refresh to preview the data.

  35.PNG 

  • Now click on Run query to generate the Webi report. The Webi report is successfully generated. Thus our Relation universe on top of the BW dataprovider works well.

36.PNG

Summary

This document provides an extensive knowledge on the new Information Design tool in Business Objects 4.0, its functionalities, step by step guide to create a relational universe on top of BW data providers like Cubes,DSO’s,Multiproviders ,most importantly various aspects of the integration of Business objects BI 4.0 with SAP BW. This document can be useful for end users, developers and architects who work on both the functional and the technical aspects of BI 4.0.

Reference(s)

Ø  Business Objects 4.0 Information Design tool guide.

Ø  Business Objects 4.0 Data federation administration guide.

Ø  http://www.forumtopics.com/busobj/

Ø  www.google.com

Ø  sdn.sap.com

Assigned tags

      20 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      I can't see images neither.

      Could SAP do something to solve this issue !

      Author's profile photo Jason Lax
      Jason Lax

      Images appear now. Please confirm.

      Author's profile photo Former Member
      Former Member

      Hi Jason,

      Still the Images not appear................not even One Image is getting displayed???

      Can you please resolve ASAP.................Even in Other posts as well.................not even single/most of the  Image gets displayed.

      The Old SDN is much better in Images part being displayed , of course it is slower...........but used to work much better.

      Please let me know once it has been resolved at :

      [email address removed by moderator]

      Author's profile photo Jason Lax
      Jason Lax

      Have tested with various scenarios and cannot replicate what you're experiencing.  If there are other examples, there might be a local issue. 

      The proper course of actions for support requests is to open a new discussion in the SCN Support space and please include examples.

      Author's profile photo Henry Banks
      Henry Banks

      OK for me in IE9 on Win7

      Author's profile photo Denis Konovalov
      Denis Konovalov

      Do not see images in IE10 anymore

      Author's profile photo Manikandan Elumalai
      Manikandan Elumalai

      Not working for me am in IE9 on Win7. I think this is due .PNG images

      Author's profile photo Former Member
      Former Member

      I am also facing the same problem................u r not working on this............somply ot os waste of time.....thr r other sites whch r providing much easier ones...................

      Also we need the selective Filters for the Search Oprtion thich is there in Old SDN.....................

      Now in this New SCN....it i really combersome with out proper filters..............we need those specific filters for BW Or ECC.......or specifc module filters so that the serach makes sense ........

      Also tht eimages r not getting dosplaer still..........for all ur posts..............I mean most of the Images r not getting displayed.......

      I tries in IE 9 with Addons & woth out Adons & 32 & 64....also.............it noever worked?

      Pls resolve ASAP

      Author's profile photo Henry Banks
      Henry Banks

      Hi,

      I assure you, it is your local issue.

      There are large images embedded into this page, and even internally in SAP domain this page takes 30s to load all the graphics. 

      This isn't a standard/official SAP page, so isn't formatted optimally.

      If you are trying to find new forums pages, go here: http://scn.sap.com/docs/DOC-18971  or here http://scn.sap.com/docs/DOC-18973

      Regards,

      H

      Author's profile photo Denis Konovalov
      Denis Konovalov

      I cannot see images either. First time on page - I see one image. I do refresh - I might see 3 or 4 images, more refreshes - same count of images..

      So far I have not seen this issue on other pages in SCN, this is the only one.

      (accessing from SAP network).

      Author's profile photo Yadwinder Sandhu
      Yadwinder Sandhu

      Can't see a single image.. tried opening in IE Firefox and chrome.. This is really annoying.

      Author's profile photo Ravi Shankar
      Ravi Shankar

      Hi,

      Its works with IE browser 8 version. successfully downloaded the document in pdf format.

      All images are showed in PDF format.

      Author's profile photo Former Member
      Former Member

      Nope, I'm not seeing images either. Using IE8. I printed this page to PDF and the PDF still shows no images.

      Author's profile photo Chandrasekhara Rao Andagunda
      Chandrasekhara Rao Andagunda

      hi,

      Thanks for the details.i selected "view as a PDF format". able to view the snap-shot without any issue,but not able to use this doc 100%, because not able to get/find the Data Federator connector configuration in BW system in more detail, just mentioned as one line, detail explanations are missing.

      Author's profile photo Former Member
      Former Member

      No images 🙁

      Author's profile photo Henry Banks
      Henry Banks

      images are OK from my side..

      Author's profile photo Henry Banks
      Henry Banks

      Here is the technical wiki describing the BW backend config : http://wiki.scn.sap.com/wiki/display/BOBJ/BW+With+RFC+JCO+Connections+In+Information+Design+Tool

      big thanks to Jacqueline Rahn

      Author's profile photo Erdem Uren
      Erdem Uren

      no images...

      Author's profile photo Former Member
      Former Member

      No images 😐

      Author's profile photo Former Member
      Former Member

      No Images could you please share the images tooo....