The Datavault Builder stores internally the data in Data Vault format but it can create in a fully automated way 3NF representations of the data to be used with reporting tools like SAP Business Objects, Cognos oder MicroStrategy.
Additionally it is able to output the same data in dimensional, flat table and data product format.
Module | Feature | Supported |
|---|---|---|
3NF | Visually select from the whole model | Yes |
3NF | Select from hubs, links, satellites and link satellites | Yes |
3NF | Automatically denormalize business objects (facts and dimensions) | Yes |
3NF | Automatic grain checks | Yes |
3NF | Visual consolidation of data | Yes |
3NF | Visual harmonization of column names | Yes |
3NF | Taking care of all necessary join operations without writing one line of code | Yes |
3NF | Automatically evaluate tracking satellites | Yes |
3NF | Either output all keys from a hub or only keys relating to a specific source | Yes |
3NF | Automatic protection against fanning | Yes |
3NF | Select Attributes by Drag and Drop | Yes |
3NF | Rename Columns | Yes |
3NF | Automatic Refactoring | Yes |
3NF | Select as-of-now (SCD type 1) or as-of-then (SCD Type 2) output | Yes |
3NF | Automatically create PIT tables if necessary | Yes |
3NF | Automatically join several PIT tables if necessary | Yes |
3NF | Automatic versioning in the logfile | Yes |
3NF | Versioning trough GIT possible | Yes |
3NF | Validate functioning of all dependent objects on changes | Yes |
3NF | Rebuild automatically all dependent objects on changes | Yes |
3NF | Preview data | Yes |
3NF | Multi column selects | Yes |
3NF | Self Service BI ready | Yes |