I've modified my time dim,
to show the date witch is the last one pupulatet with data .
It works fine in the Foodmart 2000 Cube, and also in a ProClarity sample
cube.

But it won't work in my Cube!

My cube is populated with a lot of calculated measures - so I thougt: maybe
I need a higher solve order for the dim? (the measure works with different
order levels)

has anyone a similar problem and a fix for it?

greetings sequal

What do you mean you've modified your time dim? How (using a solve order)?

Try this code as the default member in the time dim.

Tail(Filter([Time].[Month].Members, NOT
IsEmpty(Time.CurrentMember)),1).Item(0)

"sequal" wrote:

NO NO - not using a solve order, just a simple MDX statmentlike yours:

in FoodMart2000 this one:
Tail(Filter([Time].[Month].Members, NOT IsEmpty
([Time].CurrentMember)),1).item(0)

in the ProClarity SampleCube this one:
(Filter ([Time].[Month].Members, Not IsEmpty ([Measures].[Sales]))
..Item(Filter ([Time].[Month].Members,Not IsEmpty ([Measures].[Sales])).Count
-1).Item (0)).Lag (1)


the last one makes it possible to have a second measure with is populated
(e.g.: a [Measures].[Sales Forecasts]), it will always show the time with the
last [Measures].[Sales] filled month.

so both works fine, but not in my_cube! (and its no miswriting error)
the big differenz between my_cube and the samples cubes is, I have a lot of
calculated measures with different solve orders, so maybe there is a "solve
order time" when the dim is ordered, and maybe I have a measures with is in a
higher order level...

can someone follow me....???



"HWUK" wrote: