Problem concerning MDX statements

[Former Member]

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

[Former Member · Accepted solution]

Hi Markus,

Change your MDX to following and it shouldn't aggregate the columns.

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

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

FROM $A_MBER94[/code]

[Former Member]

Hi Markus,

Are you looking for the aggreated value that the parent of that dimension holds?

How is your cube set up? Cheers! Bill

[Former Member]

Hey Bill,

no, I don't want the aggregated data, I'd like to have only the non-aggregated data.

In this InfoCube, i have three dimensions and a lot of key figures...Which info do you need additionally? Maybe I can send you a screenshot of the query, if you give me your address.

Cheers

Markus

[Former Member]

Thanks a lot!!!!

Cheers

Markus