If you plan on making the BPC Explorer available in a production environment, I suggest you read the following article. It talks about customization and tuning options that are available.
The piece is that probably most important is the one where you can define a threshold. A threshold will limit the number of instances/tasks that are returned in any query executed by the BPC explorer. A current limitation is that all records are retrieved at once and the paging is done in memory. This means if you potentially have a query that returns 10,000 instances, all that information has to reside in memory, increasing the heap and potentially impacting the performance of your production system.