BI Publisher Data Model Performance Issue

Hi All,

BI Publisher Parameter:

  The following parameter has selected for the Report Parameter.

1.  Multiple Selection (Check Box Ticket)

2. Can Select all (Radio button selected the "All Values Passed")

3.  Refresh other parameters on change

Data Model Code in Where Condition:

and ((cc.segment4 in (:P_1)) OR ('All' IN (:P_1 || 'All')))

When we selected the "All" in the selection parameter for the costcenter (segment4). The report is finished quickly. If i select the particular or multiple segment4, the report is very slow.

I removed the code "OR ('All' IN (:P_1 || 'All'))" and select the single or multiple segment4. The report is finished quickly.