Dimension Role-Playing Bus Matrix
2 posters
Page 1 of 1
Dimension Role-Playing Bus Matrix
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
Re: Dimension Role-Playing Bus Matrix
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.
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
Similar topics
» Questions about Dimension Role-Playing
» Role-playing dimension or seperate dimensions?
» Role playing Dimensions: When is it appropriate?
» Role Playing vs single generic Conformed (for drill-across) time dimension
» How do I join a role playing date dimension view with a Fact table in SQL Server?
» Role-playing dimension or seperate dimensions?
» Role playing Dimensions: When is it appropriate?
» Role Playing vs single generic Conformed (for drill-across) time dimension
» How do I join a role playing date dimension view with a Fact table in SQL Server?
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum