SAP BW Planning on aDSO

On the way to BW/4HANA there is no more option to avoid using aDSO’s. The good news is that things are similar as beforehand and there are no disadvantages in using an aDSO instead of a RealTimeCube or a direct Update DSO as an InfoProvider for planning. One of the biggest advantages of using an…

Details

Script debugging in Lumira Designer

Developers need some basic tools to do their job properly and effectively, these are: a development environment with auto-complete a decent espresso-machine a debugger Unfortunately, while the choice of espresso (, pour-over, or any other form of coffee you prefer) basically depends on your budget, taste and skills, debugging in Lumira Designer is pretty limited……

Details

Can you solve this ABAP riddle?

Do you know what this ABAP code line does? It replaces¬†three variable definitions, a loop, two value assignments and a table append in a single line of code. The corresponding “traditional” code could look something like this: Semantically speaking: it will copy the contents of table lt_s into table lt_t for each column that exists…

Details

Lossless rounding in SQL – part II

In a previous blog post I presented a ‘common sense approach’ to distribute a value onto detail records without a rounding error. Remember, we were distributing 100 EUR – which is 10.000 cents – to 6 records. 10000/6=1666, the remainder is 4, so 4 of the 6 records get one plus cent. The benefit of this…

Details

Lossless rounding in SQL – part I

When developing planning applications with SAP BW IP or BPC, you will almost certainly face the need to distribute a total value onto detail records. If this shall happen during data entry in an input-ready query you can use the disaggregation option in QueryDesigner or BW Modeling Tools – the system will take care of…

Details