Hi , Iam using LookUp cube function to get some measure based on time
dimension from another cube. If the measure is not available for that
particular date , I should query to give the latest available data for
that measure. Help me with MDX query.

Thanks in advance. .

Any help on this would be appreciated. Thanks.

This MSDN paper discusses how to compute the (last non empty) closing
balance for a measure:

http://msdn.microsoft.com/sql/defaul...n-us/dnsql2k/h
tml/semiadd2.asp
...
In this example, the [Last Non Empty Value] measure has a recursive
expression that checks to see whether the value of the current cell is
empty. If it is empty, the expression moves back to the previous period
on the time dimension and checks the [Last Non Empty Value] of the
previous period. The function continues to go back in time until a
nonempty value is found.
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***