How to exclude multiple values in Analysis for Excel

[former_member329811]

Good day:

I'm starting to use Analysis for Excel or my reports instead of Bex Analyzer, when I need to make a filter in a dimension, in the filter I need to exclude multiple single values.

When I try to exclude them I don't see any option like in the Analyzer that I selected the values an exclude them in one click, or I pasted them already with the exclusion, in AFO I have to exclude the values one by one.

Does anyone knows how to achieve the exclusion o multiple single values and not do this excludin one by one?.

I appreciate any help that you can give me.

Thanks in advance

Greetings

[jyothirmayee_s · Accepted solution]

Hi,

NEW AO 2.4 has option to exclude members but the previous versions are not.

Check the link below.

https://blogs.sap.com/2016/11/28/reviewing-what-is-new-in-businessobjectanalysis-office-2.4/

Exclude Copy & Paste from Clipboard or File
You can explicitly exclude members from a file or a range

Example clipboard:
!ZY0217A
ZY0217B
!ZY0236
ZY0393
ZY0580
!ZY0589
ZY0597
!ZY0611
ZY0633A
ZY0633B
ZY1287A
< ZY1287B

Filter based on copy clipboard:

Result:

Thanks,

Jothi

[former_member329811 · Accepted solution]

Thanks a lot Jothi, that was really helpful!!!.

Greetings

[former_member970510 · Accepted solution]

Hi all,

I still can't get this to work and I'm using version 2.7.400.87314.

I get a message stating "Filter is set for all valid matches", but it doesn't work. Has anyone else encountered the same problem and figured out a fix?

Thank you!

[eric_gilbert]

Prefix your list of values to Exclude with a "!" first, then paste from clipboard.

600064
!600030
!600063

will paste from clipboard as:

[thomaspfab]

Hi,

same here, using 2.8.7.

After selecting "not equal to" and Ctrl + V the values are still pasted in with "equal to"!

Thomas

[zeiserpa]

Hi Thomas,

had the same problem. You have to include a "!" before every entry in your clipboard. After you insert it with CTRL + V, AO recognize the "!" and select the option "not equal to".

Greetings

Patrick

[thomaspfab]

Hi,

yes. Btw. the issue is still persistent on 2.8.12.

Regards,
Thomas