cancel
Showing results for 
Search instead for 
Did you mean: 

reading property values in script

Former Member
0 Kudos

Hello,

Is reading property value in script logic not supported in NW version.

For example, can we write something like this?

*WHEN TIME

*IS *

*REC(RptCurrency=Entity.CURRENCY)

*ENDWHEN

(everything is case-sensitive here)

When I try to validate it, it gives an error " Member Entity.CURRENCY doesn't exist"

If this is not supported then what is a work around in NW version?

Thanks, John

Edited by: BPCNewcomer on Jul 20, 2009 9:57 PM

Edited by: BPCNewcomer on Jul 20, 2009 10:01 PM

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Closing the thread.

Jeffrey_Holdema
Active Contributor
0 Kudos

Yes reading property values in BPC NW script logic is supported. Try enclosing your dimension and member names in brackets.


*REC(RptCurrency=[Entity].[CURRENCY])

Also check to be certain that unique CURRENCY values are available as dimension members in RptCurrency.

You should also be aware that the *REC statement requires use of either FACTOR or EXPRESSION.


*REC(FACTOR=1,RptCurrency=[Entity].[CURRENCY])
*REC(EXPRESSION=%VALUE%,RptCurrency=[Entity].[CURRENCY])

You can see some useful examples in the [Documentation Addendum |https://service.sap.com/~sapidb/012003146900000031772009E/7NW_SP02_Doc_Addend.pdf]which accompanies SAP Note [1306898|https://service.sap.com/sap/support/notes/1306898] BPC 7.0 SP02 NW Central Note.

Best regards,

[Jeffrey Holdeman|https://www.sdn.sap.com/irj/sdn/wiki?path=/display/profile/jeffrey+holdeman]

SAP BusinessObjects

Enterprise Performance Management

Regional Implementation Group

Former Member
0 Kudos

Thanks Jeff!

Do you also know if we can use Time Offsets in NW version like PRIOR, NEXT, etc.

Also are there any performance impacts by using the above statement ( [Entity].[CURRENCY]) to refer to property values as it seems to be MDX-based?

Edited by: BPCNewcomer on Jul 20, 2009 11:41 PM

Former Member
0 Kudos

I solved it.

Edited by: BPCNewcomer on Aug 29, 2009 7:57 PM

Former Member
0 Kudos

Jeff,

I have been trying to do the same thing without any success and I found documentation that it could not be done:

link:[http://help.sap.com/saphelp_bpc70sp02/helpdata/en/a1/532226947C49A5B2E2BD32450CB2D1/frameset.htm]

I have the following piece of code:

*REC(EXPRESSION=(%VALUE%),SALES_ACCT="BPCTSMultiSKUvol",PRODUCT=[PRODUCT].[NEWSKU])

This will not validate in BPC 7.0 SP4 admin. It will validate successfully when written as:

*REC(EXPRESSION=(%VALUE%),SALES_ACCT="BPCTSMultiSKUvol",PRODUCT=PRODUCT.NEWSKU)

but it fails when run through Data Manager.

Any input you have would help.

Thanks,

Jon

Former Member
0 Kudos

On the link I listed in the previous note use this path to find where it states functionality is not supported:

Administration --> Business Caluculations --> Logic --> Script Logic --> Key Word Reference --> *REC