Hyperion Essbase (MOSC)

MOSC Banner

@(ISMBR) and @(Member) in a IF statement not working

edited Sep 20, 2018 9:30AM in Hyperion Essbase (MOSC) 8 commentsAnswered ✓

Hi All,

I have a calc script where I need some help. I was wondering if someone has come across a similar issue. I am trying to copy data from one member to another. I am working on the shared hierarchies and that might be the issue. Can someone let me know if the IF statement is correct?

Thanks

FIX(@Relative(DIM1SharedHierarchy,0), @Relative(DIM2SharedHierarchy,0))

"DIM4Member"(

  IF(@ismbr(@Member(@concatenate("B_", @Concatenate(@substring(@name(@parent(@currmbr(Dim1))),5,8),":0000000000"))) ))

"NoComp_Proj"=NoDIM2;

                      )

ENDFIX

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center