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