Skip to Content
avatar image
Former Member

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

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!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    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
    Add comment
    10|10000 characters needed characters exceeded