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!
Best Answer
Feb 08, 2017 at 10:29 AM
You can use the FLD function for using values stored in dimension properties.
for example:
*WHEN TIME
*IS *
*REC(EXPRESSION=FLD(TIME.YEAR))
*ENDWHEN