DAC Repository database question

658640

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

remc0

May be you can ask your question in this forum: 3412
Hope they can help you better over there!

658640

Thanks. I'll see what I can find over there.