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

Can I merge between two subject areas in different module?

Accepted answer
62
Views
3
Comments
Mohammad Borghol
Mohammad Borghol Rank 2 - Community Beginner
in Oracle Transactional Business Intelligence

Hi All,

I am currently working on a dashboard that pulls data from the Procurement - Requisition Real Time subject area. I have a requirement to add a filter that reads sub-departments from the Workforce Management - Worker Assignment Event Real Time subject area in the HCM Module.

I have already added both subject areas, but unfortunately, the filter is not functioning as there is no direct link between the two subject areas.

I would appreciate any suggestions or solutions to address this matter.

Thank you.

Tagged:

Best Answer

  • Dimple-Nagesh-Support-Oracle
    Dimple-Nagesh-Support-Oracle Rank 6 - Analytics Lead
    Answer ✓

    Hi,

    The error shows NO fact table exists, while creating Cross-subject area reports, you need to following the following rules :


    >> Both SA should have the common dimension

    >> You need to add the related FACTS from both the SA's

    >> You Need to enable the DIMENSIONALITY on the report,


    Steps to enable DIMENSIONALITY : Edit the report >click on Advanced Tab > Scroll down to Advanced > select the check box Dimesionality > click on Apply SQL > now click on results tab

    Thanks

    Dimple

Answers