Useful links for SAP BW

• SAP BW Notes
• Something about SAP
• Yangchaung
• Way2Sap
• SAP BI Articles
• SAP BW Area
• ERP Howto
• SAP BW Developers Guide
• SAP Help for SAP BI 7.0
• SAP BI - SDN Articles
• SAP BI - How to Guides

SAP RDS on HANA

SAP RDS on HANA

This space deals about the documents available for RDS (Rapid Deployment Solutions) on SAP HANA.

SAP Insider: 2012's Top Cloud Solutions

SAP Insider: Enable Secure Single Sign-On in the Cloud

Implementation of POS Reporting With SAP In-Memory Computing

SAP HANA Information Composer - Compose and Upload Information Views

Making Business Run Better with In Memory Computing and Predictive Analysis

SAP HANA

SAP HANA

Hello Everyone,

This page gives information about the documents available in SCN for SAP HANA and the links for them.

The below documents explains about the following things.

a) what are all the basic navigation's we have to perform on brand new HANA system.

b) how to create tables,schema and packages in SAP HANA system.

c) Step by step procedure to create Models in SAP HANA system like Attribute View, Analytic View and Calculation View.

d) What are the different types measures available in HANA and how to create them.

e) How to connect HANA to excel using ODBO connection for reporting.

and lot more..... :)

SDN Articles - Integrated Planning

SDN Articles - Integrated Planning

List Of Articles:

This video demonstrates step-by-step how to create simple Integrated Planning application. The video designated especially for IP beginners. 

Integrated Planning For Beginners - Part 1

Beginner’s Guide: Create a Custom ‘Copy’ Planning Function Type

Business Intelligence Integrated Planning in SAP NetWeaver 7.0

Copying data from Actual to Planned cube in a Multi Provider using Copy function in BI Integrated Planning

Fox Formula in SAP BI-Integrated Planning

SDN Articles - BI Reporting

SDN Articles - BI Reporting

This page will provide the collection very good articles related BI Reporting from SDN.

List Of Articles:

1) Query Designer:

  a) Customer Exists:

How to Provide Proxy Authorization using Customer Exit variable

SAP BI Analysis Authorization (Customer Exit Variables)

Using Customer Exit Variables in BW Reports Part - 1

How to Use Customer Exit Variables in BW/BI Reports: Part 2

Using Customer Exit Variables in BW/BI Reports Part - 3

SDN Articles - BI Loading

SDN Articles - BI Loading

List Of Articles:

1) Data Transfer Process (DTP) :

Copy Existing DTP to a New One(SAP BI 7.0) 

Explore to the Extraction Tab of Data Transfer Process in SAP BI 7.0 

Explore to the Update Tab of Data Transfer Process in SAP BI 7.0 

Explore to the Execute Tab of Data Transfer Process in SAP BI 7.0 

How to Write a Routine in DTP Selection 

Integration Approach of SAP BW 3.x and 7.0 with Data Transfer Process 

Maintaining Data Quality in BW using Error Stack 

Making Error DTP Work for DSO‘s 

SAP BW - Handling Error Stack in DTP 

Using Error Stack and Error DTPs in SAP BI 7.0 

Why DTP Not IP in SAP BI 7 0 

Working with SAP BI 7.0 Data Transfer Process (DTP) 

SDN Articles - BI Modelling

SDN Articles - BI Modelling

List Of Articles:

1) Data Source

Better View of Data Source Features in BW 7.0 

Data Source Replication and Activation of Transfer Structures 

Explore Data Sources in BW 7.0 - Part I 

Exploring Data Sources – Part 2 

2) DSO (Data Store Object)

Step by Step Procedure for DSO Creation

Understanding DSO (DataStore Object) Part 1: Standard DSO

Understanding DSO (DataStore Object) Part 1: Standard DSO

Understanding DSO (DataStore Object) Part 3: Direct Update DSO

3) Info Cube

InfoProvider Redesign Functions- Part 1: Repartitioning

InfoProvider Redesign Functions- Part 2: Remodeling

Logical Data Partitioning of the Info-Cubes

Reading Enhanced DataSource Fields for the Remote Cube

SAP BI - Virtual Infocube based on Function Module (Transport History)

Step-By-Step Guide to Virtual InfoCube Implementation

Virtual InfoCube - Implementation in BW 7.0

SAP BI Positioning the InfoCube in BI

Info Cube creation Step by Step in SAP BI

4) Info Objects

Compounding in Infoobject and Analyzing the Infoobject in a Query

Creating New Unit of Measure in SAP BW

Creation of Key Figures with Higher Decimal Place Precision

Different Types of Characteristic Info Object Tables and its Structures in SAP BI 7.0

