Skip to Content
0

How to exclude multiple values in Analysis for Excel

Mar 16, 2017 at 03:06 PM

894

avatar image

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

exclusion.png (9.9 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Jyothirmayee A Mar 16, 2017 at 03:27 PM
1

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

Show 1 Share
10 |10000 characters needed characters left characters exceeded

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

Greetings

0