Skip to Content

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

To report this post you need to login first.

3 Comments

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

  1. 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.

    (0) 

Leave a Reply