Introduction: In today’s data-driven world, having real-time insights at your fingertips is crucial for making informed business decisions. SAP Data Sphere is a cloud-based solution designed to integrate, model, and analyze data from various sources. In this blog, I’ll show you how to set up a trial account for SAP Data Sphere and create a […]
Data and Analytics
Importance of Currency Conversion in SAP Datasphere
Accurate currency conversion ensures that financial statements reflect true value, enabling better decision-making and compliance with regulatory requirements. Without effective currency conversion, businesses may face issues such as financial discrepancies, inaccurate forecasting, and challenges in performance evaluation across different regions. “Twenty-four-hour global nature of currency markets, exchange rates are constantly shifting from day to day […]
Connecting SAP Analytics Cloud to Power BI Using Azure Data Factory
Introduction Many companies are using SAP Analytics Cloud (SAC) for planning alongside Power BI for reporting. However, users often request to utilize SAC planning data within Power BI. This integration can be challenging due to differences in data handling and capabilities. If you are facing similar demands, our blog provides a practical solution to this […]
Integration Between SAP Datasphere and SAP Analytics Cloud
In this blog, I want to provide the steps we followed to create an OData Service Connection to send data from Datasphere to SAC. By integrating Datasphere Actuals into SAC, we lay the foundation for strategic decision-making, driving business growth and agility. Sending Data from Datasphere to SAC via OData Service Our goal for this […]
Unveiling SAP Analytics Cloud Performance Analysis Insights for Optimal Performance
In a dynamic landscape dominated by data-driven decision-making, monitoring your performance is crucial. And if you learn how to strengthen data management practices with respect to your performance, your business is going to thrive and avoid pitfalls. When it comes to SAP Analytics Cloud (SAC), ensuring peak performance isn’t just a matter of preference—it’s a […]
Responsive vs. Canvas in SAP Analytics Cloud with Optimized Design Experience
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 […]
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). […]