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 ?
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.