Results 1 to 5 of 5
  1. #1
    Join Date
    Feb 2004
    Location
    Poland
    Posts
    96

    Unanswered: MDX - with member

    for example

    with member [Measures].[Accumulated Sales] as 'Sum(YTD(),[Measures].[Store Sales])'
    select
    {[Measures].[Store Sales],[Measures].[Accumulated Sales]} on columns,
    {Descendants([Time].[1997],[Time].[Month])} on rows
    from Sales



    I need more then 1 member how to do in


    Thanks

  2. #2
    Join Date
    Apr 2004
    Posts
    11

    ?

    Hi,

    Do you mean you want another calculated member?

    Ta
    Paul

  3. #3
    Join Date
    Feb 2004
    Location
    Poland
    Posts
    96
    EXACTLY

    THANKS

  4. #4
    Join Date
    Apr 2004
    Posts
    11
    with member [Measures].[Gross Sales] as 'Sum(YTD(),[Measures].[Unit Sales])'
    member [Measures].[Accumulated Sales] as 'Sum(YTD(),[Measures].[Store Sales])'
    select
    {[Measures].[Store Sales],[Measures].[Gross Sales],[Measures].[Accumulated Sales]} on columns,
    {Descendants([Time].[1997],[Time].[Month])} on rows
    from Sales

    Ta
    Paul

  5. #5
    Join Date
    Feb 2004
    Location
    Poland
    Posts
    96
    BIG
    thanks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •