Cognos Guide

 

 

Cognos site Link: https://cognos.hertz.io/ibmcognos/bi/?perspective=home

Cognos Help:  [email protected]

 

Applying for access

Navigate to Saviynt, request new access, search for:  Bi Platform-Cognos.

Request a new access.

Access to PID is not required, select No

Select: Oracle Arch - Finance Users.

Submit this request as normal.

Once approved, access should be available within a few hours.

Using Cognos

Use the link above to access Cognos.

The below is the main screen view, from the left side of the screen, select the multi lines next to IBM Cognos Analytics  with Watson.

Select Content

 

Select Team Content

 

Click on:  Oracle Archival

 

Click on: Finance

 

A list of reports will populate, use the scroll bar on the right side to locate the report you need.

Choose with report you need to run, based on your requirements fill in the filters.

Selections with an asterix are mandatory fields.

 

 

Example of searching for a supplier, use the right arrow to add.

 

Once you have selected all the requirement, click on Finish and the report will generate.

 

Once the report has run you can click here to export the report into Excel / CSV.

Reports

AP030 AP Transaction Details - this is the report banking needs to find pre cloud payments.

 

If you need to find an old pre-cloud payment, use this is the report.

 

To locate a specific payment, use below selection where possible.

• Business Unit
• Currency
• Invoice date range
• Supplier name.
• Amount of the invoice
• Fiscal Date (payment Date)
• Check number (payment Number)

 

Note: The reason for not choosing a specific invoice number is because payments can contain several invoices and banking would need to know the total amount paid to the supplier, i.e. payment amount.

Once you have the detail send the information to the correct Banking team and they will be able to investigate the payment.

Market	Email address
Belgium	Banking-BELUX <[email protected]>
France	Banking-FR <[email protected]>
Germany	Banking-GE <[email protected]>
HEL	BANKING-HEL <[email protected]>
HESC	BANKING-HESC <[email protected]>
Italy	Banking-IT <[email protected]>
Luxembourg	Banking-BELUX <[email protected]>
Netherlands	Banking-NE <[email protected]>
Spain	Banking-SP <[email protected]>
UK	Banking-UK <[email protected]>
North America	[email protected]

 

If needed, download attached word document.