- When a new Tabular fact table is created, all numeric columns that are market as additive (apart from key columns) will have auto-created measure totals.
- If the created columns are not relevant for the table, they can be deleted by using the right-click option to Delete Column.
- To add new measures to your Tabular Fact table, right-click on a column in the middle pane and click Add Column. In the table column properties you can set the following fields:
- Column name: "measure_sales_total"
- Business Display Name: "Sales Total"
- Type: Measure
- Click the Transformation tab, add SUM to the Column Transformation Code and then select a sales column from the list. Click OK.
- Right click the table fact_order_detail_tabular from the left pane and then select Create(Recreate).
- After the table has been recreated, right click again and then select Update to update the table.
null