Losing dynamic filter on EVMBR BPC7.5SP10 NW

[Former Member]

Hi Gurus,

I am trying to make a selection on Product, which should be based on Region. Here is the scenario:

The Region and Product are part of Column. Region has 4 regions, which is displayed using drop downs.

Based on the selected region (which is a property of Product), I need to restrict the Product selection.

I tried the following

        T163                         U163

Region = Asia Pacific      =EVMBR("FINANCE","AFR1","REGION="&T163&"")

The problem is, as soon as I change the region and double click and select the region, I am losing the filter above. After selection,

        T163                         U163

Region = Europe               =EVMBR("FINANCE","EURO1","REGION=Europe")

How do I retain the dynamic filter? Is there any excel option that I am missing or need to change?

I will really appreciate your help.

Thanks,

Abhishek Khatti

[Former Member · Accepted solution]

Hi Abhishek,

Try to put the below in cell S163:

="REGION="&T163

Modify the EVMBR function to:

=EVMBR("FINANCE","AFR1",S163)

Hope this helps.

[Former Member · Accepted solution]

Hi Nilanjan,

Thanks for reply. I tried that option too. But the result is the same. I tried couple of options.

I tried using VLOOKUP, I tried assigning the name using Name Manager and the above option too.

When I try using the same thing using EVCVW, the formula isn't breaking. But my users don't want to

use Current View.

Can there be an excel setting that I am missing or might be a bug in BPC?

Thanks,

Abhishek Khatti

[former_member186338 · Accepted solution]

Hi Abhishek,

I am on BPC NW7.5 SP13. I have tested both syntax's and get correct results without filter change:

=EVMBR("TEST";"2012.OCT";B3) in B3 I have YEAR=2012

=EVMBR("TEST";"2012.JUN";"YEAR="&D3) in D3 I have 2012

May be it's SP dependent?

B.R. Vadim

Message was edited by: Vadim Kalinin Explanation of contents of B3 and D3 added

[Former Member · Accepted solution]

Hi Abhishek,

As Vadim said that its working fine on his system, please upgrade your system to the latest SP.

Hope this helps.

[Former Member · Accepted solution]

Thanks for the replies guys.

I will surely check that. I will have to check what is difference between SP10 and SP13 to make a business case to upgrade. I will really appreciate if you guys can point me in the right direction for that.

Thanks,

Abhishek Khatti

[former_member186338 · Accepted solution]

By the way, your initial formula is incorrect, compare it with my formula 2.

Vadim

[former_member186338 · Accepted solution]

We successfully upgraded from SP9 to SP13 without any issues. May be it will help you.

B.R. Vadim

[Former Member · Accepted solution]

Thanks Vadim. I will have present the case to my business people to upgrade the Service Pack. Is there a place, where I can check the upgrades that are present in SP 10 and SP 13, so that I can present the difference?

Thanks,

Abhishek

[Former Member · Accepted solution]

Hi Vadim,

I checked variety of possibilities in that formula, the way your 2nd formula is written, it was one of the possible formula. Unfortunately, it didnt work for me either.

Thanks,

Abhishek

[former_member186338 · Accepted solution]

We don't see any major difference, only some bugs were fixed.

Vadim

[Former Member]

Found it in the SAP Note 1690351.

The issue is resolved in SP13.

Enhancements in This Release

o Note 1714419: Performance improvement in reading BPC member

formula.

Thanks a lot for guiding me to this resolution. I really appreciate your help.

Abhishek Khatti