Access Keys:
Skip to content (Access Key - 0)

Build Advanced Cognos Reports

On this page:

Return to Main Page

Report Design Layout

Insert Calculation

The Insert calculation field can be used to update existing fields to represent the information you need in a report.  For example you can use insert calculation to create a formula for a column of information or you can use it to concatenate a two fields into one, such as creating a Name field from First_Name;  Last_Name fields.

  1. Select the column(s) header(s) for the calculation.
  2. Click the Insert Calculation  button.
  3. Fill out the form displayed for the calculation and click OK.

Example: Concatenation

  1. Select the column headings for First_Name Last_Name, use the SHIFT key to select multiple fields.
  2. Select the Insert Calculation field drop down list and choose Custom.
  3. Set the Separator to a space.
  4. Click OK.

Prompts

Add prompts to a report to add interactivity for users. Prompts act as questions that help users to customize the information in a report to suit their own needs. For example, you create a prompt so that users can select a date range for a fiscal period or filter by a department.

Prompts are composed of three interrelated components: parameters, prompt controls, and parameter values. Parameters are based on parameterized filters and form the questions to ask users. Prompt controls provide the user interface in which the questions are asked. Parameter values provide the answers to the questions.

Add a Prompt in a report

  1. Switch from the data items area to the Toolbox by clicking the Toolbox  button.
  2. Click and drag Block from the Toolbox to the area of the report you want to put the prompt.
    This step is not required but helps format the report for a better layout.
  3. Click and drag the prompt type from Toolbox
  4. Choose Create New Parameter and enter a name in the text box then click Next.
  5. Choose Package Item ellipse and select the field that the prompt will be used against.
  6. Click Finish.
  7. Run the report
  8. Go to Tools: Build a report page.
  9. Choose Create New Parameter and enter a name in the textbox then click Next.
  10. Choose Package Item ellipse and select the field that the prompt will be used against.
  11. Click Finish.
  12. Run the report

Build a Prompt page

  1. Go to Tools: Build a report page.
  2. Choose Create New Parameter and enter a name in the textbox then click Next.
  3. Choose Package Item ellipse and select the field that the prompt will be used against.
  4. Click Finish.
  5. Run the report

Delete a Prompt

To delete a prompt from a report you need to delete the prompt object and then delete any filters created.

  1. Select the Prompt object and choose the Delete  button.
  2. Choose the Query Explorer  button and select the query you built. 
  3. Go to the Detail Filters section, select the filter and click the Delete  button.

Add reference to prompt in report

You can add a reference to the prompt that is set for the report as part of the heading or listed in the report, so it is clear it is a filtered report using a Query calculation from the Toolbox.

  1. Click and drag Add Query Calculation in the place it should be displayed.
    To create a space for the Query calculation you may want to click and drag a block to the report layout.
  2. Enter a name for the new object and click OK.
  3. Choose Parameters button and double click the name of the prompt that should be displayed.
  4. Run the report.

Drill through to another report

You may want to drill through from one report to another such as a Summary report to a Detail report.  To set up a drill through you would create an object to drill through and follow these steps.  For this example we will use the Query Calculation object created above, but you can drill through from any object on the report.

  1. Right click the report object and choose Drill Through.
  2. Click the Add button.
  3. Choose the ellipse for the Report and choose the report to be drilled to.
  4. Set the following:
    1. Target Report: name of report to be drilled to
    2. Action: Run the report,
    3. Format: default;
    4. Check Open in new window
    5. Parameters: click Edit: set to the field that filters the original report
      1. String: required,
      2. Value: Name of object that filters
      3. Method: Pass Parameter value
      4. Property to pass:  default

Import Data from an Excel spreadsheet

  1. Go to design view of the report you want to add the data to.
  2. Click the button Manage External Data.
  3. Click the Browse button and choose the file with the new data  then click Next.
  4. Click the ellipse for Existing query/subject report then Choose Query/Subject and expand the package.
  5. Choose the table with the field that has matching data.
  6. Under External data choose the field that matches and under Existing Query/ Subject choose the matching field.
  7. Click the New link button then click Next
  8. Leave the defaults and choose Next again
  9. Set the mapping options and choose Finish and then Publish.
  10. From the new table add any new fields to the report and run the report.

Community

Documentation and information provided by the MIT Community


Last Modified:

February 10, 2013

Get Help

Request help
from the Help Desk
Report a security incident
to the Security Team
Labels:
cognos cognos Delete
advanced advanced Delete
reports reports Delete
import import Delete
link link Delete
prompts prompts Delete
calculate calculate Delete
Enter labels to add to this page:
Please wait 
Looking for a label? Just start typing.
Feedback
This product/service is:
Easy to use
Average
Difficult to use

This article is:
Helpful
Inaccurate
Obsolete
Adaptavist Theme Builder (4.2.3) Powered by Atlassian Confluence 3.5.13, the Enterprise Wiki