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

working on prompts

Started by gvpreddy, 09 Jun 2010 04:26:22 AM

Previous topic - Next topic

gvpreddy

i have a requirement that when i enter the 1 in prompt i should get the last one year data , enter 2 should get the last 2 years data, enter 3 should get the last 3 years data.... there is any way to do this ,,,,,.......... pls post the answer ........... thanks

colt

Assuming you have a dataitem for Actual year, you can use prompt value as parameter in parallelPeriod function to get the first year to be used.
With help of [Fistyear], [ActualYear] - Dataitems and the functions periodstodate and except, it should be possible to define a dataitem as needed.

Colt