Setting up a cognos mapping

Some parameters apply to multiple reports, while others are report-specific.
  1. Select Maintenance > System Administration > Toolkit > Cognos Mapping.
  2. Click Create New Entry. Optionally, to edit an existing cognos mapping, click Edit beside the report name.
  3. Specify this information:
    Report Name
    Specify the name of the report.
    Cgmap Desc
    Provide a description for the report.
    Cgmap Report Path
    Specify the full Cognos report file path.
    Maintenance Form
    Click the database lookup and select a maintenance form associated with the selected report.
    Cgmap Archive View
    Select or clear this check box to enable or disable archive view for the report.
    Cgmap Preproc Task
    Specify any pre-processing task if applicable.
    Cgmap Burst Report
    Select or clear this check box to enable or disable report distribution in separate outputs.
    Render in SSP

    Select this check box to make the report available in the Self Service Portal. When the check box is cleared, the report is available only in the Admin Portal. This check box is cleared by default, each report must be enabled for the SSP individually. A report is shown in the SSP only when Render in SSP is selected and the user’s security group has access to the report.

    Note: 

    The SSP and the Admin Portal reference the same maintenance form and configuration. Report parameters are configured once in the Admin Portal, and apply to the report in both the Admin Portal and the SSP. Do not select Render in SSP for a custom report that uses JavaScript parameter validations. The SSP does not support JavaScript validations on the parameter page. We recommend to keep Render in SSP cleared for these reports.

  4. Click Save.

Configuring the Max Employee Count hidden parameter

Hidden parameters are used for advanced report configuration and are not visible by default. They are enabled through configuration mode.

This list shows the reports where the Max Employee Count parameter is available:
  • Employee Overtime Report
  • Work In/Out Report
  • Work Summary Report

This parameter is used to control the number of employees included when running the report.

  1. Select Maintenance > System Administration > Toolkit > Cognos Mapping.
  2. Select a report.
  3. Click Turn ON config mode.
  4. Click the diamond icon beside Max Employee Count.
  5. In Field UI, select NumberUI. the default value is HiddenUI.
  6. Click Save.
  7. Click X
  8. Click Turn OFF config mode.
    Note: The default value in the Max Employee Count field for existing customers is -1, which means no limit is applied. For new installations, the default value is 1000, aligning with the value specfied in the MAX_NUMBER_OF_EMPLOYEES registry parameter used for timesheets.