COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Active Reports => Topic started by: Sep2013 on 20 Jun 2017 02:22:55 AM

Title: Nested Data Decks not working
Post by: Sep2013 on 20 Jun 2017 02:22:55 AM
Hi,

I am on version 10.2.1 and using relational model.

I have created a nested data deck where users can select team and injury in data drop downs and thus relevant card is displayed.
However it doesn't appear to be working.


Is that due to my relational source as I am using union option to have option of "All Teams" and "All Injuries"?
Title: Re: Nested Data Decks not working
Post by: Sep2013 on 20 Jun 2017 05:20:06 AM
the question also becomes that what is the best way to have multiple drop downs filter one chart.
i tried nested decks as i saw them used somewhere but i am.not sure of the best method.
i wish to have two active report data controls to change values on my chart
Title: Re: Nested Data Decks not working
Post by: MFGF on 20 Jun 2017 07:13:08 AM
Quote from: Sep2013 on 20 Jun 2017 05:20:06 AM
the question also becomes that what is the best way to have multiple drop downs filter one chart.
i tried nested decks as i saw them used somewhere but i am.not sure of the best method.
i wish to have two active report data controls to change values on my chart

The trick is to use a single data deck, driven by both the team and injury variables. You can only ever display single combinations of each though.

MF.
Title: Re: Nested Data Decks not working
Post by: Sep2013 on 20 Jun 2017 08:52:29 AM
Geat. Thank you so much MF.
this means i cannot multiselect.. but i can select one value from each drop downs which shal reflevt changes in chart for combination.
wonder why i used nested deck in the first place.
I will try with only one deck n a chart inside it.

Does that mean i can also use union query to have option of all injuries n all teams or you recon i should use default card fr all option.
Title: Re: Nested Data Decks not working
Post by: MFGF on 20 Jun 2017 09:41:34 AM
Quote from: Sep2013 on 20 Jun 2017 08:52:29 AM
Geat. Thank you so much MF.
this means i cannot multiselect.. but i can select one value from each drop downs which shal reflevt changes in chart for combination.
wonder why i used nested deck in the first place.
I will try with only one deck n a chart inside it.

Does that mean i can also use union query to have option of all injuries n all teams or you recon i should use default card fr all option.

You can use a union query if you really want to, but a default card is the easiest option (in my humble opinion) :)

As we've now determined you are using 10.2.1, you can replace the charts and data deck with visualizations, and have your variables filter (rather than select) the visualizations. This enables multi-select.

Cheers!

MF.