Universe Measures - Using SUM

[Former Member]

Hi,

I am trying to make Sum calculation for a dimension variable.

I am little confused with using 'Sum' option. What is the difference for the following two.

1. Giving SUM(Variable) in Select part of Definition Tab.

2. Changing variable to Measure and selecting 'Sum' Option from the drop down in Properties Tab (Choose how this measure will be projected when aggregated)

Please clarify.

Thanks.

Nanda

[Former Member · Accepted solution]

Hi Nanda,

Please go through the below link for more information:

http://www.dagira.com/2009/07/06/sql-aggregate-versus-universe-projection/

Hope it helps.

Thanks

SandS

[Former Member · Accepted solution]

Hi,

Thanks. This is self explanatory

BR, Nanda

[Former Member]

The basic difference is that setting the measure to sum() will carry out the processing at the database level and create a group by clause in the query.

Failing to do so will result in a much larger, unaggregated set of data at the report level, which will take up more resource.

Bottom line - if it's a measure, use an aggregate function (max, min, sum, count) - if you're not using an aggregate function, you should question whether it is a measure or not.