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

Discussion Group for the Dimensional Data Warehouse and Business Intelligence Community


A Bracket Dimension - A Generic Example?

Kimball Forum :: Topics :: Dimensional Modeling and Data Architecture

Go down

A Bracket Dimension - A Generic Example? Empty A Bracket Dimension - A Generic Example?

Post  seadog2010 Mon Mar 14, 2011 10:58 am

Any templates/suggestions for a generic Bracket Dimension that could handle multiple bracket categories (age, height, salary, etc)?

Not only would this dim handle a variety of bracket categories, it would also need to handle which specific bracket ("bucket")within a category applies to a fact record.

For example:
Bracket Category - "Age"
# Brackets - 4 (<25, 26-40, 41-65, 66+)
Specific Age Bracket relating to a fact record (say, the 26-40 age bracket)

-Seadog

seadog2010

Posts : 23
Join date : 2010-03-04

Back to top Go down

Back to top

- Similar topics

Kimball Forum :: Topics :: Dimensional Modeling and Data Architecture

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