Dimensional Model

In the business objects layer, we can prepare a denormalized output based on the data vault core. A business object can be composed of fields coming from multiple related elements in the data vault. The Business Object generator will take away the work of manually joining the data vault elements and generates an as-of-now-view, on top of which the business logic can be applied in the business rules.

Definition

A business object is a denormalized view layered on top of the datavault. It delivers an as-of-now-view, based on the data-set of a chosen granularity satellite.

When creating a new business object and selecting a hub, additional technical fields are available, such as effective last seen date of a record or if the record was flagged as deleted in the source.

../_images/dimensionalModel.png
  1. Search Bar

    Allows to search for an existing business object and open it in the business object generator.

  2. Create Business Object

    Opens up the dialogue for Creating a Business Object.

  3. Add Related Business Object

    Opens up the dialogue to create a related business object. The button is only active, if a business object is currently open in the business object generator. It will invoke the dialogue to create a business object and preselect the starting hub. For details: Model a dimensional output.

  4. Business Object Slider

    The slider will open up after creating a business object or when opening an existing business object. It lets you see and compose the output of the business object.

  5. Element Selector

    The visual selection is available after creating a business object or when opening an existing business object. It lets you select an element from the data vault you would like to take fields from.

Creating a Business Object

Steps

Navigate to the business objects module and click onto “Create business object”. Fill out the fields of the dialogue and confirm the creation. Add attributes from the datavault to your output.

../_images/createBO.png
  1. Start Hub

    Declaration, based on which hub the business object should start from. Will determine the primary name of the business object.

  2. Source System

    Declaration, for which source system the business object should be generated.

  3. Granularity Satellite

    Defines the dataset, which is delivered to the output.

  4. Comment

    Custom notes about the Business Object. Appears as well in the documentation.

  5. Functional Suffix Name

    Displayed suffix name for the business object.

  6. Functional Suffix ID

    Technical suffix, which is appended to the created view.

  7. Create Business Object

    Button to complete the creation dialougue.

Working with the Business Object Generator

Once a business object is created, you can modify its output using the business object generator.

Adding attributes to the output
  1. Use the element selector and either click onto a hub or a satellite, to select a data vault object.

  2. The available columns will appear in the left part of the business object slider.

  3. Select a column you would like to have in the output.

  4. Rename the column into a business relevant terminology.

Available technical attributes

Certain attributes are automatically available within the environment, such as last seen timestamps in delta loads. With the help of these fields, you can for example cleanse outputed data from deleted records in the source.

Data Vault Object Type

Available technical attribute

Description

Hub

LT

Load Time - Timestamp when the record was inserted into the Hub

LS

Load Source - Source from which the record was inserted

DLS

Delta Load Last Seen (per Staging Table) - Timestamp for when the key has been seen a delta load the last time

FLVC

Full Load Validity Change (per Staging Table) - Timestamp for last state change (added/deleted) of a key in a full load

FV

Full Load Valid (per Staging table) - Flags if the key was in the last full load or not

Satellite

LTS

Load Time Satellite - Timestamp when the record was inserted into the Satellite

PS

Entry is Present in Satellite - Flags if the key is available in the Satellite

Link

LTL

Load Time Link - Timestamp when the record was inserted into the Link

LSL

Load Source Link - Source from which the record was inserted

ELSL

Effective Last Seen Time Link (over all Staging Tables / Systems) - Timestamp when the record was effectively seen the last time in a full or delta load

DLSL

Delta Load Last Seen Time Link (over all Staging Tables / Systems) - Timestamp, when the record was seen the last time in a delta load

FLVCL

Full Load Last Validity Change Time Link (over all Staging Tables / Systems) - Timestemp for the last state change (added/deleted) of a record in the link

Hint

No manual saving is needed. When modifying the output-columns of a business object, after each modification the result is directly sent to the database and the underlying view is rebuilt.

Browsing

You can follow along related objects in the element selector as it is possible in the data vault module, too, by double-clicking onto a hub. Some elements can appear in a gray color. In this case, it is not possible to select columns yet, as no data vault load has been defined yet to follow along the relation. Please first add a load for the link.

An important difference to the representation in the data vault is, that hubs, connected by more than one link, will be represented as two separate hubs. This way you can directly indicate, which relation to follow for the joins.

Traversing Links / available related objects

While modelling in the Datavault, the expected cardinality of a link was already defined. Based on this information, the business object generator can support you in following relations / traversing links without having a fanning in the output data.

Therefore, only related objects and links are shown, which are of the same or a more aggregated grain. This means, you can only follow along many-to-1 or 1-to-1 links, but not many-to-many or 1-to-many.

Deleting a Business Object

A business object can only be deleted, if no customized business rules are declared anymore. Therefore, previously remove all business rules. An exception to this is the unaltered default ruleset, which will automatically be removed when deleting the business object. If the unaltered business ruleset is still fed into the accesslayer, the deletion will automatically remove it from the accesslayer as well.

Steps
  1. Open up the business object you would like to delete.

  2. Open up the Business object slider

  3. Click onto the trash bin behind the magnifying glass in the Business Objects Columns.

  4. Confirm the deletion.

Note

If a dependent business ruleset exists, the deletion will directly return an error message.