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