Need to use Single prompt for 2 reports

[Archana_M]

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

[Lynn]

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 Expand


[FactYear] = ?Prompt?


Then filter the query feeding the second crosstab as:

Code Select Expand


[FactYear] = ?Prompt? - 1


[Archana_M]

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