Skip to Content
Author's profile photo Sriram Vijay R

Step By Step Guide to Create an Universe on Top of SAP ERP Queries using IDT

1. Open Information Design tool and create a new project by clicking on new Button.

1.JPG

2. Create a relational connection to the ECC system. you can createit from context menu of Project or directly from new button.

1.JPG

3. Navigate to SAP –> SAP ERP 6 –> SAP JCo. Select the data middle ware driver as below.

1.JPG

4. On clicking “Next”, you will be asked to provide system details like IP, Host name, System number, System ID, username and Password. It is preferable to use a user ID whose Password won’t change in future.

1.JPG

4.  5. Test Connection.

1.JPG

6. A connection will be visible below the project as below.

1.JPG

7. Publish the created connection to the repository and create a shortcut to it in your PC for future usage.

1.JPG

8. Next Step is to create a data foundation. Right click on Project and create a data foundation. Choose the data foundation type as single source.

1.JPG

9. On clicking next you will be asked to select a connection from available connections.

1.JPG

Earlier an Infoset query should have been created in ECC using T code SQ02. Refer other available document for creating an Infoset.

10. In the data foundation, InfoSets available in R3 are displayed in the Connections window as below. You can either navigate through Hierarchy or search using technical names.

1.JPG

     11. Define Keys as per design. Here I am setting Document number as the key.

1.JPG

     12. After creating connection and data foundation, next step is to create business Layer.

     

    1.JPG

     13. Choose the available data foundation from list.

     1.JPG

     14. In this layer you can create new calculated measures, prompts, Aggragation type and many other front end functions.

     1.JPG

14  15. Publish Universe to the repository.

     1.JPG

     16. Open web Intelligence rich client. Create a query on top of the Published universe.

     1.JPG

     1.JPG

     17. Run Query. A report will be available as below.

      1.JPG

    

45

Assigned tags

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

      Thanks Sriram for the post,

      Really helpful for a beginner 🙂

      Author's profile photo Sriram Vijay R
      Sriram Vijay R
      Blog Post Author

      Thanks for reading. 🙂

      Author's profile photo Harshil Joshi
      Harshil Joshi

      Hi Sriram,

      I am following the same steps, but cannot set any object as primary key, options are disable for the same. Attached image for reference.R3CONN.png

      We are on BO 4.1 SP05

      Please guide.