OBIEE parameter issue

1056631

Hi,

I have to build a report in OBIEE 11g answers where the parameter is "Period". But the problem is there is no column as Period (eg JUN-2013, AUG-2012 etc). The report filter apeears as

Trans Date  is less than or equal to  07/31/2013 12:00:00 AM 

AND  GL Date  is greater than  07/31/2013 12:00:00 AM

Somehow I need to pass 'JUN-2013' instead of  '07/31/2013 12:00:00 AM' and the parameter will be a dashboard prompt.

The EBS database query conditions look like below

apps.ra_customer_trx_all.trx_date <= '31-Jul-2013'

apps.ar_receivable_applications_all.gl_date > '31-Jul-2013'

In the subject area I have one presentation table called 'Transaction Date' and columns as 'Year' and 'Month' but the values are appearing as '2013' and 'JUN'.  Not sure how to use this as a parameter and then pass to the analysis.

The dashboard prompt LOV should be look like JUN-13, JUL-13, AUG-13 etc and then the user selected value needs to pass to the report to filter the data.

Could anyone please help.

Also please guide me on how to display the parameter values in OBIEE report. The report will be attached to a dashboard page.

It would be great if you could please provide steps to do these.

Thanks

Titas