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 […]
SAP HANA Cloud
Nested JSON to SAP HANA Tables with SAP Integration Suite
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 […]
Connect & Visualize: SAP Datasphere with Qlik Sense
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. […]
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 […]
SAP Datasphere – Enable SAP HANA Development Infrastructure (HDI)
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 […]
Data Transfer to GBQ From S/4HANA Private Cloud
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 […]
Git Sequencing Strategy and Best Practices: SAP HANA XS Advanced and/or SAP HANA Cloud
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 […]
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 […]
SAP HANA DB Authorization concept
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 […]
SAP HANA Development with SAP Cloud Application Programming Model using SAP Business Application Studio
Goal: This Blog explains how you can leverage native SAP HANA development artifacts with CAP. In particular we look at the use of Calculation Views, inside Cloud Application Programming (CAP) Applications. This includes OData access to Calculation Views. Solution: Pre-requisites: Set Up SAP Business Application Studio for Development Launch the Business Application Studio (BAS) and […]