Dimension Role-Playing Bus Matrix

View previous topic View next topic Go down

Dimension Role-Playing Bus Matrix

Post  rnb on 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

View user profile

Back to top Go down

Re: Dimension Role-Playing Bus Matrix

Post  LAndrews on 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

View user profile

Back to top Go down

Re: Dimension Role-Playing Bus Matrix

Post  rnb on Tue Mar 15, 2011 7:39 pm

Thanks, that makes sense.

rnb

Posts : 6
Join date : 2010-09-21

View user profile

Back to top Go down

Re: Dimension Role-Playing Bus Matrix

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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