Skip to Content
author's profile photo Former Member
Former Member

Block level filters on measure object


Wanted to know a way to suppress rows in a crosstab with all zero's

I.e. if the measure value for a complere row is zero , it should not be shown.

Or indirectly, how do I apply block level filter on a measure object in webi?

I am using block level filters on dimension objects but could not find how to do this on measure object to achive what I wanted.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Oct 22, 2010 at 07:20 PM

    Hey David Thangaraj,

    Filtering Measure objects is not possible.

    Use Alerters:

    Before creating Aleters, do sort on your Measure column.(ASC/DSC)

    1. Name Alerter

    2. Condition: Measure = 0 then <Format>

    3. Make Fore and Background same <White & White>

    4. Remove Borders

    5. Save (OK).

    Now apply this Alerter condition on toal row, means on all columns/objects there in Report/table/block.


    Select the Whole Block:

    Go to Properties:

    Uncheck : Show when empty

    and Show measures with empty values & Dimensions check boxes also. (Am not exactly remembered text)

    Hope this way you can do that.


    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member


      Thanks for your suggestions.

      When I use alerters it just makes it a blank/empty row and dosnt actually remove it.

      I already tired the properties option and it dint work as the rows have zero values and are not empty.

      Let me know if I am missing something and with any other options?

      Thanks again!

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.