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

ASO MDX Outline formula - Multiple SUM

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

Summary

ASO MDX Outline formula - Multiple SUM

Content

Ok, so here's my dilemma.  A bit of background first.  Essbase db is to recon a 3rd party feed's acct structure to our COA.  Dimensionality is small but could have thousands of members in 1 dim.  I have UDAs on their acct structure to match our COA.  But it really requires matching 2 dimensions because UDA on dim1 isn't exclusive to any dim2 member.  That is to say if it was exclusive, I could get away with more generic UDAs & thus wouldn't have the issue I'm encountering.  I've created the following outline member formula (admittedly, I don't have a

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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