Hi All,
I have a Month Range Prompt having Presentation Variable 'M'.
suppose user gives Month between: APR-2014 to DEC2015, I am passing this prompt as descriptor ID of another column which will be : 201404,201512
so the PV M will have '201404,201512',
But I need to pass one month less than the Prompted start month. So if user gives prompt as APR-2014 to DEC-2015, MAR-2014 to DEC-2015 should be passed.
i.e the PV should be having '201403,201512'
Can we achieve this in obiee 11g?
Please suggest.
Regards,
Abinash