OLAP - I have in RDBMS(Data Warehouse) - ParentId and ChildId are TypeId's
ParentId and ChildId have many to many relationship. One parent can have many children(TypeIds) and same way One ChildId can have multiple parents(TypeIds)
How will I design a OLAP solution for these tables - what are my dimension and its hierarchy?
I want to display for All Parents->All Children->Measure(Values), DateTime
View Complete Post