Oracle Transactional Business Intelligence

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Transactional Business Intelligence

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How do I get the performance tiles to aggregate properly when using multiple subject areas?

Received Response
22
Views
1
Comments
User_YDHRB
User_YDHRB Rank 1 - Community Starter
in Oracle Transactional Business Intelligence

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

Tagged:

Answers

  • Rajasekhar Bandaru-Oracle
    Rajasekhar Bandaru-Oracle Rank 6 - Analytics Lead
    edited Apr 24, 2024 2:47AM

    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