Dear readers This time I’m not presenting you any of my own work but instead want to advertise what my CSA colleague Tobias Kaufmann just… Read More »Automatic testing of BW queries, anyone? Here you go!
As the fourth quarter of the year started everybody seems to check the goals that had been set for this year and what has already… Read More »How most BW performance support messages are solved
Last week a colleague from the WHM (data warehouse management) support team called me to get some assistance with a customer message he was processing.… Read More »SAP Support case “FOR ALL ENTRIES disaster”
Let’s have a contest! One of my last blog posts started off a discussion (e.g. Bala posted his thought in a blog) about the importance… Read More »Partition count contest!
One of the quotes I like most I learned from Tom Kyte from Oracle. It’s one from Artemus Ward: “It ain’t so much the things… Read More »Short note on Line Item and High Cardinality dimensions
Welcome to the problem As usual understanding, the meaning and the scope of the question is key for the answer to this question, recently filed… Read More »Question to SAP Support “Why is partition pruning not working in my BW on Oracle?”
Lately, I’ve been confronted with several customer messages concerning problems with Infocube compression, change runs or roll-ups. For some reason, these standard BW actions, that… Read More »BW/DB Support 101 – Get to know your failing SQL statement
For many BW performance relevant DB-features, it’s really all about the details of usage and implementation when it’s about the effect of those features. The… Read More »Small changes with big effects
Ok, once again reproducing a problem takes a lot of (waiting-)time for the query to finish. In the meantime I can also just write a… Read More »BW on Oracle: a performance hunch I see more and more often…
In the second week working in BW support, I noticed that there was a problem reported by customers again and again. The customers complained about… Read More »A first (BW) issue…