Sap universe design tool user guide free download pdf

GBI bikes are consistently ridden in the Tour de France and other major international road races. GBI produces two models of their signature road bikes, a deluxe and a professional model.

The key difference between the two models is the type of wheels used, aluminum for the basic model, and carbon composite for the professional model. GBI off-road bikes are the preferred choice of world champion off-road racers and have become synonymous with performance and strength in one of the most grueling sports in the world.

GBI also sells an Accessories product line comprised of helmets, t-shirts, and other riding accessories. Figure 1 displays the GBI range of products. Traditionally GBI was a wholesaler who sold their bikes to retailers who then resold the bikes to the end consumers. Recently GBI has decided to sell their bike to the end consumer via the internet. All sales organizations have a wholesale distribution channel responsible for delivering the products to the customers.

However, only one sales organization is required in each country to support internet sales. The diagram below displays the GBI organization to support the sales process. They have discovered that one of their departments are using a Microsoft Access database to record sales data. The Department Heads have indicated that they would like the information provided in a user-friendly format. This will facilitate them to gain greater insight to their sales data to understand the trends and sales performance.

To provide the connection between the data source Microsoft Access and the reporting tool a universe needs to be created. A semantic layer is a business representation of corporate data that helps end-users access data using common business terms.

Often when database developers build databases their main objectives involve the efficient creation, updating, and deletion of data. They are not usually concerned about whether nondatabase people understand the complexities of the underlying structures. While business users want to create reports based on the data contained in the database to facilitate decision making. The semantic layer insulates the business users from the underlying data complexity while ensuring the business is accessing the correct data sources and using consistent terminology.

The semantic layer enables users to use common business terms rather than the technical database language to access, manipulate, and organize information, it simplifies the complexity of the business data. The following diagram displays the various components of the semantic layer. A Universe is a semantic layer tool used in Business Objects to map the data in your data source using everyday terms.

The Universe enables the user to create a query to extract the data from a data source, describe it using common business terms, and then analyze the data using different reporting tools. The Universe is used to run queries against the data source to extract data. On the right of the screen is the schema of the database.

While on the left are Universe objects that are required for reporting. However, before you create a universe you need to create a database connection. This will open Derived table dialog box.

You need to enter Derived table name and SQL query to select data in derived table. You can also make use of tables and columns along with Operators and Functions to create expression for derived table.

The derived table appears in the schema with the physical database tables and you can build the objects on derived tables. In Universe schema pane, select the derived table that you want to delete, and use delete key to delete the table. You can also create a nested derive table which is derived from an existing derive table. To create nested derived table, you need to enter SQL expression for the nested derived table based on a derived table.

You can also make use of DerivedTable function as a reference to the derived table in your nested derived table. You can also rename a derived table, and new name is updated in all other derived tables that reference it. To rename, select Derived table and right click Rename Table. It is a text box above universe window and you can also see 3 buttons left to formula bar. In formula bar, you can see formula or expression of any selected join in the "Structure" pane, or selected object in the "Universe" pane.

To see the formula, select the object as shown below and you can see formula used. You can modify the expression as required and to apply change, click on validate to apply the changes. To build a universe, you need to organize objects and classes in Universe. Universe pane presents a hierarchical view of the classes and objects in the active universe. In UDT, you can use "Universe pane" to view, create, edit, and organize classes and objects.

You can cut, copy, or paste objects in Universe pane. Also, it is possible to hide one or more components in the Universe Pane. These are hidden from Web Intelligence users, but remain visible in the universe design tool. You can drag table from the table browser into the Universe pane and this will create class automatically.

To create classes using table browser, select the table in the table schema and dragging it into the Universe pane. By default, it takes table name as the class name. You can also create an object manually inside a class manually. Right click a class in the Universe pane and select Insert Object. This will insert an object under the selected class and the Edit Properties box for the object appears. Enter the name of object in name and you need to mention object names are defined as per understanding of business users.

It may be different from the actual column names in database schema. You can also define if the object is a dimension, measure or detail. To do this, navigate to Properties tab under Object Properties. You can also use object as List of values. You can also edit an object definition. You can use default hierarchies in Universe Design tool and they are displayed as objects and classes in Universe pane. You can also create customized hierarchies using objects from different classes.

