Populate Dates Between Start & End Dates

Requirement

This blog is intended to show how we can fill the dates if dates are saved in two columns as StartDate or EndDate ( Refer Sample Data of Date Rang Table Screenshot).

We have one Transaction table which is having data for each day (Example: PGI_DATE).

In another table, data is entered by date range.

Tuning SAP IQ NLS in SAP BW on HANA and BW/4HANA

Introduction

In any SAP BW on HANA and BW/4HANA implementations, customers use an NLS (Near Line Store) solution to offload and archive data from the main system.  The offering from SAP as well as a few partners uses SAP IQ as the database for the NLS solution.  Invariably, situations arise when performance against data in the NLS system just seems slower than it should be.

The focus of this blog is to point you in the different directions that can be at the root cause of any performance issues.  As always, we must be prepared to change our expectations.  On countless occasions, I have had customers demand that the NLS system perform at the same level as the HANA system.  That is just not realistic and should never be expected.  SAP HANA operates on data that is in-memory and was designed to be an in-memory platform.  SAP IQ is a general purpose database that was designed for disk based storage, albeit highly optimized.

SAP Data Warehouse Cloud – Connecting local systems like SAP BW/4HANA

Intro

The Data Warehouse Cloud (DWC) comes out-of-the-box with the option of uploading your own data in the form of flat files. This is sufficient for smaller demo scenarios, but for serious use the requirement to connect data from existing systems arises very quickly.

The connection of own systems takes place via Smart Data Integration (SDI), which is an integral part of the Data Warehouse Cloud. A data provisioning agent then creates the bridge to the SDI of DWC on premise.

Since the DWC is tenant-based software-as-a-service solution, the SDI component cannot simply be installed on the DWC side or configured using the usual means. Instead, DWC also offers the option of connecting local systems “as-a-service”, which only needs to be connected to the local components accordingly.

Error Message “Unkeep Attribute could not be removed” for SQL Queries against External SAP HANA Views with Non-Cumulatives

Have you ever tried to expose a BW query with non-cumulative key figures as External SAP HANA View? Then, you probably bumped into the error message “Unkeep Attribute could not be removed”. This blog explains why the error message is raised and how it can be avoided under certain conditions.

The power of the HANA-optimized Business Content (SAP BW/4HANA) – Example FI-AA

In this blog post I want to demonstrate you the power of the HANA-optimized Business Content and how it can help to speed up your BW/4HANA implementation.

For this, let us have a closer look together into the business content area of Fixed Asset Accounting – as an example.

Handling Non-Cumulative Measures in HANA Calculation Views with Multiple Cartesian Transformation and Single Conversion Matrix

Introduction

The COPA, the forecast and many other S4HANA, ECC and legacy tables contain hundreds of measures in their record structures. This format is not suitable for efficient processing in BI front end tools; e.g., WebI reports.

Calculation Engine Plan Operators (CE Functions) Vs SQL Code

In this blog, I’m going explain few CE Functions and also the alternative solution for CE Functions using three tables with sample data.

The reason why I’m talking about this topic is, still some people are thinking about CE Functions, so I just want to clear the myths about CE Functions. CE Functions are alternative to SQL Script. We have total 13 CE Functions, but out of 13 , we may need CE_VERTICAL_UNION CE Function (this is used to combine the columns of different tables though they don’t have any relation), because we don’t have simple alternative solution in SQL.

SAP HANA and BW Mixed Scenarios Architecture

What is a Data Warehouse Mixed Architecture?

It’s an SAP best practice for modern data warehousing. Simply put, it’s a data model that is implemented at the same time in SAP BW and native SAP HANA.