|
Home > Archive > MS SQL Server OLAP > December 2005 > MDX Query Error
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| john.r.carter@bankofamerica.com 2005-12-29, 1:23 pm |
| 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
& #91;Programmatic_Bal
ance_Build]
| |
| Deepak Puri 2005-12-30, 3:23 am |
| 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:
[color=darkred]
SELECT
{[Measures].[Responses], [Measures].[Responders],
[Measures].[Trans Amount]} ON COLUMNS,
([Product].Members, [Providers].Members) ON ROWS,
{[Response Date].[Month].Members ON PAGES
FROM
& #91;Programmatic_Bal
ance_Build][color=da
rkred]
- 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.droptable.com ***
| |
| John Carter 2005-12-30, 3:23 am |
| 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.droptable.com ***
| |
| Deepak Puri 2005-12-30, 3:23 am |
| Hi John,
- AS 2000 doesn't support the implicit crossjoin syntax (assuming that
you intended a crossjoin), so instead:
[color=darkred]
SELECT
{[Measures].[Responses], [Measures].[Responders],
[Measures].[Trans Amount]} ON COLUMNS,
Crossjoin([Product].Members, [Providers].Members) ON ROWS,
[Response Date].[Month].Members ON PAGES
FROM
& #91;Programmatic_Bal
ance_Build][color=da
rkred]
- 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.droptable.com ***
|
|
|
|
|