EMTPY or #UNAVAILABLE cells in Webi by filtering

[Former Member]

Hi Experts,

I am getting empty cells or #UNAVAILABLE messages when I filtered some structure elements in Webi of BO 4.1 SP4.

My Data Source comes from BEX.

What is the reason of that? Can you have any suggesstion please?

I tried to explain scenerio in below picture.

Best Regards,

[Former Member]

Hi

can you elaborate selecting land & building, you are getting empty(Is it a query level selection on structure ?)

For your 2nd alternative:

     Suggest to check the definition for measure objects Aug 2015 & Entrance for Sep 2015.

Also, please share how filter you applied, is it a block filter or created some variable and used that to apply filter, if so what u defined?

Ideally filter should not effect your measure even the delegated ones.

Verify your BEx structure definition

Regards,

Ramachandran