Passing drilled down member as parameter to the target report

[twister]

Hello All, I have the following requirement.

a) to show certain countries in the rows. Each country will have drill through links to the detailed report.
b) columns will have a specific account on which you can drill up/down (dimensional) on the same report.

So, when we click the drill through links on the countries in the rows, I would like to pass the drilled down member (in the column) as parameter to the target report. Say for example, if we have drilled down to 4th level, I would like to pass the relevant member that was drilled on so that the detailed report can show specific rows.

How do I achieve this?

Thanks.

[cognos810]

Hello Twister,
On your target report, create a data item with expression :
children([Namespace].[Query Subject].[Country]->?p_Children?)
WHERE [Namespace].[Query Subject].[Country] should be your hierarchy.

Then pass the value of country in the drill through definition on the parent report to this parameter as memberuniquename.

-Cognos810

[twister]

Hello mate,
Yes. In my target report, I have created a data item with expression (for accounts as account is the one which will be drilled up/down on)
children([Namespace].[Query Subject].[Accounts]->?p_Accounts?)
WHERE [Namespace].[Query Subject].[Accounts] is my hierarchy

However, I couldn't pass the right value. It is always passing the default value/root value. The drilled up/down value is not being passed. So, my question is how do I rightly pass the drilled up/down value?

Thanks.

[cognos810]

Not sure what might be happening on your end. I have attached my parent report sample here, due to restrictions on number of attachments per post, will post the XML for the target report right after this.
Please take a look and see if there is something that you have done differently. It works fine for me.
In my example, the parent report starts from "Year" hierarchy's root node i.e. "All Years". If you drill through from here, you will see all the years in the target report. If you drill down first and go to Quarters, and then do a drill through you would see the months for that Quarter in the target report. So on and so forth.

-Cognos810

[cognos810]

And here is the target report's XML.

[twister]

Thanks for the response.
From your example,
lets take year is in column with drill up/down enabled. So we can navigate the year hierarchy in the column
and a hardcoded country in the row with drillthrough enabled in the target which will pass the country in the row and the corresponding member that the column was drilled on.

Basically the row needs to pass the drilled down member (present in the column) to the target report.

Row (Drill through)
-----
United Kingdom

Column (Drill up/down)
------------
Year with drill up/down enabled.

if you have drilled up to Q1 2014 in column, the drill through link in row needs to pass the corresponding member to the target report.

Drill through members in the row to pass,
Country : United Kingdom
Period : Q1 2014 (MUN) ---> This is the member that was drilled on the column.

Hope this is clear.