Hello all,

Here below you will find a tool to search for which data modules use a table in your cognos environment.

The example below apply for 11.1.7 and 12.0.1 version of Cognos.

It was tested with anaconda and spyder.

First dowlnload from https://github.com/ykud/cognosanalyticspy, the cognosanalyticspy-main.zip file and unzip it to cognosanalyticspy-mainV11 folder or cognosanalyticspy-mainV12 folder according to your version

Then update the config.ini to declare your cognos environment (cf config-illustation.png)

For V11 (11.1.7)

• copy datamodule.py from V11.zip to cognosanalyticspy-mainV11 folder
• copy cognos_analytics.py, module.py, rest.py from V11.zip to cognosanalyticspy-mainV11/services folder

For V12 (V12.0.1)

• copy datamodule.py from V12.zip to cognosanalyticspy-mainV12 folder
• copy cognos_analytics.py, module.py, rest.py from V12.zip to cognosanalyticspy-mainV12/services folder

How to use it 

• Launch anaconda and spyder
• Open the folder Cognosanalyticspy-mainV11 or Cognosanalyticspy-mainV12
• Open the console and verify that the current folder is Cognosanalyticspy-mainV11 or Cognosanalyticspy-mainV12 with command cd and pwd
• Launch the console and type the following comman, don't forget to declare which environment you want to request (ex : run datamodule.py -e prod -l info.log )
• At the question in the console " type the string you want to search in data module " , type the name of the table you are looking for and let it run
• The result will be put in the folder output. We will have only the name of the data module in V11, in V12 we will have the path and name of the data modules 

  Hope it will help you !