Text only | Text with Images

COGNOiSe.com - The IBM Cognos Community

IBM Cognos Analytics Platform => Cognos Analytics => Reporting => Topic started by: christian.koenig on 09 Oct 2019 04:15:08 AM

Title: Creating A Dimensional Tree Prompt Against A Relational Datasource
Post by: christian.koenig on 09 Oct 2019 04:15:08 AM
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
Title: Re: Creating A Dimensional Tree Prompt Against A Relational Datasource
Post by: Francis aka khayman on 09 Oct 2019 03:26:41 PM
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.
Title: Re: Creating A Dimensional Tree Prompt Against A Relational Datasource
Post by: christian.koenig on 09 Oct 2019 11:42:37 PM
The question is how ?
Title: Re: Creating A Dimensional Tree Prompt Against A Relational Datasource
Post by: Francis aka khayman on 10 Oct 2019 08:41:49 AM
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?
Text only | Text with Images