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

refer Year / period dimension as a member in BR from the date

Accepted answer
17
Views
2
Comments
edited Mar 21, 2021 3:50PM in Planning 2 comments

Content

Hi All

In Oracle EPM, I want to refer the FY or the period dimension member and store data across that combination (picked up from the date stored in EPM via data form). 

so lets suppose the "Grant Date" captured in EPM is "01/03/2021", I need to put a value across member combination FY21->"Mar = 7 (for example). 

I am using the below formula for picking up year dimension member form date, but its not working (not a block creation as well)

 

@MEMBER ( @CONCATENATE(“FY”, @SUBTRING ( @CalcMgrIntegerToString ( @CalcMgrExcelYEAR ( @CalcMgrDateToExcel ( “Contract Date” ))),2)))

 

Please tell me how to access Year / Period dynamically picking from date in BR. 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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