Universe Dynamic Prompts
I'm using SAP BusinessObjects XI 3.1 SP5 and built a universe on top of MS SQL 2008.
I've a Yearmonth dimension, LOV of this dimension is like 201001,201002.
My requirement is prompting Yearmonth and setting its default value to Currentyear+Currentmonth. User must be able change this value or report must run with current year month. At the end of the day default selection of prompt must be change next month automatically.
Is there any way to apply this ?