dimension fact matrix

View previous topic View next topic Go down

dimension fact matrix

Post  cpeterson on Tue Jan 31, 2012 1:05 pm

I was wondering if anybody knew of a good resource for dimension/fact matrices documents.

cpeterson

Posts : 9
Join date : 2011-11-26

View user profile

Back to top Go down

Re: dimension fact matrix

Post  ngalemmo on Tue Jan 31, 2012 4:44 pm

If you are referring to the dimensional matrix bus, it is desribed in the DW toolkit book as well as the Lifecycle toolkit book.


It is usually in the form of an Excel sheet with fact tables (aka subject areas) listed vertically down the sheet and dimensions listing horizontally. A blank (no relation) or a character (sometimes different characters indicating the nature of the relationship or a footnote reference) appear in the intersecting cells where a relation exists.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: dimension fact matrix

Post  cpeterson on Tue Jan 31, 2012 4:53 pm

Yes that is exactly what I was referring to. I was just curious if there were any excel templates out there that were used for documenting the dimension bus matrix.

cpeterson

Posts : 9
Join date : 2011-11-26

View user profile

Back to top Go down

Re: dimension fact matrix

Post  ngalemmo on Tue Jan 31, 2012 5:08 pm

Facts on the left and dimensions across the top is the basic form.

Depending on the complexity you may create high level matrix (business area and generic dimensions) for an enterprise view and lower level matrixes showing fact tables and role based dimensions for specific subject areas. The lower level matrix may contain coded intersection cells to improve clarity, for example you may have a date dimension and use coding such as D, M, and P at the fact/dimension intersection to indicate the facts are at a daily, monthly or fiscal period level of date. You may also break dimension columns out by role, using multiple date dimension columns for shipping date, order date, and so on depending on the nature of the facts and subject area. What you wind up doing depends on what you plan to use the matrix for and its intended audience. As you move up the corporate food chain, the level of detail needed tends to diminish.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: dimension fact matrix

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top


 
Permissions in this forum:
You cannot reply to topics in this forum