Static Choice "ALL"-Element in Single-Value Prompt

[SimonWM]

Hi all,

I am currently chewing on a way to insert an "ALL" Element in a single-select value prompt.

General setup as follows:
Data Source: TM1 Cube
UI: "Radio Button Group" with Multi-Select: "No"
Required: No
Query Filter: Optional
The prompt is showing a subset of members (A, B, C) of a dimension (A, B, C, D).

I added an static choice element "All", therefore the prompt is now showing (ALL, A, B, C).

2 things I want to accomplish:
First, "All" being default, and if "All" gets picked the report is showing the aggregation for A+B+C.
Second, "All" element being at the end of the list.

Tried the IBM-Support solution (http://www-01.ibm.com/support/docview.wss?uid=swg21339895), but I wasn't able to get it to work:
1. Add 'Show All' as static choice to the value prompt as 'use value' and 'show value'
2. Set prompt default selection property to 'Show All'
3. Set filter to a conditional expression that will accept the static choice 'Show All' Example: ((?Product line? = 'Show All' ) and (1=1)) OR ([Product line] = (?Product line?))

Would be happy for any kind of help.

Best regards,
Simon

[BigChris]

Can't you just make the prompt optional? That way if the user doesn't select a product line it'll default to All anyway.

[BigChris]

There's also this option from CognosPaul:

http://cognospaul.com/2013/10/08/checking-option-checkbox-prompt/

[SimonWM]

Hi Chris,

thanks for the effort. Both, prompt and filter, were optional. The problem was, that "All"  (A, B, C, D) has more Elements than the subset-of-interest (A, B, C).

But I came up with a (not elegant but working) workaround.

thanks anyway!