on 01-28-2011 1:59 PM
Hi gurus,
we would like to extend the DP planning area horizon now. the current planning area storage bucket profile and the time series for the planning area are only until 01.03.2012, i want to extend the horizon beyon this ..what is the exact procedure for this..
do i need to change the storage bucket prfl horizons first before extending or..pls advice..
Thanks
Hi,
I am sorry for the delay but i think you were talking about "time bucket does not exist" when you have said time buckets missing.
If my assumption is correct, then the inconsistency is from the livecache side. There will be a missing time grid in the livecache.
The programs which may delete this time grid is /SAPAPO/TS_LCM_REORG and execution of tcode /sapapo/om17. If these were running during that time then this inconsistency will be caused. Most probably i have seen this error only during extraction. When extracting data, the system creates a so-called timegrid for reading data. This timegrid is deleted at the end of each activity. But if during the extraction, the timegrid is deleted due to some other programs or process, the error 'Time bucket does not exist' will occur.
I think /SAPAPO/TS_LCM_CONS_CHECK may detect the error but it will be resolved if you run /SAPAPO/TS_LCM_REORG now.
I hope the above information helps.
Thanks and Regards,
Nithin.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Just wanted to add to the above explanation:
The storage bucket profile defines the overall validity and granularity. The horizon is important e.g. if you execute the consistency check or initialize a planning area. As a general rule, the horizon of the storage bucket profile should always be greater than any initalization horizon for an associated planning area.
However, the storage bucket profile does not keep any liveCache timeseries data. This is the big difference. Data is saved in timeseries which are reserved in liveCache as per initialization horizon of the corresponding planning area and version.
As explained, please always choose a horizon for the storage bucket profile which is greater than the initialization horizon for an associated planning area.
Thanks and Regards,
Nithin.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi
Backup the data from your planning area to back up cube (just as a safety measure).
Now check the time stream in your storage bucket profile. Extend it using tcode /sapapo/calendar if necessary. Then change the storage bucket profile horizon and then initialize the planning area for a new range and you will be all set after that
Thanks
Aparna
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Aparna & Nithin,
I made the changes in the storage bucket profile and iam trying to extend the time series of the planing area using report /SAPAPO/TS_PAREA_INITIALIZE, when i put all the details including the horizons and execute initialization fails saying time buckets missing..do i need to do the planning area consistency check after changing the horizon in the storage bucket profile? Regards
User | Count |
---|---|
12 | |
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.