A couple of months ago I wrote about how you can use the MDX
functions Ancestors() and Ascendants to retrieve the full lineage of
members. (See: "MDX: retrieving the entire hierarchy path with
Ancestors()".)
As you might recall, the immediate reason to write about those
functions was to find a pure MDX solution to implement the "Show
Parents" / "Hide Parents" functionality offered by OLAP cube
browsers. To recap, developers of MDX-based pivot tables face a
challenge when rendering the result of a query like this:
[Read more]
SELECT CrossJoin(
[Product].[Product].Members,
…