Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Groovy Script - select base members in Business Rule - EPBCS

Pete`rMay 31 2019 — edited May 31 2019

Hi Experts,

I am trying to write a groovy script in an EPBCS application which would push the base level 0 members of a dimension from OEP_WFP (Workforce BSO) cube to OEP_FS (Financials) Cube. I know we can pass multiple members in the groovy script to pass to the data map using a run time prompt with data type "Members" and select more than one member during run time prompt selection.

/*RTPS: {LegalEntity_Var} */

operation.application.getDataMap("WFP_TO_FS").createSmartPush().execute(["Legal Entity":rtps.LegalEntity_Var.enteredValue], true )

However, is it possible to write a statement in Groovy to select a parent member and all the base members are included. Such as in Business Rule @RELATIVE({LegalEntity_Var},0)

Any advice would be greatly helpful.

Thanks,

Pete`

This post has been answered by Pete`r on May 31 2019

Jump to Answer

Added on May 31 2019

#business-intelligence-applications, #performance-management-applications, #planning-and-budgeting

1 comment

527 views