Can anyone help me w/ the query below.I get an unknown query error when
I try to run the below query.

Thanks in advance

SELECT
{ [Measures].[Responses], [Measures].[Responders], [Measures].[Trans
Amount] } ON COLUMNS,
{ ([Product].Members),([Providers].Members)} ON ROWS,
{ [Response Date].[Month].Members} ON PAGES
FROM
[Programmatic_Balance_Build]

A couple of considerations that come to mind:

- Assuming that you're using AS 2005, the implict crossjoin on rows
should be framed by regular parentheses:

{[Measures].[Responses], [Measures].[Responders],
[Measures].[Trans Amount]} ON COLUMNS,
([Product].Members, [Providers].Members) ON ROWS,
{[Response Date].[Month].Members ON PAGES
FROM
[Programmatic_Balance_Build]
- What OLAP client tool are you using - can it handle a 3rd PAGES MDX
query axis (Management Studio OWC complains)?


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***

Deepak,

Thanks for you reply.
The cube was created using AS2000. Hopefully my company will be moving
to 2005 by mid 2006.

I am using this MDX query to create a dataset within reporting services
2000. I will then use this dataset to create a matirx report.
Does that help?

*** Sent via Developersdex http://www.developersdex.com ***

Hi John,

- AS 2000 doesn't support the implicit crossjoin syntax (assuming that
you intended a crossjoin), so instead:

{[Measures].[Responses], [Measures].[Responders],
[Measures].[Trans Amount]} ON COLUMNS,
Crossjoin([Product].Members, [Providers].Members) ON ROWS,
[Response Date].[Month].Members ON PAGES
FROM
[Programmatic_Balance_Build]
- Based on testing with Reporting Services 2005, the PAGES axis was
handled fine, so hopefully that should work.


- Deepak

Deepak Puri
Microsoft MVP - SQL Server

*** Sent via Developersdex http://www.developersdex.com ***