Navigate to the Mart.

Data Home Page

Select Data to see a list of tables and select one to view the data.

This will bring you to the data page.

Image showing how to Navigate to the Data Page

Initially, the table names will be displayed as tiles. In the top right is an action menu.

Image showing the navigation to the Data Page Action Menu

Toggle between Tiles and List

One of the options allows you to toggle between list and tiles

Image showing the navigation to the Data Page Action Menu

Table Grouping

The other concerns the grouping

Image showing the grouping options

Option Function
Security Groups by Private / Public
Type Groups by Tables / Views
Category Groups by Category

Object Browser

On the left of the Data Page is the Object Browser. At the top is tha action panel

Image showing the object browser action panel options which are Pin / Unpin, Search for Tables / Views / Categories, Select Object Types and Select Tags

View a Table

Select a table to see the data.

The data will appear with a set of tabs

Image showing the data page with a red box around the tabs

Data Tab

The data tab shows the first page of data and allows for various ways to see it.

The Data Action Panel

In the top right, there is a Data Action Panel

Image showing the data view page for REF_COUNTRY and the location of the Edit Data Action Panel in the top right

Image showing a close up of the Data Action Panel. This has 6 buttons in a horizontal row with a small gap to a seventh. On the left is a key marked API with the label "OData Endpoint". Next to it is key with the image of a wall with the label "Model". After that there are two keys with arrows on them, a downward pointing arrow marked "Download" and an upward pointing arrow for "Upload". ON the right of those is a key with a triangle pointing right with a line on the right of it touching the top. The text for this key is "Run a Pipeline on this data". Finally, before the gap, there is a key with a pencil on it with the caption "Edit in UI". There is then a small gap to a key with a cross in it which has the caption "Close"

Action Description
Switch to Old Table Component Reverts back to the previous version of the grid. This is there in case the user has any problems with the newer grid
OData Endpoint See Use the OData API
Model Page See Edit Model via UI
Download See Download data
Upload See Upload data
Run a Pipeline on this data See Process Data View Rows
Edit in UI See Edit Data in UI
Close Goes back to the main data page

Column Picker

By clicking on the down arrow of the column picker, the user can select which columns they wish to see

Column Picker

There are also options to hide empty columns and show system columns.

Filtering and Statistics

In order to filter and view the statistics on a column, click on the heading. In this case, we are going to look at the region codes in REF_COUNTRY.

Image showing a red box around the WHO Region column heading

This will bring up the Column Pop-up

Image showing the Data Column pop-up. In the top right are the column name and type underneath is the sorting which sort the values. In this case, the column is text so it offers the choice to sort in alphabetical or reverse alphabetical order. For numbers, the options are Large to Small or Small to Large. Underneath that is the filtering using text and to the right are the top 5 values with the number of records with those value. Underneath is the link to the "Analyze/Show more" button which brings up the "Full Column Statistics" pop-up

On the left is a box showing the top 5 values with the count of the records for each value. At the bottom is an Analyze/Show more button which brings up an Analysis for all of the records.

Image showing the Data Column Full Analysis pop-up. The position of the number of Rows and Distinct values is shown at the top right corner. The search panel is shown in the middle left. The sort is on the middle right and underneath, taking up half of the pop-up there is a panel which shows All of the values showing count and percentage of the records in the table which have the value. Values can be filtered by clicking on the checkbox on the right

By clicking next to one of the values, you can filter the data.

If a column has been filtered then the title colour changes to blue

Iamge showing the title colour of the filtered column has changed to blue

Removing a filter

There are several ways to remove a filter

The first is by using the funnel directly on the data page

Image showing the blue filter with a cross next to it on the Data View page

You can also do it from the column pop-up-box

Image showing the 2 eraser icons, the option to uncheck the filterand the option to erase the text in the text box

Fields Tab

Image showing the fields tab with a list of the fields and a box around the Model shortcut

The fields tab gives a list of fields in the table / view. In the top right, there is a shortcut to the Data Model Page

Info Tab

Image showing the Info tab for REF_COUNTRY

The Info in the Info tab comes from the model

History Tab

Image showing the History tab for REF_COUNTRY

The History tab gives a list of all of the changes which have been done to the data. Click on the arrow on the left of the change to find out more details about it.

Pipelines Tab

Image showing the Pipeline tab for REF_COUNTRY

This tab shows all of the pipelines which make changes to the table. Click on the code to go to the Pipeline Editor

Access Tab

Image showing the Access tab for REF_COUNTRY

This tab lists people users but also client applications (external applications) and xmart service accounts (other marts) which have access to the table/view.

A prominent message is displayed if the table/view is available to the anonymous public via API.

Click on any row of the Access tab to open that user for editing in the Admin area.