Cognos Analytics

 View Only
  • 1.  Data Module Table Properties Refresh

    IBM Champion
    Posted Wed October 19, 2022 12:37 PM
    Is there a way to systematically force an update of the data module's metadata (<> source's metadata)? We need to do some changes to our database tables like changing primary keys data types from bigint to varchar. After doing this change the data type property of the data module attribute/ID still shows bigint even though the preview shows alphabetical values. Editing the attribute and doing dummy changes does the trick but that's only on a column level. Relinking the source doesn't update the properties and also breaking the link (by a wrong source) and relinking again doesn't update. Does anyone know a way to force an update of all properties of a data module table? We're using CA 11.1.7.

    ------------------------------
    Philipp Hornung
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Data Module Table Properties Refresh

    Posted Wed October 19, 2022 01:29 PM
    Edited by System Test Fri January 20, 2023 04:41 PM

    Starting with 11.2.2 there is a menu item which will refresh the properties of columns in your data module.   It is available for individual columns, tables, stand alone calculations, folders, and the entire module itself.

    Here is the documentation of it:

    https://www.ibm.com/docs/en/cognos-analytics/11.2.0?topic=properties-refreshing

    I've written a blog about it here:

    https://community.ibm.com/community/user/businessanalytics/blogs/ian-henderson1/2022/03/11/synchronizing-data-source-metadata-changes-to-upda

    If you don't want to move to 11.2.2 then you can force metadata refreshing by going into the properties slide out for each column whose metadata you want to refresh and click on the view or edit button (it looks like a link).  This will bring up the expression editor for the column.  Press the space bar once to add a blank space to the expression.  It should enable the OK button. Press OK.  This make a metadata callback to the schema (or uploaded file or data set) and the refreshed metadata will be fetched.  I think that is what you have been trying.



    ------------------------------
    IAN HENDERSON
    ------------------------------



  • 3.  RE: Data Module Table Properties Refresh

    IBM Champion
    Posted Thu October 20, 2022 03:35 AM
    Thanks Ian, That is precisely what we need!

    ------------------------------
    Philipp Hornung
    ------------------------------