| Manuel 2005-09-27, 11:24 am |
| I'm starting using AS and I have many troubles in non-basic
configuration of my cubes.
I'm able to build cubes with dimension and measures, working with basic
calculated members but...
Now I want to calculate the throughput-out of a warehouse as
(number of units out per days) / (number of days)
basically a mean value of unit out basing on time
my fact table [movement_out] as
[units, id_date]
my dim table [date_out] as
[id, date, month, year]
and the obvious dimension
date_out
|-year
|-month
|-date
I know that i can make a calculated member 'day count' of the number of
days as
IFF([date_out].CurrentMember.Level.Name = 'date',
1,
Sum([date_out].CurrentMember.Children, [day count]))
but if I dont' have one movement out per day the mean value is not
correct because the number of day is not correct.
Any one can help me ASAP?
I'm newbie... so be patient
|