Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

DAC Repository database question

658640Sep 8 2008 — edited Sep 9 2008
I am trying to write a query that will provide me a list of Subject Areas and their corresponding Tasks. The same list you would see in the "Tasks" tab in the DAC Client Design view for a specific Subject Area. This is in our test environment with the 7.9.5 OBI Apps.

I am not very familiar with the DAC database tables but through the help files, information I've found online, and a little bit of hacking I believe the tables I need are:

W_ETL_SA
W_ETL_STEP
W_ETL_SA_STEP

When executing the following query I do not get the full set of results.

SELECT
W_ETL_SA.name as SA_Name
,W_ETL_STEP.name as STEP_Name
FROM
W_ETL_SA
,W_ETL_STEP
,W_ETL_SA_STEP
WHERE
W_ETL_SA_STEP.SA_WID = W_ETL_SA.ROW_WID
AND W_ETL_SA_STEP.STEP_WID = W_ETL_STEP.ROW_WID

The W_ETL_SA_STEP table has 69 distinct SA_WID values but only 5 of them correspond to records in the W_ETL_SA table.

I've been able to run a similar query for Execution Plans and their corresponding Subject areas with the W_ETL_DEFN_SA, and a query for Execution Plans and their corresponding Tasks with W_ETL_DEFN_STEP.

Any ideas why this query does not work? Have I misunderstood the purpose of the W_ETL_SA_STEP table?



Thanks is advance

Tom
Comments
Locked Post
New comments cannot be posted to this locked post.