Configure Business Objects

Define Names of Business Objects and Attributes

Yotilla will automatically create business objects and business attributes based on the technical names of the source columns. You can rename the objects and attributes to better represent your data model and data warehouse use case. The following limitations apply:

• Each business object or business alias in the configuration must have a unique name.
• A business object cannot have several business attributes with the same name.

Rename a Business Attribute

1. Select the source in the Source column.
2. Click on the name of the attribute you want to rename.
3. Enter the new attribute name.
4. Press Enter to save the change.

Rename a Business Object

1. Select the source in the Source column.
2. Click on the business object that you want to rename.
3. In the Rename business object dialog that opens, enter the new name.
4. Click on Rename to save the change.

Consolidated Attributes

Yotilla only allows one source column in each source to be mapped to a specific business attribute of a business object. You can however map source columns in different sources to the same business attribute name. This will create a Consolidated Attribute. The order of the participating source attributes within the consolidated attribute determine which value will have priority.

For more details and examples, see Consolidated Attributes.

Define Business Keys

A business key is used to identify the business object and is defined by one or more business attributes. To toggle the assignment of a business attribute to be used as business key, click on the Key switch for that attribute.

If more than one business attribute of a single business object are marked as business key, the business key is called a composite business key.

Define Business References

A business reference describes a relationship between two business objects. For example, a business object that identifies a cash point can be related to a business object that identifies a store or a sales region.

To add a new business reference on a business object, do the following:

1. Select the source in the Source column.
2. In the row for the desired business object, click on the icon in the Business Reference column.
3. Enter the name of the business object that you want to create a reference to. Yotilla will automatically suggest business objects as you type.
4. Press Enter to save the change.

If a referenced business object has more than one business attribute marked as business key (composite business key), you will be required to define the mapping order in the Define business reference dialog.

To rename or delete an existing business reference, click on its name to open the Alter business reference dialog.

Define Object Hierarchies

If the same source is mapped to more than one business object you must define the relation between these objects as an object hierarchy. For example, the object Sale would be a child of the object Cash Point.

To define the hierarchical relation between objects mapped to the same source, do the following:

1. Select the source in the Source column.

2. Click on the icon in the header of the Business Object column.

   

3. Drag and drop objects to create a hierarchical relation.

   • To make a business object the hierarchical child of another object, drag and drop it on the left edge of the other object.

   • To make the dragged object the parent, drop it on the right edge of the other object.

   • To put two objects on the same hierarchical level, drag and drop either of the objects on the bottom edge of the other object.

   

   A hierarchical relation is indicated by a single line with a dot at the child object. In this example, Sale is now a hierarchical child of Cash Point.

   

4. To save the hierarchy and close the dialog, click on Save.