How can I view the Query Subjects (SQL table or view) of a deployed package

[TheBrenda]

For example, we have a Deposit model that we use in Framework Manager to publish Deposits Daily and Deposits Monthly packages. We just make one query subject change to the SQL view v_DD for daily to v_DDME for the Deposits Monthly package. We have hundreds of packages where we make this kind of change to differentiate from our daily to monthly package version. Sometimes someone makes a mistake and does not select the correct SQL view to match the package - v_DD is in the Deposits Monthly package.

Is there a way that we can get a list of query subjects (Sql table or view names) in each of the deployed packages? SDK, third party, some automated way from within COGNOS?

[vinothkumar62]

Hi,
Select the query subject & in tools you can find the option "object Dependencies" . Then it will displays all the usages in all the packages.

Does i answer your Query?

Let me know still any assistance required.

[TheBrenda]

Select the query subject & in tools you can find the option "object Dependencies" . Then it will displays all the usages in all the packages.

Is this in Framework manager or Cognos Connection? I need a way to find the query subjects from Cognos Connection. When the model is saved, it is only saved as a Daily. The monthly model is not saved. I need to verify what query subject were used when the model was published. I need to verify the published models in Cognos Connections.