Skip to Content
0
Former Member
Aug 01, 2016 at 01:57 PM

Webi dimesion doesn't filter unless it's included

23 Views

Hi,

I have an incident in a Webi. We have some dimensions which are used as filters, not to include them in the layout. I put those dimensions as Input Controls.

However, when I filter for them, webi doesn't filter anything, ignoring it. If I include them in the layout, filter works fine. The problem is that I cannot include and then hide them because the relation is not 1:1, but 1:N, and including them would mean to duplicate rows in webi layout.

I'm working on 4.1 SP3, and webi is based on an OLAP Connection (BEx Query).

Any help is welcome!