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 Lev1 members

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

Summary

Sum of Lev1 members

Content

Hello All,

 

we have BSO outline on 11.1.2.4 version, I want to agg the products of level1 which is not a dynamic hier

 

Product

-----L2

       ---L1

          ---L0

          ---L0

       ---L1

          ---L0

          ---L0

          ---L0

L1 is level1 and L0 means Leve0... now I want the sum of all level1 members for which I had a cmd like

@sum(@relative(Product,-1)) (this is used in the right side of the quation) but its giving error while verifying

Error: (line 47): expected type [MEMBER] found [NUMBER] ([@SUM]) in function []

I can agg the complete Product Hier, but I don't want to do that I just want this agg to happen only when my script is running... and most important this

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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