on 02-20-2014 3:28 PM
Hello Experts,
I need you help, i have an keyfigure attribute in planning book which shows 2 years of history from past, instead going back in past to see the history i set the macro to copy the history to the keyfigure attribute, but now i am facing an issue i only have 4 months of history in the past and rest of the month is black, so when i tried to run the macro it keey giving an error message saying "A Macro tried to set initial Value" even though i have set the zero allowed indicator in the keyfigure setting but still no luck, is there a step in the macro that i need to add please advise how to do it.
Thanks
Hi Ganesh
Initial (i.e. blank) is different from zero since SCM5.0. Please go through OSS note 1068603 - it provides solution for this type of issue. Specifically, scenario 3 (Copying a Key Figure) in this note might be applicable to you.
Thanks,
Prasun
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ganesh
There is an example macro provided in the note for copying from one key figure to another which shows exactly the steps you need to execute/configure. You just need to change the two key figures and date range based on your requirement. Let us know where you are facing the issue with screenshot so that we can help further.
Thanks,
Prasun
Hi Ganesh,
Here's an alternative for you without having to use any macros:
Create a Univariate Forecast profile based on strategy 60 - Copy History
Choose this strategy if demand does not change at all and you want to opt for the least performance- or work-intensive strategy. No forecast is calculated. Instead, the historical data from the previous year is copied.
It's really simple to set up in my opinion. Just make sure you adjust:
Only thing is it copies a max of 12 months of history in the past. You have plenty of options to adjust and get results for 24 months.
Cheers,
MZ
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hello Ganesh,
You are missing a code before ELSE in your above screenshot, which makes you macro logic incomplete. Please refer carefully the screenshot which I had given you earlier.
IF IS_INITIAL Condition
ACTION ---> This is missing in your macro
ELSE
ACTION
ENDIF
Hope this will help
Thank you
Satish Waghmare
Af first glance, I think you can use a IF statement, to copy only the non-initilial value, like if is_initial(the source value) = 0 then make the copy
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Ganesh
Based on your screenshot, you need to incorporate the following logic
Macro for copying row XXX to YYY
Copy Step : ( 12 Iterations : P 02.2014; P 01.2015 )
IF
Value Initial?
IS_INITIAL(
Row: XXX ( Frm P 02.2014 )
)
= 1
Row: YYY ( Frm P 02.2014 ) = Initial
ELSE
Row: YYY ( Frm P 02.2014 ) =
Row: XXX ( Frm P 02.2014 )
ENDIF
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
13 | |
4 | |
3 | |
2 | |
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.