COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: siva347 on 10 May 2016 10:36:32 PM

Title: Cognos report studio weekly selection date dimension
Post by: siva347 on 10 May 2016 10:36:32 PM
I have a scenario here. Got a Value prompt, 2 Date Prompts,whenever Weekly Option was selected in Value prompt(static choice) From Date in 1 st date prompt and End date in 2 date prompt activates. here in from date prompt whatever day selected in week, it should pull from start of week(i.e.Monday) and in 2nd date prompt whatever day of week selected, it should give start of weekday to selected day of week, 1 st prompt value and 2 nd prompt value should give week format output in report in list
thanks in advance.
Title: Re: Cognos report studio weekly selection date dimension
Post by: navissar on 11 May 2016 05:20:15 AM
You can try to use the method described here
http://cognospaul.com/2015/05/24/guest-post-a-new-take-on-date-range-prompts/
and derive the script for altering the date prompts from that.
Title: Re: Cognos report studio weekly selection date dimension
Post by: siva347 on 23 Jul 2016 12:41:46 PM
Thanks paul for Solution.
Sorry for late reply.in vacation