Hi MDX experts,
I would like to create calculated mamber in my cube to known, when customers bought the last time.

My OLAP cube is similar to Sales cube in FoodMart 2000, so when I run in FoodMart :

select
Descendants([Time].[1997],[Time].[Month]) on 0,
[Customers].[All Customers].[USA].[CA].[Altadena].Children ON ROWS
from sales
where ( [Measures].[store sales] )

I got customers name on rows and months on columns. I see that customer Alice Cantrell bought for the last time on december, Amy Pertanoff on July, Angel Arevalo on August and so on.

In my cube I need to create calculated member, that shows when the customer bought for the last time. When browsing, cube should return only customer name on rows and the member "Last date" on columns.

Any ideas?

Ramunas

Try:

with member Time.LastDate as 'Tail(Filter(Time.Month.Members, Not
IsEmpty(([Unit Sales],Customers.CurrentMember)))).Item(0).Item(0).Name '
select
{ Descendants([Time].[1997],[Time].[Month]) , LastDate} on 0,
[Customers].[All Customers].[USA].[CA].[Altadena].Children ON ROWS
from sales
where ( [Measures].[store sales] )

Of course it would be clearer if member names in Foodmarrt included the
Year, but you can control this in your Time Dimension.
HTH,
Brian
www.geocities.com/brianaltmann/olap.html



"Ramunas Balukonis" wrote: