Oracle Analytics and AI

User_YDHRB

Hello Experts,

I've run into an issue when creating performance tiles from joined subject areas.  The tile (using a simple count measure) I'm using seems to aggregate properly when in the compound view, but when the tile is in edit view or on another dashboard, it only displays a one.   Is there a better way to set up the subject area join?  Should the count column be created differently to work with both subject areas?

Side note: We need to be able to do this within an analysis — BIP would not be an option for our use-case.

Thanks in advance,

Jens

Rajasekhar Bandaru-Oracle

Hi

Please review the given cross-subject area guidelines.
https://docs.oracle.com/en/cloud/saas/otbi/otbi-user/combine-subject-areas-analyses.html#GUID-8B9DF9B1-20E3-4F88-8EEE-0714EF6E2F63
When the report build with more than one subject areas, things to consider

1. You should have a common dimension in all the subject areas
2. Add Measure/Fact from each subject area on the report
3. Click on the Advance tab of the Analysis report --> Scroll down till you see Advance SQL clause --> Check the Dimensionality check box --> click on Apply SQL button. Go to Results tab to see the data.
4. You also need to consider the lowest grain at which the SA is built.
5. More then one subject area reports are complex reports, apply proper filters on the report
6. Best to debug the issue, create a simple report with one subject area, remember to add as many dimension columns from first SA and add at least one measure. Apply filters
   Add a second subject area add required dimension columns and don't forget to add a measure.

For any further issues, Please review the NQSQuery.log generated for the analysis

Doc ID 2225909.1 Fusion Applications: How to Get nqquery Using Manage Session

Thanks & Regards

Rajasekhar