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
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.
There's also this option from CognosPaul:
http://cognospaul.com/2013/10/08/checking-option-checkbox-prompt/ (http://cognospaul.com/2013/10/08/checking-option-checkbox-prompt/)
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!