SAP BPC 10 MS - SAVE DIM PROPERTY AS VALUES WITH SCRIPT LOGIC

[Former Member]

Hello SAP BPC Expert,

I’m trying to save, using a script logic, the value that I have in a dimension as property as an amount. I mean, imagine the TIME dimension one property in this dimension is “YEAR” and for the period ID = 2017.01 I have the property YEAR = 2017. Using a script logic I want to paste “2017” in an account as an amount. See an example below:

Let’s assume that we have only 3 dimension in the model TIME, ACCOUNT & ENTITY; what I need is to have the amount “2017.00 $” as an amount.

GOAL:

In a report I would like to see:

• ENTITY = Company1

• TIME = 2018.01

• ACCOUNT = Cash

• AMOUNT = 2017.00 $ à Should come from the property “YEAR” in the time dimension

Is this possible? Do you have any suggestion?

we have BPC 10 MS

Thanks!

[Former Member · Accepted solution]

You can use the FLD function for using values stored in dimension properties.

for example:

*WHEN TIME  
*IS *
  *REC(EXPRESSION=FLD(TIME.YEAR))
*ENDWHEN