I´m using a BICS connection to get data from a BW Bex query to Web Intelligence report. However, I have too many records in the Bex query and it is too havy extracting all these data to BO and then using the Ranking option from webI.
Therefore, I want to select the top N records from BW Bex, before sending them to webI (600 records).
The problem is that I have found in the documentation (link below) that BW Bex conditions are not supported in webI. I could only read there that:
Crystal Reports for Enterprise, Web Intelligence, and SAP BusinessObjects Dashboards are not able to support Local Calculations defined for key figures in the BEx Query (for example, a key figure configured to display as a rank value).
So, I cannot use rank option neither conditions!
Any ideas how can I restrict values in Bex query to send to WebI?
We are on BI 4.0 SP5.
Thanks in advance!