Skip to Content
0
Former Member
Feb 18, 2011 at 05:06 AM

How to display records in Bex month wise with out using calmonth

38 Views

Hello Experts,

This is regarding our requirement to reduce record count.

Here is the scenario.

We need to calculate forecast for next 18 month based on last 12 months history.

Let take a example :

For every Product and stock holding Location we will be getting forecasting data Past 12 Months and Next 18 month records.

For each product and stock holidng we need to do a look up and generate replica of same record differentiated by ship to

and then perfrom calculation by some look up's and do manipulation for next 18 Months Records.

Eg:

Location Product CalMonth K1 K2 .....

AB Mat1 02/2011 10 20

Ship To table

Ship To Location

s1 AB

s2 AB

s3 AB

s4 AB

Now I need to create 4 records for one records.

Location Ship To CalMonth Product K1 K2 K3 K4 K5

AB s1 02/2011 Mat1 10 20

AB s2 02/2011 Mat1 30 40

AB s3 02/2011 Mat1 50 60

AB s4 02/2011 Mat1 70 80

AB s1 03/2011 Mat1 90 100 110

AB s2 03/2011 Mat1 120 130 140

AB s3 03/2011 Mat1 150 160 170

AB s4 03/2011 Mat1 180 190 200

As it is clear from above example that we need to replication same record N no of times based on N no of ship to assigned to Location.

We are expecting 15000 Products * 8 Locations * 300 SHip To so the expected record count is 135 Miliions per month

Currently reports are running ok in Dev env since we are using calmonth as a key and for every product every ship to every location to display reports

Now my requirement is I need to understand for each product each ship to each location how can I make this 30 records in to 1 record by eliminating calmonth.

It can be done by creating key fig for each month and copy value in to that Key fig but if client wants to see data only two month for eg Jan and Feb how report will understand it need to read only first two key fig in record as we have removed cal month and kept the whole 30 months data in one single records.

Any Ideas how we can achieve will be of great help to us.

Regards,

Sachin Dehey