Using rolling horizon for TSCUBE/MC2 activities

[Former Member]

Hi,

We need to do activities like Loading sales history, generating CVCs for only the previous Fiscal period on a rolling basis. The start and end dates are as per our Fiscal year calender. So while creating the variant for TSCUBE and MC62 to be used in batch, we are using the selection variable as 'T: Table Variable from TVARVC'.

But I am not sure if we can maintain the start and end dates of multiple fiscal periods for lets say 60 fiscal periods in this variable using stvarv in APO ? In the selection options, if i use the multiple selection option to maintain these 60 start and end dates under lower and upper limit fields. Will the tscube program pick up a new start and end date each month on a rolling basis? How does the program know when to pick and what date range to pick? Or do we need to write an ABAP program to update this variable with the current set of start and end dates after each month ends from some other custom table where we could maintain these values ?

Can someone outline the best ways and the steps to maintain the TVARVC variable and ensure that programs TSCUBE/MC62 use the right values ie, start and end dates of previous fiscal periods just after the previous month (end date of each fiscal period ) ends/closes.

Thanks

[Former Member]

Hi,

There are 2 standard approaches

1) Use dynamic calculation

Pros - It calculates automatically.

Cons - It may not match exactly as per your fiscal calendar, but it mostly matches.

2) Use TVARVC table entries. - You should maintain only one entry, rather you can maintain only one and it does not dynamically change.

Pros - Exact values can be set.

Cons - It does not dynamically rollover.

Other approaches

1) Write a ABAP program to pull up the start and end periods from your fiscal year calendar and directly populate variants for mc62 and tscube.

Pros - Dates match exactly as you need, and you can control the timing of update.

Cons - This would work only for mc62 and it would screw up the KF assignment in TSCUBE txn because the FM used to read and update variants is not robust enough to handle KF mapping present in TSCUBE.

2) Write a ABAP program to update your TVARVC values based on fiscal calendar.

Pros - Dates match exactly as you need, and you can control the timing of update.

Cons - Little bit of more work, but the results are achieved.

Hope this helps.

Thanks

Mani Suresh