Passing parameter to MDX - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Analysis Services (2000)

Passing parameter to MDX

Author

Topic

narayanac
Starting Member

18 Posts

Posted - 2005-11-09 : 06:13:18

Hi All,

I have a problem of generating report using Reporting services. I had written an MDX expression from which the report needs to be generated. As i want to pass the specified day leveled in Time dimension as a parameter to MDX that i could not able to do. Can any one can help regarding this MDX passing day as a parameter to it.

Thanks

sumit_pilankar
Starting Member

2 Posts

Posted - 2005-11-17 : 23:42:38

hi

you can do this using the with clause

I guess in your case u will need a set...so u can use

With
Set [Time] AS '@ParameterTime'

Select
{
...
} on Columns,
{
[Time]
} on Rows
From [Cube]

I am working on MDX in Reporting Services, and this is the way i use it there. Hope it helps.

Bye
Sumit

eghb
Starting Member

1 Post

Posted - 2005-12-19 : 21:27:01

Hi,

I read your answer about passing parameters to MDX using Reporting Services, but it doesn’t work, I wonder if the problem is because I am using VS.Net 2003 and I need the newest version of VS.Net. When I place the parameter in quotes, it sends me a syntax error and without the quotes, it sends me an ICommandWithParameters error. Can you help me, please or can you give some link where explain this topic, because I don’t find any information in MSDN?

quote:
Originally posted by sumit_pilankar

hi

you can do this using the with clause

I guess in your case u will need a set...so u can use

With
Set [Time] AS '@ParameterTime'

Select
{
...
} on Columns,
{
[Time]
} on Rows
From [Cube]

I am working on MDX in Reporting Services, and this is the way i use it there. Hope it helps.

Bye
Sumit

Steve_Funk
Starting Member

1 Post

Posted - 2006-01-12 : 18:38:35

I would love to hear if there was ever a resolution to this. I have been searching way too long to try to find a way to parameterize an MDX query SQL RS 2005.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources