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