If you have an SAP Business Warehouse Accelerator (BWA) attached to your SAP system, and if you use flat InfoCubes, you might have noticed that you cannot create a BWA index for a flat InfoCube. Only standard InfoCubes can be indexed in a BWA. The sa...

The blog post Database Partitioning and Semantic Partitioning for SAP Business Warehouse on IBM i took a detailed look at the options that SAP Business Warehouse (SAP BW) and the database IBM Db2 for i offer in order to keep mass data in smaller, eas...

Since the program RSDU_IC_STARFLAT_MASSCONV was introduced in blog post Mass Conversion of Standard InfoCubes to Flat InfoCubes, it has received extensive enhancements. To enable the newest functions, install the support package levels or correction...

You may remember my blog post about pushing down the evaluation of so-called “FEMS queries” into the Db2 for i database from September last year. If not, check it out here: SAP on IBM i: Pushing FEMS Queries to the Database Level. Until now, the FEM...

When you work with SAP Business Warehouse (SAP BW), there's a risk that data tables might overflow as InfoProviders get larger and larger. To prevent this, SAP BW offers several options to keep the number of rows in an InfoProvider small, for instanc...