Have you ever wondered how to add variables without losing non-shared dimensions? Allocate_Direct function is here! 🥁

How does it work?

Imagine having the following variables with different dimensions activated.

1. Salaries, with city and employee as dimensions.

2. Bonus, with only city as a dimension.

3. Total people cost = ALLOCATE_DIRECT Bonus BY Salaries, with city and employee as dimensions.

By using the ALLOCATE_DIRECT function, you can add the Bonus of each city to each employee's Salary to calculate the Total people cost, by city and by employee.

Please feel free to reach out to us with any questions or comments.