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

I have to show the selected quarter and previous quarter.

Started by alex_, 01 Dec 2012 04:49:00 PM

Previous topic - Next topic

alex_

Hi,

I'm using relational model.

I have a prompt page in which can select the desired Quarter, but unless selected Quarter in the report should display and previous Quarter.

I have defined Quarters in Data Model.   
How do I make the filter to leave and previous Quarter?

I have to show the selected quarter and previous quarter.

Thanks :)

pricter

How you have define the previous quarter?

For example 2012Q1

alex_

This is the problem.

For example: If you select in prompt page 2012 Q1. The report must to show 2011 Q4 and 2012 Q1.

pricter

Create a data item to find the next quarter from the date ( usually with dateadd and datepart you can achieve that,
I do not know which database you use in order to be more specific)
and then add a filter
[Quarter]=?Quarter? or [NextQuarter]=?Quarter?

alex_

In the database contains column defined 'Quarter', witch contain following rows:
      2011-Q1,
       2011-Q2,
      2011-Q3,
      2011-Q4,
      2012-Q1,
       2012-Q2,
       2012-Q3,
       2012-Q4

From there I take 'Quarter'.