Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 54 Oracle Analytics and AI Sharing Center
- 25 Oracle Analytics and AI Lounge
- 307 Oracle Analytics and AI News
- 57 Oracle Analytics and AI Videos
- 16.4K Oracle Analytics and AI Forums
- 6.6K Oracle Analytics and AI Labs
- Oracle Analytics and AI User Groups
- 118 Oracle Analytics and AI Trainings
- 22 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Expense data and corporate data in single OTBI report.
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!
Answers
-
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,
2
