Skip to Content
0
Former Member
Aug 31, 2012 at 09:50 PM

Derive value of Dimension using a property of another Dimension - SAP BPC 10 Build 290

178 Views

Hi Gurus,

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")

2

3

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.

Thanks,

Abhishek Khatti.