If else possibility in universe designer
I am trying to implement If else logic in universe designer, but unfortunately I ended up getting error.
Below is my formula
I am getting error From keyword not found where expected.
I am wondering whether if else logic possible in universe designer or it should only be implemeted in WEBI.
Thanks for your help.
Jeevan Chaudhari replied
Hi Siva ,
We need to understand , universe supports database functions to which universe is pointing .
If you want to write logic like above ansi supported syntax will be
Original systax :-
case when (@Select(abc\col1)) is null then 0 else @Select(abc\col1) end
You can also handle the same using database specific finctions like NVL or coalesce() just go through available function list .