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
------------------------------
Original Message:
Sent: Tue June 14, 2022 08:48 AM
From: Priyanka Joshi
Subject: duplicates in value prompt
Yes I have used different query only.that field on which i am using prompt contains dupliacates.so how to resolve that.
Original Message:
Sent: 6/14/2022 8:40:00 AM
From: Todd Schuman
Subject: RE: duplicates in value prompt
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
Original Message:
Sent: Mon June 13, 2022 11:08 AM
From: Priyanka Joshi
Subject: duplicates in value prompt
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