Show only values >=1 and do not show other values

[nimishabrahamc]

HI,

I am new to Cognos. In a report column called "Amount", I want to show only values >=1 and eliminate all the other values (including null) along with its rows.

Can you please give me an example of what Expression Definition should I apply to the column.

Thanks,
nac

[cognostechie]

Create a Query filter and insert the expression:

Amount >= 1

The query filter should be a detail filter. Go to the query explorer , select your query, drag a filter from the toolbox into the filter area on the right.

[nimishabrahamc]

Okay , I did that. But it doesn't seem to do anything. It is not eliminating the empty rows or showing >=1

Please tell me an example on how to do this.

Thanks

[cognostechie]

What do you mean 'Empty rows' ? What's the value in the Amount column for those rows which you call Empty rows?

Cognos reads results from cache too and that's why lot of developers go crazy when their changes don't reflect. Clear the cache of your browser.
Other than that, what I wrote earlier should do the job provided what you wrote in your original post was a precise explanation of the issue.

[Lynn]

Is your source relational or dimensional?

[nimishabrahamc]

Ok in my "Amount" Column I have empty values (Null Values) and other values.

I want to eliminate the Null values and only display values only >=1.


In the Detail Filters I am adding [XYZ_DS].[VW_ABC].[AMOUNT]>=1

What else should I do? Please give me an example of how I do this?

Thanks,
acn

[MFGF]

Is your source relational or dimensional?

Assuming it's relational, try

[XYZ_DS].[VW_ABC].[AMOUNT]>=1 and [XYZ_DS].[VW_ABC].[AMOUNT] is not null

[nimishabrahamc]

Yes I tried that.

[XYZ_DS].[VW_ABC].[AMOUNT]>=1 and [XYZ_DS].[VW_ABC].[AMOUNT] is not null

For some reason it does not eliminate the blank rows!

Please tell me if there something I am missing?

Thanks,
Acn

[MFGF]

Yes I tried that.

[XYZ_DS].[VW_ABC].[AMOUNT]>=1 and [XYZ_DS].[VW_ABC].[AMOUNT] is not null

For some reason it does not eliminate the blank rows!

Please tell me if there something I am missing?

Thanks,
Acn

Ok. Let's try asking a third time...

Is your source relational or dimensional?

MF.

[cognostechie]

He/She may not know how to figure that out.

@ NAC - If you see hierarchies in the package then your source is dimensional, otherwise it is relational. Another way to understand this is - if you see
icons that look like a triangle and let you expand it to find fields then your source is dimensional.