Filter Expression: The filter expression[Product Group] = # sq( prompt( 'productgroups', 'token', 'Clothes' ) )#uses a prompt macro.
Default Text: The string 'Clothes' acts as the default value for the prompt. If the user does not provide a value at runtime, 'Clothes' will be used in the generated query.
Macro Function: Thepromptfunction retrieves the value provided by the user or defaults to 'Clothes' if no value is supplied.
Reference: IBM Cognos Analytics V11.1.x documentation provides detailed information on using macros and prompt functions, including the use of default values in filter expressions.
Contribute your Thoughts:
Chosen Answer:
This is a voting comment (?). You can switch to a simple comment. It is better to Upvote an existing comment if you don't have anything to add.
Submit