The architecture I’m sharing here isn’t the only way or necessarily the best approach for every scenario. Rather, it’s the solution I’ve found effective and applied successfully across multiple projects. Why did I choose a Side-by-Side Architecture? I opted for this architecture mainly because it allows me to extend the standard functionalities of SAP S/4HANA […]
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 […]
In this blog post, I will demonstrate how to send data to SAP HANA Cloud using the Integration Suite. Additionally, I will explain how to handle nested JSON data and distribute it across multiple tables utilizing parallel multicast and mapping functions. Problem Statement: We have exposed an API endpoint through which we push data in […]
In this Blog, We’ll explore how to consume data from SAP Datasphere through ODBC (Open Database Connectivity) and Visualize the data in Qlik Sense which is one of the leading Data Visualization Tools. Why SAP Datasphere over others? SAP Datasphere allows seamless connectivity with a wide range of data sources, including on-premises and cloud-based systems. […]
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 […]
Introduction Use SAP SQL Data Warehousing to build calculation views and other SAP HANA Cloud HDI objects directly in SAP Datasphere run-time database and then exchange data between HDI containers and SAP Datasphere spaces. SAP SQL Data Warehousing can be used to bring existing HDI objects into SAP Datasphere environment, and to allow users familiar […]
In SAP Implementation one of the most critical aspects is reporting. As SAP data is being integrated with many other Non SAP system’s to create reports in systems such as looker, this blog explores the option of how SAP can be Integrated to GBQ using GBQ Connector. This blog explores the option of data transfer […]
As we see more and more customers adopting the cloud based development methodologies in SAP especially with customers adopting XS Advanced and SAP HANA Cloud as their data warehousing or data mart solution, there was need to lay down some best practices for source code management and version control. This blog post talks about some […]
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 […]
SAP HANA SAP HANA is an in-memory, column-oriented, relational database management system developed and marketed by SAP SE. SAP HANA Security Sap Hana Security is protecting important data from unauthorized access and ensures that the standards and compliance meet as per the security standard. User Type in SAP HANA Depending on the different security policy […]
