Configure the Dimensional Model
The last step before deploying the data warehouse configuration on the target system is to configure the data mart. The data mart is provided in a dimensional model, which is a snowflake schema containing facts and dimensions. Once the dimensional model has been defined and deployed, the data mart is ready.
Timelines
You must define which timelines you want to use for each business object in your data mart. The Load Timeline is managed by Yotilla and is always available. If your source has an Inscription Timeline configured, you can use that timeline instead or together with the load timeline. For more information about timelines, see Temporality.
Facts and dimensions in the data mart will have a suffix that indicates the used timeline. The suffix LTL stands for the load timeline and the suffix ITL for the inscription timeline.
SCD Types
Yotilla can provide two different SCD types for dimensions: SCD1 (only the latest version of your data) and SCD2 (historical versions of your data). This way you can provide exactly the data your business users need. You can for example provide only the latest name of the product, all the historical prices, and the current and historical product category.
Business key attributes (indicated by a key icon in the Key column) will be automatically included. Business attributes and business references are not automatically included and must be explicitly marked for inclusion.
Dimensions will have a prefix in the data mart that indicates the used SCD type. The prefix D1 stands for SCD1 and D2 for SCD 2.
Fact Tables
Fact tables differ in their design and loading patterns from dimensions and therefore must be handled differently. Yotilla currently only supports transactional fact tables. To provide a transactional fact table, check the box in the Transactional column for the business attribute.
Transactional facts will be indicated with the prefix TF in the data mart.
Rename a Business Attribute
To rename a business attribute in the dimensional model, click on the Rename icon 
or in the name field to enter edit mode, type the new name, then click Enter.
Create the Data Mart
When you have defined the dimensional model, click on the Apply icon 
next to the business object that you want to deploy. Yotilla will then create and populate the data mart.
