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.

Open

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:

• Data Load Actions (for admin roles only) – Shows the available Data Load actions:

  • Refresh – Copies data from Data Sources (configured in the Datamart fields) into the target Datamart.

  • Truncate – Deletes (all/filtered) rows in the target Datamart.

  • Purge cache – Clears the cache. The cache applies to queries on Data Sources and Datamarts, from the UI and from logics. There is no expiration, but it is limited in size (default is 1,000 entries / partition). It is a LRU (Last Recently Used) cache. It gets invalidated after a data change (load, flush, refresh). Cache purging is a recovery mechanism.

• Refresh  – Refreshes the data.

• 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).

• Mass Edit (for Data Sources only) – Enables you to update several rows/attributes at once. See Common Table Actions for details.

• 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.