SAP HANA data warehousing foundation

SAP SQL Data Warehousing with HANA

A growing community of customers and partners is using the SAP HANA in-memory platform for data warehousing purposes for a long time. In recent years, several innovations occurred in this area. Especially the introduction of SAP HANA extended application services advanced version (XSA) and SAP HANA 2.0 changed the way of your traditional software development to a modern and agile data warehouse development in a DevOps style. At SAP TechEd …

Read More »

Introducing the NDSO: Part Two – NDSO services (Delta Capabilities)

Motivation / Introduction   In part one I have briefly demonstrated the creation of a native DataStore Object (NDSO) using the EDW Template project of the Data Warehouse Foundation. One of the key tasks of a Data Warehouse is the consolidation and cleansing of data from various sources. Depending on the complexity of the scenario and the degree of heterogeneity of the underlying data sources the data is processed in …

Read More »

Introducing the NDSO: Part One – How to create a NDSO

Motivation When establishing an Enterprise Data Warehouse (EDW) there are two fundamental approaches which can be taken. Either an application driven approach can be chosen by opting for a solution which covers all tasks to be performed in an EDW out-of-the-box or the data modelling is natively performed directly on the database with a collection of separate tools to support the deployment and operations of an EDW. With SAP BW/4HANA …

Read More »

BW DSO in Native HANA DataWarehouse with CDS and FlowGraph

As you already know, SAP Native HANA DataWarehousing Foundation tools are introduced With HANA SP 10, then recently with HANA 2.0 SP 2, Native DSO object and DW monitor tools are available in Web IDE to model the data effectively. With this feature, customers can leverage the most popular object in SAP BW in HANA DataWarehouse which is Advanced DSO. The loading and activation process of NDSO is very similar …

Read More »

SAP HANA Data Warehousing Foundation / HANA SQL Data Warehouse

The SAP HANA Data Warehousing Foundation product provides specific data management tools to support (large scale) HANA SQL Data Warehouse use cases.       The SAP HANA Data Warehousing Foundation (DWF) product provides the following tools & solutions: Data Distribution Optimizer (DOO)  – XS-Classic The Data Distribution Optimizer (DDO) provides the capability to plan (simulate), adjust and analyze landscape reorganizations for SAP HANA scale out systems (BW4/HANA, BWonHANA, HANA SQL DW, Data Mart, …

Read More »

Fun with Dates (M_TIME_DIMENSION): WorkDays, Holidays , Federal holidays, Weekly holidays etc

In this blog, I will be working with M_TIME_DIMENSION to make it easier to calculate number of working days between two dates or number of holidays between two dates etc Project Requirement: Calculate number of work days between two dates. Issue To calculate all the federal holidays as well as weekly holidays (USA specific) To calculate number of work days Solution Presumption: M_TIME_DIMENSION  is already created. Alter M_TIME_DIMENSION  add column Holiday below script …

Read More »

HANA Data Warehousing Foundation (DWF), Data Distribution Optimizer (DDO) and Data Life Cycle Manager (DLM)

HANA Data Warehousing Foundation (DWF)  HANA Data-warehousing Foundation  provides data management tools to manage data better in a Scale out HANA Landscape and complements the data-warehousing products like SAP BW and Native HANA DWH (also Hadoop and HANA Vora scenarios). Major use cases could be: Data Warehousing – SAP BW HANA and Native HANA scenarios, including mixed scenarios. These in a multi-tenant / Scale out system over time of multiple …

Read More »

Simple Data Lifecycle Management using Deletion Bin

Overview I thought I would share this experience with screenshots on how simple it is to perform some minimalist HANA data footprint control using the SAP tool Data Lifecycle Management (DLM)  which comes as a tool in the HANA Data Warehouse Foundation (DWF). I do not have SAP IQ or Data Tiering, and my DLM policy is to simply delete/destroy the data when it gets to a certain age, so …

Read More »

HANA Modelling – Consolidated Best Practices for better Performance

Hi All, Just putting up and writing down all the consolidated best practices for HANA modelling that we witnessed for better performance. Try using Star-join instead of joining multiple nodes of master data/dimensions to a fact table of measures. Try to use Calculation view for all the modelling and design that involves complex calculations and data massaging. For master data/attribute view types use – Dimension For mulit-dimensional purpose/OLAP scenarios – …

Read More »

Connecting To SAP HANA via PHP and ODBC

We’ve recently been so busy in the office with all things BI on HANA that it’s been a while since I had an opportunity to blog. Wow, how the world is changing, and how quickly too! I was messing about last week with some custom views to support a direct Lumira connection and thought it would be interesting to see how difficult it would be to connect to SAP HANA …

Read More »

Do you want to Get SAP Courses?

Get SAP Courses and Training, Videos, Other Useful Resources
Join Now
Written by SAP Expert TEAM.
close-link
New Registration