BusinessObjects Board

multiple identical sql queries in report

building reports webintelligence
#1

I have 2 measures which, when I include them in a report, the measures are listed 4 times. For example, if the measure was called Number of Staff, it is listed in the Data tab on the Edit Report view as follows
Number of Staff(1)
Number of Staff(2)
Number of Staff(3)
Number of Staff(4)

When I check the sql of the query, it has generated 4 seperate sql queries.
Here’s the strange part. All 4 of the queries are identical apart from the order which the columns are selected or the joins are done.

Has anyone came across this? None of the other measures in the universe do this (that I have come across yet). so I don’t think it’s an overall setting within the universe.

dopple :uk: (BOB member since 2009-06-19)

#2

Sounds like a cartesion join in your universe

Mick

mikca :australia: (BOB member since 2005-12-16)

#3

And it looks like your Number of Staff is not a proper measure, meaning it is not defined with a SQL aggregate function such as SUM or COUNT in the SELECT portion of object properties in universe designer.

Note: I am not talking about: projection althought SQL aggregation and projection go hand in hand, see this post here please.

Andreas :de: (BOB member since 2002-06-20)