If you try to make SAP BW and a Qlik Sense installation work in tandem, you will find that there are a lot of resources to fetch data from SAP into Qlik. You can load the data from external HANA views generated for your cubes, ODS or even queries, or use the extractor connector provided…
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…
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…
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…