Cognos Analytics

 View Only
  • 1.  duplicates in value prompt

    Posted Mon June 13, 2022 11:09 AM
    I have created one value prompt .when report ran its getting duplicate rows because filed is having duplicates
    how to remove those duplicates so that I can get unique selections in selection box.

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

    #CognosAnalyticswithWatson


  • 2.  RE: duplicates in value prompt

    Posted Tue June 14, 2022 08:40 AM
    Hi Priyanka,

    It sounds like the query you are using to populate the value prompt has additional detail that causes the list of value to repeat. (You would see January 31 times if you had a date query item in the same query for example).  The easiest fix is to create a new query to populate the prompt and only bring in the field you need without additional details.

    HTH,
    Todd

    ------------------------------
    Todd Schuman
    ------------------------------



  • 3.  RE: duplicates in value prompt

    Posted Tue June 14, 2022 08:49 AM
    Yes I have used different query only.that field on which i am using prompt contains dupliacates.so how to resolve that.





  • 4.  RE: duplicates in value prompt

    Posted Tue June 14, 2022 08:58 AM
    In a perfect world, you would have a clean dimension table where each value is distinct.  Since you don't have that, try to populate another query from the query you have now to get just the distinct list.

    Distinct Query


    ------------------------------
    Todd Schuman
    ------------------------------



  • 5.  RE: duplicates in value prompt

    IBM Champion
    Posted Tue June 14, 2022 08:58 AM
    Hi Priyanka,

    Is is a prompt from a dimension or from a fact? From instance, is it something with a date/time, a product, a country or is it a quantity or a revenue?

    Best regards,

    ------------------------------
    Patrick Neveu
    Positive Thinking Company
    ------------------------------



  • 6.  RE: duplicates in value prompt

    Posted Tue June 14, 2022 09:06 AM
    Hi Patrik,
    Its status column saying status of transactions.


    Thanks ,
    Priyanka