Change query subject name

[cognosmanager]

Hi all,
There is an existing model in FM. Now there is a requirement to just change the names of query subjects. But if I change names, all affected reports will fail. I have tried durable model but still it is failing. Please help

[vinothkumar62]

Hi,
I am having a valid point.

I think you have access to Fm model.

1. Please modify the name of the query subject.

2. publish the package to cognos connection.

3. Then select the modified query subject.

4. In tools menu you can find "Find report Dependencies" and you can search how many report is going to affect.

5. With this search result, you have to manually modify the name in the each report.

Finally you can able to run the report.

Please try it & Let me know any issues.

[cognosmanager]

Hi,

Actually this method will be tiresome as we have around 35 pages in report and each page has different associated query with each query having 50+ query items. Any other menthod if possible please let me know.
Thanks

[bdbits]

Why are you renaming the query subjects? Are those requesting this renaming aware of the impact they will have?

Would they be satisfied with a separate package or namespace having the query subject named the way they like? If so you could alias new names to your existing query subjects.

If you can spend money on a tool, you may want to check with our hosts about their tools in MetaManager. They might be able to do search/replace operations for you.

[TheBrenda]

Is your query subject a view? if so you can modify the view to include the old and new column names. we do this quite  frequently to not break reports from out reportnet users as we move them to BI.

IBM has DRU utility that will change all reports. I have used it. It is a bit clunky, but it will get the job done.

I have written a TSQL script that will search all the report definitions and replace old text with new text. But the input is customized for my shop. If you are good with TSQl you could change it.

MotioPI is a free tool tool that will search reports for text and let you know which report will be affected (I also have a tsql script that will do this that is a stored procedure and not shop depended). The mass update feature is a pay feature.

[vinothkumar62]

Hi,
Try this method.

1.Rename the query subject in DB layer.
2. Select the query subject in business layer.
3. Go to Actions->remap to new source
4. It asks for query item path, just point the new renamed path in DB layer.
5. Validate

Once you remap the old source with the new one, then you can test & publish the package. Then open the each report and point to the new package.

Now you can able to run the report successfully.
(This method will be suitable for Framework level and DB as well.

Try this and let me know this will adopt for you or not.