benbotektips
MIS
Here's the problem:
I have a production catalog and database, let's call them PROD. The catalog pulls in tables from the PROD database defined in the databases section.
I get projects to parallel develop on another database. So, I copy the PROD catalog, rename the copy to TEST, and point its tables to the test database, also defined, let's call it TEST.
The only way to copy calculations and formatting for the TEST reports, is to open the PROD reports (and catalog, especially need to look at the SQL) in one window, open the TEST ones in another window, and copy.
From time to time, I'll close a report in test, which leaves the catalog open. I'll open another report in PROD, which has its catalog defined as PROD, and view the report. Later, I'll find out that since I didn't close the catalog for TEST, the PROD reports and catalog are actually pulling in data from the TEST tables!!!
Of course, this is another Cognos bug. If a developer points a report to a specific catalog, naturally they'll want the report to always bring in data from the corresponding database too. How can I lock, or hard code the database in the table section of the catalog, so that PROD catalog will always pull data from PROD database, and test catalog will always pull data from TEST database, unless I go to the 'report-general' menu, and switch the catalog for the report? In other words, how can I force a logical association, PROD reports = PROD data, TEST reports = TEST data, with the only override being to switch the catalog?
I have a production catalog and database, let's call them PROD. The catalog pulls in tables from the PROD database defined in the databases section.
I get projects to parallel develop on another database. So, I copy the PROD catalog, rename the copy to TEST, and point its tables to the test database, also defined, let's call it TEST.
The only way to copy calculations and formatting for the TEST reports, is to open the PROD reports (and catalog, especially need to look at the SQL) in one window, open the TEST ones in another window, and copy.
From time to time, I'll close a report in test, which leaves the catalog open. I'll open another report in PROD, which has its catalog defined as PROD, and view the report. Later, I'll find out that since I didn't close the catalog for TEST, the PROD reports and catalog are actually pulling in data from the TEST tables!!!
Of course, this is another Cognos bug. If a developer points a report to a specific catalog, naturally they'll want the report to always bring in data from the corresponding database too. How can I lock, or hard code the database in the table section of the catalog, so that PROD catalog will always pull data from PROD database, and test catalog will always pull data from TEST database, unless I go to the 'report-general' menu, and switch the catalog for the report? In other words, how can I force a logical association, PROD reports = PROD data, TEST reports = TEST data, with the only override being to switch the catalog?