Skip to Content
0
Former Member
Dec 07, 2006 at 07:32 PM

Limits on Mulitiple Selections

25 Views

Hello,

I have a bex report of an infoset that uses "multiple selections" for 0CUSTOMER. I have discovered that if I run the report with between 0 and 100 Customers, the report runs in just a few seconds. However, with 101 Customers it runs for approx 30 minutes.

Note that the infoproviders referenced by the infoset do not have aggregates. In fact, the join in the infoset is simply between two ODS objects.

Is there a limit to how many single selections can be in a multiple selection? What is the best way to troubleshoot this type of issue. ?

We are running 3.0B with Oracle database.

Thanks in advance.