Now we have understood how to insert tables and create relationship amongst them. This posts covers how to create different types of objects in Business Objects Universe objects.
Classes are nothing but a logical group of objects. Classes are represented as a folder in a universe. Classes are very useful to group related objects in order to locate them fast and for better organization of universe. The order of objects in a particular class forms a default hierarchy from top to down order.
Classes can also contain sub classes and objects can’t exist without classes.
How to create a class
There are three ways you can create class
- Right click on the free area of left tree bar and click on class OR
- From insert menu, select class OR
- From tool bar click on insert class icon
- An create class dialog will appear provide the name and description of class and click on ok
- To create sub classes repeat above process by click on a particular class under which you want to create subclass
Objects represent a database column or an expression in a Business Objects universe. These objects are represented as different icon based on type of objects. Creating meaningful objects is a very essential part of universe development as these would be used by end user to create reports.
Users will drag drop these objects in a report panel in order to create a reports. An object or combination of objects infers a SQL which in turn gets fired on underlying database to fetch the data for report.
There are three types of objects in a Universe.
- Dimension Objects
- Detail Objects
- Measure Objects
Let’s first understand creating objects regardless of its type.
How to create an object
- Right click on class and from menu select object OR
- Click on Insert from menu bar and click on objects OR
- Drag-drop the column from a universe pane under a class you want to create an object
- Once objects icon appears under a class, double click on it to edit its properties
- Enter Name of Objects
- Select the type of objects. It depends on type of data to be returned by a column which would be used in Select clause of objects property
- Enter relevant description
- Enter the Column name or expression on Select box
- If you want impose a restriction on data to be returned by object enter a SQL expression in Where clause
- Further you can force a Business Objects to use specific table in a join condition when particular objects is used in query by click on “Tables” button and selecting table to be used.
- Click on Properties tab to define objects type and other properties.
· Select the type of objects
· Check if you want associate LOV with objects and other properties based your universe specification and type of objects
· Click on Advanced tab to define advance properties.
- Select the security access level of objects by default its Public. Following type security access leve can be applied to an object.
· Public : All user can see and use an object
· Controlled : User with controlled or higher profile can see and use object
· Restricted : User with controlled or higher profile can see and use object
· Confidential : User with confidential or higher profile can see and use object
· Private : User with private or higher profile can see and use object
· Check the required check boxes to specify if a objects can be used in result, condition and sort operations
· Database format is applicable only to date objects by default its windows regional format further it can be set
· Click on Keys tab to define primary key and foreign key to make object index aware which is helpful in performance optimization
· Source Information tab is useful when Universe is create from Data Integrator. It help to define technical information of an object like description, mapping information and Data Lineage information.
A dimension objects is an object against which analysis is done. It’s a main part of analysis. It represents single column of a table or multiple column of table.
To create dimension object follow the procedure give in “Creating Object” and from properties tab select dimension radio button.
A detail provides descriptive data about a dimension. A detail is always attached to a dimension. It maps to one or more columns or functions in the database that provide detailed information related to a dimension. You define a detail object by selecting Detail as the qualification for an object, and specifying the dimension attached to the detail.
To create dimension object follow the procedure give in “Creating Object” and from properties tab select Detail radio button.
Measure object are numeric objects and they are dynamic in nature as they value returned by measures changes based on dimension objects used in the query.
To create dimension object follow the procedure give in “Creating Object” and from properties tab select measure radio button. You would generally use aggregate functions while creating measure object.
Following five basic aggregate functions are available to be used while creating measures.
Including above other aggregate function can also be used.