Separate dimension or dimension attribute

View previous topic View next topic Go down

Separate dimension or dimension attribute

Post  kuldeepchitrakar on 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 : 34
Location : India

View user profile http://www.bidwbooks.com

Back to top Go down

Re: Separate dimension or dimension attribute

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

View user profile

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