Developing Essbase Applications

Practical MDX for Essbase Developers  •  215

6.10.1.9 Filters is next query uses the Filter() function and a text function to nd

members that begin with a particular text string; “801”.

SELECT {} ON AXIS(0),

{FILTER({[Geography].members},

Substring([Geography].CurrentMember.Member_Name, 1, 3) = "801")} ON

AXIS(1)

FROM [ASOsamp.Sample];

Axis-1

+-----------------------------

(80101)

(80107)

(80154)

(80116)

…

Similar to the query above, this query will search for members that end with a par-

ticular text string, “25”:

SELECT {} ON AXIS(0),

{FILTER({[Area Code].levels(0).members},

Substring([Area Code].CurrentMember.Member_Name,

Len([Area Code].CurrentMember.Member_Name ) - 1) =

"25")} ON AXIS(1)

FROM [ASOsamp.Sample];

Axis-1

+----------------------------- ...