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 (28.15 KiB) Viewed 6826 times