Hi,
I have a object in the Universe. The definition of the object is
sum(decode(to_char(current_fdate+1,‘mm’),‘01’,SALE_SUM2.PY_MO12_SALE_QTY,0))
if I parse the object ,Parsing is OK .
My doubt is , what could be current_fdate. I checked in the database , it is not the column of the any of our database tables. its not even function. What else it can be.
Can anybody tell me what it can be.
If I include that object in report query panel and If I see the SQL for that object , I am seeing the following SQL.
SELECT
sum(decode(to_char(current_fdate+1,‘mm’),‘01’,SALE_SUM2.PY_MO12_SALE_QTY,0)) FROM SALE_SUM2
If I try to run the same query against the database it is failing saying Invalid column.
Can anybody please tell me what could be Current_date???
Thanks in Advance.
Dharma
Listserv Archives (BOB member since 2002-06-25)