COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: fasi on 09 Jan 2009 10:07:11 PM

Title: Drill Through issue(cube to relational)
Post by: fasi on 09 Jan 2009 10:07:11 PM
im having a cube with ID in it and target report build against relational model doest have the ID, i want to bring that id from the cube when i pass the parameters so that report will be filtered on id

let say emp_id is present in cube and in target report im having 10 columns and one columns is emp id which is a data item (emp id =?emp_id?)


im trying to drill through from cube and passing the parameter emp_id from cube to report,Im unable to pass.


Any help will be appreciated. ???
Title: Re: Drill Through issue(cube to relational)
Post by: fasi on 11 Jan 2009 12:13:20 PM
Let me explain in more detail

im having a cube with ID in it and target report build against relational model doest have the ID, i want to bring that id from the report created from cube when i pass the parameters so that target report will be filtered on id

let say emp_id is present in cube and also in parent report created from the cube,target report doest have any  emp id which is a data item (emp id =?emp_id?)


im trying to drill through from report created from cube and passing the parameter emp_id from cube report to target report ,Im unable to pass.

Similar to this link below.(for my case it is showing prompt page)

http://www.tek-tips.com/viewthread.cfm?qid=1180552&page=1

Any help will be appreciated

Thanks.
Title: Re: Drill Through issue(cube to relational)
Post by: fasi on 12 Jan 2009 07:40:41 PM
This is solved.

Thanks.
Fasi.