Click here to Skip to main content
11,932,048 members (56,750 online)
Rate this:
Please Sign up or sign in to vote.
See more: SAP
I am generating a Webi report using Bex query as source (BICS connectivity). Seeing performance issue in the report as I am doing all the calculations using variables in Webi.

I would like to know any performance gain if we move the calculations to the BEX query?
Posted 16-Oct-12 10:13am

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

Following are the key points to remember,
1. Delegate all the relevant/complex calculations in BEX side by using CKF/RKF
2. Keep all the filters in BEX query rather than keeping in WEBi
3. Filter using Indexing for all the Webi.
christhomps 28-Oct-12 4:48am
nice one

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web04 | 2.8.151126.1 | Last Updated 18 Oct 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100