Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

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

Filtering the report on non conformed dimensions

Received Response
11
Views
2
Comments
2657149
2657149 Rank 2 - Community Beginner
edited Aug 13, 2024 7:03PM in Oracle Analytics Forum

Hi,

Hello Everyone,

I have few reports with one non conformed dimension D from facts F1 and F2.

The measures from F2 is set to grand total level of D as D does not have any relationship with F2..

Hence, I see the transactions from F2 alone comes with null value on the report.

Now, we wanted to filter the reports by the non conformed dimension column.

When I try to filter, I miss these F2 records on the report which does not have any corresponding records from F1..

Is there any way to always show up these records of F2 even when prompting by column from D?

I have not used selection steps anytime, but I am not sure, would this work?

Any other ideas...Thank you in advance..

Thanks

Shravan

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner 
    2657149 wrote:
I have not used selection steps anytime, but I am not sure, would this work?

    a) So why haven't you tried that?

    b) Filter on one fact table not affecting second fact table in analysis?

  • 2657149
    2657149 Rank 2 - Community Beginner

    Hi Christian,

    Thanks for your response!!!

    OBI generates two sqls for me, one with F1 and D and the other with F2 and other conformed dimensions.

    As long as I do not filter on dashboard prompt from  the column of D, OBI uses a full outer join between the 2 sqls, but when I apply any filter on column from D, it uses an inner join between the two sqls.

    I tried selection steps too, but it still use the inner join and hence the records only from F2 gets dropped..


    How can we get OBI to use a outer join even when we apply any filter in prompt from D?

    Thanks

    Shravan