BW SAP HANA Data Warehousing

SAP CDS View

  Author       : Bala.G.Reddy Company   : Cognizant Technology solutions. Created on: 22.11.2017 Author Bio   I am Bala.G.Reddy working as Senior Associate  at Cognizant Technology Solutions, India. I  joined Cognizant Technology Solutions in 2014 and I have extensively worked on multiple SAP BI implementation and support projects   Summary: In this document I am going to cover the below topics: How to add ABAP perspective in HANA studio How to create …

Read More »

Usage of SAP HANA Exit Variables for a standard reporting scenario

The scope of the document is to show how SAP HANA Exit variables are working for column selection for standard YTD reporting and delta calculation using native SQL. As a result the native SQL statements on generated calculation views work nearly similar as a SAP BW Query. By using HANA Exit variables the Query can be used within SAP BW and natively side by side. Furthermore complex SQL statements can be simplified …

Read More »

Getting Started with BW4HANA -Part 1

Purpose – This is part 1 of series of blog to get started with BW4HANA. In this part we will create a BW4HANA instance from the image deployed by SAP on Cloud Platform like AWS or Azure. Prerequisites – SAP SID. It usually starts with S and is 11 characters for eg-: S0012345678. You can get SID from SAP. SAP Cloud Appliance Library account (link). Fill in the necessary information …

Read More »

HANA Views & SQL – Technical Performance Optimization

BW on HANA can easily enable SQL data access for third party tools, using the “External SAP HANA View” flag to automatically generate Calculation Views out of BW objects. However, Consuming multidimensional BW scenarios through relational SQL paradigm can lead to quite some issues with performance. This blog is about a few basic technical tips, which help to enhance runtime performance. Tested with BW 7.5 on HANA SPS 10, 11 …

Read More »

Where Used for Calculation Views in BW

Hi All, This blog describes a way, to find out where a calculation view is used within BW. In our case such a where-used was needed, since we wanted to get rid of ‘old’ calculation views, but wheren’t sure if they might still be in use somewhere. To start off, in the HANA Modeler of the HANA Studio the WhereUsed function shows which native HANA Objects make use of the …

Read More »

How to get to P_R_REQUEST information in BW HANA Transformation using AMDP

Update(21.07.2017):  After thorough testing and communicating with SAP I can say that it works when DTP is set to “Get All new Data Request by Request”. It is caused by an error in SAP which is not able to sort the result accordingly. You should install OSS Note 2467323 to solve AMDP Field routines otherwise they provide wrong results. Side effect of the OSS Note is that SAP does add Technical …

Read More »

Operational Reporting using SAP BW Virtual Cube in SAP ECC on HANA

In this blog, I’m going to explain my recent implementation in SAP ECC HANA. The business requirement was to develop an Operational Report based on live data and usable in SAP BusinessObjects Analysis for Office to analyze Workflow with Purchasing data. After a first business requirement analysis, one point remained opened: After the data extraction from the HANA DB, how to determine in real time the workflow approvers using the …

Read More »

Procedure to create Composite Provider

Procedure to create Composite Provider Go to the Info Area and select the option to create composite provider     2. Provide appropriate name       3.You will be asked to select one of the ODS/ ADSO.               4.  After adding the provider name, next will be the other provider which you need to join.     5. After selecting the second provider, …

Read More »

Procedure To Create ODS View IN BW- HANA/HANA Studio

Procedure To Create ODS View IN BW- HANA/HANA Studio 1) Create a Data source in BW on HANA. (Assuming you have appropriate data source (Here we are using Flat File). 2) Go to HANA Studio. 3) Create ODS view in HANA Studio. (i.e. Same Info provider area name which you had created on BW on HANA as marked in the box. 4) Provide appropriate name. 5)Provide the Data source name which you …

Read More »

Step By Step Procedure to Create Advance DSO in Hana Studio from ECC To BW To Hana Studio

Create Extractor in ECC Use Tcode RSO2 for creating extractor in ECC system     3) Provide a name, now we are taking Master Data Attributes here.     4) Click Create, you get following screen, We are using View/Table here.     5) Click on Application Component, Select appropriate source ( e.g., For Sales).     6) After selecting provide all description and screen will look something like this. …

Read More »