Oracle Analytics Cloud and Server

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

Dependent DFF Value Problem in Analyticss

Received Response
45
Views
3
Comments

Summary

I can not see null values for dependent dff value in report

Content

Hi Dear All,

I use two dff value in purchase order. Those are Member Type and Member. Member Type is independent value but Member dependent on Member Type. In additional they are not required.

I created a analytics from Purchasing Real Time. I added Member Type its okey. But when i added Member. I suppose system start grouping process between member and member type. 

In report, There must be null values for Member type and member. But When i add member column, system filtered automaticly and i couldnt see any null value.

Although I have many records in purchase order has null values Member Type and Member. but When i add Member I see just not null values.

I added two before after picture.

Can you help about it ?

Best Regard 

Version

Oracle Cloud Application 20A

Answers

  • Alexandra Andrei-73074
    Alexandra Andrei-73074 Rank 1 - Community Starter

    Hi,

    Have you tried to put a filter on the columns to check if they bring the null values? For example Member Type is null .

    Also , try with Requester before Member Type and Member.

    Regards,

    Alexandra

  • Eren Göktepe-155015
    Eren Göktepe-155015 Rank 2 - Community Beginner

    Hi Alexandra,

    I tried your suggestion but it doesnt work :\

    I added some screenshots to understand clearly. I created basic table and took two screenshot with member and without member. By the way, I didnt use any filter. You can see differences between them.

    Member3.png

  • Alexandra Andrei-73074
    Alexandra Andrei-73074 Rank 1 - Community Starter

    The filter suggestion was only for debugging purpose . I wanted to check that there exist/do not exist any null values for those columns.