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

Issue with crosstab summary drill through

Started by katdbc, 05 May 2014 07:06:25 PM

Previous topic - Next topic

katdbc

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


katdbc

The Red arrow in the snapshot indicated the drill through with issues and the green arrow works just fine.

BigChris

Have you checked to see what data is actually passed by the drill-through?

katdbc

Looks like no data is passed . Thats why its displaying all the years in target report.