Unable to apply filters to OLAP data source: QE-DEF-0478

[johny.cbi]

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

[Suraj]

caption([Sales Cube].[Date].[Date].[Year]) > 2004

[rockytopmark]

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.

[jahnavi]

Hi,

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

Thanks,
Jahnavi.