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
Query error when joining two Procurement SAs: Purchase Order with Receipts

The attached error is seen when any field from Procurement - Receipts is being added to fields from Procurement - Purchase Order
Best Answer
-
@User_3512R - Make sure you include at least one fact / measure column from both the subject areas.
If you do not want to display both the measures, then you can hide them by dragging and dropping them in Tooltip section.Or
Create two different datasets - one for each subject area with the required dimensional attributes and facts / measures and then use these two datasets in creating the workbook.
1
Answers
-
Thank you, @Sumanth V -Oracle
0