Short note on Line Item and High Cardinality dimensions

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 we don't know that get us into trouble. It's the things you know that just ain't so." This blog post is about one of those cases. A customer complained about … Continue reading Short note on Line Item and High Cardinality dimensions

Question to SAP Support “Why is partition pruning not working in my BW on Oracle?”

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 by a customer. So, what is the customer complaining about? What does he mean by "partition pruning"? It's a feature of the query optimizer to figure out, which partitions of … Continue reading Question to SAP Support “Why is partition pruning not working in my BW on Oracle?”