Expense data and corporate data in single OTBI report.

Question

We are facing challenges when adding corporate card details into an Expense OTBI report. The subject area is "Expense - Expense Transactions Real Time". We have selected basic information from Expense entities, which is working perfectly fine. We are now trying to add few more fields from corporate card Transaction details entities but few of the existing data gets cleared out and report behaves abnormally.

We can create them as a separate report but if it is not something that can be resolved, we would definitely like to understand why both can't be a part of same report for future reference. Thanks!

Bhaskar Konar · Answer

https://community.oracle.com/products/oracleanalytics/discussion/24491/expense-data-and-corporate-data-in-single-otbi-report

Hi @User_VRHE6,

It seems there are some issues with underlying data model as a result it behaves bit strangely if you combine Expense with Corporate Card details. Please look at the following post.

OTBI: Join Corporate Card Data with Expenses Data — Oracle Analytics

As a work around you can use Logical SQL to get the details as per your requirement.

In high level, you have to do first set with your required columns from expense and then second set for corporate card. Finally join both and select required columns.

Hope this help.

Cheers,