Skip to Content
Author's profile photo Tammy Powlas

New Universe Wizard in BI4.1 Information Design Tool – Using it to create an ERP Universe

First you should watch this great tutorial by the SAP Product Education Team at http://scn.sap.com/docs/DOC-42033

You’ll notice the new welcome screen:

/wp-content/uploads/2013/05/1newwizardcheatsheets_222257.jpg

Notice in the lower left-hand corner the cheat sheets; it reminds me of the HANA studio.

I go ahead and select the Universe Wizard.

/wp-content/uploads/2013/05/2newproject_222258.jpg

You can create an existing project or new project.

I create a new project.

/wp-content/uploads/2013/05/3newproject_222259.jpg

Since I am creating an ERP universe I select Relational data source.

/wp-content/uploads/2013/05/4datasourcerelational_222260.jpg

Give the relational connection a name.

/wp-content/uploads/2013/05/5relconnectname_222261.jpg

Since this is a SAP ERP universe, I select the SAP JCO connection

/wp-content/uploads/2013/05/6driver_222262.jpg

Enter the parameters for the connection

/wp-content/uploads/2013/05/7erpconnection_222263.jpg

Enter more parameters listed below.

/wp-content/uploads/2013/05/8parameters_222264.jpg

This is a single-source universe

/wp-content/uploads/2013/05/9singlesource_222265.jpg

Now follow the normal steps of creating the data foundation and the business layer.  In my example I am creating a Universe against an ERP infoset.

/wp-content/uploads/2013/05/10datafoundation_222266.jpg

The business layer – I have to turn the value into a measure:

/wp-content/uploads/2013/05/11businesslayer_222267.jpg

/wp-content/uploads/2013/05/12query_222268.jpg

Follow the normal steps of publishing the connection to the repository.

Assigned Tags

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

      Thanks Tammy,

      Please give to us more about 4.1

      Does BI 4.1 supporting ECC table with ERP connection ?

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      No, it does not support direct connections to ERP tables yet.

      Author's profile photo Former Member
      Former Member

      Did you know any logical reason why ?

      Author's profile photo Tammy Powlas
      Tammy Powlas
      Blog Post Author

      I do not - I believe that is a question for SAP to answer, not me.  I am just a customer.

      Author's profile photo Former Member
      Former Member

      I am customer too. Maybe you will ask on next workshop.