IBM Support

How to add an additional column to and existing data module

Question & Answer


Question

How do we add an additional column to an existing data module in Cognos Analytics 11.1.3?

Answer

Steps:
  1. Refresh the schemas in the data server to which the data module is linked to: Manage > Data server connections > Select data server > Connections tab > Select connection name > Schemas tab > Select schema > More > Load metadata
  2. Open the data module and click on the 'Source view' tab on the left 
  3. Expand the schema and the drag the updated table into the data module metadata tree. The new columns will be added to the list of query items.   

[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSTSF6","label":"Cognos Analytics"},"Component":"Data Servers","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF016","label":"Linux"},{"code":"PF033","label":"Windows"}],"Version":"11.0.x;11.1.x","Edition":""}]

Document Information

Modified date:
03 October 2019

UID

ibm11078221