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,
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,