Cognos Analytics

 View Only
  • 1.  Count Distinct Multiple Fields

    Posted Thu June 17, 2021 12:37 PM
    Hello,

    Does anyone have a way in Cognos Analytics to be able to select multiple 20+ field and simply apply count distinct? Today we are having to select field by field and it's very time consuming. We are building a bunch of reports in order to do some testing using MotioCI and have hundreds of dimensions to test and create reports.

    Thanks



    ------------------------------
    Gaston Pouliot
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Count Distinct Multiple Fields

    Posted Tue June 22, 2021 04:49 AM
    Hi Gaston,
    you need to specify the question. It does not make much sense what you want to achieve.

    ------------------------------
    Josef Minarik
    https://www.linkedin.com/in/josef-minarik/
    ------------------------------



  • 3.  RE: Count Distinct Multiple Fields

    Posted Tue June 29, 2021 09:23 AM
    You can CTRL + Click multiple data objects and set the aggregation.

    ------------------------------
    Zach Zeman
    ------------------------------



  • 4.  RE: Count Distinct Multiple Fields

    Posted Tue June 29, 2021 09:32 AM
    Tried that one also. But in the in the properties now I no longer see Detail Aggregation. I do not think in Cognos we have a way to select multiple fields and assign them the same detail aggregation values.

    ------------------------------
    Gaston Pouliot
    ------------------------------



  • 5.  RE: Count Distinct Multiple Fields

    Posted Tue June 29, 2021 09:41 AM
    Hi Gaston,
    When I select multiple data items in the query, I can set the Detail aggregation. It is not possible when selecting the items in the page design.

    ------------------------------
    Thomas van der Meer
    ------------------------------



  • 6.  RE: Count Distinct Multiple Fields

    Posted Tue June 29, 2021 09:54 AM
    Thomas this is what I've been looking for. This is amazing! Thank you so much!

    ------------------------------
    Gaston Pouliot
    ------------------------------



  • 7.  RE: Count Distinct Multiple Fields

    Posted Tue June 29, 2021 09:49 AM
    My mistake.....My solution was for working within the actual query and not when working on a page.

    ------------------------------
    Zach Zeman
    ------------------------------



  • 8.  RE: Count Distinct Multiple Fields

    Posted Tue June 29, 2021 01:07 PM
    Edited by System Fri January 20, 2023 04:41 PM
    this is really good

    ------------------------------
    sharry paul
    ------------------------------