How to modify possible Selected Items depends on what is already choosen

[rchibani]

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

[JaromirSeps]

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

[StuartS]

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

[craig_karr]

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.

[StuartS]

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

[craig_karr]

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  :)

[rchibani]

Thx for all