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.

Proposed Architecture for File Transfer into SAP Private Cloud

Options Evaluated for SFTP Integration

1. Integration Suite with SAP S/4 SFTP Folder (via Cloud Connector)

• Mechanism:
• Configure the file server as a target in the SAP Cloud Connector.
• SAP Cloud Connector acts as a reverse proxy, routing SFTP traffic securely to the mapped directory in the SAP S/4 system.
• Pros:
• Low cost; leverages existing components.
• Secure and scalable.
• Cons:
• Adds configuration complexity.
• Slight latency due to indirect communication.

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. 

Triggering SAP Build Process Automation Processes from SAP Cloud Application Programming (CAP) Apps

In this blog post, we'll explore the different methods to trigger SAP Build Process Automation (BPA) processes from a SAP Cloud Application Programming (CAP) application. We will cover triggering via destinations and Event Mesh.

Triggering via Destinations

Prerequisites

Before starting, ensure you have:

SAP Cloud ALM: Empowering Efficient Application Lifecycle Management

As organizations increasingly adopt cloud-based technologies, managing the lifecycle of applications has become more critical than ever. SAP Cloud ALM (Application Lifecycle Management) is SAP’s response to this demand—a streamlined, cloud-native solution designed to simplify and optimize the implementation and operational processes of SAP applications.

This article provides an overview of SAP Cloud ALM, its key features, benefits, and how it compares to traditional tools like SAP Solution Manager.

What’s New in Job Monitoring for SAP Cloud ALM

SAP Cloud ALM continues to evolve as an indispensable tool for managing and monitoring SAP landscapes. The latest updates to Job Monitoring bring significant enhancements, enabling organizations to efficiently manage automated processes, improve transparency, and streamline operations.

This blog explores these updates in depth, offering insights into how they can empower businesses to optimize their IT operations and adapt to evolving business needs.