Qlik Compose – Add Data Mart Global Settings
Problem: There are two problems with data mart settings being at the data mart level only
- Creating a new data mart begins with its setting to the default even if the settings have been changed in an existing data mart. This causes inconsistency between marts when that is not the desired intention.
- There is way a user can compare settings across data marts to be aware of any unintended differences.
Example:
I created one data mart, which I changed the “Create tables in…” settings. I placed the data mart tables into its own database.
Two weeks later, I created a second data mart and forgot to change the settings. I was confused why my fact and dimension tables where not in the same data mart database as above. After realizing my mistake I had to drop the physical tables, adjust settings, re-generate, and re-run.
Proposed Solution:
A better solution is to offer a global data mart settings (pic below), which is used as the default for all data marts. Users can still override each individual data mart’s settings if needed. In addition, there needs to be a few key placed alerts for user to be aware of differences.
Key UX points:
- The Global Settings should default to the same default mart settings as exists today.
- When changing the first data mart’s settings, allow the user to apply the settings to the following:
- Change Global Settings to these settings?
- When changing an existing data mart’s settings, allow the user to apply the settings to the following:
- Change Global Settings to these settings?
- Change all Data Mart settings to these setting?
(This is only shown when 2 or more data marts exist)
- Allow a user to see settings across all marts in a grid and to
- Identify what is a difference
- Mark changes in the grid without having to go into each mart to make the change
- Option to sync all marts to the Global Settings