Condition on BW universe

[Former Member]

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

[IngoH · Accepted solution]

here some examples on custom filters:

https://www.sdn.sap.com/irj/scn/go/portal/prtroot/docs/library/uuid/c0a45246-ce76-2b10-e688-f5c82062...

Ingo

[former_member142702]

Try the following syntax

<FILTER KEY="[0MATERIAL]>"><CONDITION OPERATORCONDITION="Equal"><CONSTANT CAPTION= "MAT1"></CONSTANT></CONDITION></FILTER>.

I assume that MAT1 is the caption value of the material. If this is the key value, please try the following

<FILTER KEY="[0MATERIAL]>"><CONDITION OPERATORCONDITION="Equal"><CONSTANT TECH_NAME= "[0MATERIAL].[MAT1]"></CONSTANT></CONDITION></FILTER>.

Regards,

Stratos