BusinessObjects Board

what is the difference in measure and making it in report

building reports webintelligence
#1

Hello ALL,
I have a question, I have number of Customer as measure in the univesre, and i have Customer object in the universe.

Usally, we drag the customer objects and make a count in the reporting side rather than ussing the count(customer) as measure in the universe.

Can you guys tell me what is the difference between using the measure from universe and making as report level.

Thanks

Pooja

ktm :us: (BOB member since 2008-11-12)

#2

Performance and the number of rows returned would be a good starting point.

dessa :madagascar: (BOB member since 2004-01-29)

#3

Performance Yes. When you perform a count(customer) in the SELECT declaration of the object then the processing is pushed to the database and the count is performed at the database level and not report level.

tmir :us: (BOB member since 2010-06-29)

#4

Thanks for your reply,I just want to know Is there be any data difference in counting in general scenario ?

I understand that i need to keep count(Table.column) in the select statement.But In the object properties

" Choose how this measure will be projected when aggregated:"

What should i need to choose?What exactly this mean?

Thanks
Pooja

ktm :us: (BOB member since 2008-11-12)

#5

Please, see here for an extensive explanation about aggregation versus projection of a measure.

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