Create a table from editable table

Edit online

You can create a table from an existing Editable Table using the following steps:

From TBM Studio, go to Home tab >� New  dropdown > select Table .

In the Create Table popup, enter a name for the table and select Ok.

Select the Editable Table tile.

Select a value from the Editable Table dropdown.

Choose the method of upload and select the recurring publish schedule

Save and check-in the table.

Disable Data Flow in Enriched Transform

If you configure an enriched editable table and then change the information in the source transform table in the development stage, the data will not flow automatically to the enriched editable table. Only once the table is Published, the data will flow from the source table to the enriched editable table.

To enable this feature, navigate to TBM Studio > Project Settings, and select the Disable Data Flow in Enriched Transform option.

If the feature is disabled, the data flow will be as shown below.

If the feature is enabled, the data flow will be as shown below.

After checking in the changes, the data will appear as shown.

For the current enriched editable table flow, consider 3 tables involved:
  • Table_1 – source transform table
  • EET_Table_2 – enriched editable table built off Table_1
  • Trf_Table_3 – transform table created off ET_Table_2.

The Values shown in Trf_Table_3 come from 2 tables:

  • Table_1 has the original source rows, and
  • EET_Table_2 has the overlay records which modifies the cells in the original source rows from Table_1, and may include new, added rows. (It cannot delete any existing rows in Table_1).

When you upload a new dataset to Table_1, the changes will be seen immediately in EET_Table_2 and Trf_Table_3 even though you have NOT published changes from the EET_Table_2 to Trf_Table_3. EET_Table_2 only has the overlay records to the source rows from Table_1.

This new feature gives you the option to control which behavior you prefer and is controlled via a new project setting: “Disable Data Flow in Enriched Transforms”
  • Disabled (default) – the transform table will receive updates from the source table (Table_1) immediately (current behavior)
  • Enabled – the transform table will only see the updates from the source table (Table_1) when the table upload is “checked in”
Note: Editable Tables are now branch-specific, allowing work in each branch without impacting the main Trunk. That is, creating a branch will have its own copy of Editable Tables and modification in trunk will not be visible in branch.

Uploading and Publishing Data to a Transform Table

The Transform Table feature allows administrators to upload and publish data from an editable table in the data pipeline.

Correcting Errors in Editable Table Changes

You can correct errors in editable table changes that were published to an earlier period. Suppose you published changes to an editable table in January, but later discovered that there were errors in the data. You can download the data from the Transform Table for January, make the necessary corrections, and then upload the corrected data directly to the Transform Table. This will correct the errors in the cost model and ensure that the data is accurate and up-to-date.
Note: This feature is applicable only for blank ET and not enriched ET
  1. Navigate to the data pipeline step and select the Transform Table for which you want to upload data.
  2. Download the table data for a specific period.
  3. Make the necessary changes to the downloaded file. The data should be in the same format - it can only by modified, rows/ column can neither be deleted nor added.
  4. Upload the corrected data directly to the Transform Table for the specific period. This will overwrite the original data and correct the errors in the cost model.