Author Topic: Creating A Dimensional Tree Prompt Against A Relational Datasource  (Read 94 times)

Offline christian.koenig

  • Full Member
  • ***
  • Join Date: Jan 2018
  • Posts: 6
  • Forum Citizenship: +0/-0
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

Offline Francis aka khayman

  • Statesman
  • ******
  • Join Date: Jun 2009
  • Posts: 480
  • Forum Citizenship: +25/-3
    • CognosM
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.

Offline christian.koenig

  • Full Member
  • ***
  • Join Date: Jan 2018
  • Posts: 6
  • Forum Citizenship: +0/-0
The question is how ?

Offline Francis aka khayman

  • Statesman
  • ******
  • Join Date: Jun 2009
  • Posts: 480
  • Forum Citizenship: +25/-3
    • CognosM
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?

 



       
Twittear