One of the best techniques to achieve code-to-data paradigm, allow developer to write more complex logic which is not possible with simple views in HANA. This helps us to squeeze the best performance out of HANA DB. This is DB programming language. SQL script is a collection of extensions to SQL (DDL. DML, DQL, DCL). […]
SAP HANA
MDG DQM: Employing rules in central governance & mass processing in S/4 HANA
The blog provided a step by step overview of how to create a basic rule in DQM, enable it for data quality evaluation and generating evaluation scores on the in the system for product master. In today’s data-driven landscape, enterprises are increasingly recognizing the significance of maintaining accurate, reliable, and consistent master data to extract […]
SAP HANA Database Creation from SAP BTP
Creation of SAP HANA Database Instance in SAP BTP 1. Open SAP BTP Cockpit and click on subaccount. 2. Click on Instances and Subscriptions and then click on create button. 3. Select Service as SAP HANA Cloud and Plan as tools. 4. SAP HANA Cloud is now subscribed. 5. Click on Security -> Users and […]
5 shades of input parameter types in calculation views
Introduction Anyone who has made a jump into the development of HANA native objects will come across graphical Calculation Views (CV) very soon. On the one hand, they offer easy handling because they work with very few basic elements (projection, union, join, aggregation and ranking). On the other hand, they offer high processing speed because […]
Custom Fields and Logics – Create and Capturing the Changes into Transport Request
Custom fields and logics are strong tools that enable users to modify software systems to meet their unique requirements, increasing efficiency and functionality. Custom fields and logics are frequently implemented using the software system’s administration interfaces or configuration tools. Without needing to know programming, users with the proper permissions can use these interfaces to add, […]
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 […]
Building Expertise in SAP Database Administration: C_DBADM_2404 Certification Path
The C_DBADM_2404 certification helps experts grow in SAP HANA Database Administration. It teaches more than basic skills, requiring real work in an SAP HANA team. This certification means you can manage the SAP HANA database well. You will make sure the data is safe and easy to use, improving IT tasks. Getting the C_DBADM_2404 certification […]
SAP BW on HANA: A Practical Approach to E_HANABW_13 Certification
Unlock your potential with our guide to achieving E_HANABW_13 certification – your pathway to mastering SAP BW on HANA.
Crack the C_HANATEC_19: In-Depth Preparation for SAP HANA Certification
Preparing for the C_HANATEC_19 certification exam requires more than just casual preparation—it demands a steadfast commitment, unwavering concentration, and effective study methods. Administered by SAP, this certification serves as a testament to one’s expertise in SAP HANA technology and database administration. To assist you in navigating this rigorous journey toward certification success, we’ve meticulously curated […]
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 […]