on 01-28-2017 1:03 PM
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?
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"
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
6 | |
5 | |
2 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 | |
1 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.