COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: Fulvio on 29 Oct 2008 04:13:32 AM

Title: Drill Through problems
Post by: Fulvio on 29 Oct 2008 04:13:32 AM
Hi

I am using ReportStudio in Cognos 8.3 . I have an Issue with  ;) with Report studio crosstab to Report studio list. 

I have a master report set up with drill through capabilities to a target report.

In the target report i have created 2 filters (Product Line and a Key Performance Indicators (Index stock average stock) and in the source
report i have created the drill by selecting the two parameters created from the target Report.

The measure of the source report is the Key Performance Indicators, in columns I have the months and in rows the departmental production  nested by products.


Issue :


Is it possible, starting from the selected source, have in the target report, the first 20 target positive values, that depart from the index selected in the source ?
Is there a function ?

Thanks in advance. 


Fulvio
Title: Re: Drill Through problems
Post by: BIsrik on 29 Oct 2008 06:12:49 AM
do u want the first positive 20 numbers entered or top 20 postive number...?

Srik
Title: Re: Drill Through problems
Post by: Fulvio on 29 Oct 2008 06:19:36 AM
Top 20 positive number.

Thank you