Smart Measure

[Former Member]

Hi,

I was reading the Help Document of Web Intelligence for smart measure but still not very clear about how it is implemented.

My understanding is that whenever for a measure in the Universe aggregation function is selected as Database Delegated then that measure is a smart measure. Is this correct or there are other possibilites.

Thanks,

CD

[Former Member]

Hi,

you can go through this links below for better understanding the Smart Measure.

http://www.dagira.com/2008/11/10/designer-xi-3-new-feature-database-delegated-measures/

and http://help.sap.com/businessobject/product_guides/sbo41/en/sbo41sp3_ffc_user_guide_en.pdf

Section 5 in Second link.

[former_member793810]

Hi,

Smart measures behave differently from classic measures, which support a basic set of aggregation functions (Max, Min, Count, Sum, Average) that Web Intelligence can calculate in all contexts without help from the database.

For example, if you build a query containing the [Country] and [Region] dimensions and the [Revenue] measure (which calculates the sum of the revenue), Web Intelligence initially displays Country, Region and Revenue in a block. If you then remove Region from the block, Web Intelligence is still able to calculate the total revenue for each country by summing the revenues for all the regions in the country.

Regards,

Bashir Awan