SAP Business Objects Information design tool with SAP HANA

Welcome to part 2 of the SAP Business Objects Information design tool (IDT) tutorial. If you landed on this page directly, please read the Part 1 before continuing further.

If you are done with the first part.. read on.

Step 2A: SAP Business Objects Information design tool – Creating a Data Foundation (BO Version < 4.1) 

Note: This explanation is of SAP Business Objects Information Design tool version less than 4.1. If you are on 4.1 version, skip to Step 2B.

The next step to create a universe, is to create a “Data Foundation”. Right click on your project folder and then navigate to New Data Foundation.

SAP Business Objects Information design tool

It asks you for the technical name and description of this data foundation.

SAP Business Objects Information design tool

I name this TMH_DF_OLD since this is the older method for creating data foundation (i.e for versions 4.1 and before).

SAP Business Objects Information design tool

Since there is only a single source of data, select “Single Source” and press “Next”

SAP Business Objects Information design tool

It now requires you to choose a relational connection to connection to the underlying data source. Choose the secured connection always which is the “.cns” one.

Press Finish when done.

SAP Business Objects Information design tool

As seen below, the data foundation has been created successfully. Also, a connection pane opens up. Expand the connection to see the SAP HANA schemas below.

SAP Business Objects Information design tool

As you see below, in this case, you don’t see the SAP HANA packages and the underlying views directly. You only have access to the schemas which house the tables and view metadata as well.

If you have gone through my HANA and SQL tutorials, you would already know that the “_SYS_BIC” schema contains the metadata for all the SAP HANA information views that we model under different packages. Expand this schema as I’ve done in the example below.

SAP Business Objects Information design tool

Now scroll down and find your SAP HANA information view on which you wish to create the SAP HANA universe. This is a bit of a mess since all the information views from your entire SAP HAAN system are in this schema and it might take a while to find it. This has been made better in the consequent SAP Business Objects versions which we will learn soon but for now, double click on your view once you find it.

SAP Business Objects Information design tool

Press the save button once done.

SAP Business Objects Information design tool

Step 3A: SAP Business Objects Information design tool – Creating a Business Layer (BO Version < 4.1) 

Note: This explanation is of SAP Business Objects Information Design tool version less than 4.1. If you are on 4.1 version, skip to Step 2B and 3B.

The next step now requires us to create a Business Layer. To do this, right click on the “Project” folder and select New Business layer from the context menu as shown below.

SAP Business Objects Information design tool

Select the type of data source as “Relational Data Foundation” and press “Next”.

SAP Business Objects Information design tool

Again, you are now required to enter a technical name for this business layer and a description.

SAP Business Objects Information design tool

Since this is the older method, I name the business layer as TMH_UNIV_OLD.

Press Next when done.

SAP Business Objects Information design tool

It would ask you to select a data foundation. Since we only have one data foundation here, it shows up. If you have multiple, choose the data foundation on which you wish to build the report on later.

Press Finish when done.

SAP Business Objects Information design tool

As you press finish, the new business layer now appears.

SAP Business Objects Information design tool

You are now one step away from converting this Business layer to a universe by publishing it to the repository. But before we get there, let’s see how to create a data foundation and business layer on Business objects versions 4.1 and above.

Once we have both these business layers, we will publish them together.

If you are not interested in the explanation of versions 4.1 and above and just want to learn how to publish the older universe version, skip to Step 4.

Otherwise, read on..


Step 3B: SAP Business Objects Information design tool – Creating a Business Layer (BO Version > 4.1) 

The process here is quite similar with the exception that you do not have to create a data foundation by yourself here, system does that part for you. Just a small added luxury .. nothing to brag about.

Right click on the project again, navigate to New “SAP HANA Business Layer” this time. You won’t see this option in SAP Information design tool versions <4.1 .

SAP Business Objects Information design tool

A window opens up asking for the Business Layer and Data foundation name – give them some meaningful technical names compliant with your project guidelines and press “Next”.

SAP Business Objects Information design tool

We already created a relational connection earlier which we can use here. But, we needed the secure connection (.cns which we had published to the repository earlier). Instead the system only shows us the local .cnx. For now, we compromise and pick this connection as the system gives us no choice. We would need to switch the connection later once the business layer has been created.

SAP Business Objects Information design tool

Click the checkbox and press “Next”.

SAP Business Objects Information design tool

Now, instead of having to go through the clutter of _SYS_BIC schema in the older IDT versions, we now have the luxury of having the SAP HANA package tree hierarchy at our disposal. Expand the schema where your view is contained.

SAP Business Objects Information design tool

For example, let’s choose our employee view. Press finish.

SAP Business Objects Information design tool

As you see below, a TMH_UNIV_NEW data foundation(.dfx) and a business layer (.blx) have been auto generated. This version now saved us the time of creating a data foundation.

SAP Business Objects Information design tool



1

Now, since we used a local .cnx connection to create this business layer and underlying data foundation, now comes the time to switch the connection to a secure .cns type. Only then would we be allowed to publish our business layer to the repository to create the universe.

To do this, double click on the new data foundation we just created – TMH_UNIV_NEW.

SAP Business Objects Information design tool

The data foundation opens up as shown below. Click on the “Edit Connection” button

SAP Business Objects Information design tool

This shows you the list of available connections. We would need to select the secured connection here and press “Finish”.

SAP Business Objects Information design tool

Press the “Save” button to save your changes.

SAP Business Objects Information design tool

Step 4: SAP Business Objects Information design tool – Publishing a Business Layer 

Finally, we reach the magical step where we publish the business layers which creates a universe. This step is fairly straightforward. Just right click on your business layer and press Publish -> “To a Repository”

SAP Business Objects Information design tool

Here, there are different validations/check you can perform based on your project guidelines about universes, if any. Otherwise, press “Next”

SAP Business Objects Information design tool

Choose the folder where you wish to publish this universe. In this example, we continue the shameless self promotion and name another folder as TEACHMEHANA. We will publish our Business Objects artifacts here from now on. Double click on the folder to go inside.

SAP Business Objects Information design tool

Press Finish to publish your universe here.

SAP Business Objects Information design tool

The Business Objects Information design tool congratulates you on this monumental achievement. The universe is now saved on the repository with the same name as the business layer with an extension of .unx

SAP Business Objects Information design tool

Let’s do the same for the business layer we created with the new process.

SAP Business Objects Information design tool

Ignoring the validation window, we reach the below step where I already navigated to our TEACHMEHANA folder where we saved our last universe. You can see it resting in the folder below under the unx extension as explained before.

Press finish to save this new universe as well.

SAP Business Objects Information design tool

IDT confirms that the publish was successful.

SAP Business Objects Information design tool

I started writing this tutorial on Oct-2016 and it’s the mid of March-2017 as I finish this. This has been the longest one by far. Had quite a slump and grew lazy in this duration but all the support for this site and the fact that viewership has blown up in the last few months motivated me to write again and finish what I started.

This is a free to use site and supports itself on ads. Please support this initiative by sharing at least one document on social media. It helps a lot.

Thanks,

Your Loyal and lazy author.

<<Previous Page                                                                                          Next Tutorial>>         

3 Comments

Leave a Reply

Your email address will not be published. Required fields are marked *