user172839
user172839

Reputation: 1065

SSAS MDX Parameter Error

In SSRS, I've created a dataset connecting to an AS datasource. I've written up a MDX statement in the query designer and it works fine, until I substitute

STRTOMEMBER('[....]') 

with

STRTOMEMBER(@Parameter1) 

I've also got @Parameter1 defined in the Query Parameter section of the query designer, but I get the following error.

Messaging-handling subsystem. The message manager for the default locale cannot be found. The locale will be changed to US English. Errors in the metadata manager. The configuration property updates were not persisted. Message-handling subsystem. The message manager for the the 3081 locale cannot be found. Parser: The query contains the Parameter1 parameter, which is not declared. (msmgdsrv)

I've defininately checked the parameter names and they all look correct.

Upvotes: 1

Views: 1822

Answers (1)

sung
sung

Reputation: 366

Try

STRTOSET(@Parameter1, CONSTRAINED)

Upvotes: 1

Related Questions