How to remove duplicate items in select & search prompt DMR model

[Chandrasekar]

Hi Gurus,

I have Price volume report, I need to select price volume items via select & search prompt(multiselect). Prompt use value & Query value is member set. Cognos 10.2.1 version DMR model.

The scenario is when i search any keywords its specify duplicate items. That means it provides repeated items. How to solve this?

Thanks & Regards,
Chandrasekar.

[Chandrasekar]

Here the problem is members have same child names. For example,

              Unit1
                  Gross Revenue V1
                  Gross Revenue V2
                Unit2
                   Gross Revenue V1
                    Gross Revenue V2
                 Unit 3
                       Impact
                                  Gross Revenue V1
                                   Gross Revenue V2
                        Impact %
                                   Gross Revenue V1
                                    Gross Revenue V2

I choose 2 waays to handle this.
1. If i fix Member property([PV_CV_Item - Name]) as Prompt use value,  Select & Searchprompt will display for Gross Revenue V1 in 4 places. But we need once in a prompt selection(Why it comes means it have 4 times in different levels )

2. If i fix Member set([PV_CV_Item]) as Prompt use value, Select & search prompt will display one time, But result will be come 4 times. That means 4 repeated columns displayed.

Here dimensional functions not worked. Because  user need to enter string for search.

And my question is wrong. Its not duplicate items. It is unique values. How to concadinate this level childrens?

Please help to provide the solution.

Thanks & Regards,
Chandrasekar.