Hello,
how is it possible to pass parameters through
MDX? for eg:

SELECT {[qty invoiced], [Cost], [Price]} ON COLUMNS,
NonEmptyCrossJoin ([N_Cust].Members,[N_time].Members) ON
ROWS FROM N_Cube

I saw in a previous reply to this question you can pass
the MDX code as string, but this is hard coded at design
time right, is it possible to get parameter values @
RUNTIME? suppose i want the user to enter a value for the
year field so that informtion will be filtered based on
that year

thanks
regards
Imran

No, this isn't possible in MDX - as was stated in the previous reply, the only way to do it is to build the MDX query string dynamically in your client application

Chri

----- Imran wrote: ----

Hello
how is it possible to pass parameters through
MDX? for eg

SELECT {[qty invoiced], [Cost], [Price]} ON COLUMNS
NonEmptyCrossJoin ([N_Cust].Members,[N_time].Members) ON
ROWS FROM N_Cub

I saw in a previous reply to this question you can pass
the MDX code as string, but this is hard coded at design
time right, is it possible to get parameter values @
RUNTIME? suppose i want the user to enter a value for the
year field so that informtion will be filtered based on
that yea

thank
regard
Imra

Another technique, which is more limited, but more secure against MDX
injection attacks is to use StrToXXX family of functions.

--
==================================================
Mosha Pasumansky - http://www.mosha.com/msolap
Development Lead in the Analysis Server team
All you need is love (John Lennon)
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
==================================================
"Chris Webb" <OnlyForPostingToNewsgroups (AT) hotmail (DOT) com> wrote

client application.