Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

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

Summary

Essbase Allocation Advice

Content

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.

Register

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