[Product].[All Products].Children [Time].[1997].Children [Time].[1997].FirstChild [Time].[1997].LastChild [Product].[All Products].[Drink].Parent [Product].[All Products].[Food].Parent [Time].[1997].[Q1].[1].Parent [Product].[All Products].LastChild.Children [Product].[All Products].LastChild.Parent [Product].[All Products].Children.Parent (Doesn't work - see text) (Product.CurrentMember, Measures.[Unit Sales]) / (Product.CurrentMember.Parent, Measures.[Unit Sales]) * 100 (Product.CurrentMember, Measures.[Unit Sales]) / (Product.[All Products], Measures.[Unit Sales]) * 100 SELECT { [Time].[1997] } ON COLUMNS , { [Product].[All Products].Children} ON ROWS FROM [Sales_MDX1] WHERE ( [Measures].[Product Total Percentage] ) (This will only work if you've created the calculated measure Product Total Percentage) Descendants( [Time].[1997],[Quarter]) Descendants( [Time].[1998],[Month]) Descendants( [Time].[1998].[Q2],[Month]) Descendants( [Time].[1998].[Q2],1) Descendants( [Time].[1998],2) Descendants( [Time].[1998].[Q2]) Descendants( [Time].[1997]) SELECT {Descendants( [Time].[1997])} ON COLUMNS , {[Product].Children } ON ROWS FROM [Sales_MDX1] WHERE ( [Measures].[Product Total Percentage] ) (This will only work if you've created the calculated measure Product Total Percentage) SELECT {Descendants( [Time].[1997])} ON COLUMNS , {[Product].[Product Family].[Food].[Breakfast Foods].[Breakfast Foods].[Cereal].Children } ON ROWS FROM [Sales_MDX1] WHERE ( [Measures].[Product Total Percentage] ) (This will only work if you've created the calculated measure Product Total Percentage - see text) Descendants([Time].[1997].[Q1].[1]) SELECT { [Time].[1997] } ON COLUMNS , { Descendants([Product].[All Products],3)} ON ROWS FROM [Sales_MDX1] WHERE ( [Measures].[Product Total Percentage] ) (This will only work if you've created the calculated measure Product Total Percentage - see text) Ancestor( [Product].[All Products].[Food].[Baked Goods].[Bread].[Bagels], [Product Department]) Ancestor( [Product].[All Products].[Food].[Baked Goods].[Bread].[Bagels], 2) Ancestor( [Product].[All Products].[Food].[Baked Goods].[Bread].[Bagels], 3) Ancestor([Product].[All Products].[Food].[Baked Goods].[Bread].[Bagels], [Product Family]) [Product].[All Products].[Food].[Baked Goods].[Bread].[Bagels].Siblings [Product].[All Products].[Food].[Baked Goods].[Bread].[Bagels].FirstSibling [Product].[All Products].[Food].[Baked Goods].[Bread].[Bagels].LastSibling Cousin([Time].[1998].[Q1].[1], [Time].[1998].[Q2]) Cousin([Time].[1998].[Q4], [1997]) SELECT {[Time].[1997] } ON COLUMNS, Descendants( [Product].[Bread],[Product Subcategory]) ON ROWS FROM [Sales_MDX1] WHERE ( [Measures].[Unit Sales] ) SELECT {[Time].[1997] } ON COLUMNS, Descendants( [Product].[Bread]) ON ROWS FROM [Sales_MDX1] WHERE ( [Measures].[Unit Sales] ) SELECT { Cousin([Time].[1],[Q2]) } ON COLUMNS , { [Product].[All Products] } ON ROWS FROM [Sales_MDX1] SELECT { Descendants([Time].[1998].[Q1].[1],[Month]) } ON COLUMNS , { [Customers].[All Customers] } ON ROWS FROM [Sales_MDX1] WHERE ( [Measures].[Unit Sales] ) SELECT { [Product].[All Products] } ON COLUMNS , {[Time].[1997].[Q1].Parent } ON ROWS FROM [Sales_MDX1] SELECT { [Time].[1997] } ON COLUMNS , { Descendants(Product,[Product Category]) } ON ROWS FROM [Sales_MDX1] WHERE ( [Measures].[Product Percentage] ) (This will only work if you've created the calculated measure Product Percentage) SELECT { Descendants([Time].[1997],Month) } ON COLUMNS , { [Customers].[All Customers] } ON ROWS FROM [Sales_MDX1] WHERE ( [Measures].[Unit Sales] ) SELECT { [Time].[1997] } ON COLUMNS , { Descendants(Product,[Product Category]) } ON ROWS FROM [Sales_MDX1] WHERE ( [Measures].[Product Total Percentage] ) (This will only work if you've created the calculated measure Product Total Percentage) SELECT { Descendants( [Time])} ON COLUMNS , { DESCENDANTS( [Product].[All Products], [Product].[Product Department] ) } ON ROWS FROM [Sales_MDX1] WHERE ( [Measures].[Product Total Percentage] ) (This will only work if you've created the calculated measure Product Total Percentage)