Skip to Content
0
Former Member
Mar 09, 2011 at 05:12 PM

Repeated LOVs

16 Views

Hello Everyone,

We are using BO on top of the BEx Query. I came across an issue and thought someone might know the right solution. We have created BEx query and then designed the universe on top of that BEx query. When we go to WEBI and created a report, in the filter area some of the objects shows repeated values. For example, if I select Calender Month and then select the LOVs, the list would appear something like this

JAN

JAN

FEB

FEB

FEB

instead I would like this list to appear like as below

JAN

FEB

The only solution I was told is to convert that object to Navigational Attribute and it will work and it does to be honest but consider we have lot of these kind of requirement and my issue would be that we'll end up converting all the Display Attributes to Navigational Attributes because of this issue.

I am sure there must be an easy way somewhere in the Universe Designer or at the Report Designer to handle this kind of problem.

Thanks.