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

Last 7 months data

Started by srinu_anu2007, 13 Feb 2014 03:13:24 AM

Previous topic - Next topic

srinu_anu2007

Hi,

I have Year and Month prompts , both are coming from different dim's and i want to show when u select the Year:2014 and Month:Feb
it should display from 201402 to last 7months.i.e201401,201401,201312,201311...etc how do we relate for month and year?

Iam not sure about to convert from Char to numeric(Month prompt)?

Can anyone done before please help on this? and Iam using DMR package.

Thanks,