Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Dimension Role-Playing Bus Matrix

2 posters

Go down

Dimension Role-Playing Bus Matrix Empty Dimension Role-Playing Bus Matrix

Post  rnb Tue Mar 15, 2011 5:57 pm

How come in a bus matrix, none of the dimension roles are indicated (e.g. only date dimension instead of begin date and end date "logical" dimensions)? Wouldn't this help with the design of the OLAP cube?

rnb

Posts : 6
Join date : 2010-09-21

Back to top Go down

Dimension Role-Playing Bus Matrix Empty Re: Dimension Role-Playing Bus Matrix

Post  LAndrews Tue Mar 15, 2011 6:19 pm

My $.02....

The Bus Matrix is not intended to design the cube (or reports).

The Bus Matrix is intended to be used as part of the Dimensional design process. If focusses on business processes (facts) , business context (dimensions) and their logical relationships.

More detailed design criteria (SCD definitions, hierarchies, helper/bridges etc) are defined during later design stages.

Technology specific design elements (e.g. cube designs, report designs) come even later in the design process.


LAndrews

Posts : 132
Join date : 2010-05-13
Location : British Columbia, Canada

Back to top Go down

Dimension Role-Playing Bus Matrix Empty Re: Dimension Role-Playing Bus Matrix

Post  rnb Tue Mar 15, 2011 7:39 pm

Thanks, that makes sense.

rnb

Posts : 6
Join date : 2010-09-21

Back to top Go down

Dimension Role-Playing Bus Matrix Empty Re: Dimension Role-Playing Bus Matrix

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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