Cognos Analytics

Cognos Analytics

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

 View Only

  • 1.  Datasource connection is not used!

    Posted Tue June 24, 2025 07:33 AM

    Hi,

    In Cognos Analytics v12.0.4 FP1, I have created one datasource DW_TST. For this datasource, I have 2 connections DW_FRA and DW_ITA.
    I have 2 security groups, FRA and ITA. Both have access to DW_TST.
     
    The DW_FRA dataSourceConnection is only available to security group FRA.
    The DW_ITA dataSourceConnection is only available to security group ITA.
     
    I've created a new data module based on the following connection:
    In Data Server connection, DW_TST is the default (not modified) value. In Catalog, DW_FRA is the default (not modified) value.
     
    When I open this data module, I have a dialog box asking to choose a connection for 'DW_TST' data source, I can choose either DW_FRA either DW_ITA. 
     
    If I choose ITA, it is weird because the 'Show query information…" option for a table do NOT display anything related to DW_ITA connection, only DW_FRA!
     
    I can reproduce the same issue with a report. I don't understand why the datasource connection is not used in this case.

    Best regards,


    ------------------------------
    Patrick Neveu
    BSL Consulting
    IBM Champion
    ------------------------------


  • 2.  RE: Datasource connection is not used!

    Posted Wed June 25, 2025 02:03 AM
    Edited by Philipp Hornung Wed June 25, 2025 02:05 AM
    Hi Patrick, 
     
    I'm sorry, I did a mistake in the other thread. Now I remember that in production we were still using a FM package where the database connection could easily be overwritten. 
    In data modules the database connection is fixed on first saving (for whatever reason this might be good for). In data modules you can only overwrite the data server connection (= database) or the catalog (if applicable) or the schema. 
    Maybe it is possible the you set up multiple data server connections for ITA and FRA with one database connection ("default") each? For an administrator's access who needs to use both connections, you could override the data server connection with the help of a prompt macro instead of a fix value. 
     
    Best regards, 
    Philipp 



    ------------------------------
    Philipp Hornung
    Product Owner & BI Manager
    Techniker Krankenkasse
    Hamburg Germany
    #IBMChampion
    ------------------------------

    Original Message


  • 3.  RE: Datasource connection is not used!

    Posted Tue July 01, 2025 03:45 AM

    Hi,

    I'm in contact with IBM Support regarding this issue. This is case number TS019706253.

    Best regards,



    ------------------------------
    Patrick Neveu
    BSL Consulting
    IBM Champion
    ------------------------------
    -------------------------------------------
    Message d'origine:
    Envoyé: Tue June 24, 2025 07:33 AM
    Depuis: Patrick Neveu
    Sujet: Datasource connection is not used!

    Hi,

    In Cognos Analytics v12.0.4 FP1, I have created one datasource DW_TST. For this datasource, I have 2 connections DW_FRA and DW_ITA.
    I have 2 security groups, FRA and ITA. Both have access to DW_TST.
     
    The DW_FRA dataSourceConnection is only available to security group FRA.
    The DW_ITA dataSourceConnection is only available to security group ITA.
     
    I've created a new data module based on the following connection:
    In Data Server connection, DW_TST is the default (not modified) value. In Catalog, DW_FRA is the default (not modified) value.
     
    When I open this data module, I have a dialog box asking to choose a connection for 'DW_TST' data source, I can choose either DW_FRA either DW_ITA. 
     
    If I choose ITA, it is weird because the 'Show query information…" option for a table do NOT display anything related to DW_ITA connection, only DW_FRA!
     
    I can reproduce the same issue with a report. I don't understand why the datasource connection is not used in this case.

    Best regards,


    ------------------------------
    Patrick Neveu
    BSL Consulting
    IBM Champion
    ------------------------------


  • 4.  RE: Datasource connection is not used!

    Posted Tue July 01, 2025 04:25 AM

    Hi Patrick, 

    Thanks. Please let us know the outcome. A dynamic data source connection would be an advantage from my point of view. 

    Best regards 

    Philipp



    ------------------------------
    Philipp Hornung
    Product Owner & BI Manager
    Techniker Krankenkasse
    Hamburg Germany
    #IBMChampion
    ------------------------------

    Original Message


  • 5.  RE: Datasource connection is not used!

    Posted Tue July 01, 2025 10:14 AM

    Hi,

    I've done more testing and I would like to share the results with you. Now, I have one datasource called DW.
    For this datasource, I have 2 connections DW_FRA and DW_ITA.

    I ran the report with then without "Run with full interactivity", same result.

    I've created a report view (please see report-view-for-dw_ita.png) and I've used DW_ITA as the current value for credential:dw. There is no difference with the report, as expected.

    When I ran the report with an URL with the parameter, I had the following results:

    Value for parameter is DW_ITA:

    http://localhost:9300/bi/?pathRef=.my_folders%2FDataModule%2FNew%2Breport%2Bwithout%2Bcorrect%2Bdatasource%2Bconnection&prompt=false&action=run&p_credential:DW=%3Ccredential%3E%3CdataSourceConnection%20name%3D'DW_ITA'%3ECAMID(%22%3A%22)%2FdataSource%5B%40name%3D'DW'%5D%2FdataSourceConnection%5B%40name%3D'DW_ITA'%5D%3C%2FdataSourceConnection%3E%3C%2Fcredential%3E

    The report runs with data from DW_FRA. UNEXPECTED behavior.

    Value for parameter is DW_FRA:

    http://localhost:9300/bi/?pathRef=.my_folders%2FDataModule%2FNew%2Breport%2Bwithout%2Bcorrect%2Bdatasource%2Bconnection&prompt=false&action=run&p_credential:DW=%3Ccredential%3E%3CdataSourceConnection%20name%3D'DW_FRA'%3ECAMID(%22%3A%22)%2FdataSource%5B%40name%3D'DW'%5D%2FdataSourceConnection%5B%40name%3D'DW_FRA'%5D%3C%2FdataSourceConnection%3E%3C%2Fcredential%3E

    The report runs with data from DW_FRA. Expected behavior

    Value for parameter is DW_SOS (note: there is no such DW_SOS dataSourceConnection):

    http://localhost:9300/bi/?pathRef=.my_folders%2FDataModule%2FNew%2Breport%2Bwithout%2Bcorrect%2Bdatasource%2Bconnection&prompt=false&action=run&p_credential:DW=%3Ccredential%3E%3CdataSourceConnection%20name%3D'DW_SOS'%3ECAMID(%22%3A%22)%2FdataSource%5B%40name%3D'DW'%5D%2FdataSourceConnection%5B%40name%3D'DW_FRA'%5D%3C%2FdataSourceConnection%3E%3C%2Fcredential%3E

    The report could not run with DW_SOS. Expected behavior with the following error message:

    QE-DEF-0286 Unable to find the connection 'DW_SOS' in the content store.

    Best regards,



    ------------------------------
    Patrick Neveu
    BSL Consulting
    IBM Champion
    ------------------------------
    -------------------------------------------
    Message d'origine:
    Envoyé: Tue June 24, 2025 07:33 AM
    Depuis: Patrick Neveu
    Sujet: Datasource connection is not used!

    Hi,

    In Cognos Analytics v12.0.4 FP1, I have created one datasource DW_TST. For this datasource, I have 2 connections DW_FRA and DW_ITA.
    I have 2 security groups, FRA and ITA. Both have access to DW_TST.
     
    The DW_FRA dataSourceConnection is only available to security group FRA.
    The DW_ITA dataSourceConnection is only available to security group ITA.
     
    I've created a new data module based on the following connection:
    In Data Server connection, DW_TST is the default (not modified) value. In Catalog, DW_FRA is the default (not modified) value.
     
    When I open this data module, I have a dialog box asking to choose a connection for 'DW_TST' data source, I can choose either DW_FRA either DW_ITA. 
     
    If I choose ITA, it is weird because the 'Show query information…" option for a table do NOT display anything related to DW_ITA connection, only DW_FRA!
     
    I can reproduce the same issue with a report. I don't understand why the datasource connection is not used in this case.

    Best regards,


    ------------------------------
    Patrick Neveu
    BSL Consulting
    IBM Champion
    ------------------------------


  • 6.  RE: Datasource connection is not used!

    Posted 2 days ago

    Hi,

    Just to let you know that this is seen as a defect: When a report is run based on Data module created from data server connection with multiple connections , connection selected in prompt is not used in report.

    Known Issue: DT447416

    Best regards,



    ------------------------------
    Patrick Neveu
    BSL Consulting
    IBM Champion
    ------------------------------

    Original Message


Related Content