Hi D V,
I do not knwo how I can post the excel with the QV to this Discussion.
Sample Data in Excel is quite simple. Looks like this :
Starting from this forecast, which is for a complete year, I want a table that holds for each item a value for each week of the year.
With this table I can show in a graph how stock will lower each week.
Later on, I can add incoming quantities in the same chart, so this chart will show stock level forecast.
Thanks for helping me.
If this data is in Excel as the screen shot than you might want to try this:
load the table
link this table to your fact table
that might also solve possible 'level of detail' issues (transaction data by day and forecast data by week)
(if the table has a week number).
Hope this helps
I found the solution my self.
This is how I solved it, I'm posting it becaust it could be helpfull for others maybe...
for x = 2011 to 2012
for i = 1 to 52
if i < 10 then
let vnummer = chr(39) & $(x) & '/0' & $(i) & chr(39);
let vnummer = chr(39) & $(x) & '/' & $(i) & chr(39);
text($(vnummer)) as WeekForecastWeek,
(S2012 * (PerMaat/100)) / 52 as WeekForecast
(ooxml, embedded labels, table is Reeks);
Thanks to everybody who tried to help me !