About Sefan_Linders

Sefan_Linders

Suppose you want to access two SAP Datasphere spaces using the same SQL user, how do you create such a user? That’s what we will go through in this blog post.As an example, we have two spaces as the below screenshot shows. We will create a SQL user t...

Sefan_Linders

You want to partition a Transformation Flow in SAP Datasphere, to reduce the memory consumption? That’s what we discuss in this blog post and provide the Python code to realize this. It makes use of the SAP Datasphere Command Line Interface (CLI) to ...

Sefan_Linders

In the diagram below you can see three departments: Sales, Marketing and Development, ordered as such. They are not ordered alphabetically, but according to an alternative sequence. SAP S/4HANA allows you to create hierarchies like that, where the no...

Sefan_Linders

In our previous blog, we covered the basics of creating a Hierarchy with Directory. Now, we're taking a step further in this blog by enhancing our model with an extra node type, language-dependent texts, and time-dependency, both for the hierarchies ...

Sefan_Linders

In the previous blog, we provided an overview of the new features introduced with the Hierarchy with Directory. In this blog, we'll guide you through creating a basic Hierarchy with Directory, starting from scratch and progressing to the data preview...

Sefan_Linders

@jannis that's hard to say without seeing the actual models you are using. Did you try creating a new Analytic Model?

Sefan_Linders

Hi @RajeshG1227 what version of the DP agent are you running? (2.7.6.1 is what you should go for at this time, which is the latest version)

Sefan_Linders

@swatisonawane then you are logged on with the wrong user. You have to log on with the space database user to grant select on a view to the target SQL user.

Sefan_Linders

Hi @albertosimeoni, no, this is not possible for SAP Datasphere SQL users

Sefan_Linders

@attila_kiss no update on that. You can work around it by first joining the node table on itself so that you identify the "dimension technical name" parent for each "dimension technical name" child (which is the dimension technical name you already h...

User Statistics

User Activity

Create a SQL user with access to multiple spaces in SAP Datasphere

Transformation Flow partition generation with SAP Datasphere CLI

Order siblings in a Hierarchy with Directory with SAP Datasphere

Modeling an advanced Hierarchy with Directory in SAP Datasphere

Modeling a basic Hierarchy with Directory in SAP Datasphere

Re: Modeling a basic Hierarchy with Directory in SAP Datasphere

Re: How to add Snowflake as a source for SAP Datasphere or SAP HANA Cloud

Re: Create a SQL user with access to multiple spaces in SAP Datasphere

Re: Create a SQL user with access to multiple spaces in SAP Datasphere

Re: Modeling an advanced Hierarchy with Directory in SAP Datasphere