levels

Returns the level in "hierarchy" whose distance from the root is specified by "index".

Syntax

levels ( hierarchy , index )

levels ( [great_outdoors_company].[Products].[Products] , 2 )

Result

Returns the members two levels from the root Products hierarchy.

Result data

Cooking Gear
Sleeping Bags
Packs
Tents
...
Irons
Putters
Woods
Golf Accessories

levels ( [great_outdoors_company].[Products].[Products] , 1 )

Result

Returns the members one level from the root Products hierarchy.

Result data

Camping Equipment
Mountaineering Equipment
Personal Accessories
Outdoor Protection
Golf Equipment