a simple filtering problem

[kennyyeungkw]

I am doing a filter function with OLAP report ,please help !

I have two Data Item :
Financial Year
Amount

Before adding the filter , the report can show the data correctly. (see attached 1.JPG)


what i want to do is to filter the Financial Year in 09-10 ,10-11. so i add
[financial_year] in ([09-10],[10-11]) in detail filter

After added, there are two new data items 09-10 and 10-11 in the Data Item list
When run the report , the report display nothing  (see attached 2.JPG)


I am new with OLAP reporting ,Any idea ?

[srinu1253]

The filter condition should be [financial_year] in ('09-10','10-11')

[kennyyeungkw]

I can't use member attributes as filtering because it will degrade the performance
But problem solved! Thanks anyway.
The problem is because i view the data in View Tabular Data,so nothing are displayed