Post reply

mdx question?

  • September 29, 2004 at 12:11 am

    #112444

    I have a quick mdx question?

    with Member Measures.[Profit] as '[Measures].[Value] - [Measures].[Cogs]'

    select {[Measures].[Value],[Measures].[Cogs],Measures.[Profit]} on columns, {Descendants([Date].[All Date].[2001])} ON Rows From Sales

    I need to select one more Dimension  in the rows

    How can I write the mdx query?

     Can anyone help Please ?

  • September 29, 2004 at 6:13 pm

    #524855

    I would normally crossjoin the second members inside or outside of the time mebrs that you have (say you wanted sales person, you could see each salesperson and the children of 2001 under them, or the children of 2001 with all salespeople nested under them). 

    with Member Measures.[Profit] as '[Measures].[Value] - [Measures].[Cogs]'

    select {[Measures].[Value],[Measures].[Cogs],Measures.[Profit]} on columns,

     {Descendants([Date].[All Date].[2001]) * {[Salesperson].members}} ON Rows From Sales

    Alternate syntax (to *)  is using full function name i.e.

    crossjoin(Descendants([Date].[All Date].[2001]), [Salesperson].members) ON Rows From Sales

    Steve.

  • September 29, 2004 at 10:27 pm

    #524858

    Hi Steve

    Excellent Advice

    Thanks for your reply.Thank you for your time.

    Regards & Thanks

    Vijay

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply