Hi,

we are trying to find a fast way of searching an MSOLAP cube for members.
Our search facility supports case sensitive and wildcard queries. So far, we
have been using the Filter() function, where we are using String
modification functions as LCase (for case insensitive queries) and InStr
(for wild card queries). This functions ok, but slow.

A complete query looks like
----------
SELECT
{
Filter(
[Time].Members as MemberList,
(LCase(MemberList.CurrentMember.Properties("CAPTIO N")) = "q1")
OR (LCase (MemberList.CurrentMember.Properties("NAME")) =
"q1")
)
} ON COLUMNS
FROM [Sales]
----------

which searches members with q1 as name or caption.

This is rather slow. My question is is there any other way of searching an
MSOLAP cube for members with a given name and/or caption?

Thanks for your help.
Also any comment is highly appreciated.

Cheers,
Stephan

Stephan,

This would always be faster (if you can use it):

SELECT
FROM [Sales]
where ( [Time].q1)

Jon Jahren

"Stephan Klaffer" <stephan.klaffer (AT) ____no_spam____decisionworks (DOT) co.uk> wrote
in message news:%231pERa1WDHA.2080 (AT) TK2MSFTNGP11 (DOT) phx.gbl...