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 copy then load additive issue

edited Mar 13, 2019 1:29PM in Essbase 1 comment

Content

ASO cube that is copying data into a current month then loading additively on top of this data to create a total.  The problem is the load file might have a minimal amount of rows where one dim changes among the key intersections.  The copied data should reflect this change.  So the copy data might look like:  Dim1 = X, Dim 2 = L1, Dim 3 = P1

Loaded data: Dim1 = Y, Dim2 = L1, Dim3 = P1

ASO makes it a bit trickier but is there an idea someone might have where I can "stage" the copied data somewhere & reference loaded data intersections to change copied data Dim1 to equal Y?  Or is maybe SQL the best bet?  It's quick turnaround so unfortunately I didn't have a ton of time to start a lot of dev so was looking for ideas.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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