Skip to Content
author's profile photo Former Member
Former Member

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

Posted on Jan 27, 2017 at 05:51 PM 121 Views

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!

SAP Business Planning and Consolidation, version for the Microsoft platform script logic sap bpc logic script sap bpc 10 ms sap bpc ms dimesion properties
Add comment
10|10000 characters needed characters exceeded

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on 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