If you copy objects from report A to report B in new version of Cognos, it always creates new assets when the name of queries or variables matching on both reports.
We are facing this problem when more than one developer creates the report or when the developer wants to merge parts from different version of the same report. It always creates new queries and variables with number suffix (e.g. q_table -> q_table1). It takes a lot of time to clean-up the final version of report.
Currently we have to use external tool (DRU) to switch the reference of object to query or variable and then we need to manually clean the report definition.
Why is it useful?
|Who would benefit from this IDEA?||Developers or customers who needs to create Cognos reports in parallel way.|
How should it work?
When you copy objects from report A to report B, and variables or queries are matching in both reports, Cognos should ask you if you want to merge the queries and variables or you want to create the new ones.
|Priority Justification||It is High because we need to clean the report every time when we copy the object. And copying is one of the most used functions in Cognos.|
|Customer Name||Komercni Banka|
NOTICE TO EU RESIDENTS: per EU Data Protection Policy, if you wish to remove your personal information from the IBM ideas portal, please login to the ideas portal using your previously registered information then change your email to "email@example.com" and first name to "anonymous" and last name to "anonymous". This will ensure that IBM will not send any emails to you about all idea submissions