Building Cubes From Operational Systems (SQLBits Presentation)

25 November 2009

Filed under: Analysis Services,Event — Vincent Rainardi @ 9:40 pm
Tags: Analysis Services, Event

My presentation at SQLBits 5 last Saturday is here: Building Cubes From Operational Systems.

SQL Scripts for the DDL and DSV are here: SQLScripts.zip, and the BIDS project files are here: Broker5.zip.

Any problem downloading please let me know.

Comments (2)

[…] 2. CustomerKey. In the stock broker data mart (see my SQLBits presentation here for a background), in the account balance fact table we have AccountKey, OrderDateKey, […]

Pingback by Putting Higher Grain Attributes into a Separate Dimension « Data Warehousing and Business Intelligence — 5 March 2011 @ 6:23 pm | Reply
[…] is an order table in a stock brokerage company (click here for a background). It has these 3 columns: Order date time, cancellation datetime, settlement date. […]

Pingback by Datetime Columns in a Fact Table « Data Warehousing and Business Intelligence — 8 March 2011 @ 10:03 pm | Reply

Enter your comment here...

Fill in your details below or click an icon to log in:

Email (required) (Address never made public)

Name (required)

Website

You are commenting using your WordPress.com account. ( Log Out / Change )

You are commenting using your Google account. ( Log Out / Change )

You are commenting using your Twitter account. ( Log Out / Change )

You are commenting using your Facebook account. ( Log Out / Change )

Connecting to %s