OTBI Reporting for Expenses

Summary

Creating a new analysis report for Expenses

Content

Hello:

We are trying to create a report on Expense Reports.   Using the subject area, Expenses-Expense transactions real time, I am able to get most everything I want; except when I try to combine data from Corporate Card Expenses with say Line Item expenses.  For example if I have the distribution account pulled, I can pull in the billed amount under corporate card transaction details, but when I try to add the posted date/transaction date, etc. receive an error.

Does anyone know how to get all the data for both the corporate card and cash reimbursements in the same report?