SAP Analytics Cloud & SAP Datasphere Combined to the rescue.... (Drill Down in SAP Analytics Cloud)

I have been using SAP Analytics Cloud now for a few years and yes - there are some really impressive features coming up in the next couple of months, but there is one of those features that I think is still missing in SAP Analytics Cloud (and has been missing for quite some time), so I decided to look into some options and would like to show in the next couple of days, how this feature could get implemented using SAP Analytics Cloud and SAP Datasphere combined.

I am talking about the option to do a simple Drill Down navigation as part of SAP Analytics Cloud Charts or Tables, similar to what is possible in Analysis Office or other BI tools.

Today it is possible to perform a Drill Down navigation (Figure 1), but that does require a hierarchy being defined in SAP Analytics Cloud.

Consuming Data from Azure Data Lake Storage to Datasphere

Prerequisites: 

• Access: Ensure access to both SAP Datasphere and ADLS. 
• Azure Credentials: Have the ADLS storage account name, key, or other authentication methods ready. 

Steps: 

• Login to SAP Datasphere: 
• Access your SAP Datasphere instance via the web browser. 
• Navigate to Connections: 
• Go to the Connections section from the main menu. 

SAP Datasphere – How-To integrate Open SQL Procedures in a Task Chain

Introduction

Within SAP Datasphere a task chain is a structured sequence of tasks or operations designed to be executed in a specific order or concurrently. It automates the process of running multiple related tasks, ensuring that they are executed in a predefined sequence or parallel, depending on the requirements. Such objects can be Remote Table Replication, View Persistency, Intelligent Lookup, Data Flow, Replication Flow and Transformation Flow runs.

SAP Datasphere now allows also the integration of SQL Procedures directly into Task Chains. To achieve this, you start creating a SQL Procedure within the underlying SAP HANA database. Once the procedure is created, it can be incorporated into your Task Chain. This guide provides a quick overview of the necessary steps and considerations for this process.

Exploring Data Access Control: Ensuring Consistency from SAC to Datasphere and Back - Blog 1

Introduction

Welcome to the first segment of this two-part series. In this introductory blog, I want to provide an overview of the following key aspects in relation to data access control in SAC and going from SAC to Datasphere:

• What is Data Access Control (DAC) in SAC?
• The different type of DACs - dimension based and role based
• Benefits & drawbacks for both dimension based and role based controls
• Which Type of Data Access Control Is Best for Different Situations

Set up connection between SAP C4C (Sales Cloud) and SAP Datasphere

To connect SAP Cloud for Customers (Sales Cloud) with SAP Datasphere or SAP Analytics Cloud, there are two options available. Use remote tables or load data via Data Flows.

With data flows you might have less options, that is why we recommend to use remote tables.

1. Option with remote tables

Within SAP Datasphere, go to connections.