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

Sum of UAD's

Received Response
17
Views
7
Comments
edited Aug 2, 2018 2:36AM in Essbase 7 comments

Summary

Sum of UAD's

Content

Hi All,

I have a requirement to get the sum of UDA's under Account node, my Account node and attributes are as below

So when script ran for A1, I need sum of keeplike  under A1 only(700) and Keepother(800) when Script run for A1

same for A2, keeplike should be (850) and Keepother should be (900)

I have a script like

In main Fix I have @relative(A1,0)

and

FIX(@UDA("Year","BPFYEAR_CURRENT"),

      @UDA("Time","BPFTIME_FORECAST"),

      @UDA("Scenario","BPFSCEN_CURRENT"),

      @RELATIVE("C1",0)

      @RELATIVE("A1",0))

T2 = @SUMRANGE("Fullyear"->"T1"->"V1"->@UDA("Scenario"

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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