Skip to Content

Issue with Visibility Filter after currency conversion implemented?


We are seeing an issue with Visibility Filter after Currency conversion implemented to existing KF

Here is the use case...

Before currency conversion implemented..

1) KF1@PerSOrgBrandCustProdCurr

2) Visibility filter created at Brand Level

3) Users were able to see KF1 based on VF assignment and it worked as expected.

After currency conversion implemented..

1) KF1@PerSOrgBrandCustProdCurr moved to KF1@PerSOrgBrandCustProdCurrCurrto

2) No changes made to visibility filter

With Currency change, Now VF stopped working and system returned message " No data found"...Log file shows "Error in Refresh Sheet", # 400 Bad Request and Query returned data..

Planning view showed data only when "All Data" Visibility Filter applied.

3) Different addl VF changes done but no success...

  1. Existing visibility filter modified to in include all Exchange rates and All Currency to
  2. New visibility filter modified to in include all Exchange rates and All Currency to

Any help is appreciated....

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Best Answer
    Posted on Jul 22, 2015 at 06:19 AM

    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


    Add a comment
    10|10000 characters needed characters exceeded

    • Hi Krishna

      if you have several different planning level, visibility filter do get a bit more complicated...

      But if all your planning level have the material included, than the one exclusion of just the material is enough. If you have another planning level that e.g. only has material group, than you should include the material group as well

      It does not hurt to have more, but it should not be necessary, and I tend to build solution as simple as possible...



  • Posted on Jul 22, 2015 at 03:38 AM

    You need to add another condition to visibility filter "Brand" = "Has no value" and then you should be able to view KF value



    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Krishna Mamidipaka

      Hi Krishna,

      The condition Brand = Has no values is required. However the 'Error in refresh sheet' after creating VF could be due to version specific master data.

      Can you please check if it is a version dependent master data. If yes, then apply SAP note 2192540 .



Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.