Search
InstantDoc ID
GO

Browse By: Author | Issue

November 20, 2007 05:20 PM

Data Warehousing: Dimensional Role-Playing

When a single dimension needs to be part of a fact table multiple times
Rating: (0)
Michelle A. Poolet
SQL Server Magazine
InstantDoc ID #97272

Executive Summary:
When many same-type events are in a single fact table, you have an accumulating fact table. Dimensional role-playing is when a single dimensions needs to be part of a fact table multiple times. The views (dimensional roles) serve as virtual dimensions.


Role-p...

...This article is for paid Professional Members only.

Already a Professional Member? Please log in now:

NOT A PROFESSIONAL MEMBER? YOU CHOOSE:

Professional Membership

Monthly

Annual

VIP Membership

Monthly

Annual

Compare Member Benefits

Add a Comment

rhilton, thanks for the feedback! What could we have done better, to give you the information you needed?

Anne6/24/2008 7:03:27 PM

Just didn't get what I needed out of this article.

Ray6/24/2008 7:48:00 AM

You must log on before posting a comment.

Are you a new visitor? Register Here

Related Resources

Top 8 Considerations for Sizing a Microsoft SQL Server BI Solution
A Tip Guides by Hewlett-Packard
Moving SQL Server to the x64 Platform
A EBooks by AMD
A Jump Start to SQL Server BI
A EBooks by Microsoft
The Essential Guide to SQL Server 2005 BI
A Essential Guides by Dell
More
GOOGLE LINKS
SPONSORED LINKS
FEATURED LINKS

© 2010 Penton Media, Inc.

Windows is a trademark of the Microsoft group of companies. Windows IT Pro is used by Penton Media Inc. under license from owner.