%PARM parameter_name AS 'value:default_value,caption:label'
-
parameter_name is the name of the parameter.
-
default_value is the default value of the parameter.
-
label is the caption to use when prompting for a value of this parameter.
When you run a query within the MDX shell, the shell prompts you for values of any named parameters.
Then, to refer to the parameter within the query itself, use @parameter_name
For example:
>>WITH %PARM c as 'value:Pine' select homed.[city].@c ON 0 FROM patients
Please supply parameter value(s) for this query:
C [Pine]:
Pine
1,073
---------------------------------------------------------------------------
Elapsed time: 2.136337s
>>WITH %PARM c as 'value:Pine' select homed.[city].@c ON 0 FROM patients
Please supply parameter value(s) for this query:
C [Pine]:Magnolia
Magnolia
1,113
---------------------------------------------------------------------------
Elapsed time: 2.627897s
>>WITH %PARM c as 'value:Pine,caption:city' select homed.[city].@c ON 0 FROM patients
Please supply parameter value(s) for this query:
city [Pine]:
Pine
1,073
---------------------------------------------------------------------------
Elapsed time: 2.235228s
>>WITH %PARM c AS 'value:5,caption:count' SELECT TOPCOUNT(birthd.decade.MEMBERS, @c) ON 1 FROM patients
Please supply parameter value(s) for this query:
count [5]:3
1 1970s 1,593
2 1960s 1,505
3 2000s 1,442
---------------------------------------------------------------------------
Elapsed time: 1.207581s
See Also
The WITH clause defines elements that are available only during the query that defines them.
To define calculated members and named sets for use during the entire session, use the following statements:
For information on defining calculated members and named sets as part of the cube definition (available in all sessions), see Defining Models for InterSystems Business Intelligence.