Dimensional Model Output

The Datavault Builder is able to virtually output any data in dimensional or snowflake format. As storage and presentation are split, you don’t need to reload your dimensional model just because you want to add one more column.

Addtionally you can output the data in 3NF, flat table or data product format.

Get your free personal presentation

Dimensional Model FEATURES

Module

Feature

Supported

Dimensional Model

Visually select from the whole model

Yes

Dimensional Model

Select from hubs, links, satellites and link satellites

Yes

Dimensional Model

Automatically denormalize business objects (facts and dimensions)

Yes

Dimensional Model

Automatic grain checks

Yes

Dimensional Model

Visual consolidation of data

Yes

Dimensional Model

Visual harmonization of column names

Yes

Dimensional Model

Taking care of all necessary join operations without writing one line of code

Yes

Dimensional Model

Automatically evaluate tracking satellites

Yes

Dimensional Model

Either output all keys from a hub or only keys relating to a specific source

Yes

Dimensional Model

Automatic protection against fanning

Yes

Dimensional Model

Select Attributes by Drag and Drop

Yes

Dimensional Model

Rename Columns

Yes

Dimensional Model

Automatic Refactoring

Yes

Dimensional Model

Select as-of-now (SCD type 1) or as-of-then (SCD Type 2) output

Yes

Dimensional Model

Automatically create PIT tables if necessary

Yes

Dimensional Model

Automatically join several PIT tables if necessary

Yes

Dimensional Model

Automatic versioning in the logfile

Yes

Dimensional Model

Versioning trough GIT possible

Yes

Dimensional Model

Validate functioning of all dependent objects on changes

Yes

Dimensional Model

Rebuild automatically all dependent objects on changes

Yes

Dimensional Model

Preview data

Yes

Dimensional Model

Multi column selects

Yes

Dimensional Model

Self Service BI ready

Yes
GDPR Cookie Consent with Real Cookie Banner