Hi
We are developing impromptu reports for a client. The database is Oracle 8i. In this we have a schema where there are around 2000 tables and views. In Cognos Catalogs we are making logical databases depending upon the subject areas. Now we are trying to do simple Powerprompts application for some of these impromptu reports. We came to know that the equilent of catalog picklist is Dynamo in powerprompts. When we try to retrieve metadata for a dynamo, its retrieving the metadata of all 2000 tables and views.
Is there anyway that we can select only those tables and views which are necessary for that particular Dynamo? Is there any way to simplfy the entire process?
Thanks in advance.
We are developing impromptu reports for a client. The database is Oracle 8i. In this we have a schema where there are around 2000 tables and views. In Cognos Catalogs we are making logical databases depending upon the subject areas. Now we are trying to do simple Powerprompts application for some of these impromptu reports. We came to know that the equilent of catalog picklist is Dynamo in powerprompts. When we try to retrieve metadata for a dynamo, its retrieving the metadata of all 2000 tables and views.
Is there anyway that we can select only those tables and views which are necessary for that particular Dynamo? Is there any way to simplfy the entire process?
Thanks in advance.