Dimension vs Smart lists - Part 1 - MRC approach
It has been really a while that I posted anything. It was either work or arrival of a sweet angel into our lives, which kept me busy throughout this time. There have been many topics which I want to write about and probably my schedule will allow me to get back into motion. Let me give you a brief background about of this post. We were implementing a workforce and OPEX solution. The workforce module was an employee based model calculating salary, benefits, etc. and OPEX module had all expenses rolled up to give us P&L. The solution seems to be a usual one but things turned complex while we were almost half way through our implementation when the client brought in a new set of requirements. OPEX cube uses Entity and Location dimensions to track expenses while Workforce cube didn’t use Location dimension. It was after a while that client came back asking for the ability to track workforce expenses by locations. Being almost half way through the implementation, we had two option...