Skip to Content

We know that in BI 4.0, we cannot create a Universe using BeX with Information Design Tool(IDT) ,as we were doing it in legacy designer tool.

But Using a cube we can build the universe using IDT. Below are the steps for the same.

Universe creation using InfoCube in IDT

  1. Insert a relational Connection

6.JPG

2.  Select SAP Java connector Driver from the available list

  2.JPG
3.  Fill in the credentials

3.JPG

  4. On Clicking the ellipses highlighted, the below info provider screen appears.

4.JPG

5. Under filter dropdown, check CUBE and Click on OK and Click Finish to complete the Wizard to create a connection.

 

5.JPG

6. With the Connection created, create a data foundation with type as multisource-Enabled  and just select single connection created above and build the data foundation layer.

7. Finally build the Business layer and publish it to repository.

8. Use this universe (unx) created for reporting.

Universe can be created between Cube and SQL (no BEX) and create an .UNX in IDT.  Few advantages are

  • Direct link to infoprovider level
  • Allows to combine multiple source in a single connection.
  • Allows you to customize the objects.

o

To report this post you need to login first.

14 Comments

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

  1. Rusyinni Rusanto

    Hi

    I am able to create the connection to Cube like you explained.
    However, when I proceed to create DataFoundation, choosing multisource-enabled, there’s no connection for me to choose from.

    Any idea?

    Thks

    Rus

    (0) 
  2. Nirupa Nalabotula

    Hi,

    I am getting below error while testing BW Relational connection, can you please help me.

    Test failed,

    com.sap.connectivity.cs.java.drivers.DBDError: [Data Federator Driver] Cannot reach server. Reason: attempt to establish connection failed: java.net.ConnectException: Connection refused: connect

    Thanks in advance,

    Nirupa

    (0) 
      1. Nirupa Nalabotula

        Hi Sayi,

        I have checked the credentials, everything is correct. Server is also up as other IDT’s created using the same server are working fine. Could there be any other reason for this error?

        (0) 
    1. Ingo Hilgefort

      In BI4 you can only create a UNX (XI 3.1 Universe) based on BEx query. In BI4 there is no need at all to have a Universe on top of a BEx query, unless you wanna combine data from BW with another data source.

      regards

      Ingo Hilgefort, SAP

      (0) 
      1. Rajeev Parimi

        Hi Ingo,

        When I created Universe using UDT on BEx Query, I was not able to access from WebI?

        But I can access from Web Rich Client.But Im getting error as Database Error:Failed To Execute MDX Query

        How can I access from WebI [SAP BI 4.0]?

        regards

        Rajeev

        (0) 
      2. Liza Layne

        Hi Ingo

        In BI4 I have tried to combine data from BW with another data source, in this instance an excel spreadsheet. However, I get an error stating the specfied RDBMS is invalid, this only occurs when creating a multisource data foundation.

        However, I create a single source data foundation to the same excel spreadsheet, I able to create a universe.

        Not sure if this issue due to having BI 4.1 Server running on a Unix box or it may be a known issue when trying to build multi source universes with BW Cube relational connections.

        Liza

        (0) 
  3. Mariele Specht

    Hello,

    could someone tell me why I cannot see SAP Netweaver BW under step 2 > SAP  ?

    Is this because I have BW based on HANA?

    I´m using SAP BI 4.1 SP02.

    thanks and regards

    MarieleSAP BW missing.PNG

    (0) 

Leave a Reply