problem with MDX query

[Faabris]

hi@all

I get the following message:



[file name=message.zip size=1020]

Any idea?
can someone help me?

Thanks in advance!
Faabi
Post edited by: Faabris, at: 2008/04/24 10:09

[jonnyfrastovner]

I believe you can not list two hierarchies of the same dimension at once in an mdx query. Anyways, in order to select a particular hierarchy other than the default, you have to name it explicitly in the schema and in the query. In the schema, add a name attribute to the second hierarchy, in the query, add a dot and the hierarchy name to the dimension, like this (assuming you name the second hierarcy "beschwerdeinhalt"):

select [x] on columns,

[Daten Feld.beschwerdeinhalt].[All beschwerdeinhalt] on rows

 

In this case, you probably will have to make two separate dimensions beschwerdeinhalt and entschaedigungsform.