Urgent problem

building semantic layer
1

dharmendra.reddy@GEPEX.GE.COM

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)

2

What is your database? Is it a system function, like SYS_DATE?

Just a thought, I don’t see it as a BO function…

Brent

sum(decode(to_char(current_fdate+1,‘mm’),‘01’,SALE_SUM2.PY_MO12_SALE_QTY,0))

Listserv Archives (BOB member since 2002-06-25)