Issue with Visibility Filter after currency conversion implemented?

Hi Krishna

Root cause - and that makes it easier to understand the solution - is that visibility filter needs to be applicable for every single keyfigure, meaning you need to check every planning level.

If you filter on something that the planning level does not know, you will not be able to see any of the KF from that level

Your normal KF have the Brand in the planning level.

But your currency conversion factor (exchange rate) is on a planning level that is material- independend and with that filter on brand will not work

What you should do:

Create a new visibility filter and assign that directly to the role and not to the user (because every user will need it, that makes maintenance easier). That filter must include:

- currency from: has some value

- material / brand / sales Org / whatever: has no value

"has no value" means not only that the entry is initial, but as well that the entry (brand) does not exist in the planning level at all

If you just have a filter on brand has no value, you would be able to see all KF that are on a higher level than brand.

Same can happen for UoM conversion! Here you should have a filter that includes UoM from has some value, and all other root characteristics from other planning level = has no value

And: The same applies if you have KF on aggregated level. E.g. within your sales organization you have different Sales Areas. You filter on Sales Area (the lower level) and you have a KF on the higher level (Sales Org), than those KF will not be visible

Good luck

Irmi