June 14, 2011 at 10:05 am
Comments posted to this topic are about the item Stairway to MDX - STEP 6: Member “Family” Functions: .Parent and .Children
July 27, 2011 at 5:48 am
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
February 20, 2013 at 3:16 am
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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply