Skip to Main Content

Analytics Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to achieve this in OBIEE 11g?

AbinashBeheraMar 2 2016 — edited Mar 3 2016

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

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details