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

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

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 Org Month Working days M1 Jan-14 23 M1 Feb-14 20 M1 Mar-14 21 M2 Jan-14 20 M2 Feb-14 20 M2 Mar-14 20

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

• ###### 1. Re: OBIEE report to calculate avg daily demand by month and product line
Currently Being Moderated

What else you need?

looks like you got #working days for the month, use that metric as of jan 15th

#### Legend

• Correct Answers - 10 points