Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 214 Oracle Analytics News
- 42 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 78 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations 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,
1
