I have created an infocobe in Bi and then query on it. The IC has just one dimension say Material and one key figure say amount with fixed currency s GBP>
And I have created an universe on this query. Now in the universe , I am able to see
material-> material Id.
Now I want to put a filter on material id but i am not able to do it.
I am able to see the filter in WEBi as material->material Id-> condition1.
I have parse the following condition in universe , it says parsing is OK.
I have put following code in the where part.
<FILTER "[Material]"><CONDITION OPERATORCONDITION="Equal"><CONSTANT Material id = "MAT1"></CONSTANT></CONDITION></FILTER>.
In WEbi , the reports never gets generated when I put the filter in the filter panel but it runs successfully when no filter is put on the filter panel.
Can anyone tell me where I am going wrong.