SAP BW Info

How to remove special characteristics while loading data into SAP BW

2014-07-06T01:51:00.001+05:30

Function module to remove special characteristics while loading data into SAP BW from different sources.

* Create ZSTRING OF LENGH "25O" AND TYPE "CHAR".
* Create STR_IN and STR_OUT with reference to ZSTRING.

FUNCTION < >.
*"----------------------------------------------------------------------
*"*"Local Interface:
*" IMPORTING
*" REFERENCE(STR_IN) TYPE Z_STRING
*" EXPORTING
*" REFERENCE(STR_OUT) TYPE Z_STRING
*"----------------------------------------------------------------------
CONSTANTS:
cc_okchar(59) TYPE c VALUE ' !"%&''()*+,-./:;<=>?_0123456789ABCDEFGHIJKLMNOPQRSTUVWXYZ'.

DATA:
lc_okchar1(72) TYPE c,
lc_okchar2(59) TYPE c,
lc_okchar(131) TYPE c,
l_d_offset LIKE sy-index,
ls_string TYPE Z_STRING,
li_strlen TYPE i.

* Get the list of allowed characters.
CALL FUNCTION 'RSKC_ALLOWED_CHAR_GET'
IMPORTING
e_allowed_char = lc_okchar1
e_default_char = lc_okchar2.
IF sy-subrc IS INITIAL.

* No error .. set the Ok Char variable
CONCATENATE lc_okchar1 lc_okchar2 INTO lc_okchar.
CONDENSE lc_okchar NO-GAPS.
ELSE.

* Error ... Just use the value in the constant.
lc_okchar = cc_okchar.
ENDIF.

ls_string = STR_IN.
CONDENSE ls_string.
TRANSLATE ls_string TO UPPER CASE.

* Remove initial characters that can cause problems: !, #, ?, etc
IF ls_string(1) = '!'.
ls_string(1) = ' '.
ELSEIF ls_string(1) = '#'.
ls_string(1) = ' '.
ELSEIF ls_string(1) = '?'.
ls_string(1) = ' '.
ENDIF.

* Get the length of the string being processed.
DESCRIBE FIELD ls_string LENGTH li_strlen IN CHARACTER MODE.

* Process string and remove unwanted characters
DO li_strlen TIMES.
l_d_offset = sy-index - 1.
IF ls_string+l_d_offset(1) CO lc_okchar.

*Character allowed, do nothing
ELSE.
ls_string+l_d_offset(1) = ' '.
ENDIF.
ENDDO.

str_out = ls_string.

ENDFUNCTION.

SAP Web Intelligence 4.0 SP5: SAP BW Connectivity - Introduction

2013-04-10T16:29:00.001+05:30

SAP HANA Information & Documents

2012-10-25T12:59:00.000+05:30

SAP HANA Information and Documents

Data Aquisition Techniques in SAP Netweaver BW BI

2012-06-27T17:37:00.000+05:30

Please check: Data Aquisition Techniques in SAP Netweaver BW BI

Step by Step on Changing ECC Source Systems without Affecting Data Modeling Objects in SAP BW

2012-06-21T22:13:00.000+05:30

To change source system in BW without impacting objects developed in BW system.

Please check: ECC source systems on SAP BW environment without impacting the Data modeling objects built in the SAP BW system.

SAP BUSINESSOBJECTS BI 4.X - SYSTEM LANDSCAPES

2012-01-19T14:51:00.001+05:30

SAP BUSINESSOBJECTS BI 4.X - SYSTEM LANDSCAPES

The SAP BusinessObjects BI Solution Architecture is based on a set of customer landscape patterns. To start leveraging the material you should use the introduction and see which of the available landscape types is matching your own overall landscape.

SAP BusinessObjects BI 4.0 Solution Architecture - System Landscape Overview

The SAP BusinessObjects BI Solution Architecture is based on a set of customer landscape patterns. This presentation outlines the different landscape options and should be used as a start to explore further the additional material.

SAP BusinessObjects BI 4.0 Solution Architecture - System Landscape Type 1

This presentation provides an overview on the SAP BusinesObjects BI 4.0 Solution Architecture for the System Landscape Type 1. This is relevant for customers leveraging non-SAP based packaged applications such as PeopleSoft, Siebel, or Oracle e-BusinessSuite, or any other non-SAP based packaged applications without a datawarehouse solution

SAP BusinessObjects BI 4.0 Solution Architecture - System Landscape Type 2

This presentation provides an overview on the SAP BusinesObjects BI 4.0 Solution Architecture for the System Landscape Type 2. This is relevant for customers leveraging SAP ERP or any other packaged application from SAP without a datawarehouse solution.

SAP BusinessObjects BI 4.0 Solution Architecture - System Landscape Type 3

