Cognos Analytics

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

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
------------------------------

Original Message:
Sent: Wed October 19, 2022 12:37 PM
From: Philipp Hornung
Subject: Data Module Table Properties Refresh

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

Thanks Ian, That is precisely what we need!

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

Original Message:
Sent: Wed October 19, 2022 01:29 PM
From: IAN HENDERSON
Subject: Data Module Table Properties Refresh

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

Original Message:
Sent: Wed October 19, 2022 12:37 PM
From: Philipp Hornung
Subject: Data Module Table Properties Refresh

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