Hello
We need to find the right query on our Oracle database to be able to create a dashboard to do some impact analysis.
From a Colomn, Filter, Join ...
--> Where does it come from (Database, Table (or View), Table colomn)
--> Where is it user ? (Information link, DXP)
And the path to all thoses objects.
We connect on our oracle repository, played with LIB_ITEMS and lib_item_types, but we are quickly stopped.
Could you help us please?
Thanks
Virginie
I found the right syntaxe
type:dxp depends_on(table:VF_PRE_DOSS)
It answer a part of the question. I still can't show it in a DHB (for no technical user)
I test this syntaxe , to find in which query the table 'FICHE_INDIVIDU' is used, and it don't work.
type:query depends_on(type:table title:FICHE_INDIVIDU)
Hello
We know this method already.
We need something more automatic, easier for users.
We were ok to copy the data in our DWH and to a Spotfire DHB on :-) But the Blob format stop us.