You are Here: ://Universe creation using Information Design Tool (IDT)

Universe creation using Information Design Tool (IDT)

Hello Everyone,

In this document we are going to learn, Universe creation using Information Design Tool (IDT) which is one of the semantic layer tool from SAP BusinessObjects Business Intelligence (BOBI).

The major steps involved in universe creation are:

  1. Create new project in IDT
  2. Create Relation Connection to HANA
  3. Publish the connection to Repository
  4. Create Data Foundation
  5. Create Business Layer (Universe)
  6. Publish the Universe to Repository

 

Step 1: Create new project in IDT:

  • To create a new project in IDT, click on ‘Create’ → Project.

image1

  • Give a name for the Project and click on ‘Finish’.

image2

Step 2: Create Relation Connection to HANA:

  • Now right click on project and select ‘Relational Connection’.

image3

  • Give the Connection Name and Click on ‘Next’.

image4

  • Select the driver as “SAP” => SAP HANA => JDBC Driver.

image5

  • Now click on ‘Next’ to proceed further.
  • Provide the HANA connection parameters as below and click on ‘Test Connection’.
  • Once the Test is successful, Click on finish.

image6

  • Now we can see a.cnx connection under the new project we have created.
  • We should have a .cns (Secured) connection to publish the universe to Repository.
  • Once we publish this .cnx connection to repository, we will get .cns connection.

Proceed to the next page to continue reading…

By | 2016-03-22T04:31:03+00:00 July 3rd, 2015|BOBI|4 Comments

4 Comments

  1. sapbwhana July 5, 2015 at 11:50 AM - Reply

    excellent information

  2. Armando June 8, 2016 at 4:47 AM - Reply

    Great post.

  3. Subhash Chandra Kilari June 9, 2016 at 2:54 AM - Reply

    Can we create UNIVERSE using ODBC connection? If yes, whats the difference between UNIVERSE-JDBC and UNIVERSE-ODBC?

  4. Kannan August 9, 2017 at 6:03 AM - Reply

    Excellent post

Leave A Comment

two + seventeen =

Skip to toolbar