Datamart Viewer

The Datamart section allows (especially non-admin) users to view all data in the selected Datamart in Analytics. This can be useful when users need to verify the data used in their calculations.

To view a Datamart or its Data Sources:

1. Navigate to Analytics > Data Analyzer > Datamart Viewer.

2. In the Select Datamart drop-down menu, select the Datamart you want to view.

3. Select a Data Source from the drop-down list (only Data Sources related to the selected Datamart are displayed) to view its content.

By default, the tables display up to 12 columns, with the following priority: fields that have a function (key, alt-key, per unit basis, etc.), fields that are dimensions and then all other fields up to the limit. If you want to see more fields, add them using the Select Fields to Display option or create and save a view preference.

Additional options are:

• Status History – Shows information on the Datamart status history – a list of Data Load actions that have been executed. Clicking on the Info icon opens a pop-up window with Data Loads messages (if available).

• Export XLS, CSV – Exports the selected Datamart or Data Source to the XLS or CSV format.
   Any value starting with @,+,-, or = will be escaped by adding a leading single quote.

• You can filter, search etc. like in all grid tables and save the changed view as a preference.