Oracle Analytics Cloud and Server

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

Analysis does not show data if one measure is null

Received Response
1
Views
1
Comments
1128728
1128728 Rank 2 - Community Beginner

Hello,

I have one analysis with 3 measures, if one of them does not return data, the analysis neither do it. I need show the other two measures with its data and the third as null. Is something like full outer join between measures but i don´t know how making it.

Thanks a lot.

Answers

  • cesar.advincula.o
    cesar.advincula.o Rank 6 - Analytics Lead

    Hello,

    For your question: Is something like full outer join ? Yes you could implement INNER JOIN, LEFT OUTER, RIGHT OUTER, FULL OUTER JOIN, for these steps:

    1. Go inside your RPD.

    2. In the  Business Model and Mapping Layear

      BMM.png

    3. Check your relationship

    outer join.png

    The part you said that you have 3 measures, "two of them have data and one no have data", please you could explain in more in detail, how do you have your RPD model.

    Kind Regards,