Issue with Visibility Filter after currency conversion implemented?

[Krishna1]

Experts,

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....

[Irmi_Kuntze · Accepted solution]

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

[Krishna1 · Accepted solution]

Irmi and Parag,

This is brilliant!!!!

It worked as you suggested..Initial results look good and we will do more test.

I have more questions but we will have a thread separately.

Thanks,

Krishna

[Krishna1 · Accepted solution]

Hi Imri,

Just one follow-up question...

Per your solution, We have created global VF with

- currency from: has some value

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

Question : Do we need to create "has no value"  just for all planning level KEY attributes or for ALL attributes in the system?

Thanks,

Krishna

[Irmi_Kuntze · Accepted solution]

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...

Yours

Irmi

[parag_bakde]

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

Regards,

Parag.

[Krishna1]

Parag,

Do you know what exactly is going on?

Thanks,

Krishna

[parag_bakde]

Have you tried AND condition to filter and see if it worked ?  Filter needs to be added for actual and NULL value.

[Krishna1]

Didn't work....

[parag_bakde]

If You specify Filter rules as shown above,

Brand = value and

Brand = Has no value

Then it should work of Currency KF. There is no additional Currency/Exchange Rate filter needed.

[Krishna1]

Parag,

I exactly tried and it is brining all brand values...not working

Thanks,

krishna

[Former Member]

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 .

Thanks,

Rohit