Cognos Analytics with Watson

 View Only
  • 1.  records not matching

    Posted Tue June 21, 2022 08:35 AM
    Hi All,
    I am extracting report based on sql from snowflake database.
    I got 166 records when checked in snowflake but in report I got 155 records,
    Does cognos removes duplicates.

    ------------------------------
    Priyanka Joshi
    ------------------------------


  • 2.  RE: records not matching

    Posted Tue June 21, 2022 10:04 AM
    Yes, Cognos reports by default do auto-summarization.
    You can change it by going to the properties tab of a query
    Kind regards,
    Henk





  • 3.  RE: records not matching

    Posted Tue July 05, 2022 08:15 PM

    Suggest you refer to the documentation regarding automatic group.

    https://www.ibm.com/docs/en/cognos-analytics/11.0.0?topic=relationally-set-auto-group-summarize-property

    Assuming of cause that your BI-query doesn't include other filter/join operations which would eliminate rows you are expecting to see.



    ------------------------------
    NIGEL CAMPBELL
    ------------------------------