Choose between prompts

[cognosehelp01]

Hey guys,

I'm farely new to Cognos so sorry if this is a simple question:
I want the user to be able to pick either a Car Model, otherwise we choose a Make.

I made them both optional but what I would like is that if a user pics a Make, they can pick a Model, but if a Model is picked they cannot change the Make, does Cognos support this?
I guess the functionality i'm mostly intested in is the second half, since we can filter Model after Make

[Francis aka khayman]

cascading prompts can be used in the first scenario. the second one is a little bit tricky. you might want to implement javascript to disable the Make when a Model is chosen.

are you using relational or dimensional?

i'm interested in a simple solution as well

[cognosehelp01]

I am using a relational db, and yeah I would think the solution would consist of a check and then possibly a function to disable the model, is this an available function in Cognos?

[esar]

If you dont want to further allow the user to select make if he choses a model directly, you can put an optional filter in the prompt query of make. This will only show the make of the selected model in the prompt.