change Query Item & Query Subject Names in Framework Manager

[phanicrn]

Hi

Is there any way we can change queryitem & query subject names  as per our specification..

Say when i import metadata. Obviously column shows "Product_Type". Now when i want to remove  "_" from query item name and show only "Product Type". For one column we can do, say if we have to change 1000 columns  , then what should i do, Is there any script that can  do..

[MFGF]

One option is to use the Export Language File option from the Project menu to export all the names to a text file.  You can then run this though an editor to strip out punctuation etc, then re-import into Framework Manager.

Regards,

MF.

[phanicrn]

Hey

I did all what you said, I expored to Text files, When i did that i have all the column names. Only thing i dont know , How & where  i should exectue the script. Do i have to call  the model.xml file in script editor  and point to text file , if matching string finds, change  in .xml file, is it  what i have to do..

[rocket]

Unfortunately the [namespace].[query subject].[query item] is the key identifier in report specifications (report studio, query studio).  With Report Studio, you can make the change manually to a report by either searching each query in the report and fixing manually, or you can copy the xml to clipboard, fix it in a text editor like notepad, and then open from clipboard.  Unfortunately both of these are painful options if you have more than one or two reports to fix, and they don't address Query Studio, where you can't see the underlying XML spec and therefore making this type of change in the model will break the QS reports and not let you fix.

There is a product that handles this exact issue in an automated fashion by searching all QS and RS specs in the content store for FM changes and fixing them automatically by replacing the old reference with the new one.  It also allows you to copy any specification (RS, QS, Analysis Studio or PP Web) from Content Store, modify it, and put it back with just the click of a button.

Take a look at the Powered by Cognos website via  Cognos's website for information. 

http://www.cognos.com/solutions/powered_by_cognos/brightstar_partners.html

The product is MetaManager, and is a Powered by Cognos solution.

[shawnzhao123]

I want to do the same thing for my project, did anyone know a solution?

[MFGF]

I want to do the same thing for my project, did anyone know a solution?

A muppet once said:

One option is to use the Export Language File option from the Project menu to export all the names to a text file.  You can then run this though an editor to strip out punctuation etc, then re-import into Framework Manager.

Regards,

MF.