Making all the queries on universe pull distinct rows

building semantic layer
1

Hi All,
Is it possible to modify parameters in universe such that all the queries build on the universe will pull distinct rows. I know we can avoid pulling duplicate rows in report but is it possible to achieve this in universe.
I would really appreciate any help with this.

Thanks

helloraveesh (BOB member since 2006-09-11)

2

Not that I’m aware of. I’ve never heard of anyone requesting this type of parameter.

MichaelWelter :vatican_city: (BOB member since 2002-08-08)

3

@helloraveesh:
Check this topic here

https://bobj-board.org/t/141955/15

As far as I know, DISTINCT is used for LOV’s on Universe.

BO_Chief :us: (BOB member since 2004-06-06)

4

WHat about adding the word “DISTINCT” to the BEGIN_SQL of the Universe Parameters?

I don’t recall if it executes this parameter before the query, or at the start of the query. My mind wants to think there was a method of Forcing hints in (and DISTINCT would be at the same place in the code), so perhaps a search for that as well…

digpen :us: (BOB member since 2002-08-15)

5

That would put the DISTINCT before the SELECT, so that wouldn’t execute at all. :cry:

MichaelWelter :vatican_city: (BOB member since 2002-08-08)