Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Essbase Allocation Advice — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Essbase Allocation Advice

Received Response
edited Aug 2, 2018 2:36AM in Essbase 2 comments


Essbase Allocation Advice


Hello All,

I'm attempting to write an allocation calc that retains its 'source' information after being allocated out. My thought is to use a second set of dimensions for two purposes:

1. Take in the alloc % for target intersections

2. To receive the $

This is my desired result (note the header line = column names):

I'm struggling with the calc though, since I'm not sure how to bring multiple dimensions into the calculation and multiply across all possible combinations. I'm also not sure how to create a relationship where src_b = b.

Any advice? Is there a better way to go about this?

Howdy, Stranger!

Log In

To view full details, sign in.


Don't have an account? Click here to get started!