Monday, January 25, 2010

How to filter for a range of dates?

Typically, users create two date prompts: A Start date prompt and an End Date prompt to get data for a period.

IBM Cognos Report Studio lets you accomplish this using one Date prompt and using “in_range “ operator.
1. Drag and Drop a Date prompt
2. Enable the Create a Parameterized filter
3. Select a date field ( such as ship date, Order date etc)
4. Select the Operator as “in-range” as shown below:

5. Click Finish and run your report

Tuesday, January 19, 2010

What does Select and Search prompt do?

IBM Cognos Report Studio provides a ‘Select & Search’ prompt. This prompt searches for a keyword and returns all matching values.

For example if you were searching for employees with the name ‘Jack’. The prompt searches and returns the values ‘Jack’, ‘Jackie’ or Jackzie’. Users can then choose the required employees and run the report.

Use a Select & Search prompt in 2 scenarios:

1. When you have too many values (too many to fit into a Value prompt)

2. When your values are case sensitive (For example, ‘Test’, ‘test’)

For example, in the image below we are searching for all employees with the name Jack

Monday, January 11, 2010

How to filter reports at different levels of data?

How do you retrieve data for last quarter in previous year and all of the current year?

Tree Prompts allow you take advantage of hierarchically structured data such as Time periods( Years, Quarters and months) and other hierarchies.
Tree Prompts displays all members in a hierarchy and allow users to select the level of detail they want to filter on.

For example, in the image below, we have a tree prompt with values selected for 1999 December and 2000 Q1.

Monday, January 4, 2010

How to standardize the numbers of rows per page on a report?

IBM Cognos Report Studio allow report authors to set the number of rows per page, the orientation of the report and default output for reports.

1. Create a List or Crosstab report
2. Go to “Run” menu and select “Run Options”
3. Select the required report format, orientation, output and the numbers of rows per page.