Reporting date from Custom Fields

[BriP25]

Hi, I've created some custom fields for our expenses (input) form.

How do I add information from these custom fields into a (modified) report using Cognos Analysis /Cognos Data Warehouse/Cognos Query Studio?   Where and how do I add the custom fields to the list of data in the screenshot below?

Thanks in advance

[KevinD]

@BriP25 this depends on which fields in SAP Concur you used for these Custom Fields. Did you use the Org Unit fields or the Custom 1, Custom 2, etc. fields? 

Also, have you ever used the Configuration report before? This report will show you the custom field label you created and which field within the SAP Concur configuration you mapped it to. 

Lastly, these fields in the data warehouse can be found in a couple of different places, but most commonly people pull them for the Expense>Expense Reports>Report Header Information>Additional Employee Details folder. In here you will see all the generic field names (Org Unit 1, Org Unit 2, Custom 1, Custom 2, etc.). You won't know from here which is which, so that's why you would use the Configuration Report (found on the Expense Admin screen), to see the mapping. Or, if you have time, you just start adding those fields to your Query Studio report and see what data appears. If it is what you need, keep it on the report, if not, just delete it. 🙂