Skip to Content
avatar image
Sivaram Bandaru

Data not updated for different cost centers

Jan 28, 2017 at 01:03 PM | 55 Views | Last edit Jan 29, 2017 at 10:38 AM 2 rev.

Hi Guys,

We have a weird issue and I would like to know possible places for incorrect logic. My script in default logic says: if the changed Cost element is B, then look for rate in Cost element C. If there is no rate for CE C, use the value in CE A for CE A.

In my input layout I am only changing CE A. What is weird is it is allowing me to change for all the months except for 1st month. For another cost center it is not allowing me to change anything. As there is no difference in any dimension including cost element except for hierarchies they belong to I am breaking my head over what can go wrong.

*IS CE B

*BEGIN
*REC(EXPRESSION=(([KEYFIGURE_TYPE].[RATE],[COSTELMNT].[CE C])>0?
%VALUE%*((([KEYFIGURE_TYPE].[RATE],[COSTELMNT].[CE B])*
([KEYFIGURE_TYPE].[RATE],[COSTELMNT].[CE C]))+
([KEYFIGURE_TYPE].[RATE],[COSTELMNT].[CE C])):
([COSTELMNT].[CE A])),COSTELMNT= CE A)

I know I cannot get answers on these but I am looking at the approach I am taking to solve this puzzle. Anyone has a better approach to solve this?

SAP Business Planning and Consolidation, version for SAP NetWeaver
bpc | script logic lookup
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Vadim Kalinin
    Jan 29, 2017 at 07:44 AM

    It's a bad idea to have spaces in the member id's! "CE C", "CE A"...

    Use CE_C, CE_A...

    Please change the primary tag to "SAP BusinessObjects Planning and Consolidation, version for SAP NetWeaver"

    Add comment
    10|10000 characters needed characters exceeded