Can't I use a value prompt together with parameter-based member expression?

[nm]

Hi,

I've a dimensional query where I want to calculate the member based on a report parameter. The expression to calculate the members looks like this:

Code Select Expand

IF(
    ?pParam? IS NULL
) THEN (
    [MyDefaultMember]
) ELSE (
    ?pParam?
)

The ?pParam? is populated by a non-required value prompt. But Cognos always forces me to enter a value. Isn't it possible to have the value prompt not to be set in such a scenario?

Best regards

[bus_pass_man]

If I recall correctly, the hook syntax prompt is always mandatory.  Investigate the prompt (and promptmany) functions, which have optionality and default values available.