SAP Business Warehouse Queries with Virtual Key Figures

Today we're going to discuss SAP Business Information Warehouse (BW) query techniques for BW users, consultants, and developers.

As you may know, Virtual Key Figures are used to handle complex algorithms and logic within a Bex query. In this linked white paper, we outline a solution that HPC America developed for one of our utility customers to split (i.e. allocate) the common administrative and general costs and common customer accounts expenses in the FERC 900 series of accounts to electric and gas lines of business based on the percentages derived from two look-up tables using FERC account and year/period. It's impossible to achieve this in a regular Bex query, but our solution worked very well.

Since the query does not use the cache when the virtual key figures are used, it can get slow at times. That depends, of course, on the data volume of the cube (or multi-cubes) and other variables, such as the usage of aggregates.

If you're facing a challenging BW coding issue, don't hesitate to get in touch with us directly for some advice. Download the HPC white paper on Virtual Key Figures.