Hi NG,

i got the following MDX-query:

SELECT
NON EMPTY {[Measures].[IstMonat], [Measures].[IstJahr],
[Measures].[BudgetJahr], [Measures].[ForecastJahr] , [Measures].[KTOBEZ]}
ON COLUMNS,
NON EMPTY{[Konto].[2.].Children} ON ROWS
FROM IUB_1
WHERE ([ZEIT].[KJ 2004].[Jun 2004])

What must i edit in this statement to supress elements of the dimension
KONTO, who contains the string '(E)' in her names?

best regards

Frank
--
www.xax.de

NON EMPTY{Filter([Konto].[2.].Children, InStr(1, [Konto].CurrentMember.Name,
"(E)") > 0 )} ON ROWS

Ohjoo Kwon


"Frank Matthiesen" <fm (AT) xax (DOT) de> wrote