COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: johny.cbi on 29 Feb 2008 09:29:04 AM

Title: Unable to apply filters to OLAP data source: QE-DEF-0478
Post by: johny.cbi on 29 Feb 2008 09:29:04 AM
Unable to apply filters to OLAP data source: QE-DEF-0478
Invalid coercion from 'level' to 'value' for '[Sales Cube].[Date].[Date].[Year]

can you give any ideas how to give a filter for the year
In want to give a filter for the Year > 2004

it is showing the error message

please share your ideas
Title: Re: Unable to apply filters to OLAP data source: QE-DEF-0478
Post by: Suraj on 29 Feb 2008 11:20:19 AM
caption([Sales Cube].[Date].[Date].[Year]) > 2004
Title: Re: Unable to apply filters to OLAP data source: QE-DEF-0478
Post by: rockytopmark on 29 Feb 2008 01:47:22 PM
Use the Filter() function to filter your dimensional data source in a dimensional manner.  Good description of Filter() usage is in the online help or user doc.
Title: Re: Unable to apply filters to OLAP data source: QE-DEF-0478
Post by: jahnavi on 02 Mar 2008 11:09:37 PM
Hi,

I TRIED out this and its working caption([Product forecast].[Time].[Time].[Year])>2004 replace this with your package items.

Thanks,
Jahnavi.