Skip to Content
0
Former Member
May 23, 2010 at 07:37 AM

Condition on BW universe

18 Views

Hi ,

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.

Thanks,

Anjna Goyal