|
|
|
Forum Newbie
      
Group: General Forum Members
Last Login: Sunday, May 19, 2013 2:04 PM
Points: 1,
Visits: 44
|
|
|
|
|
|
Valued Member
      
Group: General Forum Members
Last Login: 2 days ago @ 6:15 AM
Points: 59,
Visits: 334
|
|
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
|
|
|
|
|
SSC Veteran
      
Group: General Forum Members
Last Login: Tuesday, April 23, 2013 1:37 AM
Points: 275,
Visits: 222
|
|
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.
|
|
|
|