Skip to Content

IDT predefined filter - unexpected branch erorr

Nov 21, 2017 at 02:19 PM


avatar image
Former Member

Hi guys.

I have a strange predefined filter that won't parse/validate. I'm using BO 4.2., database is SQL Server 2012, tool is Information Design Tool.

Syntax is also correct I believe:
"DATE_DIMENSION"."BUSINESS_DATE_ORDER" <= (@Prompt('Count of needed Business Dates','N',,Mono,,))

When parsing that syntax I'm getting "Invalid expression. Unexpected branch. (IES 00013)".

Object from that syntax is valid and is parsing and I'm using it on the report. So I'm very surprised I can't get this to work.

Kind regards,


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

1 Answer

Nov 21, 2017 at 02:51 PM

try to create filter condition in webi query and from SQL generation tab copy the syntax.same paste in the universe filter and if it will parse or not.

10 |10000 characters needed characters left characters exceeded