Associated Request ID and Name to expense cognos report

[AnnaL]

Hi,

I would like to add associated Request ID and Name to expense cognos report, is it possible? The final output should be the expense report with the travel request ID associated.

Thanks,

Anna 

[KevinD]

@AnnaL yes, this is possible. After you add Employee and Report Name to your report from the data warehouse, move down the data warehouse folders and you will see a Travel Request folder. Here you can add Request ID to the report and any other Travel Request data to the Cognos report.

[AnnaL]

Hi @KevinD,

thanks for your feedback. I've already tried to do what you suggested but in the output, the ID request field remains blank, even if the report has a request. How is it possible? It seems that cognos can't recognize that a report has a request linked to it.

Thanks,

Anna