How to develop date prompt display only month and year

[inu]

Hi Team,

Is it possible to create date prompt which shows only year and month.
See the attached file.

Please suggest..


Regards,
Inam

[dougp]

I don't see why it wouldn't be possible.  You'll probably need to have JavaScript use the PromptAPI (see the Report Studio User Guide) to write the chosen value to a Text Box Prompt.

I think this is the document I used when I created a custom control:  http://public.dhe.ibm.com/software/dw/dm/cognos/reporting/prompts_and_filters/advanced_prompting_ibm_cognosbi83_84.pdf

You'd do well to use RequireJS (http://requirejs.org/) and AMD (https://github.com/amdjs/amdjs-api/wiki/AMD) to implement your custom prompt control.  Take a look at the way JavaScript is used in Cognos Analytics 11.0.4 and later (https://www.ibm.com/communities/analytics/cognos-analytics-blog/javascript-support-in-interactive-viewer/) so it won't be a complete do-over when you upgrade.

Be sure to post about your success with lessons learned.

[Invisi]

What about using a dropdown list with the year/month attribute from your date dimension?