If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Drill Through issue on Cognos8.3 in Reportstudio Crosstab to Crosstab

Started by elisha, 12 Oct 2008 01:46:06 AM

Previous topic - Next topic

elisha


Hi

I am using ReportStudio in Cognos 8.3 . I have an Issue with Drill Through issue with Report studio crosstab to Report studio crosstab. 

I have a summary report set up with drill through capabilities to a detailed report.

I have created 2 Drills (for 2 rows i.e., for 2 different fields) in the Target report and created corresponding 2 filters in the Source Report. The Summary  data and detail data is matching for these 2 drills.

The below 2 different filters I have created in the Source report.
[SAL_LABORA] IN ?DRILL?
[SAL_EBA] IN ?DRILL? 

In the Target report If user clicks on SA_LABORA it will give detail report for that field. Like the same for SAL_EBA.

Issue :

I have added one more Drill in the target and corresponding Filter in Source reports.
Target Report :
I don't have any issue with the Target Report because the target report is fetching same data for the old 2 rows and proper data for the 3rd row.
Source Report :
But the source report is fetching value “0’s ” for all the 3 rows I mean if I drilled any one of the 3 drills all detail reports are generated with value 0’s for all the rows.

I need to create more than 30 drills in the Target report. So up to 2 Drills working fine. Only problem I am facing in the source report if I add a new Drill.   

Is there any other way to define the filters. Because I Need to create more than 30 Drills and corresponding filters for each Drill.

I have already verified the below.

Target Report :

1) Is I am passing the correct Data Item Value and Parameter Values.   

Note : I did not done any thing in Bookmark tab . Do I need to add any thing ?

Source Report :
1)   Is I am applying correct filter for the corresponding Drill. 

I am in confusion if the Drills are working fine for the 2 drills If I added one more Drill all 3 Drills are not fetching the correct data. Please advise me where I missed and any other way to define the Filters in Source Report.
Thanks in advance â€" Elisha

elisha

Hi 

The below steps used.

User want to Drill through on Salaried-Regular-Full Time .

Source Crosstab report filter :

STEP1 :
[Salaried-Regular-Full Time] IN ?DRILL?

STEP2 :
And I have created Data Item in Query Explorer Query as below.

Data Item Name :  DRILL
Expression I have mentioned : ?DRILL?

Target report (Crosstab) settings :

Created drill through definitions as below.

NAME:                    METHOD                                     VALUE
DRILL                     Pass Data Item Value                  [Salaried-Regular-Full Time]
Prompt1                   Pass parameter value                    prompt1
Prompt2                   Pass parameter value                    prompt2
Prompt3                  Pass parameter value                     prompt3
Prompt4                   Pass parameter value                    prompt4


The same way I have created for the Second Drill.

I mean… I have created one more filter in Source with the same name DRILL.

[Professional services] IN ?DRILL?

And created corresponding drill definitions in Target.

Upto 2 drills working fine. Data is matching (summary data = detail data)

Issue :

If I added 3rd filter in source and corresponding Drill definitions in Target all drills are fetching value 0's for all rows. The previous drills also not fetching the data. 

I believe that the problem with the Filter in Source report. Is there any other way to define the filters ? . Please help me to resolve the issue and get the proper drills. 

Note :

The below way I tried today.

Only made filter changes in Source report the remaining is same as mentioned above.

And kept Data Items in Query of Source report which I am going to Drill on Target.

I have deleted all filters in Source. And kept only one filter in Source Report.

(Because if I keep more than 2 filters with same name like ?DRILL? the report is fetching value 0's for all rows)

[Salaried-Regular-Full Time] IN ?DRILL? 

Now I am able to get data for all drills (I have tried for 6) and data also matching for all 6 drills . (Summary data = Detail data )

I am not sure it is correct because I have applied only one filter but why Data is matching for all 6 drills.

If  I remove all filters the detail report is generating with more data.

I am not sure it will work on production data. Currently I am working on Test environment. 

If I used the below filters the report getting Parsing error.

1)
([Salaried-Regular-Full Time], [Professional services] ) IN [DRILL]

Note:  DRILL is Data Item which having the expression ?DRILL?

2)
([Salaried-Regular-Full Time], [Professional services] ) IN ?DRILL?

3) [DRILL] IN ?DRILL?
 
Please review the above and advise me if I need to any modifications or is it correct way to define Drills.