Problems with parameterized MDX query in Reporting Services 2005

I'm trying to create some reports based on an OLAP cube. Creating a simple
MDX based report is a breeze with the new report builder, but I haven't
figured out how to optimize things. Like using descendants instead of where
etc. If I just add a pre-made MDX statement, I loose the Fields in the
report datasets.
I managed these types of reports quite well in SQL Server 2000, but now I
feel completely lost. Can anyone tell me how to do this, or just point me to
a good article or two about "Using mdx statements with parameters in SQL
Server 2005"? Please...
Kaisa M. LindahlKaisa,
If you switch to the MDX Query Builder in MDX mode (click on the rightmost
button) you can type your MDX statement manually. Unfortunately, the SSAS
team didn't implement reverse-engineering the query when switching back to
design mode, so you must avoid clicking that button again.
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"Kaisa M. Lindahl" <kaisaml@.hotmail.com> wrote in message
news:%23GnjOHF9FHA.808@.TK2MSFTNGP09.phx.gbl...
> I'm trying to create some reports based on an OLAP cube. Creating a simple
> MDX based report is a breeze with the new report builder, but I haven't
> figured out how to optimize things. Like using descendants instead of
> where etc. If I just add a pre-made MDX statement, I loose the Fields in
> the report datasets.
> I managed these types of reports quite well in SQL Server 2000, but now I
> feel completely lost. Can anyone tell me how to do this, or just point me
> to a good article or two about "Using mdx statements with parameters in
> SQL Server 2005"? Please...
> Kaisa M. Lindahl
>