Hi all, I have a cube that shows products along the rows,
days across the columns,
and the product prices for the measurement.

The problem:
Even though a product doesn't sell on a particular day,
we still want the price
to show by using the last known price.

Can someone please show me an example of how to make the
price use the last known
price, i.e. the previous time member's price for the days
when it did not sell?


An example of my cube is below:


This is what I currently have:

Day1 Day2 Day3 Day4 Day5

Prod1 Price $5 $5 $7




This is what I want:

Day1 Day2 Day3 Day4 Day5

Prod1 Price $5 $5 $5 $5 $7


Day3 and Day4 uses Day2's price of $5 even though Prod1
did not sell on Day3 and Day4.


I really do appreciate any assistance.

Jason

Here is a "unique solution" to your problem. Try this on Foodmart.

- Create a "dummy measure". (Just anything will do) We will use this
as a place holder.

- Create a Calculated Cell

- Define the subcube with the [dummy measure] and the [Time] at Month
level.

- Put this MDX for calculation.

iif(IsNull([Measures].[Units Ordered]),(Tail(filter({lastperiods(7,
[Time].currentmember)}, Not IsEmpty([Measures].[Units Ordered])),
1).item(0).item(0), [Measures].[Units Ordered]), [Measures].[Units
Ordered])

Remember to handle the "aggregation". This would be a semiadditive
measure, so please be careful about that.

HTH