COGNOiSe.com - The IBM Cognos Community

Planning & Consolidation => COGNOS Planning => Topic started by: rchibani on 28 Oct 2009 12:20:26 PM

Title: How to modify possible Selected Items depends on what is already choosen
Post by: rchibani on 28 Oct 2009 12:20:26 PM
Hi All

I have a D-List "Movements" how have items :

1 -  "Type" which have format as D-list. this D-list have items "IN", "OUT"
2 -  "Details" which have a format as D-list. this D-list have items "IN 1", "IN 2", "OUT 1", and "OUT 2"

What i want to do is when a user in contributor selects "IN" as a choice for "Type" only "IN 1" and "IN 2" appears as a possible choices for "Details" item, and of course if "OUT" is selected only "OUT 1" and "OUT 2" appears

if there is any suggestions for Analyst or Contributor

Cognos EP version : 8.1.1636

many thanks

Title: Re: How to modify possible Selected Items depends on what is already choosen
Post by: JaromirSeps on 29 Oct 2009 03:18:01 AM
My belief is, you can't do this in planning.
But maybe somebody has some solution ... than I'll be glad to hear it :)
Jaromir
Title: Re: How to modify possible Selected Items depends on what is already choosen
Post by: StuartS on 29 Oct 2009 09:09:37 AM
I agree.

You may want to consider adding a validation item to your Movements D-List.  This would then display an error message if an incorrect choice of entries was made.

Stuart
Title: Re: How to modify possible Selected Items depends on what is already choosen
Post by: craig_karr on 29 Oct 2009 12:09:41 PM
I haven't figured out how to do this either but I have often had the need so I would be very interested if someone has any idea how to solve it. Valdidation rule is the second best thing and the solution I have had to settle with, but if you are running 8.1 that is not an option.
Title: Re: How to modify possible Selected Items depends on what is already choosen
Post by: StuartS on 04 Nov 2009 04:44:18 AM
You are right in that you cannot use validation in 8.1. 

What can be done in 8.1 is on another D-List item is put a conditional calculation.  If the result of this conditional calculation does not meet your validation then it can display a value from a formatted D-List.  This formatted D-List will contain messages.

This is a solution I have used.

It isnt the best but it works.

Stuart
Title: Re: How to modify possible Selected Items depends on what is already choosen
Post by: craig_karr on 06 Nov 2009 07:40:28 AM
Quote from: StuartS on 04 Nov 2009 04:44:18 AM
You are right in that you cannot use validation in 8.1. 

What can be done in 8.1 is on another D-List item is put a conditional calculation.  If the result of this conditional calculation does not meet your validation then it can display a value from a formatted D-List.  This formatted D-List will contain messages.

This is a solution I have used.

It isnt the best but it works.

Stuart

Very clever solution if you build in 8.1! There is so much one can do with Planning if your'e just being a little bit creative  :)
Title: Re: How to modify possible Selected Items depends on what is already choosen
Post by: rchibani on 07 Nov 2009 01:17:38 PM
Thx for all