New hierarchies are defined in Hierarchy editor. This will open Hierarchy editor. To create new hierarchy, click on New button and enter the name of hierarchy. Add objects to custom hierarchies. To select a series of dimensions, hold down CTRL and click each dimension.

Using LOVs in Universe, you can allow business users to select associated value with an object while running reports. LOVs take values from database and they are displayed when a designer selects to show list of values for object in Universe. Double click on an object in Universe pane and this will open edit properties dialog box. Go to Properties tab. Select or clear check boxes in the list of values group box at the bottom of the page. Enter the name for the associated.

LOV file in the List Name box as shown in above snapshot. You can also use edit option to define restrictions on the list values. Use query pane to create a query on the list data. To view list of values associated with an object, double click on an object and navigate to Properties tab. To see values, click on Display tab. You can see table or hierarchical view of associated list of values. In query pane, drag an object that you want to serve as a condition on the list of values for the active object over to the Conditions pane and double click the operator in the Operators pane.

Connection to an OALP data source can be created using connection wizard. You can use standard and transactional info cubes to create OLAP Universe or you can also use virtual info cubes. You can see Bex queries supported more Universe features as compared to InfoCube and InfoCube requires more effort to customize Universe. Click Add in the "Wizard Connection" dialog box. In the next window, you need to select Connection Type. Select Personal to restrict access to the universe creator.

You can use personal connections to access personal data on a local machine only. You can also launch connection wizard from Quick Design wizard. Click on Begin button as shown below and it will take you to Define Universe parameter window. You can also check connection properties of an existing connection. In UDT, you have an option to run query against the aggregated tables in database. A condition can be set, and that query will run against aggregated tables for query optimization.

This method of using aggregated tables is known as aggregate awareness. To build aggregated aware objects, you need to first identify the objects: measure or dimension objects. You need to find out all possible combinations of aggregate objects in all tables and then arrange them in aggregate level order. Pass the names of all aggregated tables as arguments. When a universe is deployed, you make it available to Web intelligence users for reporting. Universe are deployed when they are exported to CMS repository.

To make Universe available to all designers, you have to check if the Universe is not built on a secured connection.

Secured connections are used to export Universe to CMS repository. You need to select the target Universe domain and a group. If someone else is using Universe, it will be showed as greyed locked. For Universe in CMS, you can define users who can edit and delete based on access rights assigned to their user group.

At the Universe level, you can define users who are allowed to use a particular Universe. Access to Universe are managed using restrictions and you can apply multiple restrictions to single dashboard. You can also edit and delete restrictions as per access requirement. The dialog box appears.

The current restrictions which are applied to Universe are available under available restrictions column. You can find users and user groups that are defined for each restriction under Available Groups and Users pane.

To add a user or group, click on add user or group button. You can also define groups with highest priority of restrictions. Click on Priority button and restriction on group name with highest priority will take precedence. To create new restrictions, click on New button on left side. This will open Edit restriction dialog box. You have to enter the restriction name and you can see all restriction control tabs below. From each tab, you can select different restriction types as mentioned above.

For example, control settings allow you to limit the size of result set and the execution time of the query. Once you create new restrictions, you can apply to selected user and group. Once restriction is applied, it will show restriction name in the right pane.

In the Universe design tool, the access to users and groups are managed using restrictions. In BO 4. Linked Universes are used to share common components such as parameters, classes, objects, or joins from different data sources.

From BO 4. In UDT, Universe are created with file extension as. In IDT, Universe file extension is changed to. To open unv file in IDT, it cannot be directly opened, however, you can convert unv file to unx file to open in Information Design tool. You cannot open an IDT. Universe Design tool is single source enabled.

IDT is multi source enabled which means the data can be extracted from different data sources while creating a Universe. You can select unv file saved in repository or on local folder. Once you connect to BO repository, you can find all Universe published to repository in the left pane. In the next window, you have an option to select conversion parameters. You can also change the destination folder to save.

Previous Page.