A common inquiry # Last week I got two very similar question from colleagues in the consulting teams: " […] We created a user (“john” with select / execute privileges on “SYS_BI & SYS_BIC” schema. User can access data… Read More » SAP HANA DBA Ninja vs. GEIGOKAI
I just came across SAP note 1850112 - Changes to technical properties row/column store again and found it to be an interesting and reassuring collection of design decisions taken over time. Read More » Changes to technical properties row/column store
I’ve mentioned it before in a couple of threads and today I am happy to officially and proudly announce: There is now a pack of paper with my name on, available and waiting to be bought by you. Read More » Book Announcement: SAP HANA Administration
Based on revision 81 of SAP HANA Database Just shortly before my vacation starts I thought I leave you with another pearl of knowledge… *cough*cough* Don’t expect suspense or a proper three act structure - it’s just one… Read More » Quantum mechanics in SAP HANA?
Seth Godin put it so nicely: Seth’s Blog: Analytics without action “If you’re not prepared to change your diet or your workouts, don’t get on the scale.” meaning that if you don’t want to actually do something with the… Read More » Is this the gym you pay for but never actually show up?
Not sure you knew this already, but starting with SPS 8 (seemed to work with Rev. 74 as well), SAP HANA comes with an option to have an IDENTITY column in column store tables. Read More » Quick note on IDENTITY column in SAP HANA
Based on SAP HANA revision 74 of SAP HANA Database »> update 09.02.2016 «< If you are trying to work on a similar problem, please make sure to also review the solutions posted in discussion Fetch the first record with… Read More » Of groups of serial shoppers…
Based on HANA revision 70 of SAP HANA Database A question came up about timezone handling in SAP HANA. As you might know SAP HANA offers functions to deal with local time as well as with UTC based time and provides the… Read More » You got the time?
Let’s do this quick and painless! From SPS 7 (rev. 70.00) SAP HANA doesn’t automatically create concatenated attributes for multi-column-joins anymore. BANG! There you go. Just asked for it (Looking for more info on… Read More » SAP HANA double-0 revision in “A secret present"
Another half year passed and another SAP HANA SP has just been released. SAP HANA 1.0 SPS 7 is out in the wild as revision 70.00 (double zero revision, yes Moneypenny 😉 ) and a lot of things had been changed, added and… Read More » HANA SPS 7 first dazzling highlights