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

Title: How to find the maximum of a date in report studio, datasource is cube from SSAS
Post by: xyz on 24 Sep 2014 03:46:03 AM

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

Title: Re: How to find the maximum of a date in report studio, datasource is cube from SSAS
Post by: Francis aka khayman on 24 Sep 2014 03:59:07 AM

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/

Title: Re: How to find the maximum of a date in report studio, datasource is cube from SSAS
Post by: xyz on 24 Sep 2014 06:00:31 AM

Hi Khayman,

Thanks for the reply, the post is very useful.

Thanks & Regards,
XYZ

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: xyz on 24 Sep 2014 03:46:03 AM