Aggegration Function MAX and "Most Recent" -
05-19-2004
, 12:18 PM
Suppose a measure "A" with Aggregation function Max
is created.
Its normal range is between 1 and 99.
It is inialized by multiplying todays date(integer
format YYYYMMDD) * 100 plus its normal range.
I create a calculated member "B" which
"A" - "A"/100 which will give me the normal range back (1
to 99).
The Measure B is the most recent value of "A" with the
date removed.
Is this an appropriate method to retrieve the latest value
of a measure even though the time period of the other
measures in the query is some other time period.
Thanks
Gary |