Oracle Analytics and AI

Dependent DFF Value Problem in Analyticss

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

Find more posts tagged with

Reporting

Tips & Tricks

Developers

Analysis

Prepare and Model Data

Accepted answers

All comments

Alexandra Andrei-73074

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

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.

Alexandra Andrei-73074

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