Calculation before aggregation: A big NO in BW7.4

I believe all of us have been using the “calculation before aggregation” option multiple times working with (calculated) keyfigures when creating queries/reports. Even though SAP doesn’t want us to keep on using the “calculation before aggregation” option (see warning message below when using it in a SAP BW 7.3 system),...

More

From IaaS, to PaaS, to SaaS, to PizzaS ;-)

The VNSG (Dutch SAP user group) visited Walldorf two weeks ago and during this visit Jos Houben (VP, CIO Customer Office, SAP SE) shared some inside information about moving the suite to Hana, Ariba and hybrid landscapes. As I’m not sure if I’m allowed to share his entire presentation (NDA/disclaimer wise), I’m only...

More

Getting out of my comfort zone: SAP Business Objects Dashboards

unnamed

I’ve been a ‘back end’ consultant for most of my professional life. I started out with (back end) ABAP development and gradually moved over to (back end) BW development…and later on to Project Management, but that’s less relevant for this blog post. Even though I’m aware of the fact that...

More

Reporting on (non-materialized) transitive attributes

Reporting on a transitive attribute, aka an attribute of an attribute, can be a tricky thing to model if you don’t want to materialize the transitive attribute(s) in your data provider. Imagine we have an infoobject Z__ATE which represents a calendar day and contains many (date related) attributes, like fiscal...

More