Stairway to MDX - STEP 6: Member “Family” Functions: .Parent and .Children

  • Bill Pearson

    Ten Centuries

    Points: 1349

    Comments posted to this topic are about the item Stairway to MDX - STEP 6: Member “Family” Functions: .Parent and .Children

  • darth_vodka

    Ten Centuries

    Points: 1379

    a very simple question that I'm sure I did before, but is eluding me...

    how do you get

    [Bikes] [Mountain NBikes]

    [Bikes] [Road Bikes]

    [Bikes] [Touring Bikes]

    onto the rows? i.e. A parent and its children on the rows

    ta

  • ldorian81

    SSCommitted

    Points: 1694

    Brilliant Stairways series,

    1 Note to make in the example code, when instructed to copy & paste out on each section of code where you have written [Calendar Year] on the Columns there is a double space between the two words which will error the query.

    Query (2, 14) The MEMBERS function expects a hierarchy expression for the argument. A member expression was used.

    Just for info as sometimes not easily spotted. 😀

    edit:

    Also on [Product Line] & [Customer Geography]

    [Code="sql"]

    SELECT

    NON EMPTY {[Date].[Calendar].[Calendar Year].MEMBERS} ON AXIS(0),

    NON EMPTY {

    [Product].[Product Model Lines].[Product Line].[Accessory].CHILDREN}

    ON AXIS(1)

    FROM

    [Adventure Works]

    WHERE

    ([Measures].[Internet Order Quantity],

    [Customer].[Customer Geography].[Country].[United Kingdom])

    [/code]

    Regards
    ld

    Stoke-on-Trent
    United Kingdom

    If at first you don't succeed, go to the pub and drink away your current thought plan.

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

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