Database Reference
In-Depth Information
(May)
33674.0000
(Dec)
33342.0000
(Sep)
33073.0000
(Apr)
32917.0000
(Oct)
32828.0000
(Jan)
32538.0000
(Mar)
32213.0000
(Feb)
32069.0000
(Nov)
31971.0000
notice the use of the key word BDESC in this case to sort the results in descending order.
This next query returns all level-0 members of the queried member. This is a little
trickier, requiring us to use the full functionality of the Descendants() function.
SELECT {} ON AXIS(0),
{Descendants([Time].[1st Half], [Time].levels(0), SELF)} ON AXIS(1)
FROM [ASOSamp.Sample];
OR
SELECT {} ON AXIS(0),
{Descendants([Time].[1st Half], 100, LEAVES)} ON AXIS(1)
FROM [ASOSamp.Sample];
6.10.1.6 What Level/Generation?
Sometimes an administrator may require certain
information about their database. This query returns a list of all members and their
level by using the intrinsic DImEnSIon ProPErtIES.
SELECT {} ON AXIS(0),
[Time].members DIMENSION PROPERTIES [Time].[LEVEL_NUMBER] ON AXIS(1)
FROM [ASOsamp.Sample];
Axis-1 Axis-1.properties
+-------------------+-------------------
(Time)
(LEVEL_NUMBER = 4,
(MTD)
(LEVEL_NUMBER = 3,
(1st Half)
(LEVEL_NUMBER = 2,
(Qtr1)
(LEVEL_NUMBER = 1,
(Jan)
(LEVEL_NUMBER = 0,
(Feb)
(LEVEL_NUMBER = 0,
(Mar)
(LEVEL_NUMBER = 0,
(Qtr2)
(LEVEL_NUMBER = 1,
(Apr)
(LEVEL_NUMBER = 0,
(May)
(LEVEL_NUMBER = 0,
(Jun)
(LEVEL_NUMBER = 0,
(2nd Half)
(LEVEL_NUMBER = 2,
(Qtr3)
(LEVEL_NUMBER = 1,
(Jul)
(LEVEL_NUMBER = 0,
(Aug)
(LEVEL_NUMBER = 0,
(Sep)
(LEVEL_NUMBER = 0,
(Qtr4)
(LEVEL_NUMBER = 1,
(Oct)
(LEVEL_NUMBER = 0,
(Nov)
(LEVEL_NUMBER = 0,
(Dec)
(LEVEL_NUMBER = 0,
