SAP BI/BW

What is SAP Business Planning and Consolidation 11.0, version for SAP BW/4HANA

2017-06-07T02:18:00.004+05:30

What is it? SAP BW/4HANA – The NEXT GENERATION OF DATA WAREHOUSE – has been announced and released for three quarters. I think most of you must be very clear about the selling points and strength of BW/4HANA by now, and you may notice that except all the advantages we have on the new platform, there is one important functionality missing – PLANNING (probably CONSOLIDATION as

The Road to SAP BW/4HANA – Part 2

2017-04-07T07:00:00.000+05:30

In the first part, we looked at the different paths to get to SAP BW/4HANA. Now let’s see which path makes the most sense for a given starting point of a customer’s landscape. One or More Legacy Systems Unless you are a brand new enterprise, your landscape will most certainly contain some databases or systems that are collecting various kinds of data. Now you realize that you need a

The Road to SAP BW/4HANA – Part 1

2017-03-27T19:49:00.000+05:30

One of the most frequently asked questions is how you can get from your current data warehouse landscape to SAP BW/4HANA. At SAP, we realize each of our customers are starting their journey to a modern data warehouse from different places. That’s why we have created distinct paths, complete with distinct services and tools, to help you achieve your goals in the most direct fashion, with the

Share the Knowledge - Optimizing SAP BW on SAP HANA Part 2

2015-02-12T20:34:00.000+05:30

Share the Knowledge - Optimizing SAP BW on SAP HANA Part 2 Via Content in SCN Hi Everyone, This is the second part of the blog Share the Knowledge - Optimizing SAP BW on SAP HANA Part 1 Best Practice # 7: Avoid Issues During Migration by Using Automated Task Lists We were told

Optimizing SAP BW on SAP HANA Part 1

2015-01-12T22:31:00.000+05:30

Optimizing SAP BW on SAP HANA Part 1 Via Content in SCN Hi Everyone, During the TechEd I attended lecture RDP303 - "Master Class for Optimizing SAP Netweaver Business Warehouse on SAP HANA" It was only a 1 hour session but there were many things to learn. The session was aimed at Optimizing SAP BW on

How to optimize Reporting Performance in SAP BI

2015-01-07T22:28:00.001+05:30

How to optimize Reporting Performance Via Content in SCN Introduction We face many challenges in our BI projects in terms of Reporting Performance. Users always expect outstanding performance of our BI reports. No matter what ever we do in the backend (Modeling and Query Designer). I am going to share very important tips & techniques which I have learned through out my experience

SAP Hana Series - 5

2014-10-18T02:21:00.000+05:30

HANA Overview - 5 How is HANA licensed? SAP tried to keep licensing simple with HANA. HANA is available in the Cloud as Infrastructure as a Service (IaaS), Platform as a Service (PaaS) and as an application platform (AaaS), and it is possible to buy all those options now, on a monthly basis, from the SAP Website. For on-premise customers, HANA is licensed in one of two major

SAP HANA Series - 4

2014-10-13T02:19:00.000+05:30

HANA Overview - 4 Is SAP HANA a database, platform, appliance, or cloud? SAP HANA was designed to be a truly modern database platform, and as a result the answer is: all of the above. A modern database should be a database, platform and be available on-premise or in the cloud. SAP has a large installed-base of on premise ERP customers, and the HANA platform supports their needs,

SAP HANA Series - 3

2014-10-08T02:17:00.000+05:30

HANA Overview - 3 What SAP Applications run on SAP HANA? SAP CEO Bill McDermott said “HANA is attached to everything we have”. Almost all the major SAP Applications now run on the SAP HANA platform. This includes the SAP Business Suite (ERP, CRM, PLM, SCM) and the SAP BW Data Warehouse. The BI Suite including BusinessObjects Enterprise, Data Services and SAP Lumira are all

SAP HANA Series - 2

2014-10-03T02:15:00.000+05:30

HANA Overview - 2 Where does SAP HANA come from? SAP built SAP HANA from the ground up, including research from the Hasso Plattner Institute in Potsdam, the acquisition of the IP from the p*Time database, the TREX search engine, BWA in-memory appliance and MaxDB relational database. It has been extended with intellectual property from the Business Objects and Sybase acquisitions with

SAP HANA - Series - 1

2014-09-30T02:13:00.000+05:30

HANA Overview What is SAP HANA? SAP HANA is an in-memory database and application platform, which is for many operations 10-1000x faster than a regular database like Oracle on the same hardware. This allows simplification of design and operations, as well as real-time business applications. Customers can finally begin to reduce IT complexity by removing the need for separate and

Generic Delta Extraction using Function Module along with currency conversion in source system

2014-09-22T01:55:00.000+05:30

Generic Delta Extraction using Function Module along with currency conversion in source system Via Content in SCN Business Scenario: 1. Need to have additional fields from Sales Partner Table (VBPA) for all Order Line Items in Sales Item Table (VBAP) for Sales Order Line Item

10 Golden Rules for SAP BW on HANA Migrations

2014-09-16T01:50:00.000+05:30

10 Golden Rules for SAP BW on HANA Migrations Via Content in SCN This blog is the third in a sequence of blogs. It starts with Licensing, Sizing and Architecting BW on HANA and moves onto 10 Golden Rules for SAP HANA Project Managers. In this piece, I'm going to discuss some tips for making a

2014-09-10T20:49:00.000+05:30

What’s the Difference Between a Classic #SAPBW and #BWonHANA? Posted by Thomas Zurek This is yet another question that I get from all angles, partners, customers but even colleagues. BW has been the spearhead SAP application to run on HANA. Actually, it is also one of the top drivers for HANA revenue. We've created the picture in figure 1 to describe - on a high level - what has

Concepts on BW,Understanding Connections

2014-09-02T02:23:00.000+05:30

Concepts on BW,Understanding Connections Via Content in SCN I have gone through a lot of articles on SCN which speak extensively about integration with BO-BW however, I could not find a document that consolidated and spoke about UNX on Multiprovider SSO manually setup, BICS on BEX issue and the

The HANA Journey: Determining When HANA is Right for You

2014-08-25T02:17:00.000+05:30

The HANA Journey: Determining When HANA is Right for You Via Content in SCN I would like to thank my colleague Robert Hernandez, Director of In-Memory Services, North America for his collaboration and input to this blog. If you're reading this blog, SAP HANA has caught your attention. By now, you've probably heard a significant amount about SAP HANA. It's the next-generation

Standardizing Data Flow Patterns using Data Flow Templates

2014-08-25T02:14:00.000+05:30

Standardizing Data Flow Patterns using Data Flow Templates Via Content in SCN Standardization is a key aspect of SAP BW Layered, Scalable Architecture (LSA), SAP's best practice in Enterprise Data Warehousing. One of the ways to realize standardization in the data staging process is using Data Flow Templates. SAP BW

Where to find information on SAP BW on HANA migrations

2014-08-21T02:22:00.000+05:30

Where to find information on SAP BW on HANA migrations Via Content in SCN I've been part of projects to migrate to BW on HANA recently and one of the things that I noticed was that resources can be fragmented and tricky to find. I thought I'd curate a list of places to go to find information. If I

How to Generage a datasource from a Custom Report in ECC

2014-08-18T02:06:00.000+05:30

How to Generage a datasource from a Custom Report in ECC Via Content in SCN When more analysis on a custom report in ECC system is required, users ask for a bw report that shows exactly the same data with the custom report in ECC. In standard cases, the rational behavior would be to search for business content if there is any corresponding content for the requirement. Most of the time, we can't

Manage big data in SAP BW more cost-effective and with optimized performance using SAP NetWeaver BW Near-Line Storage (NLS) rapid-deployment solution

2014-08-13T02:01:00.004+05:30

Manage big data in SAP BW more cost-effective and with optimized performance using SAP NetWeaver BW Near-Line Storage (NLS) rapid-deployment solution Via Content in SCN Near-line storage is a concept in the big data topic that many analysts are talking about. What is it? Near-line storage is the activity of storing

Major Lessons Learnt from BW 7.30 Upgrade

2014-07-21T01:45:00.000+05:30

Major Lessons Learnt from BW 7.30 Upgrade Via Content in SCN Dear SAP BW-ers, It's about journey when upgrading to BW 7.30 SP05 from BW 7.01 SP07. Whatever written below is purely an opinion and may not be best practice. It has been a painful project yet rewarding since this will enable the BW to be on HANA and

How to handle Year Wise Cubes in a Multiprovider

2014-07-14T01:42:00.000+05:30

How to handle Year Wise Cubes in a Multiprovider Via Content in SCN Applies to: Up to BI 7.0 Introduction After the BW implementation is over in any client, the data from the Source systems will keep on extracting to

Data Functions in Bex Query Designer

2014-07-08T01:40:00.000+05:30

Data Functions in Bex Query Designer Via Content in SCN Hi All, I have made an attempt to explain some of the data functions which can be used as operands when we define formula or Calculated Key Figure 1) COUNT() This data function is used when we would like to display

Some key points about SAP HANA Technology & Architecture

2014-07-03T01:36:00.000+05:30

Some key points about SAP HANA Technology & Architecture Via Content in SCN The term SAP HANA is used for both (in-memory) database and an application platform. SAP HANA is a platform offered as both an appliance and a cloud service. SAP HANA in-memory database is a specialized database with following

FI-AP Data Extraction to BW using 0FI_AP_4, 0FI_AP_6 and 0FI_AP_7 DataSources. Parked Documents

2014-06-30T01:34:00.000+05:30

FI-AP Data Extraction to BW using 0FI_AP_4, 0FI_AP_6 and 0FI_AP_7 DataSources. Parked Documents Via Content in SCN 1 Scope: From the Functional Specs it was derived that Business required reporting on the AP Line Item Data, Transaction Figures and Payment history along with some