Supress Zeros

building reports desktopintelligence
1

Hi all,

I’m creating a report with two sheets. They both show the same data but once in table form and once as a chart.

The problem now is that I have too much data… There should be a constraint on some values. Like the record should only be shown when there are more than 5 .

BUT and this is the problem: Those values are already self made variables and I don’t know how to filter on these… Is it even possible ?

Thanks in advance,

Tom

TCL (BOB member since 2008-09-01)

2

Hi Tom, what do you mean by self made variables? Do you mean report level variables created? If yes, please post the code. It is possible to apply filters to the block/report. Did you try it?

Jansi :india: (BOB member since 2008-05-12)

3

Hi and thanks for your reply :

Indeed I mean variables made on report level. I would describe my report having 3 groups of report level variables.

Derogated:
I can select the object as a Universe measure. It’s a number stating the amount of items derogated.
Depending on this number I make an object that sais 1 if the is more than zero. And 0 if it ain’t.
Then I make a Sum of the last object for each Supplier. So I have the total amount of orders that are derogated.
Rejected:
The same goes for
% Non Conformities = ( + ) /

As you can see, in the report I work with variables. They work fine, but I want to supress some values, and don’t know how…

TCL (BOB member since 2008-09-01)

4

You created this variable. Now use this in your block and assuming it as a flag variable, apply a filter like =1 and then hide this variable from the block. Does that help?

Jansi :india: (BOB member since 2008-05-12)

5

Apply a ranking to this and select Top 1 if you just want these items.

6

I can not place a filter on my variables. But you are talking about a ‘flag variable’. Is there a difference ? An important one ?

Sorry could not really follow your advice… :oops:

TCL (BOB member since 2008-09-01)

7

I can’t set a rank on this variable. The option is gray and in slice and dice panel clicking it just does nothing.

TCL (BOB member since 2008-09-01)

8

If you have a Flag - =If > 4 Then 1 Else 0 - then you should be able to place a rank on this. It’s a standard workaround for filtering on measure variables within reports.

9

Thanks again both,

And Mark P I think I’m getting somewhere with your explenation. With a rank on the object only selecting value 1.

Nice, nice and thank you all very much. (I hope I can get the whole report right)

Update :

I think Im very close now BUT the field I need to put the ranking ‘based on’ is not available. And that is because I use two providers and one of the objects is placed in the COMMON folder (because it uses data from both I guess). But the field where I put the rank on does not show this self made object in the ‘based on’ list…

Any help please ? :slight_smile:

TCL (BOB member since 2008-09-01)

10

Hi,

I solved it by creating an object in both dataproviders. Now the measure that I use for the rank is in the list because it is not in the common folder anymore !!

And thanks all !

TCL (BOB member since 2008-09-01)