If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Here you know how to create cognos static report filter

Started by jackcart, 20 Apr 2017 01:49:09 AM

Previous topic - Next topic

jackcart

Report Filter:

A filter allows you to limit the kind of data you want retrieved for your report. For example, you may want to create a filter to limit your report to information for only a specific department, or a specific profit center, or a data range.

You can have one or many filters in a report query – when you run the report, Cognos returns only those records that agree with all filters.


  • A report filter is a restriction that reduces the amount of the data returned from database.
  • Report filters are measurable.

Static Report filters:

Run immediately upon request, and then stored with the data in the Completed Reports module.



  • Create a list report by adding following query items
  • Order no
  • Order date
  • Product name
  • Quantity
  • Select order date data cell
  • From menu bar, select data
  • Select filters
  • Select create custom filter
  • In the operator list box, select ≥
  • In the value box
  • Select Jul 1, 2005
  • Click on OK
  • Save & Run the report


For more information please visit cognos online studies with screenshots

MFGF

Quote from: jackcart on 20 Apr 2017 01:49:09 AM

  • Create a list report by adding following query items
  • Order no
  • Order date
  • Product name
  • Quantity
  • Select order date data cell
  • From menu bar, select data
  • Select filters
  • Select create custom filter
  • In the operator list box, select ≥
  • In the value box
  • Select Jul 1, 2005
  • Click on OK
  • Save & Run the report

Hi,

I suspect new Cognos users might find this extremely confusing. In Cognos Analytics authoring, there is no menu bar, so these instructions would confound anyone trying to learn how to author reports in CA. All in all, it's not a good way to tempt people to your site. I'm guessing you meant to post this in the Cognos 10 Report Studio board?

MF.
Meep!