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

How to handle : Product with N level of categroeis

3 posters

Go down

How to handle : Product with N level of categroeis Empty How to handle : Product with N level of categroeis

Post  kuldeepchitrakar Thu Apr 28, 2011 5:05 am

Hi

I have a product say ‘ABC’ now its product dimension, however a product can have N level of categories.

e.g.

Product ‘ABC’ can have following categories. Cat1->Cat2-Cat3

And product ‘XYZ’ can have C at1->Cat2->Cat3->Cat4

How do I handle this scenario. Can I use bridge table between Product dimensions and Fact table.

Also, It is also possible that product can change the categories means SCD, If I use bridge table how to handle SCD.

--Kuldeep

kuldeepchitrakar

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

http://www.bidwbooks.com

Back to top Go down

How to handle : Product with N level of categroeis Empty Re: How to handle : Product with N level of categroeis

Post  Jeff Smith Thu Apr 28, 2011 12:22 pm

One way of doing it is to have the hiearchy for ABC repeat one of it's levels. Nothing says that Cat3 to Cat4 can't be one to one.

Jeff Smith

Posts : 471
Join date : 2009-02-03

Back to top Go down

How to handle : Product with N level of categroeis Empty Re: How to handle : Product with N level of categroeis

Post  kuldeepchitrakar Fri Apr 29, 2011 1:27 am

Jeff Smith wrote:One way of doing it is to have the hierarchy for ABC repeat one of it's levels. Nothing says that Cat3 to Cat4 can't be one to one.

But levels are not limited it could 4, may be 5 or may be 10.

What if I create a categories table which has a bridge table type structure (represents hierarchies within categories) and join it to Product dimensions.

Categories(:1) -----> (:N) Product (:1) ------->(:N) FactTable

As Product can have only one root level hierarchy. Do you see any problem traversing the product hierarchy like

Product1->Category1->Categgory2->------- etc

--Kuldeep





kuldeepchitrakar

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

http://www.bidwbooks.com

Back to top Go down

How to handle : Product with N level of categroeis Empty Re: How to handle : Product with N level of categroeis

Post  John Simon Sun May 01, 2011 6:49 pm

You need to either use a parent-child hierarchy, or a bridge table.
Whichever you choose will depend on your OLAP/Reporting tool.


John Simon

Posts : 186
Join date : 2009-05-29
Location : Melbourne, Australia

http://jsimonbi.wordpress.com

Back to top Go down

How to handle : Product with N level of categroeis Empty Re: How to handle : Product with N level of categroeis

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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