Print Page - Need to use Single prompt for 2 reports

Title: Need to use Single prompt for 2 reports
Post by: Archana_M on 10 Jul 2013 07:43:32 AM

Hi All,
Attached is the year dimension in the database.
I have created 2 cross tab reports with year prompt on the same page.
I want to use year prompt for both the crosstabs wherein 1 crosstab(C1) gives the value of the prompt & the other cross tab(C2) with value of prompt -1
Eg.Prompt->2012-13 ......C1->2012-13
Prompt->2012-13 .......C2->2011-12

Title: Re: Need to use Single prompt for 2 reports
Post by: Lynn on 10 Jul 2013 08:24:48 AM

What are the use and display values for your prompt? I'd suggest use YEAR_NAME or YEAR_ID and display YEAR_NAME1. Will the YEAR_ID column always be sequential? Is YEAR_NAME a numeric or character data type? What value is found on your fact data? These are the questions you'll need to answer in order to decide what to use and how to reliably filter the data correctly.

As a general idea, you could filter the query that feeds the first crosstab as:

Code Select


[FactYear] = ?Prompt?

Then filter the query feeding the second crosstab as:

Code Select


[FactYear] = ?Prompt? - 1

Title: Re: Need to use Single prompt for 2 reports
Post by: Archana_M on 11 Jul 2013 01:49:10 AM

Thanks for your prompt reply,the solution worked for me.... :)

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Archana_M on 10 Jul 2013 07:43:32 AM