Database Reference
In-Depth Information
Axis-1 (Measures)
+-------------------+-------------------
(YearChildrenCount) 4.0000
This query will count the number of descendants for the specified member.
WITH
MEMBER
[Year].[YearDescCount] AS
'Count(Descendants([Year]))'
SELECT {[Measures]} ON AXIS(0),
{[Year].[YearDescCount]} on AXIS(1)
FROM Sample.Basic;
Axis-1 (Measures)
+-------------------+-------------------
(YearDescCount)
17.00
6.10.1.8 Filter Counts
Filters with counts can be very useful in scoping the set to cer-
tain criteria. use this query to search for members that have only one child member.
This can be useful when trying to understand your implied shares:
SELECT {} ON AXIS(0),
{FILTER({[Stores].members},
COUNT({[Stores].CurrentMember.Children}, IncludeEmpty) = 1)} ON
AXIS(1)
FROM [ASOsamp.Sample];
Axis-1
+-----------------------------
(Electronic Essentials)
(Club Electronics)
This next query can be used to search for members that have more than 100 children.
This is another query that can be used to help optimize an outline.
SELECT {} ON AXIS(0),
{FILTER({[Geography].members},
COUNT({[Geography].CurrentMember.Children}, IncludeEmpty) > 100)}
ON AXIS(1)
FROM [ASOsamp.Sample];
Axis-1
+-----------------------------
(CO)
(KS)
(NE)
(IA)
(IL)
(IN)
…
