Previous 3 Months Data from a Prompt.

959186May 8 2013 — edited May 8 2013

I am trying to go back 3 months from a selected month via prompt using this formula

timestampadd(sql_tsi_month, -3, EVALUATE('TO_DATE(%1,%2)' as timestamp,'01/'||substring("Time"."Month",8,2)||'/'||substring("Time"."Month",1,4), 'dd/mm/yyyy'))

OR

TIMESTAMPADD(SQL_TSI_MONTH, -3, substring("Time"."Month",8,2)||'/'||'01'||'/'||substring("Time"."Month",1,4)AS DATE))

This formula is working in 'edit formula' for a column but not working for filter. In the edit formula by writing this only the column headers are going back 3 months but the data is not. I guess this is how the edit formula works. So i tried to put this in Filter. But it is throwing an error.

ORA-01858: a non-numeric character was found where a numeric was expected at OCI call OCIStmtFetch. [nQSError: 17012] Bulk fetch failed. (HY000).

i need help soon.

Thanks

Added on May 8 2013

#11g, #answers, #business-intelligence-applications, #business-intelligence-foundation, #business-intelligence-suite-enterprise-edition-obiee, #obiee, #prompt, #report

1 comment

113 views