I am trying to create an Input Schedule in BPC 10. Let me explain the scenario:
I have a dimension, COSTCENTER, which have properties REGION, SEGMENT and COMPCODE. These properties are in turn another dimensions.
e.g. A master data entry for COSTCENTER will look like
ID EVDES COMPCODE REGION SEGMENT SCALING.....
CC_100 CC 100 CCD_10 CE TRAN
My typical record in the Input Schedule looked like:
A B C D
COSTCENTER COMPCODE REGION SEGMENT
1 CC_100 =EVPRO(EVAPP(),A1,"COMPCODE") =EVPRO(EVAPP(),A1,"REGION") =EVPRO(EVAPP(),A1,"SEGMENT")
In our previous projects, we used the EVPRO function to derive the values for COMPCODE, REGION and SEGMENT in the rows (which were under the row key range) before submitting the records.
I am finding a hard time to achieve the exact same scenario in BPC 10. Can someone please help on how I can achieve the same in BPC 10.
Your help will be greatly appreciated.