Current_fdate

building semantic layer
1

SELECT
sum(decode(to_char(CURRENT_FDATE+1,‘mm’),‘01’,SALE_SUM2.PY_MO12_SALE_QTY, 100))
FROM
SALE_SUM2
WHERE
(SALE_SUM2.BUS_TYPE=‘RS’ )

Can anybody tell me what can be the CURRENT_FDATE which is used in the to_char function. We checked it in the database. its not column of any of our database tables.

Thanks & Regards
Vinay.

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

2

Vinay,

CURRENT_FDATE doesn’t look like it’s referring to a field in your database, else it would reference a table/alias before it. Perhaps someone set this up as a run-time variable.

Have you done a search in your Universe for the CURRENT_FDATE character string? Also, what is the name of the object that holds this particular SQL Select … perhaps that can provide some clues.

Ang.

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