How to Enable Authorization on Navigational Attribute

5) Info Set

Better View of InfoSets in SAP BW

Copying Queries Between InfoSets

Interpreting Query Results using InfoSets and the Concept of Temporal Join with Practical Scenarios

Steps to Create Infoset using InfoObject and DSO

6) Multi Provider

Consistency Issues in MultiProviders - BI 7.0

Multi Provider Creation Based on Sales and Planning Info Cubes

Step by Step procedure for multi provider creation

7) Open Hub Destination (OHD) and APD

Analysis Process Designer - Step by Step Process to Extract Data to a File and Rearranging the Columns Using Transformations

Analysis Process Designer (APD) Illustrated Step-by-Step Implementation Part 1 (using Filter Transformation)

Analysis Process Designer (APD) Illustrated step-by-step implementation Part 2 (using Routine Transformation)

Analysis Process Designer (APD) – Step by Step – Business Intelligence

Analysis Process Designer: Step by Step Process for Formatting the Query Extract

APD to Update Marketing Attributes from SAP BI to SAP CRM

APDs and Open hubs Sending SAP BW Data to 3rd Party

InfoSpokes and OpenHubs in SAP BIInsert Custom Header and Remove Trailing Commas from APD Generated (or any)-CSV file

Join and Union options in APD

Open Hub Destination - Basics

Open Hub Destination - Make use of Navigational Attributes

Open Hub Destination-Use Same Logical Path for Multiple Directories

SAP BW Infospoke – Dynamic Update Selection Screen Values 

8) RDA (Realtime Data Acquistition)

How to do Real-Time Data Acquisition trough Web Service (Push Method)

Real Time Data Acquisition (RDA) – Overview and Step-by-Step Guide (SAPI and Web Services)

RDA – Step by Step

Real Time Data Acquisition (RDA) Steps - Business Intelligence

9) Miscellaneous

0RECORDMODE and Delta Type Concepts in Delta Management

Record Mode Concept in Delta Management

Aggregation of Key Figures

ALE Settings for Communication between a BW System and an SAP System

Basics of Non – Cumulative Key Figures

Direct Access to Source System Data using VirtualProviders

SAP BW - Virtual Characteristic (Multiprovider & Infoset) - RSR_OLAP_BADI

SDN Articles - BI Extraction

List Of Articles:

1) DB Connect

DB Connect with Delta Mechanism

DB Connect in SAP BI

2) Extraction from R3

Checking the Data using Extractor Checker (RSA3) in ECC Delta and Repeat Delta etc...

Data Flow from LBWQ/SMQ1 to RSA7 in ECC (Records Comparison).

Data Flow from LBWQ/SMQ1 to RSA7 in ECC and Delta Extraction in BI

DELTA QUEUE DEMYSTIFICATION

Dynamic Call Specific R/3 Datasource Using Same Exit

Extractor in R/3 and Delta Queue

TRANSACTION LBWR

    2.a) COPA Extraction

      How to do COPA Extraction 

      COPA Extraction Step by Step 

       

    2.b) Generic Extraction

      Extractor for Multi Value Class Characteristic Values using Function  Module

      Functional Module Based Delta Enabled Generic Datasource 

      Functional Module Based Generic Datasource Part I 

      Generic DataSource on CDHDR and CDPOS Tables 

      How to Create a Generic Data Source Based on a Custom View and Further Enhance the Data Source for BW Extraction 

     How to Create View on Different Tables and Load Data through Generic Datasource based on that View 

     Step by Step Guide to Extract Batch Master Data via Generic and Classification Datasource to BW 

     Safety Intervals in Generic Delta – How to Guide 

     How to Implement BAdI for Enhancing the Datasource in ECC 

     SAP BW - Generic Datasource Function Module (Multiple Delta Fields) 

     Step by Step Procedure to Extract Data from R3 to BI 7.0 using Generic DataSource 

     Step by Step Procedure to Extract Data from R/3 to BI 7.0 using Query 

     Steps to Activate ALE Delta for Custom Master Datasource Created on ZTable 

     Using Timestamps in Generic Delta Extraction by Function Module 

    2.c) LO Extraction

       A Treatise on Logistics Data Extraction for Business Information Reporting 

       Data Flow During Different Update Mode in LO Cockpit 

       Enhancing LO DataSource – Step by Step

       LO Extraction – Part 1: SD Application Short Overview

       LO Extraction – Part 2 Database Update Logic

       LO Extraction: Part 3 Extractor Logic

       LO Extraction – Part 4 Update Methods

       LO Extraction Part 5 - Sales and Distribution (SD) Datasource Overview

       LO Extraction - Part 6 Implementation Methodology

       LO Extraction – Part 7 Enhancing LO Data Source

       LO Extraction – Part 8 Post Implementation and Support Issues

