List of all Direct Database Query Analyses

JessicaWilson

What would be the easiest way to find all the direct database analyses?  We're getting ready to do an EBS upgrade to 12.2.8 and I need to make sure that our BI queries conform to the new 12.2 architecture. Any help is appreciated.

Oracle Business Intelligence 11.1.1.7.160719

Joel Acha

Quickest way would be to enable OBIEE Usage Tracking and you can pick up DDR easily from there.

https://www.oracle.com/webfolder/technetwork/tutorials/obe/fmw/bi/bi1116/ut/ut.html

Gianni Ceresa

I would agree with Joel but usage tracking will only list analysis which have been executed, so any analysis which hasn't been executed will not be found.

If you mean to find all the DDR (direct database requests) in the shared folder of the catalog you can use catalog manager, make a catalog report of all the analysis and get the subject area: a DDR will have an empty value.

If you also want to cover the various users private folders you can take a "workaround" : a filesystem search for any file containing the XML which identify a DDR (like fgrep or recursive grep in linux).

A DDR will have something like: <saw:criteria xsi:type="saw:physicalCriteria" connectionPool="&quot;ORCL&quot;.&quot;SH Connection pool&quot;">

The ' xsi:type="saw:physicalCriteria" ' attribute or the presence of the ' connectionPool ' attribute are a good indicator it is a DDR.

Because it's a filesystem search (outside OBIEE) you can search in all users folders too as there isn't any OBIEE security applied here.

JessicaWilson

Very helpful, thank you!

JessicaWilson

Thanks Joel...luckily we have had usage tracking turned on so I'm going to take a stab at both of these methods to find what I need.

[Deleted User]

Not to say Joel is wrong, but in this case not 100% and reinforce Gianni's point;

ONLY xsi:type="saw:physicalCriteria" in the web catalog gives you a complete picture.

Just like ONLY xsi:type="saw:derivedCriteria" will retrieve all UNION analyses.