Categories
- All Categories
- 70 Oracle Analytics News
- 7 Oracle Analytics Videos
- 13.9K Oracle Analytics Forums
- 5.2K Oracle Analytics Idea Labs
- Oracle Analytics User Groups
- 38 Oracle Analytics Trainings
- 56 Oracle Analytics Data Visualizations
- 2 Oracle Analytics Data Visualizations Challenge
- 2 Oracle Analytics Career
- 4 Oracle Analytics Industry
- Find Partners
- For Partners
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
Answers
-
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
0 -
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.
0 -
The filter suggestion was only for debugging purpose . I wanted to check that there exist/do not exist any null values for those columns.
0