This presentation provides an overview on the SAP BusinesObjects BI 4.0 Solution Architecture for the System Landscape Type 3. This is relevant for customers leveraging SAP ERP or any other SAP packaged application in combination with non-SAP based packaged applications such as PeopleSoft, Siebel, or Oracle e-BusinessSuite, or any other non-SAP based application without a datawarehouse solution.

SAP BusinessObjects BI 4.0 Solution Architecture - System Landscape Type 4

This presentation provides an overview on the SAP BusinesObjects BI 4.0 Solution Architecture for the System Landscape Type 4. This is relevant for customers leveraging SAP ERP or any other SAP packaged application in combination with non-SAP based packaged applications with a data warehouse solution not based on SAP NetWeaver BW.

SAP BusinessObjects BI 4.0 Solution Architecture - System Landscape Type 5

This presentation provides an overview on the SAP BusinesObjects BI 4.0 Solution Architecture for the System Landscape Type 5. This is relevant for customers leveraging SAP ERP or any other SAP packaged application in combination with non-SAP based packaged applications with a datawarehouse solution based on SAP NetWeaver BW.

SAP BusinessObjects BI 4.0 Solution Architecture - System Landscape Type 6

This presentation provides an overview on the SAP BusinesObjects BI 4.0 Solution Architecture for the System Landscape Type 6. This is relevant for customers leveraging SAP ERP or any other SAP packaged application in combination with non-SAP based packaged applications with combination of datawarehouse solutions - SAP NetWeaver BW and non-SAP based datawarehouse solutions.

CONCEPT: USE SAP HANA WITH BI 4.0

2011-12-19T16:59:00.000+05:30

OVERVIEW

SAP HANA is a high-performance analytic appliance that provides SAP software components optimized on hardware from SAP’s leading hardware partners. HANA’s in-memory computing engine enables organizations to effectively analyze business operations based on very large volumes of detailed real-time data, without affecting backend enterprise applications or databases.
In this tutorial, you will review high-level steps for using SAP HANA with SAP BusinessObjects Business Intelligence (BI) tools.

Available @ CONCEPT: USE SAP HANA WITH BI 4.0

SAP HANA - REPLICATING DATA INTO THE SAP HANA DATABASE USING SAP LT REPLICATION SERVER

2011-10-24T12:26:00.001+05:30

In this session, you will learn about the system requirements and overall solution architecture. You will also discover how SAP LT Replication Server needs to be configured. And finally, you'll see how to enable the replication from the SAP HANA ™ Studio.

REPLICATING DATA INTO THE SAP HANA DATABASE USING SAP LT REPLICATION SERVER - WEBINAR PRESENTATION

Replicating Data into the SAP HANA Database Using SAP LT Replication Server - Webinar Replay

SAP BI AR Ageing query

2011-10-12T14:47:00.000+05:30

AR Aging Based on Net Due Date

SAP BW & SAP R3 Integration With Oracle Business Intelligence Suite

2011-08-01T12:32:00.000+05:30

SAP BW & SAP R3 Integration With Oracle Business Intelligence Suite

Filling an Infocube with sample data without loading it!

2011-03-23T16:32:00.000+05:30

To load some sample data into an Infocube without loading data using DTP or Infopackage.
Available @ Filling an Infocube with sample data without loading it!

Changing the Source System Assignments in SAP BW Objects without Affecting the Data Modelin

2011-03-02T17:09:00.001+05:30

To change the source system assignment details in the mapping of all the data sources, transfer rules etc. without affecting any rules.
Author: Nitesh Verma
Available @ Changing the Source System Assignments in SAP BW

Creating Formatted reports using BEx Report Designe

2011-03-02T16:45:00.001+05:30

Outlines the steps to create a formatted report using Report Designer.
This report can be displayed on the web or can be converted into a PDF document to print or distribute
By: Gopalakrishnan Venkatachala
Available @ Creating Formatted reports using BEx Report Designe

Also Check: BEx Report Designer - OSS Notes
Frequently Asked Questions - Report Designer

SAP BW 730: What's New in the SAP BW Near-Line Storage Solution

2011-03-01T13:05:00.000+05:30

SAP BW 730: What's New in the SAP BW Near-Line Storage Solution
Introduction:
SAP NetWeaver BW customers have to handle increasingly large data volumes. This typically leads to a steady increase in hardware requirements and maintenance costs. Keeping the system running efficiently and at low operation costs is a permanent challenge.
Therefore, SAP NetWeaver BW offers a near-line storage (NLS) interface that enables customers to separate frequently accessed data from older, less frequently accessed data

Available @ SAP BW 730: What's New in the SAP BW Near-Line Storage Solution

