Many to Many relationship in Dimension Modelling - Part 1

Some times business poses questions that are fundamentally flawed. However, the beauty of dimension modelling is, most times it doesn't allow you to build wrong logic. A typical example is many-to-many relationship between levels.

Question for this series: Consider a company where a product where belongs to one or more Product Groups, and a Product Group can have one or more Products. How will you represent that in a dimension model or cube?

So, in this series we will discuss various options, their pros and cons, the fundamental flaw in this question and something I call as 'intelligent modelling'.

I hope I will get a good audience for this series, and useful comments.

1 comment:

jake george said...

cognos online training, online training – it support – corporate training the 21st century software solutions of india offers one of the largest conglomerations of software training, if you’re serious about a career in it, 21st century would like to provide you a guidance don’t hesitate to organize a free demo session. for any further information regarding the courses once go through our website visit: | call us +917386622889 - +919000444287 -