Skip to Content
0
Former Member
Aug 01, 2005 at 10:50 PM

Problem concerning MDX statements

38 Views

Hi everybody,

i executed a MDX statement as follows:

SELECT NON EMPTY [Measures].MEMBERS ON AXIS(0),

NON EMPTY CROSSJOIN([A_MBERT00].MEMBERS, {[A_MBERT38].MEMBERS}) ON ROWS

FROM $A_MBER94

The result, I get with mdxtest, contains some rows and columns, I don't want in that table. I don't know, how they are called in English, but they summarize all values from [A_MBERT00] and [A_MBERT38].

I try to explain a bit more: If the column header for [A_MBERT00] is "SimulationID" then the first x rows in this column contain the string "All SimulationID".

How can I hide such entries by tuning the MDX statement?

Any help appreciated.

Cheers

Markus