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

@ConcatenateCalculation script help

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

Summary

@ConcatenateCalculation script help

Content

Hello Community,

I am facing an issue while writing a concatenate function.

This is what I am trying to achieve

I have two Heirarchies in Period Dimension

YTD

ATD

  Ytd_P01

     B-Bal

     P01

     YTD_P02

        B- Bal

        P01

        P02

   ATD_P01

        A-Bal

        P01

   ATD_P02

        A Balance

        P01

        P02

I am trying to accomplish the following for account X

FIX(@Children(ATD), @levmbrs(Entity,0),"2016")

X = X->A-Bal- ("X"-> (@Member((@CONCATENATE("YTD_",@NAME(@CURRMBRRANGE(Period,LEV,0,0,0))))))) ;

Endfix

Getting an error aborted due to status [1200402].

I want it to be so that

Atd_P01 = = X->A-Bal – X-> Ytd_P01

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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