Skip to Content
Former Member
Jul 12, 2013 at 04:34 AM

Top N results from Bex to WebI using BICS


Hello Folks,

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!