For details about a table, open its Table Properties panel.
From this panel, you can view:
- The table's type—Fact or Dimension
- The table's name and description
- How many datasets, records, and columns the table contains, and how they compare to any limits
- When table was created
- Any dependent queries that use the table as a source
Change a table's type
When you create a table, you select its type:
- Fact , for information that builds up over time, such as general ledger entries or other transactions.
- Dimension , for relational information, such as rollups by department, or small sets of data used for mapping, like dates for fiscal year accounting.
You can edit a table's type as necessary:
- To change a table's type to Dimension, unimport any datasets, and click Change type to Dimension. When you change the type to Dimension, the table can include up to 2,000,000 records.
- To change a table's type to Fact, click Change type to Data. When you change the type to Fact, none of the table's columns will be marked as Key.
Rename a table
When you create a table, you assign it a name. To edit a table's name, such as to clarify the context of its data:
- From Wdata Home , select Rename from the table's menu.
- From the table, click Rename on the toolbar, or open the Table Properties panel.
Edit a table's description
When you create a table, you enter a description to help explain its data or intent. To update this description:
- Double-click the description on the table, or open the Table Properties panel.
- Edit the description.
- Click Save .