I'm trying to build a sales dashboard where I want to display information from several sources. One is a SQL based ERP system.
I run into the following issue with BCS. There are several lists with over 50.000 or more than one million rows. If I create an external content type SPD advises me to apply a top x filter, and SharePoint itself has a limit of 2000 items (I know this
can be changed, but I assumed this is nog best practice).
If I use one of the standard filter webparts (e.g. Text Filter, Query String etc) the BCS list does get filtered, however only the records that are in the top x items are presented. Is there a method where I can go back to the source with the parameter from
one of the standard filter webparts to filter the dataset. I've tried using stored procedures, but so far I haven't found out how to configure it proparly (if it's even possible).
View Complete Post