Skip to Content
avatar image
Former Member

Smart Measure

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Jun 18, 2010 at 03:27 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    May 14, 2015 at 05:46 AM
    Add comment
    10|10000 characters needed characters exceeded