hierarchy
Returns the hierarchy that contains "level", "member", or "set_expression".
Syntax
hierarchy ( level|member|set_expression )Example 1
hierarchy ( [Cooking Gear] )Result
Returns every member in the hierarchy that contains Cooking Gear.
Result data
Products
Camping Equipment
Cooking Gear
TrailChef Water Bag
TrailChef Canteen
...
Mountain Man Extreme
Mountain Man DeluxeExample 2
hierarchy ( [great_outdoors_company].[Products].[Products].[Product
line] )Result
Returns every member in the hierarchy that contains the Product line.
Result data
Products
Camping Equipment
Cooking Gear
TrailChef Water Bag
TrailChef Canteen
...
Mountain Man Extreme
Mountain Man Deluxe