- Browse your Data Warehouse connection.
- Within your Tabular Project, click the Fact Table object group on the left pane to set your work pane to be your Fact Tables.
- From the right pane, drag a Fact Table into the middle pane, rename it with a tabular or relevant reference and select the Tabular target you want to place the table in.
We have renamed this table to "fact_order_detail_tabular" and selected the "Tabular_Demo_Fact target" to place it in.
- Click OK in the Fact Table's Properties screen.
- Right click on the table fact_order_detail_tabular from the left pane and select Create(Recreate).
- After the table has been recreated, right click again and select Update to update the table.
- Browse your Data Warehouse connection again, set your work pane to be Dimension tables and drag your Customer Dimension from the right pane into the middle pane Dimension group.
- Change the Object Type from Dimension View to Dimension and give the table a relevant name.
Select a tabular target location to place the table.
- Click OK in the Properties screen.
- Right click the dim_customer_tabular table from the left pane and select Create(Recreate).
- After the table has been recreated, right-click again and select Update to update the table.
- Repeat steps 7 to 11 for all other dimension tables joined to your tabular fact table.
- Right-click the fact_order_detail_tabular and select Query Via Excel to view the table in Excel.
Note
RED operations such as Validate Against Database, Generate Statistics, Table Row Count and Regenerate Indexes are currently not supported with Tabular mode.