Bex variables – where used list

2011-03-01T12:47:00.000+05:30

To check all dependency queries for any BEx Variable.
Available @ Bex variables – where used list

Routines in SAP BI 7.0 Transformations

2011-02-25T20:00:00.000+05:30

An overview about the different routines available in SAP BI 7.0 Transformation . In particular the paper highlights when and where an appropriate routine has to be used and shows how to implement .The paper explains the concepts based on a simple scenario for all the routines. The paper also gives the sample code and results at the end of each routine.
Author: Vamsi Kiran Tallu

Available @ Routines in SAP BI 7.0 Transformations

How to Display Result Row in one Line while Reporting on Multiprovider

2011-01-26T09:58:00.000+05:30

Summary

This document helps to overcome multiple record problems while reporting on Multiprovider. The step by
step by solution explains, how to display all the required field values in a single line and also pros and cons
of using “constant selection” option

Available @ How to Display Result Row in one line Reporting on Multiprover

An Overview of SAP BW 7 and SAP BusinessObjects XI Integrated Roadmap

2011-01-10T12:08:00.000+05:30

An Overview of SAP BW 7 and SAP BusinessObjects XI Integrated Roadmap

When to use which tool?

Let’s advance the discussion further by understanding how the above mentioned list of tools could be used in combination to fulfill reporting and analysis requirements for a customer. In order to make a decision about which tool to use to fulfill a particular requirement, it is very important to comprehend the functional requirements of the business reports, as well as different types of users who will be using those reports and analytic content.

In the following sections, we look at these two important aspects that could help us in streamlining the decision workflow for choosing a particular tool or combination of tools to satisfy reporting requirements. Please note that this discussion is not an absolute statement or final judgement on the selection of technology to be used, rather it should serve as a general guideline and you should always exercise your best judgement in making a decision that best fits your needs.

Complete info available @ An Overview of SAP BW 7 and SAP BusinessObjects XI Integrated Roadmap

ROADMAP SAPNETWEAVER BW 7.3

2010-12-21T20:58:00.001+05:30

OVERVIEW

This presentation gives an overview about the upcoming release SAP NetWeaver BW 7.3.

Available @ ROADMAP SAPNETWEAVER BW 7.3

SAP NETWEAVER BW - WHAT’S NEW WITH SAP NETWEAVER BW 7.3

2010-12-21T20:55:00.000+05:30

OVERVIEW
This presentation describes the new EDW features delivered with SAP NetWeaver BW 7.3
Available @ SAP NETWEAVER BW - WHAT’S NEW WITH SAP NETWEAVER BW 7.3

Is your BW the Data Warehouse, anyway?

2010-12-08T20:12:00.002+05:30

There seems to be a big wall between the worlds of BW and "traditional EDW" (whatever it means). Go to the LinkedIn forum of The Data Warehouse Institute (TDWI) and try to open a mouth that you are working with BW - you will be smashed immediately with many comments like "[BW] has always been an ancient, clunky and monstrous solution to implement.", "I'm yet to come across an SAP customer that isn't into their Nth attempt at trying to get it to work properly or efficiently." or "How much did [BW implementation] cost (software, hardware, consulting, etc.), how long did it take and how much frustration did the business users feel while waiting for a solution?
Nice blog available @ Is your BW the Data Warehouse, anyway?
Read & write your comments.

SAP® HANA 1.0 ENABLES BREAKTHROUGH DATA MANAGEMENT WITH IN-MEMORY COMPUTING ENGINE

2010-12-08T19:46:00.003+05:30

The SAP in-memory computing engine that resides at the heart of SAP HANA is an integrated database and calculation layer that allows the processing of massive quantities of real-time data in main memory to provide immediate results from analyses and transactions.

Like any standard database, the SAP in-memory computing engine supports industry standards such as SQL and MDX but also incorporates a high-performance calculation engine that embeds procedural language support directly into the database kernel. This approach is designed to eliminate the need to read data from the database, process it and then write data back to the database

More info available @ SAP® HANA 1.0 ENABLES BREAKTHROUGH DATA MANAGEMENT WITH IN-MEMORY COMPUTING ENGINE

SAP BI Overview

2010-11-30T14:14:00.000+05:30

SAP BI Overview

See more presentations by pippo.borghese | Upload your own PowerPoint presentations

An Expert Guide to new SAP BI Security Features

2010-11-24T15:39:00.001+05:30

Available @ An Expert Guide to new SAP BI Security Features

Maintaining Roles and Authorizations in BI7.0 - RSECADMIN

2010-11-23T15:44:00.003+05:30

SAP BI Authorizations and Role creation available @
Maintaining Roles and Authorizations in BI7.0 - RSECADMIN.pdf