how to get latest date using mdx

[louise]

Hi,

I have a measure that calculates the difference between two dates.
How will I get the latest date without inputting the date value so that it will automatically update the measure? I am using mdx in EG since my source is OLAP cube.

Thanks!

[sasrac]

Hi,

MDX is almost like an SQL syntax.
You could try to get the max of the date.

sample:

select max(date)as date from source;
quit;

or

select distinct(max (date_column)) from table_name

[sasrac]

you could also try this doc.

sww.sas.com/base/olap/MDX%20Tutorial.doc