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?
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) = (
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...