sap business objects information design tool tutorial

You can convert Dimension objects to Measure object by right click the object and click “Turn into Measure with Aggregation Function” and its vice versa for Measure to Dimension object. You can edit / update the universe objects by clicking the particular object in the Business Layer window and I will open the edit window next to the Business Layer. Since we have select “Automatically create folder (class) and objects” check box, Business Layer would created the Folders & Object based on the available tables in your selected Data foundation.

Once you provided the business layer inform then select the Data found from where you want to create classes and objects. Select the Data source for the business layer and create Business layer by providing Business Layer Name and description. Go to File–New-Business Layer to create class, objects and other parameters and LOV’s. Also detect / manually validate is there any loops in your data foundation and fix those loops by using alias / context based on your requirement. In Insert table section, you can select the tables whatever you need to pull into your structure, select all of them and then click Insert.Ĭreate join between tables and setup cardinality for the same. Plain Data foundation layer would be available to insert necessary table, alias, joins, etc. Provide all the required details to create Relation Connection.Ĭreate New Data Foundation under DWBI_project.Ĭlick Next and then select your data sources (single Source or Multiple source) and here I have shown the Data foundation creation by using single data source.Ĭlick Next and it would show all the available connections under DWBI_project and here we have only one connection created under DWBI_project and select that connection for this Data foundation.Ĭlick Finish. Right Click the Local Project and create New Relational Connection.

Provide the proper project Name and location where you want to store the local project. This post is to explain the basic process of creating universe (.unx) using IDT.įirst create local project. The Universe creation process completely different and the functionalities used in IDT to create universe is phased in different resources. You can create universe using universe designer tool or Information design tool in SAP 4.1.

Sap business objects information design tool tutorial