About richard_bremer

richard_bremer · 11-27-2014

One of the most stupid things I've done in my life was to create SAP Note 1651055 (SAP Service Market Place login required) and the script attached to that note. I'm very pleased to say that today I've released a new version of that script, and that ...

Copying users in SAP HANA · 10-13-2014

Hi all,as most readers will be aware, database users in SAP HANA are non-copiable entities. The most important reason for the lack of a generic user copy mechanism is in the course of a user copy, all privilege and roles assignments shall be copied a...

richard_bremer · 04-27-2014

Recently an interesting question reached us from a customer - it was one of those questions that you might not have an immediate answer for and which thus triggers a tiny bit of R&D.The storyThe question was this: "SAP recommends that the SYSTEM user...

richard_bremer · 04-09-2014

In a discussion related to the How-To Guide with Role Templates for SAP HANA, the question was raised which privileges are needed for BI users to consume data from SAP HANA. Since this is a good question and I'm not really aware of a complete answer ...

richard_bremer · 08-04-2023

Hello Avik, table grouping is not exposed in the ABAP layer, and grouping alone would not even be useful here - because the thing that counts is the actual table/group distribution across the physical database nodes. Before you ask: also this physic...

richard_bremer · 08-03-2023

Hello Avik, regarding your question about OLTP-queries and table joins: When operating S/4HANA on HANA scale-out, it's not our goal to avoid ALL joins between tables on different nodes, but to minimise such joins and avoid such joins in expensive s...

richard_bremer · 09-29-2016

Hi Roger,please understand that we will not discuss licensing-related questions on SCN. You may want to refer to SAP Note 1704499 which explains license measurements based on memory utilization, also applicable to extension nodes.Please check with yo...

richard_bremer · 05-09-2016

Hi Kevin,basically, both answers are correct: if you take a given HANA scale-out setup for BW, the extension node concept allows you to load more compressed data into that setup than traditional BW sizing allows. You view this as a lowering of the co...

richard_bremer · 03-08-2016

Hello Andreas,thanks for your response here - and confirming that the problem is not as theoretical as one might intuitively assume.The procedure needs to be created in "definer" mode - which means that regardless of who executes the procedure (the i...

User Statistics

User Activity

New and final version of backup script

Copying users in SAP HANA

Reactivating the SYSTEM user when no User with USER ADMIN is Available

Overview: Security Considerations for BI End Users Reporting on SAP HANA

Re: Running SAP S/4HANA cloud, private edition at the largest scale

Re: Running SAP S/4HANA cloud, private edition at the largest scale

Re: More Details - HANA Extension Nodes for BW-on-HANA

Re: More Details - HANA Extension Nodes for BW-on-HANA

Re: Reactivating the SYSTEM user when no User with USER ADMIN is Available