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

Top N results from Bex to WebI using BICS

176 Views

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).

"

http://www.mastering-sap-and-businessobjects.com/sap-businessobjects-bi-4-service-pack-05-support-for-bex-query-elements

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!

Regards,

Mariele