Build a table directly in your Cube Workspace and have it available everywhere tables are used, including the spreadsheet apps.
Required permission: Create Tables. This permission is available to Finance Users and Admins by default.
Create a table from scratch
- In the Workspace side navigation, select Tables.
- Select Create Table.
- Enter a name in the Table Name field.
- Select one or more scenarios to associate with the table.
- Select a sharing level: Table Owners Only, Specific Team Members, or All Users.
- Define your first column: enter a Column Name and select a Data Type.
- Repeat for each additional column.
- Enter your data row by row in the inline grid.
- Select Update to save the table.
Note: Table names have a 150 character limit.
Note: When you create a table with more than one scenario, the initial save copies the same data to every selected scenario. You can edit each scenario independently afterward.
What updates automatically
- The table becomes available in the Excel and Google Sheets apps via Open Existing Table.
- Any edits made to the table in a spreadsheet are reflected when you open it in the Workspace, and the reverse.
- Calculated columns recompute from the data you enter or import.