How-to
How to list cube records in a data table
Create a data table in Hubviz Studio to list the records of a cube row by row, with search, sorting and pagination.
A data table lists the records of a cube, one row per record, like a spreadsheet. Readers can search, sort and page through it.
When to use it
- To show the detail behind the charts, such as every sale of the month.
- To check that the data arrived correctly after connecting a source.
- When people need to find one specific record, such as a business unit or a customer.
If you want to add up, count or cross fields, use a pivot table. A data table does not summarize anything: it shows the records as they are in the cube.
Create the data table
- In the project side menu, open Charts, click the + button (Add New Chart/Demonstration/Filter) and choose Data Table. Another way: expand the Data Table section, click Add New and choose New Data Table.
- Under Data Table Configuration, type the name in Table Name.
- Pick the cube in Cube to Display Data. The Table Data Preview shows the records right away.
- Save with Ctrl + S.
There is nothing else to set up in the editor. The columns, their names and their order come from the cube.
What the table shows
| Item | Where it comes from | How to change it |
|---|---|---|
| Columns | The cube fields, in field order. | Change the order in the cube fields. |
| Column title | The field’s User Friendly Name, or the technical name if it is empty. | Fill in the field’s friendly name. |
| Hidden columns | Fields marked with Hide Field in the cube do not show up. | Clear the option in the cube. |
| Dates | Shown as day/month/year and time, for example 01/01/2026, 00:00. | There is no format option. |
| Numbers | Shown as they are in the cube, with no currency symbol or thousands separator. | There is no format option. For formatted values, use a pivot table. |
Search, sort and page
| Action | How |
|---|---|
| Search | Type in the search box above the table. The search looks at every column. In the image, searching for Retail leaves 12 of the 36 records. |
| Sort | Click a column title. Click again to reverse the order. |
| More column options | The three-dot menu on the column title filters, hides or sorts by that column. |
| Change page | Use the arrows in the footer. Pick how many rows per page: 5, 10, 20, 50 or 100. |
Search and sorting only apply to the person looking at the table. They are not saved with it.
Example: detailed sales
In the Sales Results 2026 sample project, the Detailed sales table uses the Sales cube. It has 36 records: 12 months for each of the three business units (Industry, Retail and Services). Place it at the end of the Executive view dashboard, below the charts, for anyone who wants to check the number for a specific month.
Watch out
- Calculated fields do not show up. The table shows the fields that come from the source. In the example, Gross profit is a calculated field and is left out.
- The data has to be loaded. If the cube has not been processed on this computer yet, the preview shows Cube data not found.. With no cube selected, you see Cube not configured. Configure the cube to continue..
- Dashboard filters do not narrow the table in Hubviz Studio. Hubviz Studio keeps the full cube records when a dashboard filter is applied. Use the table’s own search.
- Very large cubes. Every record of the cube goes into the table. For cubes with many rows, prefer a pivot table with totals.
- To place the table on a dashboard, use Add Chart in edit mode. It shows up in the data tables group of the picker. See How to build a dashboard.