Page 125 - DCAP606_BUSINESS_INTELLIGENCE

Business Intelligence

Notes Min

If a measure’s Aggregate Function property value is Min, the measure value for a cube cell is
calculated by taking the lowest value in the measure’s source column from only the rows for the
combination of members that defines the cell and the descendants of those members.
The following examples return values that represent the lowest Sales price:
A query on the Sales measure for customer A, retail store A, and product A returns 250.

A query on the Sales measures for customer A, retail store A, and product category AB
returns 100.
A query on the Sales measure places each retail store on the x-axis, nests products under
product categories on the y-axis, and slices by All Customers. It returns the result as
shown in Table 8.7.

Table 8.7: Result of Query

All Retail Stores A B C D
All Products 90 100 90 110 350
AB 90 100 90 110 350
A 250 250 290 350
B 90 100 90 110
CD 510 700 510 550
C 510 510 550
D 700 700 750
Source: http://msdn.microsoft.com/en-us/library/ms365396.aspx

Max

If a measure’s Aggregate Function property value is Max, the measure value for a cube cell is
calculated by taking the highest value in the measure’s source column from only the rows for
the combination of members that defines the cell and the descendants of those members.

Table 8.8: Result of Query

All Retail Stores A B C D
All Products 750 700 290 510 750
AB 350 300 290 110 350
A 350 300 290 350
B 110 100 90 110
CD 750 700 510 750
C 550 510 550
D 750 700 750
Source: http://msdn.microsoft.com/en-us/library/ms365396.aspx
The examples return values that represent the highest Sales price.

A query on the Sales measure for customer A, retail store A, and product A returns 300.
A query on the Sales measures for customer A, retail store A, and product category AB
returns 300.

120 LOVELY PROFESSIONAL UNIVERSITY