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

Convert member formula to Groovy script

Hi All,

I have multiple Dynamic currencies in ASO cube of EPBCS and they have member formulas. I am planning to convert this member formulas to Groovy and store.

I am facing multiple challenges, some of the functions are not available in groovy script.

Example Member formula as below:

CASE WHEN (IS([Scenario].CurrentMember,[Act]) OR IS([Scenario].CurrentMember,[Budget]) OR IS([Scenario].CurrentMember,[Fcst])) AND IsLevel([Entity].CurrentMember, 0) AND (IsAncestor([Net account], [Account].CurrentMember) OR IS([Account].CurrentMember,[Net account]) OR IS([Account].CurrentMember,[EBA]) OR IS([Account].CurrentMember,[Sales])) AND IsLevel([Period].CurrentMember, 0) AND IS([View].CurrentMember,[MTD]) AND ISUDA([Entity].CURRENTMEMBER,"ELIMY") THEN

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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