Database Reference
In-Depth Information
(Mar)
(Qtr2)
(Apr)
(May)
(Jun)
(Qtr3)
(Jul)
(Aug)
(Sep)
(Qtr4)
(Oct)
(Nov)
(Dec)
6.10.1.2 Querying for Children Members
many functions have the option of being writ-
ten in traditional format, such as Children([time]) or a type of mDx shorthand [time].
children.
SELECT {} ON AXIS(0),
{[Year].[Qtr1].Children} ON AXIS(1)
FROM [Sample.Basic];
Axis-1
+-------------------
(Jan)
(Feb)
(Mar)
Sometimes a user may want to join two sets together. note that this is different from
a Crossjoin() that combines sets from different dimensions. In this example, we are sim-
ply combining two sets to make one larger set.
SELECT {} ON AXIS(0),
{[Qtr1].Children, [Qtr2].Children} ON AXIS(1)
FROM [Sample.Basic];
Axis-1
+-------------------
(Jan)
(Feb)
(Mar)
(Apr)
(May)
(Jun)
When combining two sets, it is possible to return the same member twice if the
member is in both sets as shown in the example below. It is up to the user to remove
duplicates by using other functions, such as the union() function and the Distinct()
function.
SELECT {} ON AXIS(0),
{[Year].Members, [Year].Children} ON AXIS(1)
