SQL 92 code for Multi Source IDT

247 Views

Hi,

I have a single source universe(.unx) created in IDT and I am creating the same universe with multi source option and while creating a multi source universe using IDT, the date functions such as getdate() / dateadd doesnt work. It works well on a single source universe, but not with the multi source universe. Can anyone please help in translation?

@Select(TimePeriod\Fiscal Year)=(

SELECT FiscalYearShortLabel

FROM dbo.DIM_Time

WHERE Date = DATEADD(D,-1,CONVERT(DATETIME, CONVERT(VARCHAR(50),GETDATE(),101),101)))

I tried below code, but its giving error...

@Select(TimePeriod\Fiscal Year) = (

SELECT Table__2."FiscalYearShortLabel"

FROM @catalog('BISALES')."BISales.dbo"."DIM_Time" Table__2

WHERE Table__2."Date" = DATEADD(D, -1, CONVERT(DATETIME, CONVERT(VARCHAR(50), GETDATE(), 101), 101)) )

Please help with code...

Thanks,

Sagar