Just like for every IT system, for SAP BO / BI Platform you have a multi-system landscape: at least one a development system, and a productive one. Most often also a third system for testing and quality assurance. Applications are developed on the development system and then “transported” (SAP term) to test and productive systems.…
EvoClock is a desktop clock that will show the time in words on a matrix of led-lit letters. It is the little sister of the much bigger (and much more expensive) wall clocks of this type. It comes as a DIY electronics experiment kit and can be used to learn the basics of modern open…
Customer exit variables… You might like them, you might hate them, one thing is for sure: you need them. They provide (some degree of) flexibility in your queries – to include a custom logic that can’t be modeled by mere selections and formulas. They are the duc(k)t tape to glue together the bits and pieces,…
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……
For one of our dashboarding projects we needed to display multiple KPIs, one of them as a tiny “ring chart” showing the forecast accuracy as a percentage between 0% and 100%. Instead of using the built-in chart component of Lumira we used a trick to implement the chart as a light-weight solution with CSS only.…
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…