Hello,

I am writing a MDX Query which will show the Sales Information of Product
dimension. I am passing the Brand Name to the query and I expect to get the
Sales for Brand Name, Product Subcategory, Product Category, Product
Department and Product Family for the selected Brand Name for the customers
in Canada..

Below is my MDX Query:

Select
{[Measures].[Unit Sales]} On Columns,
NonEmptyCrossJoin({[Customers].[Canada].Children, Descendants([Product].[All
Products].[Drink].[Alcoholic Beverages].[Beer and Wine].[Beer].[Good], 5,
Self_And_Before)) On Rows
From
Sales

Please help me in resolving this.

Thanks in advance.

Manoj

Are you looking for hierarchized details like this?

{[Measures].[Unit Sales]} On Columns,
NON EMPTY
Hierarchize(Except(Generate(Filter(
[Product].[Brand Name].Members,
[Product].CurrentMember.Name = "Good"),
Ascendants([Product].CurrentMember)),
{[Product].[All Products]})) On Rows
From Sales
Where ([Customers].[All Customers].[USA].[OR])

- Deepak

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!