Universe

building semantic layer
1

How Do i make universe to retrieve duplicate records?

ssk_BO (BOB member since 2010-04-28)

2

When you go to Universe parameter Option and Make the ‘DISTINCT VALUES’ to ‘NO’ or ‘NULL’.
It Does not work .
could any one suggest me how to go about?

ssk_BO (BOB member since 2010-04-28)

3

Universe picks all the values: Just see if at the report level whether you have checked the option"Avoid duplicate row aggregation".

Kind Regards,

shiva.tomar (BOB member since 2007-10-05)

4

Thanks Shiva ,i looking at universe level.

ssk_BO (BOB member since 2010-04-28)

5

I am afraid but in universe there is no such option, if can do this at report level only.

gaurav S (BOB member since 2010-04-22)

6

To clarify: There is no option in the universe to eliminate duplicate rows. Since there is no option, there is nothing to change the behavior that you’re seeing. There are several things that might be affecting the rows that you see, but all of the rows are retrieved from the database.

Dave Rathbun :us: (BOB member since 2002-06-06)

7

So does this mean that if I run an integrity check and I get an error/warning saying:

i can ignore the error if UAT does not complain about the data output in their report?

shawzozo :zimbabwe: (BOB member since 2006-08-08)

8

this universe integrity check means that you have defined some measures as count(x) rather count(distinct x) - syntax depends on your underlying database

jemstar :ireland: (BOB member since 2006-03-30)

9

The integrity check is not an error list for you to work through. Certain things in the check are flagged up that you can ignore - if you’ve aliased a table and parked it on one side, that will be flagged up as a table on its own.
If you’ve created a security table with a self-restricting join, it will be flagged up as an isolated join.
If you’ve added an object for today using sysdate, getdate() or some other system function, it will flag up as an invalid definition.

Just some examples of integrity check feedback that you don’t need to worry about. As jemstar says, it depends on your data model in this instance.

10

To avoid duplicate values it is possible in universe level also by selecting the table and table values and clicking the distinct values

surya_sudheer :india: (BOB member since 2006-11-01)

11

Is that a question or a statement?

If it’s a question, the answer is “no” it is not possible to do this.

Dave Rathbun :us: (BOB member since 2002-06-06)