Cognos Analytics

 View Only

  • 1.  Conditional Tagging for Filtering

    Posted Tue March 26, 2019 02:25 PM
    I'm trying to filter out rows from a list report with certain conditions. My report has duplicated IDs and I'd like to filter the duplicate IDs that have NULL values in one column. Could you please tell me how to elaborate the proper formula for Cognos 11?

    Thanks
    Anmedia

    ------------------------------
    AnMedia
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Conditional Tagging for Filtering

    Posted Wed March 27, 2019 11:08 AM

    Hello Ann,

    Are you ok with filtering out all Null values for all Ids? or you only want to filter out the Null Values where you have a duplicate ID?



    ------------------------------
    DENNY NAREZNY
    ------------------------------

    Original Message


  • 3.  RE: Conditional Tagging for Filtering

    Posted Wed March 27, 2019 03:45 PM
    Hello Denny, second option: just filter the null ones that have ID duplicated. My thought at first was to sort by ID and the field with/without nulls and then to number duplicated IDs, and then to filter, let's say "all the numbers 2". but how to achieve this?

    ------------------------------
    Ann Media
    ------------------------------

    Original Message


  • 4.  RE: Conditional Tagging for Filtering

    Posted Wed March 27, 2019 11:55 PM
    The attached PDF contains a description of how this might be done.

    I've also attached the data file that I was using for this.

    This was done using Data Modules in Cognos Analytics, but similar techniques apply to Framework Manager defined models as well.



    ------------------------------
    HENK CAZEMIER
    ------------------------------

    Attachment(s)

    pdf
    HC308 Filtering Description.pdf   95 KB 1 version
    xlsx
    SampleData01.xlsx   8 KB 1 version
    Original Message


  • 5.  RE: Conditional Tagging for Filtering

    Posted Thu March 28, 2019 05:48 PM
    Many thanks Henk for your contribution. But unfortunately it's not working for me, and I think I know the reason. I'm working with an already pre-filtered data,  coming from a lot of sources related. For example, where I can see 2 rows, the count method returns sometimes 10, sometimes 5, sometimes 18 rows. So, I think if my report were an Excel I should simply copy and paste "values only" into another worksheet, and then, I'd apply your idea. But I don't know if such a solution is possible in Cognos.

    ------------------------------
    Ann Media
    ------------------------------

    Original Message


  • 6.  RE: Conditional Tagging for Filtering

    Posted Thu March 28, 2019 08:48 PM

    Hi Ann,
    I'm pretty sure we can do this with Cognos.  To give you an answer in the right direction, could you pls tell me:
    Which product are you using for modeling, Web-based modeling with Data Modules or Desk-top modeling with Framework Manager ? Or are you trying to do this in Reporting ? Which version of Cognos are you using ?
    From what it sounds like, you're using aggregated data from multiple tables and/or query Subjects.
    In each of the modeling tools and in Reporting it is possible to create a view on a summarized set of data. Using that technique, that will do the counting not on the underlying data, but on the summarized results.
    // Henk



    ------------------------------
    HENK CAZEMIER
    ------------------------------

    Original Message