Any more feedback replies? 🙂

@ChazMan,

Thanks for yor reply.

I exclude customer 3 from CASE 3 like is excluded by a normal transactional fact table in CASE 2. And this is an example just to explain...

@paul-2,

I understand your perspective... and was an interesting answer. But the reality is that you have these agregate tables in real world scenarios assuming the role of a fact Table...

Not yet...:-(

Try to use google translator... but at least get the SQL Scripts

Regards,

Pedro

Download the SQL scripts included in the MSFT article to create dimension date:

http://support.microsoft.com/kb/2293691/pt

Regards,

pedro