03-23-2023
01:56 PM
- last edited
3 weeks ago
by
JackLacava
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!
03-24-2023 05:11 AM - edited 03-24-2023 06:15 AM
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.