How to handle : Product with N level of categroeis

View previous topic View next topic Go down

How to handle : Product with N level of categroeis

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

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

Back to top Go down

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

Post  Jeff Smith on 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

View user profile

Back to top Go down

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

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

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

Back to top Go down

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

Post  John Simon on 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

View user profile http://jsimonbi.wordpress.com

Back to top Go down

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

Post  Sponsored content


Sponsored content


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