RRDI - how to create cascading parameter
Hi,
In RRDI Cognos report studio, I am using my own deployed view from DW which list 10 people and projects where they work on. It has two colums: MEMBER and PROJECT So, I build one report prompt parameter called Member, I chose to create new query called MemberQuery which uses MEMBER column and gives me my 10 members to select. Then, I build second report prompt parameter called WorkProjects, I chose to create new query called ProjectsQuery which uses PROJECT column and as Cascading source I chose Member parameter, but on test report, I get my 10 members, but in WorkProjects I don't get anything. Can anyone help on this. Regards, |
Be the first one to answer this question!
Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.