Hi,

I have a time dimnesion Date(Year,Month,Week,Day) and Client dimnesion
Client(Client_number).I'd like to know the date of last transaction of
specified client?
For example:
select {[Date].Lastchild} on columns
from cube
where [Client].[CLI00001]
gives me the last year of transaction.
How can I get Day,Month and Year of last transaction?
Is it possible to get it from CUBE this way?

thx
Sobota

The lastchild function returns the last child of a member,
in this case a Date dimension member, regardless of the
Where specification. As long as you do not add new members
to the date dimension it will always return the same
member for all clients, with or without transactions.
To find the last Date member at a specific level for which
a given measure is not empty, and assuming your measure to
be Sales, you can use an expression such as :

Tail(Filter(Date.Day.Members,not isempty
((Measures.Sales,Client.[CLI00001])))).item(0)

HTH,
Brian
www.geocities.com/brianaltmann/olap.html