on 10-25-2016 10:16 AM
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
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
are you able to see the DATEADD,GetDate functions under the Functions section in Object SQL expression?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
90 | |
10 | |
10 | |
10 | |
7 | |
7 | |
6 | |
5 | |
4 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.