Cognos Analytics

Cognos Analytics

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


#Product
#Analytics
#CognosAnalytics
#Analyticstools
#TechXchange Partner
#TechXchange Session
#TechXchange Presenter
#AI
 View Only

  • 1.  Data Module Security Filter Issue

    Posted 03/17/20 04:33 PM

    I'm working with ICA 11.1.5 and a DB2 database building a Data Module. I've applied data security to one of my data source tables, and in the data server connection properties I've implemented the connection property "ibmcognos.typeinsqldisabled".

    Now if I create a new typed-in SQL table in my Data Module, I get an error message - 'DB2SOURCE' is configured to prevent type-in sql. This is a good thing – the property setting is working for any new SQL table I create.

    However, in my Data Module I have several typed-in SQL tables that I created before implementing the connection property setting and they're running on the same connection. And, they are drawing data from the same connection just fine. And, if I do an "Edit SQL table" on these existing SQL tables and validate I get the - 'DB2SOURCE' is configured to prevent type-in sql – error generated. But the SQL tables still work fine and retrieve data regardless of the validation errors.

    So, the big question – what the heck is going on? Why do new SQL tables error out while old SQL tables still retrieve data? I'm baffled… <â¿â> Help!



    ------------------------------
    Syd Shewchuk
    Trainer / Consultant
    Newberg, OR
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Data Module Security Filter Issue

    Posted 03/18/20 10:47 AM
    Edited by System Admin 01/20/23 04:36 PM
    Hi @Syd Shewchuk,

    If you refer to the documentation here, the expected behavior is "If you specify this property after an SQL-based table was created, the query execution is stopped."

    Since that is not the behavior you are seeing, I would recommend logging a support case for it and we can get it fixed. Our development team has also identified this and has logged it internally. Apologies for any inconvenience this may have caused.

    Best Regards,

    ------------------------------
    MOHAMMED OMAR KHAN
    Offering Manager
    IBM Cognos Analytics
    ------------------------------



  • 3.  RE: Data Module Security Filter Issue

    Posted 03/18/20 12:41 PM

    Thanks for the response MOHAMMED. I did see that explanation in the documentation earlier, and the key word there seems to be "after the SQL table is created". That would explain why my tables created "before" implementing the property are still supplying data and working well. However, the documentation doesn't provide an explanation for why both "before" and "after" SQL tables generate the same error on validation, even though the "before" SQL tables still deliver data. Maybe it's a bug – or as I call it, a "feature"... Thanks for responding.



    ------Original Message------

    Hi @Syd Shewchuk,

    If you refer to the documentation here, the expected behavior is "If you specify this property after an SQL-based table was created, the query execution is stopped."

    Since that is not the behavior you are seeing, I would recommend logging a support case for it and we can get it fixed. Our development team has also identified this and has logged it internally. Apologies for any inconvenience this may have caused.

    Best Regards,

    ------------------------------
    MOHAMMED OMAR KHAN
    Offering Manager
    IBM Cognos Analytics
    ------------------------------

    #CognosAnalyticswithWatson


  • 4.  RE: Data Module Security Filter Issue

    Posted 03/18/20 03:01 PM
    The document states:  "If you specify this property (ibmcognos.typeinsqldisabled) after an SQL-based table was created, the query execution is stopped."

    I interpret this to mean the query should not function in your case Syd.  We've reached out to development and will log a bug as appropriate. 

    ------------------------------
    ANDREW ALLEN
    ------------------------------

    Original Message


  • 5.  RE: Data Module Security Filter Issue

    Posted 03/19/20 01:36 PM
    Thanks for the response Andrew. In my case the property is working as intended 1) table created before setting property, query executed, 2) table created after setting property, query stopped.
    However, the problem lies in the Data Module design tool. In both cases the tables' Validation throws an error: "The expression is not valid. The data source connection 'DB2SOURCE' is configured to prevent type-in sql"
    So, for the SQL table created before implementing "ibmcognos.typeinsqldiabled", it works fine except when its validated.
    So if there is a bug, it must be in the validation process.
    -syd


    ------Original Message------

    The document states:  "If you specify this property (ibmcognos.typeinsqldisabled) after an SQL-based table was created, the query execution is stopped."

    I interpret this to mean the query should not function in your case Syd.  We've reached out to development and will log a bug as appropriate. 

    ------------------------------
    ANDREW ALLEN
    ------------------------------

    #CognosAnalyticswithWatson