Display Parent details

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Manoj (Manoj_at_discussions.microsoft.com)
Date: 12/15/04 

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

Relevant Pages

  • Musketeer
    ... The role of the musketeer is to grow the Company's brand and maximise sales by ... Grows distribution by gaining new on-premise customers as per targets. ... Secures a proper implementation of the customers contracts. ...
    (soc.culture.hongkong)
  • Re: Whats the Verdict on Amazing Spider-Man
    ... happening just before the retcon. ... If sales stay roughly the same as they were on Amazing, ... Brand New Day is awesome. ... Thor has been great but Secret Invasion ...
    (rec.arts.comics.marvel.universe)
  • Re: A Call to Overthrow the Cult of Sharpness!
    ... He's just tired of reading about the lens QC issues his favorite brand ... Interesting that canon users are the ones talking about needing to try ... So this 'sales figure' herring isn't to try to make your brand better, ... To give your car sales figures validity, we would have to take a look at car sales in relation to "wealthy" purchasers. ...
    (rec.photo.digital.slr-systems)
  • Re: Whats the Verdict on Amazing Spider-Man
    ... happening just before the retcon. ... If sales stay roughly the same as they were on Amazing, ... Brand New Day is awesome. ... I keep hearing online about people dropping the title but its selling ...
    (rec.arts.comics.marvel.universe)
  • Re: Inconsistent query results
    ... If you executes your MDX query in MDX Sample Application, ... > 'select product.children on columns from sales' ... Default member is 'all member' for all dimensions. ...
    (microsoft.public.sqlserver.olap)