DISCLAIMER: this blog describes unsupported and unlicensed use of the SAP HANA software. I describe my personal try-out of a hardware/software combination. It's not in any way meant to be used productively or recommended to use the software in the way I describe. If you loose data, waste life-time, money, your good mood or damage … Continue reading HANA in a pocket, a skull and some dirty hands on Linux
Based on SAP HANA SPS 11 Update 1.6.2017 Retesting the APPLY_FILTER() approach on rev. 112.07 showed that it is now possible to simply hand APPLY_FILTER() an IN condition with a list of integers. This approach for the workaround of the general limitation on multiple input parameter values for scripted calculation views is also shown in … Continue reading On multiple mistakes with IN conditions
Far fetched... A colleague asked me over a year ago (2015 and SPS 9 ... sounds ancient now, I know) whether it is possible to leverage information models in a different SAP HANA instance via SDA (Smart Data Access - look it up in the documentation if you didn't know this yet). The scenario … Continue reading Modelling Learning Double Action or two things I just learned about modelling in SAP HANA SPS 11
Dear SAP HANA aficionados If have not been living under a stone lately and visited the SAP HANA corners of SCN (SAP HANA and In-Memory Computing, SAP HANA Developer Center) recently you surely will have noticed that there is currently one particular person putting in effort, patience and willingness to help others in extraordinary … Continue reading SAP HANA community alert 260416: new moderator aboard
Today's tidbit is one of those little dumb things that happen every now and then and when I think: "Great, now this doesn't work... WTF...?" Usually that's a bit frustrating for me as I like to think that I know how stuff works around here (here, meaning my work area, tools, etc.). So here … Continue reading *click* – *click* – *doubleclick* and nothing happens
Fellow Community members, readers and otherwise interested! Today I share a change in the organisation of this community. Last week I returned the moderator and space editor privileges and the duties that come with those. Lucas, who has done a awesome job as a moderator since he came aboard last year, will take it from … Continue reading Things keep changing around here!
Fresh out of the Christmas/New Year vacation I yesterday received this question from one of my colleagues: Hi Lars I am trying to set up a demo to show MDC at FKOM. I am trying to configure MDC via the Python script method – although I have an issue where I am missing a file … Continue reading HANA dude analyses Python error and this happened next… (plus: something with Andy Warhol)
Dear all Since there had been quite big changes happening to me (which will affect my engagement here on SCN) I thought I pen down a few lines about that. Relocation (again) Looks like I am not the person to stay put in one place for a long time. But after my move from Austria … Continue reading Changes, News and Annoucement
In Quick notes during a fiddle-session I played around with a table that contained all possible values for a date column. To fill it I used a FOR LOOP with an INSERT and a commit every 10000 records. That took 9:37 minutes for 3.652.061 records. That's terrible performance and nothing that needs to be accepted … Continue reading Fiddle riddle – Amazing: stuff gets faster and takes less space!
For a while now I am working as a Solution Architect for the SAP Custom Development organisation. This is the team you'd call when you want custom-built solutions that perfectly fit into your standard solution landscape. My job there is not coding or implementing systems, but rather designing Solutions and turning those designs into commercial … Continue reading Quick notes during a fiddle-session