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)
(http://bobby.com8.hk/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)
(http://bobby.com8.hk/2.JPG)
I am new with OLAP reporting ,Any idea ?
The filter condition should be [financial_year] in ('09-10','10-11')
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