I must be missing something. In Reporting Services I am creating a
report in based on an Analysis Services cube. I want to add my own
dataset to the report. I click on "<New Dataset>" and type my custom
MDX in the Query string field. I then get this error:

"Modifications to the MDX query cannot be saved. You must use the MDX
Query Builder to edit an MDX query that is not an expression."

I think the Query Builder is very simplistic, and doesn't allow me to
design queries with basic things like topcount, etc. (And, for that
matter, doesn't allow me to view the MDX it is generating while I am
working on the query. I have to muddle through monitoring tools to
catch it.) So if I want to create a report with Top 5 companies, how
do I do this if I can't edit the MDX? Again, I must be missing
something. Please illuminate.

You can put any mdx query you want in there.

You can't run the mdx query if it has vaiables in there, or surrounded by
quotes. I fill in the values of my mdx query, then run it to get the data
fields. Then put my variables in, and query in quotes.


"Kyler" <kylernunery (AT) gmail (DOT) com> wrote

Based on your description, you are always in the Design Mode of the MDX
Query Designer - you can switch to the Query Mode by clicking the
rightmost toolbar icon, as explained with screenshots here:

http://msdn2.microsoft.com/en-us/library/ms403829.aspx

Analysis Services MDX Query Designer User Interface
...
Graphical MDX Query Designer in Query Mode

To change the graphical query designer to Query mode, click the Design
Mode button on the toolbar.
...

- Deepak

Deepak Puri
Microsoft MVP - SQL Server

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