Mastering SAP BW to Snowflake Migration: Best Practices and Key Considerations

The ever-expanding data landscape within modern enterprises demands a resilient data infrastructure that facilitates efficient analysis and informed decision-making. In response to the growing complexity, businesses are increasingly exploring alternatives to traditional data warehouse solutions, with Snowflake, a cloud-based data warehouse, emerging as a compelling migration target. This exploration delves into the crucial aspects of […]

Flattening SAP Dimension Hierarchy using a Table Function

In this blog, we will understand the approach of utilizing SAP Hierarchies in Visualization tools like Power BI, Tableau, and others.

Drill Through from BPC to BW by using Hierarchy members

In this blog, I will explain the issue caused during Drill-Through from BPC to BEx when we pass Hierarchy Node variable values. Background We had a requirement to configure Drill Through from the EPM report to a BEx query. To fulfill this requirement we followed the SAP document ‘How to.. Configure Drill Through Functionality’ and […]

Loading JPY Currency Amount in SAP BW

Implementing Currency Amounts Via DB Connect Data Source in SAP BW We were facing an issue in the BW report where JPY currency amounts were displaying 100 times more than its actual value in the source. The source of data was the SQL database via DB connect. We mapped the amounts to an info object […]

Tracking Inventory Ageing powered by S/4 HANA

Understanding the concept of Inventory Aging The foremost need is to understand what is inventory aging and how it affects our business? In simple terms: Inventory Aging indicates how long a product has been hoarded in a warehouse. Inventory Aging is of utmost significance in the food industry along with others, where consumable goods which […]