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
8
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!