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

Previous 11 months column amounts -cognos8

Started by Anand, 13 Sep 2007 03:35:45 AM

Previous topic - Next topic

Anand

Hi,
I am having year(2004,2005,...) and month prompts(1,2,....,12) if a user selects year and  month then it should display previous 11 months column.How can i achieve this? please give me a solution. if i select Dec it should display as below.

Custid  Name  Jan Amount........ Oct Amount  Nov Amount  Dec Amount   



Regards,
Anand.



larsonr

I've seen and done this using math based on a single time dimension.

In your case, every month is essentially given a unique ID.

Example for your case maybe that January is 2004.01 and December is 2004.12

By Using math based on certain cases you should be able to come up with your minimum and maximum queryable months by number assignment to be able to use in a filter.

Ex.  Using math logic come up with min and max months.

So if I select October 2005,
I want to see as the min_month 2004.11 and max_month is 2005.10

Then my query is set with a filter of where month_id is between min_month and max_month.

I should then be able to bring in my month object in the query, and sort by month id achieving hopefully the result you are looking for.