I'm just learning to use MDX to create queries. Not real
knowledgeable with SQL queries, but have a very short learning curve.
Can I get some help on resolving the error I'm getting.

Select
NON EMPTY {[Broker].[GN_Hierarchy].[President].Members} ON COLUMNS,
NON EMPTY {[Broker].[State].[Broker Name].Members} ON ROWS
From
[GN_Loans]
Where ([Broker].[State].[All Broker].[ALABAMA])

Recieve this message "Unable to open cellset formula error duplicate
dimensions across (Independent) axes when calculating a query axis".

than one axis. Since you already select [Broker].[State].[Broker
Name].Members on the rows, you may not use another member of the [Broker]
dimension on the filter axis.

If the [Broker Name] level is under the [State] Level, the following query
would should select all brokers that are under ALABAMA on the rows:

Select
NON EMPTY {[Broker].[GN_Hierarchy].[President].Members} ON COLUMNS,
NON EMPTY {[Broker].[State].[All Broker].[ALABAMA].Children} ON ROWS
From
[GN_Loans]

If there are additional levels between [State] and [Broker Name] you could
use the descendants() function like this:
Descendants([Broker].[State].[All Broker].[ALABAMA],
[Broker].[State].[Broker Name])

This function returns all descendants of [Broker].[State].[All
Broker].[ALABAMA] which are on the [Broker Name] level.

HTH
Stefan Farthofer

Stefan

Thanks a lot, your query worked just fine.

"Stefan Farthofer" <sf (AT) immobilien (DOT) net> wrote