Categories
- All Categories
- 15 Oracle Analytics Sharing Center
- 15 Oracle Analytics Lounge
- 208 Oracle Analytics News
- 41 Oracle Analytics Videos
- 15.7K Oracle Analytics Forums
- 6.1K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 76 Oracle Analytics Trainings
- 14 Oracle Analytics Data Visualizations Challenge
- Find Partners
- For Partners
OTBI report built using cross subject area not pulling the data for custom subject area column
Hi,
There is an OTBI report built using crm sales standard subject area and the column named "Customer Driver" in the same subject area is pulling incorrect data as the column is using custom object to pull the data . As suggested by oracle we created custom subject area using the custom object columns and most of the dimension tables like for product and revenue are missing to get it added to custom subject area. When we add custom subject area into the existing report there is duplicate rows with correct and incorrect column value for "Customer Driver" as there is no specific connection between product and revenue tabled with custom subject area. Any suggestion for fixing this issue except for BIP report option as we have multiple OTBI reports depenedent on this in several Dashboards?
Thanks,
Vidhya C
Answers
-
Hi @cvidhya,
It is probably because you don't have a common dimension between both subject areas.
Basic rule to use more than one SA in a report, you need a common dimension (object), add one metric from each SA. See details and examples in below doc:
Regards,
Priscila Terazawa
0 -
It looks like the duplicate rows issue is occurring because the custom subject area lacks a proper connection between product and revenue tables. Please check the below:
How to delete duplicated records in OTBI Analysis — Cloud Customer Connect
1 -
Hi @cvidhya
Please add a proper measure column and a common dimension if that did not resolve the issue
please share the log file
0
