Creating A Dimensional Tree Prompt Against A Relational Datasource

[christian.koenig]

Hello Community, is there a way in Cognos 11 to populate a dropdownbox with data from DMR and use the parameter to filter a relational list. I found an old document which does not work?

ftp://public.dhe.ibm.com/software/dw/dm/cognos/reporting/prompts_and_filters/tree_prompt.pdf

Hope that someone can help me

thx Chris

[Francis aka khayman]

so long as you are able to extract the correct value from your prompt and somehow integrate it in your relational query, i don't see why not.

[christian.koenig]

The question is how ?

[Francis aka khayman]

now you're talking.

1. what is your display value and MUN for the prompt?
2. what is are the values you have for the column(s) you want to filter?