Skip to Content

SQL 92 code for Multi Source IDT

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 25, 2016 at 12:27 PM

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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 26, 2016 at 04:17 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded