How do I turn off the 'select distinct' feature for an object in the universe? I have tried changing the value for DISTINCT_VALUES to no value. Didn't work. I have tried removing the parameter altogether from the parameter list (of dynamic sql generation parameters). Even by removing it, when I look at the sql to be generated for an object in the object pane, I see that SELECT_DISTINCT persists. It appears that I can only choose DISTINCT or GROUPBY as valid options. Anyone aware of how to turn off this feature??!!!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Turn off SELECT DISTINCT in BOE XI Universe
- Thread starter lpjwadsw
- Start date
Similar threads
- Locked
- Question