refer Year / period dimension as a member in BR from the date
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.
0