Database Reference
In-Depth Information
OR
SELECT {} ON AXIS(0),
Withattr([Pkg Type], "==", "Bottle") ON AXIS(1)
FROM [Sample.Basic];
Axis-1
+-------------------
(100-30)
(200-10)
(200-20)
(200-30)
(200-40)
(300-10)
(300-20)
(400-10)
(400-20)
(400-30)
utilize one of these queries to find members with a specific Boolean attribute set to true.
SELECT {} ON AXIS(0),
{FILTER({[Product].members},
[Product].CurrentMember.[Caffeinated])} ON AXIS(1)
FROM [Sample.Basic];
OR
SELECT {} ON AXIS(0),
Withattr([Caffeinated], "==", "TRUE") ON AXIS(1)
FROM [Sample.Basic];
Axis-1
+-------------------
(100-10)
(100-20)
(200-10)
(200-20)
(300-10)
(300-20)
(300-30)
OR to look for the opposite
SELECT {} ON AXIS(0),
Withattr([Caffeinated], "==", "FALSE") ON AXIS(1)
FROM [Sample.Basic];
note that the following two examples will not work because “truE” is not a mem-
ber of an attribute dimension in this database. “truE” is a property of a Boolean type
Attribute Dimension. Do not get confused with text Attribute types where in another
database a developer may have created members in the attribute dimension with the
names “truE” and “FALSE.”
