Data, Process, Insights & things I write about
Something (hopefully useful) for the all the Tableau repository warriors: Table schedules holds, as the name implies, the definition of schedules in Tableau Server. Unfortunately for the SQL user, the information about… Read More » Tableau repository schedules decoded
Analysing the data in SAP systems can be done in many ways. While SAP would like all customers to use the tools from their portfolio, many customers prefer to use other platforms. Snowflake is arguably one of the most… Read More » SAP Factory Calendar in Snowflake
Apart from writing blog posts I have written answers to many questions on several Q&A sites like StackOverflow and SAP Community. Some of those answers received good feedback and/or the answer surprised me once I worked… Read More » Answers Pinboard
When SAP tries to explain HANA as a technology the buzz words “Big Data” have always been part of the story. Commonly “Big Data with HANA” then gets specified to mean one or another thing - often to caveat what the… Read More » SAP HANA middle of the road for Big Data or just average?
Real programming # One of the aspects of doing “actual” programming is to automate computations. Making the computer do things not just once, say by running a calculation on the October sales data, but to do it over and… Read More » Separate business logic from tables and avoid dynamic SQL
In Matchmaker, I developed a solution to a not-so-obvious problem. The solution worked and delivered the right answer - finding documents where the line items match to a certain degree the line items of a reference… Read More » Matchmaker - quick quick?
SQL is an easy language to learn. A few commands to learn ( SELECT/FROM/WHERE/GROUP BY) and you are good to go. One downside of the simple syntax and small vocabulary is that it can lead many SQL users to the assumption… Read More » Matchmaker
A recent question on StackOverflow about how to “format” date values in WHERE-conditions in HANA brought up an aspect of date-handling that is easily overlooked and that can lead to unexpected results. Read More » Be careful with dates and timestamps
On Saturday, 15.02.2020, a rather rain-drenched stormy day in Melbourne, Australia, the SAP Inside Track #sitMEL – Full Day Event was held. I was honored to get a speaker slot and the chance to talk about “Humane DB… Read More » SAP Inside Track #sitMEL – Full Day Event in Melbourne
This is about an error I ran into while fiddling with an SQL query. Since it was not immediately obvious to me what was the cause this makes a good topic for a new post. Read More » Types of NULL