3) Flat File Loading

Data Upload from Flat File to Business Intelligence 7.0 System 

Flat File Upload – Considerations - Preliminary Program 

Flat File Load Mechanism in SAP 

Making Flat File Data Sources Delta Capable by Using Routine in Infopackage Selection 

Step by Step Guide - How to Copy Flat File from Other Application Server to BI and Load through Info Package 

Step by Step Procedure for Loading of Data From the Flat File to the Master Data/Text Tables 

Step by Step Procedures to Load Master Data (Attribute and Text) from FlatFile in BI 7.0 

Flat File Upload – Considerations - Preliminary Program 

4) UD Connect

How to Configure UD Connect on the J2EE Server for External Databases (NW2004) 

How to Transfer Data from SYBASE to BI Using UD Connect 

5) XML Services

XML Data Extraction

SDN Articles - BI Related ABAP

SDN Articles - BI Related ABAP

List Of Articles:

i) Data Source Enhancements:

Enhancing / Modifying Multiple Data Sources in Parallel

How to Implement BAdI for Enhancing the Datasource in ECC

How To Use ABAP Classes Instead of “CMOD” for BW Datasource Enhancements

SAP BW Data Source Enhancement

Step by Step Guide to DataSource Enhancement – BAdI Approach

Step by Step Guide to Enhance a Datasource

Step By Step Procedure to Enhance Standard BI/BW Extractor Using BADI

iii) Routines:

Create Monitor Entries in BI Using Start Routine

Customizing Built In Formulas

Implementation and Usage of Expert Routine in SAP BI 7.0

Implementation and Usage of Transformation End Routine in SAP BI 7.0

Integrating Custom Formulas into Formula Builder in SAP BI 7.0

Routines in SAP BI 7.0 Transformations

Using Return Table in Update Rules

Using Rule Group in SAP-BI. Part - 1

Rule Groups in Transformation

How to Write Inverse Routine with Expert Routine

iii) Miscellaneous:

ABAP Code - Email Recipients (Specific Format) – SAP BW Process Chain

ABAP Code - Read SAP BW Infoprovider (Infocube, DSO, Multiprovider) Data using ABAP Code 

ABAP Code – To fetch SAP BI Query Data 

SAP BI - Virtual Infocube based on Function Module (Transport History) 

Replacement for Return Table in BI 7 

Role and Scope of ABAP in SAP BI 

SAP BW: ABAP Code to Schedule APD in Background 

Usage of ABAP in BI 

Using OOPS ABAP (Class Concept) in Transformations in SAP BI 

SAP BW on HANA

SAP BW on HANA

Informative Blogs:

Info cubes and Data Store Objects ... and HANA

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/24672

SAP In-memory - what is in the bag?

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/24738

Podcast: Straight Talk about HANA with SAP

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/25174

HANA and BW 7.30 - Part 1

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/25122

HANA and BW 7.30 - Part 2

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/25123

Important Questions (with Answers) about SAP's in-memory High-performance Analytic Appliance - HANA

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/21589

SDN Blogs Index - BW Part3

SDN Blogs Index - BW Part3

List Of Blogs:

How to get selection criteria in Transformations routines?

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/21931

Overview of BW 3.x to 7.x migration possibilities per BW objects

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/21950

BW 7.30: Transport support in BW landscapes

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/20890

How to generate a selective deletion program for info provider

www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/21078

Counters in Infoproviders - Boon or Bane ?

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/22174

Triggering Email to different users using same email setting each with different Query Variants

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/21393

SDN Blogs Index - BW Part2

SDN Blogs Index - BW Part2

List Of Blogs:

Dependency information of Function Modules in BW transformations and DTPs

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/25255

List BEx Analyzer 7.X variables and generate the associated PROCESS_VARIABLES commands

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/25185

SAP BW: monitor inactive objects (Multiprovider, Cubes, Update Rules etc.) after the import of transport requests 

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/25059

General Guidelines for ABAP coding in BW

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/24981

Deletion of WDSO (Write-optimized DataStore object) Load requests and active table data without deleting it from target

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/24891

SDN Blogs Index - BW Part1

List Of BW Blogs:

How most BW performance support messages are solved

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/27033

All embracing inventory Management in BW with special emphasis on Non cumulative and Markers

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26630

How to Fetch Your Info package Details From R/3 System

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26901

3 Easy Steps to Upload an Image into Process Chain Maintenance Screen

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26069

How to save your Listcube selction screen and the output

http://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/26903