Question:
Hi BW Gurus,
I have a problem and I need help to solve it.
I am creating a query report that is time based. I have the periods for the year as columns. For periods to date I need to have an actuals figure. For the remaining periods of the year, I need to replace the actuals with a forecast figure.
Anyone got an idea of how I can do that?
Example layout is:
Char ¦ Pd 1 ¦ Pd 2 ¦ Pd 3 ¦ Pd 4 ¦ Pd 5 ¦ Pd 6 ¦ Pd 7 ¦ etc....
____________________________________________________
AAA ¦ Act. ¦ Act. ¦ Act. ¦ Act. ¦ Fcst. ¦ Fcst. ¦ Fcst. ¦ etc....
I hope this is clear enough!
Thanks in advance for any help you can provide.
David
Answer:
What KFs are you talking about? Looks like shipping acutals and order forecasts. It depends on how you capture. If this is what you are talking about, then VBEP is the table you want.
Once you have the data over in BW, there is no problem. Our master schedulers and sales planners, run reports with orders, shipments and forecasts for a year out, and all future periods are with forecast, only the past and current have shipments, and only current has orders (and some "past overdue" orders, in the past)
As far as I know, there is no extract for forecast in the LO cockpit. May have changed with 3.x though, haven't looked at it, since I am running an LIS structure created in the days of 2.0A, with a zillion table joins.
Mabye Belgio or some other expert could confirm if 3.x extracts forecast data.
_________________
Keep smiling
Answer:
we have customer developed extractors for forecast data...
Answer:
I believe that what David is asking for is :
he's got KYF1 which is actual data, and KYF2 which is forecast data
for period 1 2 3 4, he wants to show KYF1 as it lies in the past,
while for period 5 6 7 8, he wants to show KYF2 instead
next period, he will want
1 2 3 4 5 showing KYF1
and 6 7 8 9 showing KYF2
without having to change the query, so the query must be period based
So, the problem lies more in a restricted keyfigure or formula or whatever you may imagine in Bex... and as it is in Bex, I leave it to somebody else...
Ch
Answer:
Here is a query that our users have developed:
Rows:
Plant (with restrictions)
Sales District
Sold-to-party
Ship-to-party
Product code
Hardware model
Part Family (with exclusions)
Material
Material entered
Key Figures (in the rows area, below the last characteistic, as shown
Shipments (Actual quantity delivered)
Forecast
Orders
Columns
Cal. year / month (with variable, ranging from Jan 2004 - Dec 2005, or as desired)
and it's been working fine, with the time variable changing over time.
Of course it is a custome cube, with a custom ztable (not an LIS structure as I mentioned earlier, we moved away from it last year) in R/3 with a custom code to fill it with data on a daily basis, and with a datasource created from this ztable, replicated in BW ... yadda yadda yaddah......
_________________
Keep smiling
Answer:
Thanks all for the replies,
CHC got the concept right and SR got the Key Figures right.
I am using Shipment Actuals and Forecast as the Key figures. In my BEx query, I want to display only one key figure for each period.
Up to the period previous to current period, I want to show the actuals and for the current period to the end of the year I want to show the Forecast.
My problem is how do I populate the report key figure with the actuals for the first periods of the year and then populate it with the forecast for the remainding periods of the year.
The data is coming from a custome InfoProvider.
Thanks for your help so far, but I hope this explains my problem better.
Again, any help and suggestions are gratefully accepted.
David
Answer:
David,
Create a restricted key figure for the KF for Actuals restrict it with variable current month(assuming u want to know the vaues from previous month and the months before that), restrict the variable value by ofsetting -1, -2 and so on to get previous months figure. Repeat the same for forecast vaue KF but ofset to 1, 2,3..
You can have cal/month in the rows/colums but you cannot have a make a selection in the run time. You can have the values displayed for the previous and future as long as you can in the report directly.
Thanks