Hi Suman,
The weird thing is that the view really has the column. The definition of the view is attached.
And the column "SLICE_CREATED_DATE" is properly showed if I run a select of the view.
I compared this view with the one you sent me. They are a little bit different, maybe because my PPM uses SQLServer.
However, I tried to run the SQL below and I really got the same error as showed in the bg_dwh log.
SQL:
select * FROM [PPM_DWH].[ppm_dwh].DWH_X_RES_AVAIL_PER_FACTS
WHERE EXISTS (SELECT 1
FROM [CLARITYDBLINK].niku.niku.DWH_X_RES_AVAIL_PER_FACTS_V src
WHERE DWH_X_RES_AVAIL_PER_FACTS.RESOURCE_KEY = src.RESOURCE_KEY AND DWH_X_RES_AVAIL_PER_FACTS.PERIOD_KEY = src.PERIOD_KEY
AND src.SLICE_CREATED_DATE BETWEEN CONVERT(DATETIME,'2017-09-14 07:00:51') AND CONVERT(DATETIME, '2017/09/15 07:00:49'))
RESULT:
Msg 207, Level 16, State 1, Line 6
Invalid column name 'SLICE_CREATED_DATE'.
Thanks,
Vitor.