Skip to Content
author's profile photo
Former Member

How to exclude one or more than one member on report?

Post Author: izhar

CA Forum: WebIntelligence Reporting

Hi all group members, I am working on BOXI R2. I have to ask that, How to exclude one or more than one member from the report. I know there is function of filter, through which we can see our desired members and other remaining will be excluded, but that's filter. In some of tools i have seen just do right click on a specific member and click on "Exclude" option to exclude the member. Suppose i have placed a Time dimension on the report and standing on "Month Level" which has data from 1, 2, ... 7,8, ... 11, 12 Now i just have to exclude member 7 from the report. Can any member guide me here. Regards, Izhar

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • author's profile photo
    Former Member
    Posted on Oct 01, 2007 at 01:53 PM

    Post Author: jsanzone

    CA Forum: WebIntelligence Reporting

    Izhar,

    If you run the report in "modify" mode, then you have two options

    1) You can click on the "Show/Hide Filter Pane" button which opens up the "apply filter" pane. From there you go to your Data panel and grab, drag, and drop an item from the Data panel into the apply filter pane and provide a constant or select a value to filter in or out from your report.

    2) You can highlight the column of data that you want to filter on, then click on the "Add Quick Filter" button. Using the List of Values menu you either select one or multiple items that you want to include in the report.

    Add comment
    10|10000 characters needed characters exceeded