1 Reply Latest reply: Jan 30, 2014 12:09 PM by Srini VEERAVALLI RSS

OBIEE report to calculate avg daily demand by month and product line

ST Newbie
Currently Being Moderated

Hello,

I have a requirement to calculate the average daily demand by month for each product line.

Each Manufacturing Org has the list of working days for the month.

 

Mfg OrgMonthWorking days
M1Jan-1423
M1Feb-1420
M1Mar-1421
M2Jan-1420
M2Feb-1420
M2Mar-1420

The data for demand in fact table is by day, Item, Org, Dem Qty

Item rolls into Product Line

 

Based on when the MRP plan was run the number of working days for the month reduces.

So for eg if the MRP plan was run on 15 Jan then the number of working days reduced to 13 days.

Then the average demand for Jan will be all demand in Janurary/ # of working days left in January ie 13

The the average demand for Feb will be all demand in February/# of working days in February.

 

So how can I dynamically calculate the average daily demand by Org and product line based on when MRP plan completion date

 

Any pointer highly appreciated

 

Thank you

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points