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


Loading dimensions

2 posters

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

Go down

Loading dimensions Empty Loading dimensions

Post  kruthi Mon Aug 24, 2009 2:43 am

Hi,

I have a scenario where I have a time dimension and have quarters and seasons in it. A quarter can be a subset of season and season can be a subset of quarter. Can you please let me how to load alternate paths of such a Time dimension?

kruthi

Posts : 1
Join date : 2009-08-24

Back to top Go down

Loading dimensions Empty Re: Loading dimensions

Post  ngalemmo Mon Aug 24, 2009 10:47 am

The time dimension would be by date. Season and quarter would simply be attributes of the date. They are independent of each other.

Some industries (such as retailing or agriculture) may have seasons that are product dependent. In such cases implementation of season becomes more complex as it is a relation between date and product.
ngalemmo
ngalemmo

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

http://aginity.com

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