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,…
DetailsOn 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…
DetailsDevelopers 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……
DetailsFor 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.…
DetailsIf 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…
DetailsDo 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…
DetailsIn 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…
DetailsWhen 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