In the second quarter of 2022, SAP Analytics Cloud (SAC) introduced the Optimized Design Experience, marking a significant advancement in data visualization capabilities. This update presents users with two distinct layouts tailored to meet diverse analytical needs: Canvas Layout: Provides users with precise control over the placement and size of dashboard elements. Responsive Layout: Designed […]
Data and Analytics
Consuming data from SAP Datasphere into Power BI via ODBC connector
I wanted to share my proof of concept about consuming data from SAP Datasphere into Power BI via ODBC connection (Open database connection) Required: Datasphere part: Login into Datasphere -> Space Management -> Choose the space and select Edit. Click Create and Make sure that you have enabled Expose for consumption by default Copy Database […]
How to Connect SAP HANA Calculation View to SAP Analytics Cloud (SAC)
1. Introduction 1.1. Background Jeff possesses extensive expertise in SAP BW, SAP BW on HANA, SAP BW4HANA, Native Hana, Business Objects, Data Services, SAP DataSphere, and SAP Analytics Cloud (SAC). He is currently based in Brisbane, Australia. 1.2. Purpose of this Post In my role as an SAP Data Analytics Consultant, my experience with Cloud […]
Use Data Export Service to Replicate Data Between SAP Analytics Cloud Tenants
Purpose This blog describes how to replicate model data between two SAP Analytics Cloud systems using Data Export Service within an OData connection. This workflow is very suitable for the movement of data from production to development environments or vice versa, and for models that contain large volumes of data. Note that a pre-existing model […]
Expose OData services/URL for Calculation View in SAP HANA
In this blog post, we will learn how to build the XSODATA services used to expose our data model to the user interface. This tutorial is designed for SAP HANA on premise and SAP HANA, express edition. It is not designed for SAP HANA Cloud. I have used SAP HANA XS Advanced (SAP Web IDE). […]