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?
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.
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.