Maintaining Cognos Settings

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​

Review the following steps to learn how to map custom fields to Cognos 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 field 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.

Summary

  • After mapping a concept to specific company hierarchies and custom fields, the data is extracted to the Concur Data Warehouse during the overnight process.
  • These mapped concepts then become available in the data warehouse model for use in custom reports.
  • Report creators can use these concepts in Query Studio or Report Studio without needing to know the underlying hierarchy or custom field names.
  • Concept fields can be re-mapped at any time if needed.
  • This feature is available only to customers who use Analysis or Intelligence along with Expense or Invoice (but not Travel).

Reference

TopicLink
Mapping the FieldsSAP Help Portal
Learning

SAP FacebookSAP YoutubeSAP LinkedIn