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

Dynamic Year Prompt in Cognos 10.2.1...

Started by l.russo, 17 Jan 2014 10:53:17 AM

Previous topic - Next topic

l.russo

Hello everybody,i'm searching for a solution to my new problem.

I have a report with a list and a value prompt in this page.I have no prompt page.
My prompt is filled with year data (2013,2014...) and i want that my report runs with a default dynamic year for value prompt.
The value and the display on my value prompt will have to be set to this default value.
the default value will be current year if it is present in prompt values otherwise the prior year...so if 2014 is present in prompt values the default will be 2014 else 2013...

i have read many post but none is correct or suitable to my situation..(some old javscripts for cognos 8 or 10.1.) and some with prompt page.

thank you for your time and for your
and sorry for my poor english.
i hope that i have been clear in my request.

Bye

charon

hey gdulli,

have you checked these two pages?
http://cognosknowhow.blogspot.de/2013/04/how-to-dynamically-set-up-default-value.html
this is kind a "all kind of approaches" collection, which will show the challenge cognos has setting dynamic data values as default for prompts.

"best practice" (which would be 2 get an property or a direct way to implement default dynamic values imao) is
http://www.ibm.com/developerworks/library/ba-pp-reporting-scripting_techniques-page634/

Also, another approach might be to create a flag or another function on db side to set the actual loaded month e.g. but i dont know your requierement so this is just a wild idea.
gl