Workforce Planning

[OS_Pizza]

What alterantive solution you have build for Workforce Planning. I don't want to use People Planning Market place solution.

1) Run calculations inside the cube by storing all employee information.

2) Relational Table + Cube.

Can you give me a top level design where i can start with ?

Thanks!

[JackLacava]

The problem with anything related to employees is that they make for bad cube metadata: flat, changing often, potentially with thousands of members. So, ideally, you want to keep them somewhere else, like a dedicated relational table, and then blend them with cube data only when strictly required. You could link their data via Attributes and do some Stage blending on reports.

A similar approach you could use is to keep them and all their data out of the cube altogether, by pushing it through BiBlend  when you need to aggregate it.