Oracle AI and Analytics

User_RJHPO

I have Natural Account Tree Filter and Natural Account Tree Hierarchy , When i filter for Account EE-Account EE Current using Natural Account Tree Filter as work book filter and put Natural Account Tree Hierarchy as Pivot it wont filter for EE-Account EE Current , It shows all the Hierarchy. As per the attached screen shot . When i filter using work book filter its not refreshing both the viz's its just filtering only one that has got the relationship. So we want to check how we can get that filtered based on Work book filters.

User_RJHPO

Oracle responded as below :

Have verified same 2 columns on internal application. We also see different values for 2 columns. There were some values which are same some are different.

From session log we could see both columns are belongs to 2 different tables.

"Financials - GL Profitability"."Natural Account Hierarchy"."Natural Account Tree Filter"
======================================================================

WITH 
SAWITH0 AS (select distinct T4526.HIERARCHY_NAME_HIERARCHY_VERSION_NAME as c1
from 
   OAX$OAC.DW_NATURAL_ACCOUNT_DH T4526 /* Dim_DW_NATURAL_ACCOUNT_DH */ )
select D1.c1 as c1, D1.c2 as c2 from ( select 0 as c1,
   D1.c1 as c2
from 
   SAWITH0 D1
order by c2 ) D1 where rownum <= 500001

"Financials - GL Profitability"."Natural Account Tree Hierarchy"."Natural Account Tree Filter" 
=========================================================================

WITH 
SAWITH0 AS (select distinct T366.HIERARCHY_NAME_HIERARCHY_VERSION_NAME as c1
from 
   OAX$OAC.DW_NATURAL_ACCOUNT_RF_D T366 /* Dim_DW_NATURAL_ACCOUNT_RF_D */ )
select D1.c1 as c1, D1.c2 as c2 from ( select 0 as c1,
   D1.c1 as c2
from 
   SAWITH0 D1
order by c2 ) D1 where rownum <= 500001