Calling MDX query in TSQL Stored Procedure to Pass Parameter

Hi;

I would like to know if it is possible to call MDX query from TSQL Stored Procedure to pass parameter? Can I create MDX query dynamically? If it is possible then can anyone provide some examples. For more details; let say I have one MDX query which has parameters which I would like to call from a TSQL stored procedure and pass that parameter from Stored procedure.

Any help would be apprecaited.

Thanks

M. Essa Mughal

Yes...you can send MDX from SQL

but for this one method that I know is to create a linked server to the OLAP database.

after that you can use openquery to pass the MDX.

ex:

Select *

from Openquery(<Linked_server_name>,

'select [measures].[value] on columns

from cube

where ([Dimension].[member])'

)

you can create the MDX dynamically also.

declare @.qury varchar(2000)

set @.query = 'Select *

from Openquery(<Linked_server_name>,

'select [measures].[value] on columns

from cube

where ([Dimension].[member])'

)

exec master.dbo.executesql @.query

try it.....