Skip to Content
0

SQL 92 code for Multi Source IDT

Oct 25, 2016 at 09:16 AM

130

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

2 Answers

AMIT KUMAR
Oct 25, 2016 at 12:27 PM
0

are you able to see the DATEADD,GetDate functions under the Functions section in Object SQL expression?

Share
10 |10000 characters needed characters left characters exceeded
Sagar Vora Oct 26, 2016 at 04:17 AM
0

I am not able to see, but i don't think that's the issue.

In one of my filter i have used Max function which is also not availble.

Share
10 |10000 characters needed characters left characters exceeded