Export (0) Print
Expand All

DrilldownMemberBottom

SQL Server 2000

DrilldownMemberBottom

Drills down the members in a specified set that are present in a second specified set, limiting the result set to a specified number of members. Alternatively, it also drills down on a set of tuples.

Syntax

DrilldownMemberBottom(«Set1», «Set2», «Count»[, [«Numeric Expression»][, RECURSIVE]])

Remarks

«Set1» can contain tuples instead of members. Tuple drilldown is an extension of OLE DB, and it returns a set of tuples instead of members.

This function is similar to the DrilldownMember function, but instead of including all children of a member, only the bottom «Count» of children is returned, based on «Numeric Expression».

Example

This example

DrilldownMemberBottom({USA, Canada, Mexico}, {USA, Washington, Mexico}, 2, [Unit Sales])

returns the set

{USA, <bottom two states in USA>, Canada, Mexico, <bottom two states in Mexico>}

and this example

DrilldownMemberBottom({USA, Washington, Canada, Mexico}, {USA, Washington, Mexico}, 2, [Unit Sales], 
RECURSIVE)

returns the set

{USA, Washington, <bottom two cities in WA>, Canada, Mexico, <bottom two states in Mexico>}.
Tuple drilldown

This example

DrilldownMemberBottom({(USA, [Unit Sales]), (Washington, [Unit Sales]), 
(Canada, [Unit Sales]), (Mexico, [Unit Sales])},
{USA, Washington},2,[Store Sales],RECURSIVE)

returns the set

{(USA, [Unit Sales]), (Washington, [Unit Sales]), (<bottom two cities in WA>, 
[Unit Sales]), (Canada, [Unit Sales]), (Mexico, [Unit Sales]}.

See Also

DrilldownMember

Show:
© 2014 Microsoft