Display Parent details
From: Manoj (Manoj_at_discussions.microsoft.com)
Date: 12/15/04
- Next message: Jéjé: "Analysis manager strange issue with calculated members..."
- Previous message: franciscoalvarado: "MDX Query with Members and Member Properties"
- Next in thread: Deepak Puri: "Re: Display Parent details"
- Reply: Deepak Puri: "Re: Display Parent details"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 15 Dec 2004 06:49:05 -0800
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
- Next message: Jéjé: "Analysis manager strange issue with calculated members..."
- Previous message: franciscoalvarado: "MDX Query with Members and Member Properties"
- Next in thread: Deepak Puri: "Re: Display Parent details"
- Reply: Deepak Puri: "Re: Display Parent details"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|