M2M Dimensions in OLAP Cube

We have a situation in building an OLAP cube where there is a M2M relationship between two dimensions. An example could be Faculty and Department. We have actually measures that we are collecting so there is data in the cells (not just a flag=1). In other words, we are not talking about a factless fact. But a Professor (Faculty) can work in many Departments and a Department can have many Faculty (Professors). How can we handle this in a cube structure?

Questions by Tom Haughey   answers by Tom Haughey

 

This Question is not yet answered!

 
 

Related Answered Questions

 

Related Open Questions