1

Topic: OBI Publisher 12.2.1.3.0 usage of parameters

Good afternoon.
I try to use parameters for a plural choice in model .
In  in sql-inquiry in where I can not pick up the necessary construction for correct display of parameters in the report (at a choice of several values).
Type construction: "REP_SOW_PIGLETS_NEW". "CITY" =NVL (:P_CITY, CITY) - returns error ORA-00909: invalid number of arguments
Type construction: "REP_SOW_PIGLETS_NEW". "CITY" in (:P_CITY) OR "REP_SOW_PIGLETS_NEW". "CITY" = decode (:P_CITY, NULL, CITY, ' dummy ') - but it as does not fulfill correctly.
Prompt how correctly to use parameters for a plural choice in reports ?
The second question: why parameters are visible in the report if it separately to open, but are not visible on a data panel?