eul5 - does any table list the folders that each query uses
Hi Everyone,
Hope all is well,
We use Discoverer to report off of Sungard Banner data (for Universities)
We report off of an ODS, not directly off of the production system.
We are moving from ODS 3.1 to ODS 8.
I learned here recently about EUL5_DOCUMENTS to dump a list of out existing queries.
Is there any table that lists for each query, the folders that the query uses?
I learned here recently that when creating an OUTER join in Admin, there is a desc. field
to describe the join. We do that now, but we have many previous joins that are not documented this way.
If i could create a query with all the tables that a query uses, i could use this query as some kind of checklist
as we create the joins in ODS 8.
Please advise with your thoughts and ideas, tx, sandra