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
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
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?
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.