Database Reference
In-Depth Information
FROM [Sample.Basic];
Axis-1
+-------------------
(Year)
(Qtr1)
(Jan)
(Feb)
(Mar)
(Qtr2)
(Apr)
(May)
(Jun)
(Qtr3)
(Jul)
(Aug)
(Sep)
(Qtr4)
(Oct)
(Nov)
(Dec)
(Qtr1)
(Qtr2)
(Qtr3)
(Qtr4)
SELECT {} ON AXIS(0),
Distinct({[Year].Members, [Year].Children}) ON AXIS(1)
FROM [Sample.Basic];
OR
SELECT {} ON AXIS(0),
Union({[Year].Members}, {[Year].Children}) ON AXIS(1)
FROM [Sample.Basic];
Axis-1
+-------------------
(Year)
(Qtr1)
(Jan)
(Feb)
(Mar)
(Qtr2)
(Apr)
(May)
(Jun)
(Qtr3)
(Jul)
(Aug)
(Sep)
(Qtr4)
(Oct)
(Nov)
(Dec)
Search WWH ::




Custom Search