Skip to Content
0

Data not updated for different cost centers

Jan 28, 2017 at 01:03 PM

53

avatar image

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?

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Vadim Kalinin Jan 29, 2017 at 07:44 AM
0

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"

Share
10 |10000 characters needed characters left characters exceeded