How to change calender format in obiee 11g when applied column prompt?

ARIVEMULA KAVYA KUMARI, LERA TECHNOLOGY PVT LTD

Hi,

I am working on monthly wise report in obiee 11g.. My Client requirement is, prompt apply on calender..

calender format shoud be like this

if we select jan month, we have to get oustanding balance of jan month

I have applied column prompt on calender in obiee 11g .

then i am getting calender format like this. i dont want this foramt .

I want to get  following format.. calender format like this. please help me.. is it possible to chage?

i have one idea, obiee schema have some system tables ..like calender tables...

for example, table names are calender_date, timeid.

then it is some possible to change calender format

@{system.calender_date}[MM/YYYY]

Please help me.  i dont know this will work fine or not..

please help me.. how to do this.?

is there any possibles?

please send any document for this.

Thanks in advance,

A.kavyao

[Deleted User]

Unless you hack your own calendar using JS or something you won't get that display. What's wrong with a Year/Month prompt?