Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 

 View Only

  • 1.  Framework Manage - any short cut to adding column/field descriptions for a table with many columns?

    Posted 24 days ago

    Framework Manage - any short cut to adding column/field descriptions for a table with many columns?

    I have a really wide table (lots of columns/fields) that was added to FM. Now I need to enter a description for each column. I have a list of each column name and its associated description that is in the same order as the list columns in FM. Is there an easy/short cut way to enter descriptions for multiple columns without having to click on each column individually? 



    ------------------------------
    brenda grossnickle
    BI Programmer Analyst
    FIS
    ------------------------------


  • 2.  RE: Framework Manage - any short cut to adding column/field descriptions for a table with many columns?

    Posted 23 days ago

    I haven't had to do this. But I would try using Power Automate.

     

    Diego Ferrara
    Technical Service Team Leader | Almac Clinical Technologies

    Partnering to Advance Human Health

    T: +1 215 660 8520 Ext:21238
    M: 2674162223
    E: Diego.Ferrara@almacgroup.com
    1690 Sunneytown Pike | Lansdale | PA 19446 | United States of America

    www.almacgroup.com
     




    Original Message


  • 3.  RE: Framework Manage - any short cut to adding column/field descriptions for a table with many columns?

    Posted 22 days ago

    Quick tip that might be helpful for you. You can check out the FM SDK documentation to manage FM via scripts. It provides detailed guidelines and examples on how to handle various fields and automate processes efficiently.

     

    To make things even easier, you can start with a couple of fields and then take the script into your favorite GenAI tool to generate the rest of the fields. This approach can save you time and effort while ensuring accuracy and consistency.

     

    Oleg

     



    This email has been scanned for email related threats and delivered safely by Mimecast.
    For more information please visit http://www.mimecast.com



    Original Message


  • 4.  RE: Framework Manage - any short cut to adding column/field descriptions for a table with many columns?

    Posted 23 days ago

    Hi Brenda -

    You can try to export a translation file and see if this does what you want.  (Project > Languages > export file>.  

    In previous versions, you would be able to export the list of objects to an excel file, modify the description, screen tips and what not - then import the changes back into the model.

    I hope this helps. 



    ------------------------------
    John Cusack
    Analytica iQ
    ------------------------------

    Original Message


  • 5.  RE: Framework Manage - any short cut to adding column/field descriptions for a table with many columns?

    Posted 22 days ago

    Check BmtScriptPlayer - it's a command line tool that can playback FM transaction logs.

    When you do something in FM, it's recorded in the transaction log (XML). You can modify a column description manually, check the transaction log and mimic the same actions from your description file. You could probably generate a python script in chatgpt to translate your description file to the XML log that can be read by the script player.

    Make sure to backup your model before running the script ;)



    ------------------------------
    Tomáš Polakovič
    ------------------------------

    Original Message


  • 6.  RE: Framework Manage - any short cut to adding column/field descriptions for a table with many columns?

    Posted 21 days ago

    Hi Brenda,

    I have done this before using multiple languages and translation exports. Message me if you want me to jump on a quick call and show you.

    Thanks,

    Nipun



    ------------------------------
    Nipun Gupta
    ------------------------------

    Original Message


Related Content