Skip to main content
O
OS_Pizza
Veteran
March 23, 2023

Workforce Planning

  • March 23, 2023
  • 1 reply
  • 0 views

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!

1 reply

J
OneStream Employee
JackLacavaOneStream Employee
OneStream Employee
March 24, 2023

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.

Terms & ConditionsAccessibility statement