Hello,
Environment :cognos 10.1.1 and DB2. relational package.
Facing issues to pass parameters from the column summary of a crosstab.
I have a YTD values and when I drill through , the target report displays the value for all years .
I have a single metric in the row and Year and Months in columns . The column summary is at Year level.
when I click the month cell, the drill through seems to carry the parameters for both year and months. but when summary is clicked it brings data for all the year.
In the target report I don't see any prompt being selected for year and month.
Im reli confused on whats going on.
I defined the summary by setting "define contents" to YES and then using the cell value from the query. Then I defined a separate drill through for the target with YEAR set to take the data item value and the month is set to "do not use parameters".
The Red arrow in the snapshot indicated the drill through with issues and the green arrow works just fine.
Have you checked to see what data is actually passed by the drill-through?
Looks like no data is passed . Thats why its displaying all the years in target report.