Mapping Invoice Concept Fields

Objective

After completing this lesson, you will be able to map custom fields to Cognos concept fields.

Cognos Concept Fields Overview

Once you map a concept to specific company hierarchies and custom fields, the Data Warehouse Expense Archive job populates this information in the reporting database overnight. These concepts then become available in the data warehouse model, allowing you to add them to custom reports.

Report writers can use these concepts in reports created with Query Studio or Report Studio, without needing to know the actual company hierarchy or custom field names.

It’s important to know that you can’t change the names of the concept fields, but you can change the label names in any report you create. You can also re-map concept fields as needed.

Note

Only customers who use Analysis or Intelligence and Expense or Invoice (not Travel) can use this feature.
The image displays the Map Invoice Concept Fields screen, where users select fields for different concept types such as Division, Department, Business Unit, Cost Center, and Project using dropdown menus, with Save and Cancel buttons at the top.

Map Custom Fields to Cognos Concept Fields​

To map invoice concept fields:

Steps

  1. On the Invoice Administration menu, select Map Invoice Concept Fields.

    The image displays the Invoice Processing Admin interface with a navigation menu on the left, where the Map Invoice Concept Fields option is highlighted, and a main section on the right listing various administrative options and their descriptions.
  2. For each concept, select the Employee field, Payment Request Header field, Payment Request Line Item Details field, or Payment Request Allocation that best matches the concept for your company and then select Save.

    The image displays the Map Invoice Concept Fields screen, where users assign fields to concept types such as Division, Department, Business Unit, Cost Center, and Project using dropdown menus, with Save and Cancel buttons at the top. The navigation menu appears on the left.