If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Cognos Tree Prompt Issue

Started by Kiran Kandavalli, 03 Jun 2016 10:06:58 AM

Previous topic - Next topic

Kiran Kandavalli

When the user accidently selects both Parent Node and child Node. I want to consider the Parent Node in the filter.

---------------------------------------------------
I have requirement as below. Please suggest.
1) I have a Tree Prompt which is Multi select having 7 levels.
2) User can choose any level from each Category.
3) when the user chooses
a) In a particular category user selects Level 3, in the report we have to show from Level 3 to Level 7 in the report for that category.
b) In another category he may select Level 1 then in the report for that category we have to show from Level 1 to Level 7
For implementing the logic as stated in 3a and 3b - I have used Descendants function.
The Problem is
4) when the user selects in the same group Level 3 and Level 4 (manually) then report is showing

Level 3 to Level 7 Rows - Which is fine

Below to the above rows again from Level 4 to 7 rows are repeated.

As they are in same group I do not want them to be repeated in the report.

Thanks!
Kiran