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.