Filter on Nav Attribute in SAP Webi.

[abhimanyu_sharma]

Hello Experts,

I have two columns in the BEX report:

1. "Local Count" which is restricted with Multiple Single Value variable "ZIN_CITY" on navigational Attribue 0ROUTE__0ROUTEID.

2. "Out Count " which is restricted with Multiple Single Value variable "ZOUT_CITY" on navigational Attribue 0ROUTE__0ROUTEID.

I put value 100 in prompt ZIN_CITY and 200 in ZOUT_CITY when i run this query in BOBJ WEbi.

But i am getting the error - Not able to retrieve data. i checked in the backend and data is present and also Bex query is working fine.

IF i change the property of variable to Single value then it is working fine in WEBi.

Also i tried another method - irresprctive of setting the prompt in BEx on Nav attr 0ROUTE__0ROUTEID, i created the prompt in BOBJ WEBi, but LOVs (list of values)are not coming in the prompt.

Please suggest on this?

Thanks.

[Former Member · Accepted solution]

Hi Abhimanyu,

Yes this is one of the limitation in BI4.0 as of now.

This can be addressed by BI 4.1 onward powered by SAP HANA.

As of now, there are two ways, it can be addressed:

1. Create two WEBI document separate with each variable and merge into one then and it will work fine.

2. Else you can get this fixed at the backend level itself by making it as display attribute or having two fields with the same data.

Thanks,

Shyam Alok