Cost allocations by Department & Employee

Post Reply
CRP0021
Posts: 11
Joined: Mon Aug 21, 2017 2:14 pm
OLAP Product: TM1
Version: 10.3
Excel Version: 2016

Cost allocations by Department & Employee

Post by CRP0021 » Fri Nov 01, 2019 7:33 am

Hello all,
I'm looking for an efficient way to setup rules to capture departmental salary allocations by employee and would appreciate any advice.

Basically there should be an input of allocation % by Department and by Employee. This would be the source view or the sender view. The receiver of the allocation would be the flip side and all rule based. I have a good understanding of the logic and how it should work just running into a roadblock translating this into rules. This could be split up into 2 cubes if necessary, I'm not bound by any design structure at the moment.
For simplicity here is a screenshot example of what I'm trying to achieve.
Thank you in advance!
Allocation example.png
Allocation example.png (28.15 KiB) Viewed 228 times

Post Reply