Dimension and fact settings

The Settings tab of a Dimension or Fact table is where the table is deployed and kept running. Open it to deploy the table, read its statistics, remove the data of one source system with Truncate, and follow the transformation runs that load the table. Static tables have a tab like this too; see Static table settings.

When the table is not saved or deployed

The Settings tab fills in only after the table exists and is deployed. Until then it explains what is missing.

If the table has never been saved, the tab reads Table Not Created, with the table type named in the title, for example Dimension Table Not Created. The line under it reads Please save the Dimension table first to view settings for a Dimension, and names the Fact table in the same way for a Fact. Save the table first, as described in Create a dimension or fact table.
If the table is saved but not deployed, the tab reads Dimension Table Not Deployed and says: "Deploy this Dimension table to access statistics and transformation runs. Deployment creates the table in the warehouse with your current configuration." A banner adds: "This Dimension table is not deployed. Deploy to enable statistics and transformation runs."

No statistics and no runs appear until the table is deployed, and Refresh stays greyed out.

Deploy the table

Deploying creates the table in the warehouse from its current configuration.

Open the table and go to Settings.
Click Deploy in the statistics bar. The button appears only while the table is not deployed.
Read the result.

You see	What it means
Table deployed successfully, with The table has been deployed to the warehouse	The table is in the warehouse. Statistics and runs start loading, and Preview unlocks.
Table partially deployed	Only part of the deployment succeeded. The line under the title names the problem.
Table deployment failed, with The table could not be deployed., or Failed to deploy table	The table was not deployed. Read the message, fix the problem, then click Deploy again.

You can also deploy from the tree's right-click menu. Deploy, run, truncate and monitor tables covers that route and the other day-to-day actions. Troubleshooting lists the messages that can stop a deployment.

Read the statistics

Above the other areas sits the statistics strip, titled Dimension Statistics or Fact Statistics. Three cards summarise the stored table:

Size: the stored size of the table.
Rows: the number of rows the table holds.
Partitions: the number of partitions the table is split into.

A card shows - while its value is not available.

The strip also carries the actions:

Synchronize keeps the stored table in step with its definition.
Refresh reloads the statistics. It stays greyed out until the table is deployed.
Truncate opens Truncate Partitions; see below.
Deploy appears only while the table is not deployed.
Drop, which removes the stored table but keeps its definition so you can deploy it again, is covered in Deploy, run, truncate and monitor tables.

Truncate partitions

Truncate removes the stored data of one source system. The table itself stays.

Open Settings and click Truncate. The button appears once the table is deployed.
In Truncate Partitions, pick a source system under Source Systems. If none can be truncated, the panel reads No source systems available.
For a Fact, pick the dates under Partition Dates; the panel shows N selected for your choice. For a Dimension that stores history, pick a Truncate Target instead.
Check the row counts next to each choice. They follow the Truncate Target you select.
Click Truncate and read the confirmation: You are about to truncate N partitions from source system "X". It ends with This action cannot be undone.

The target options are:

Truncate Target	What it clears
Main	The current (main) table data
History	The historical (versioned) data
All	Both main and history data

Details along the way:

Truncate in the dialog stays greyed out until you pick a source system and, where dates are shown, at least one date.
Before you pick a source system, the dates panel reads Select a source system to view its partition dates.
A source system with no dates shows No partition dates for this source system.
A table with nothing to target says This table has no partitions to target.
While the truncation runs, the button reads Truncating...

Warning

Truncation removes data for good. The confirmation names the number of partitions and the source system, and states that the action cannot be undone.

When the truncation finishes, you see Partitions truncated successfully, with N partition(s) have been truncated. If it fails, you see Failed to truncate partitions; read the message and try again.

Follow the transformation runs

Under the statistics strip, Transformation Runs lists the production runs that write into the table.

Each row shows the run's ID, Name, Status, Note, Rows, Error, Duration, User, Start, Finish and Snap Date.
Only production runs appear. Test runs you start while validating a transformation are not listed.
While a run is running, a stop button appears at the end of its row. Click it to stop the run; the button is disabled while the stop is in progress.
The list reloads by itself: every 2 seconds while a run is in progress, and every 10 seconds otherwise. Refresh runs reloads it straight away.
The list shows 50 runs per page; you can switch the page size to 20, 50, 100 or 500.
A table with no runs yet shows No transformation runs found.

When you run a transformation from the Transformations tab, the popup switches to Settings so the run appears here. To create, schedule and run them, see Table transformations.

Questions, answered

Why does Settings say "Table Not Created"?

The table has not been saved yet. Save the table first, including its General step, then open Settings. For a Dimension the message reads Please save the Dimension table first to view settings; for a Fact the same line names the Fact table.

Why does Settings say "Dimension Table Not Deployed"?

The table is saved but not yet in the warehouse. Click Deploy on the Settings tab. Until the table is deployed, no statistics and no runs appear here.

Where did the Deploy button go?

Deploy is shown only while the table still needs deploying. Once the table is in the warehouse, the button is hidden.

What do the Size, Rows and Partitions cards show?

A summary of the stored table: its size, its row count and its number of partitions. A dash appears while a value is not available. Click Refresh to reload the numbers.

Why is Refresh greyed out?

Statistics need a deployed table. Deploy the table first, then click Refresh.

Why is the Truncate button greyed out?

Truncate in the dialog stays disabled until you pick a source system and, where dates are shown, at least one date. If the table has no partitions to target, the dialog says so.

Why are there no partition dates for my source system?

Either no source system is selected yet, or the selected source system has no partition dates on this table. Pick another source system, or check its data. The dates belong to Fact tables; a Dimension that stores history uses a Truncate Target instead.

Why is my test run missing from Transformation Runs?

This list carries production runs only. A test run you started while validating a transformation stays with the transformation.

Why does the runs list say "No transformation runs found"?

No production run has written to this table yet. Run one of its transformations from the Transformations tab, and the run appears here.