Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Stairway to MDX - STEP 6: Member “Family” Functions: .Parent and .Children Expand / Collapse
Author
Message
Posted Tuesday, June 14, 2011 10:05 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, January 14, 2014 8:22 PM
Points: 2, Visits: 63
Comments posted to this topic are about the item Stairway to MDX - STEP 6: Member “Family” Functions: .Parent and .Children
Post #1125147
Posted Wednesday, July 27, 2011 5:48 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 6:49 AM
Points: 59, Visits: 380
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
Post #1149021
Posted Wednesday, February 20, 2013 3:16 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Monday, July 14, 2014 4:37 AM
Points: 275, Visits: 229
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]

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])



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.
Post #1422003
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse