Help on Filter definition in IDT

building semantic layer
1

I’m getting the below error

[Teradata][ODBC Teradata Driver][Teradata Database] ‘{’ ('7B’X) is not a valid Teradata SQL token.

for the below Filter definition in Universe.

CASE WHEN @Prompt(‘Select Begin Date:’,‘D’,Mono,Free) BETWEEN ABC.START_DATE AND ABC.END_DATE THEN ABC.START_DATE
ELSE
CASE WHEN @Prompt(‘Select End Date:’,‘D’,Mono,Free) BETWEEN ABC.START_DATE AND ABC.END_DATE THEN ABC.START_DATE
END END

Please help me on this.

Thanks,
Ram

rams2k (BOB member since 2014-07-14)

2

Are your Teradata drivers up to date?

3

Yeah, They up to date.

rams2k (BOB member since 2014-07-14)

4

Could be some sort of data parameters - I’d google your error as it sounds database specific.

5

Remove the “ELSE CASE” in the middle and 1 “END”. It should read like this:

CASE WHEN @Prompt('Select Begin Date:','D',,Mono,Free) BETWEEN ABC.START_DATE AND ABC.END_DATE THEN ABC.START_DATE 
WHEN @Prompt('Select End Date:','D',,Mono,Free) BETWEEN ABC.START_DATE AND ABC.END_DATE THEN ABC.START_DATE 
END

Norm Rosen :us: (BOB member since 2002-07-10)