In this submodule, the users can manage their information marts to use the raw data from the Data Vault for useful insight!
Information mart
This section allows users to create, edit, and delete the information marts in which the key insights are built through a set of scripts that will be executed on the raw vault and/or the business vault.
Create an information mart
To create a new source, click on the “Create an information mart” button in the top-right corner of the interface. A pop-up wizard will appear, requiring you to enter several required and optional attributes.
Specifically, you must provide:
-
Name: mandatory – The name of the information mart
-
Business Description: optional — Detailed information about the information mart from a business perspective.
-
Technical Description: optional — Any descriptive detail on the technical aspect of the information mart
-
Schema: mandatory – The schema in which the tables and views built through the set of scripts in the informtion mart should be created
-
Prefix: optional – Prefix for tables' name generated automatically
-
Snapshot group: mandatory – The group of snapshot for which the information in the tables of the information mart will be caculated/distributed
Once you have entered this information, click the “Save” button to create the new information mart.
If the information mart is successfully created, it will appear in the list of information marts.
If you would rather not create the information mart, click the “Cancel” button.
Modify an existing information mart
To modify an existing source, click the “Open in a new tab” button for the corresponding information mart.
A tab will appear, allowing you to edit the required and optional attributes (refer to the instructions for creating an information mart for more information) in a first section “Information mart metadata”.
Once you have made your changes, click the “Save” button to apply them. If you would rather not save your changes, close the tab without saving, and they will be discarded.
Note that, by clicking on the second button on the vertical menu on the left, a list of the scripts created under the information mart is displayed with the possibility to create, display in a new tab and edit or delete a script.
By clicking on the third one, a feature allowing to sort the script to define in which order they should be run during an execution of beVault. By using the arrow, scripts can be reorderd to be below, above or at the same level of another script (meaning that they will be run in parallel).
Delete an information mart
To delete an information mart, click the trash icon on the corresponding line. Please note that, if you delete a source system, any script within the information will be deleted.
