Cognos Analytics

Cognos Analytics

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

 View Only
  • 1.  Warning: MSR-VRF-2193

    Posted Tue August 31, 2021 06:27 PM
    In my 11.2 Data Modules I am getting this warning.  Want to get rid of it.  "Column "Created Date" is not in a column dependency group.  If it is used in a query, no column dependency will be applied for the query.  Can I get rid of warnings?  They clutter up my items.  I only want Errors, not Warnings.

    ------------------------------
    Razorbx13
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Warning: MSR-VRF-2193

    Posted Tue August 31, 2021 09:25 PM

    Hello,
    There are 2 solutions to this problem, depending on the need to define this information.
    See: Column dependencies - IBM Documentation
    1 - remove the column dependency information for the table. This is fine as long as:
        a) all the relationships to this table use the same items from this table
        b) the table does not contain any items with usage=measure
        in essence when there is no need to avoid double counting when this table is involved in a query
    2 - update the column dependency information
       a) select the table that the column belongs to
       b) right click to get to the context menu and select: "Specify column dependencies"
       c) select the column "Created Date" from the metadata tree and drag it to the column dependency panel and add it to the appropriate group or create a new group.

    Hope this helps.
    // Henk



    ------------------------------
    Kind regards,
    HENK CAZEMIER
    ------------------------------