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

Separate dimension or dimension attribute

2 posters

Go down

Separate dimension or dimension attribute Empty Separate dimension or dimension attribute

Post  kuldeepchitrakar Thu Sep 13, 2012 10:55 am

Hi

I have dimension say dimProduct
and product has its product type and its riskBand

now should i put them in product dimension or separate dimension table e.g. dimProductType, dimRiskBand.

Basically, how to decide if those belongs to dimension or should exists as separate dimension.

from reporting perspective, user will analyze data by product, its type and by riskBandType also.

Thanks,
Kuldeep

kuldeepchitrakar

Posts : 17
Join date : 2010-04-21
Age : 39
Location : India

http://www.bidwbooks.com

Back to top Go down

Separate dimension or dimension attribute Empty Re: Separate dimension or dimension attribute

Post  TheNJDevil Thu Sep 13, 2012 12:29 pm

If product type or risk band actually describe part of the fact, (example, order line item) separate from the product, then they would be separate dimensions. I don't see this as what you are describing.

You state Product has its ProductType and Riskband. Therefore they are attributes of the product dimension.

TheNJDevil

Posts : 68
Join date : 2011-03-01

Back to top Go down

Back to top

- Similar topics

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