Drill through - Passing multiple values (by data item)

[LukeMal]

Hi All!

I'm using:

-> Cognos 8.4.0 (no fix packs' installed)
-> Windows Server 2003
-> IE 8


CASE:


I have created MASTER report and DETAILED report.

In MASTER I have two Data Items - [Country]-attribute and [Sales]-measure
In DETAILED I have three Data Items - [Country]-attribute; [Customer Name]-attribute; [Sales]-measure

What I wanted to do is simply create a Drill throug between MASTER and DETAILED reports.

1. In MASTER report I've set a detailed filter to show me Countries with Sales above 10K $
2. In MASTER report I've added Text Item ("Go for Details") and set Drill through on it:
-------> I've set the drill to DETAILED report passing DATA ITEM VALUE (Country Name)

DETAILED report has a detail filter "[Country Name] IN (?Country Name?)" setted as Required

ISSUE

When I Drill from MASTER to DETAILED report, only one value (first from the top) is beeing passed for the parameter to a DETAILDED report

or if I change the Drill through settings I can choose values that I want to pass (but it is not my target)

HAVE ANYONE FOUND A SOLUTIONS FOR SUCH A CASE???

I don't know is it a matter of Cognos version or lack of fix packs installed, but it isn't working for now...

The only workaround that I have managed to be done was to Pass Parameter Value instead of Pass Data Item Value but - again - it's not meeting my needs...


Best regards,
LukeMal

[adik]

what do you mean by "only one value (first from the top) is beeing passed for the parameter to a DETAILDED report" ? first country in your list? do you have a parameter in your master report? post a picture with the drill through definition from master to detail, a screenshot with master and one of detail report as it.

[LukeMal]

Hi Adik, thx for the reply...

1. Yes, that's mean first country in my list
2. I don't have a parameter in MASTER report (I don't want to have)

I'm posting pics below:

MASTER report:
http://i48.tinypic.com/jsnbjc.jpg

DETAILED report:
http://i49.tinypic.com/2qbyouv.jpg

DETAILED report output:
http://i49.tinypic.com/2m60ebb.jpg

Regards,
LukeMal

[adik]

hi, not sure what happened, but the images are not showing up. upload them to a image hosting site and then post the links

[LukeMal]

I've modyfied my last post. It should be okay now.

[adik]

what you have in the master report is a link outside your list that drills to the detail report and throught that link you are passing country. but because you are outside the list it doesn't know what country to pass to the detailed report parameter so it passes the first one. either you set up the drill through definition on the country cells, or you create that link without passing a parameter.

[LukeMal]

So regarding to your solutions, there's no possibility to pass more than one Country from MASTER to DETAILED report (without having a prompt parameter) ???

[LukeMal]

Could you be more specific?

1. "set up the drill through definition on the country cells" -> then report will pass only one value in its parameter (not all)
2. "create that link without passing a parameter" -> If I do that, DETAILED report will "ask" me what values do I want to pass, so again it's not what it should be...

Or maybe I'm wrong :)

Thx in advance!

[adik]

based on what logic do you want to pass countries to the detailed report? because in your master report you don't have any country prompt then i'm assuming in your detailed report you are looking to either view all countries or certain ones. but which ones? what is the requirement?

[LukeMal]

What I want is to pass the countries that were selected in MASTER report to the DETAILED report, without choosing any.
So for example if in MASTER report I have two countries starting from A (like Australia or Austria), than after drill through I want to see DETAILED data for these countries.

Is it all clear?

[adik]

and how do you select the countries in the master report? this is not clear

[LukeMal]

I'm not selecting it manually.

There is a selection by detail filter. It selects only those countries with name starts from letter A (for example) -> [...].[...].[Country Name] LIKE 'A%'

that's it.

[adik]

then put the same filter in the detailed report and remove the prompt

[shibastroke]

Were you able to make what you have asked? I have something similar that I need to implement and I have the same doubt :(

[ravireddy]

Hi Adik, thx for the reply...

1. Yes, that's mean first country in my list
2. I don't have a parameter in MASTER report (I don't want to have)

I'm posting pics below:

MASTER report:
http://i48.tinypic.com/jsnbjc.jpg

DETAILED report:
http://i49.tinypic.com/2qbyouv.jpg

DETAILED report output:
http://i49.tinypic.com/2m60ebb.jpg

Regards,
LukeMal

Change Default pareamenter value to child values or Parent values (Donno exactly)  :o

Please check and confirm

Mostly it should solve.

[cognos810]

Adik is right in saying that apply the same filter logic in both the Master and the detail reports.
If you have a filter like [Country] like 'A%' then put this filter in the detail report also, and then do not pass anything related to the country from the drill through.
Just an example:
If that alphabet "A" is parameter based, meaning a user selects what the country name starts with, then pass the value of that parameter through the drill through, but again both master and detail should have the same filter.
[Country] starts with ?Alphabet_selected? in Master.
[Country] starts with ?Alphabet_selected? in Detail, BUT pass the ?Alphabet_selected? parameter via drill through.

By using a text item based drill-through, you cannot pass the data item as the drill through link will not know which data item value to pass in case there are multiple values. A data item value selection in drill through definition cannot pass multiple values.

Does it help ?

-Cognos810