What is Default Aggregation in Web Intelligence ?

[Former Member]

In WebI, when I click on the Sigma (Sum) icon, the last option is "Default aggregation". What are the uses of this function?Also, what is the difference between Sum and Default Aggregation?

[Former Member]

Default and Database Deligate settings will give the Weighted Average.

Regards,

Pullareddy Nemali

[arijit_das]

if you are using universe, the the default aggregation is the projection function defined for the measure object in the universe. Otherwise it is database delegated, i.e., the aggregation defined in bex.

[Former Member]

I am using BEx.

My problem is col1 is showing 85.5 in BEx.

In Webi, when i select "Sum" it is showing 13.5, but when i select "Default Aggregation" it is showing 85.5

When is checked "Duplicate Row Aggregation" there are only 8 records in col1 which sum upto 13.5. I dont know how 85.5 is arrived while using "Default Aggregation" ?

[arijit_das]

how is the aggregation happenning in bex ?

[Former Member]

Aggregation in BEx is "Delegated".

[arijit_das]

The default aggregation will happen exactly same way as it is happening in BEx.

You can compare the report data with BEx query result in rsrt transaction.

[Former Member]

What is "Delegated " in BEx. I am new to BEx

Comparing with RSRT, the BEx result and "Default Aggregation" result are matching