How to find the maximum of a date in report studio, datasource is cube from SSAS

[xyz]

Hi All,

We have a requirement to find the maximum of the date from date dimension, which is coming from cube data source. I took the date level from date dimension into a dataitem and If I try to apply maximum function on the dataitem, report throws error with the below message.

XQE-PLN-0043

The query is not supported. The value summary function 'maximum' in the data item 'Data Item1' is based on detail values and the function does not match the pre-aggregated values in the OLAP data source.

How to get the maximum date on from cube data source using dimensional functions. Where as I don't have any prompts on the date dimension.

Can some one help me on this issue, your help will be much appreciated :)


Thanks & Regards,
XYZ

[Francis aka khayman]

closingPeriod

this post is about getting the current month but the function is mentioned as well
http://cognosm.fm3online.com/dimensional/dimensional-current-month-2/

[xyz]

Hi Khayman,

Thanks for the reply, the post is very useful.


Thanks & Regards,
XYZ