Skip to Content

How to exclude multiple values in Analysis for Excel

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Mar 16, 2017 at 03:27 PM

    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

    Add comment
    10|10000 characters needed characters exceeded