Hi everyone,

I have a Sales cube with two dimensions: Date and Location and one measure:
Value.

I don't have a value for each date. If the value for the date is missing I
need to copy it to from the last available day.

10-may 10
11-may missing
12-may missing
13-may 20

For 11 and 12-may, I should have 10 and for 13-may, 20.

Is there anyway to do this with MDX or do I need to make changes in the
fact table?

Thank you!

--
Message posted via http://www.sqlmonster.com

What you are describing is semi-additive measures, e.g. account balances or
quantity on-hand values. For AS2K you need custom MDX which looks at the
last non-empty sibling. For AS2K5, we support last non-empty childs natively
as an aggregation function.
--
Dave Wickert [MSFT]
dwickert (AT) online (DOT) microsoft.com
Program Manager
BI SystemsTeam
SQL BI Product Unit (Analysis Services)
--
This posting is provided "AS IS" with no warranties, and confers no rights.


"angie via SQLMonster.com" <forum (AT) nospam (DOT) SQLMonster.com> wrote