IN2BI, Microsoft Business Intelligence
data, stories & insights
rss | email | twitter

DWH DECK Part 4: The Model Window

Adapted for version 1.1 on 18/04/2011

This is the fourth part of a series on the DWH DECK. A tool that will allow you to build and maintain your data warehouse better and faster. This series will act as documentation and will give you some insides into the way the program works.

Overview of this series

Generate
When you are satisfied with the choices you made it's time to generate the model. Menu: Model.
A new window will open: DWH Deck - Model. Choose Generate in the menu and the model will be generated.
 

You can now expand the treeview and select one of the tables under Staging, Data Vault or Data Mart.

For each table you can examine the columns in the treeview and the SQL statements:

  • to create the table (under the tab Table)
  • to create the view that is used to import the data (Under the tab View)
  • to create the stored procedure that is used to import the data (under the tab ETL)

Publish
When you are satisfied with the created model you can use menu option:Publish.
The sql statements to create the tables, views and stored procedures will be executed.

Run
With the tables, views and stored procedures published in your data warehouse you can now run the ETL stored procedures. Menu option: Run.

If you select one of the tables under Staging, Data Vault or Data Mart you can now see a short history of the imported data of the selected table (under the tab: Run History).
 

» Similar Posts

  1. DWH DECK Part 3: Importing Source Information
  2. DWH DECK Part 5: Staging
  3. DWH DECK Part 2: Creating your data warehouse

» Trackbacks & Pingbacks

    No trackbacks yet.

» Comments

    There are no comments.

Comments are closed