SAP RDS on HANA

This section deals 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: My experiences on using Predictive Analysis Toolset with HANA

SAP BO and HANA

At present to do the reporting on SAP HANA, we can say the best reporting tool available is SAP BO 4.0.

This section deals the useful documents available for SAP BO on HANA.

Connecting to SAP HANA with Microsoft Excel 2007 PivotTables and ODBO

SAP HANA: Data provisioning using BI 4.0 Data services

Browse help.sap.com, you will find lot of information about SAP BO on HANA.

Check out the below link for latest documents:

http://help.sap.com/hana_appliance

Here you will get HANA Modeling Documents, Technical Operations Manuals and Reporting Tools available on HANA and connectivity options available.

SAP HANA

This section gives the information of the documents available in SCN for SAP HANA and the links for them.

The below documents explains about:

a) What are all the basic navigation's that 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 of measures available in HANA and how to 
    create  them?

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

And many more.....

Analytic View creation in SAP HANA

SAP HANA: Data provisioning using BI 4.0 Data services

Connecting to SAP HANA with Microsoft Excel 2007 PivotTables and ODBO

Export and Import feature in HANA Studio

Basic Navigations in SAP HANA Brand New System

SAP HANA: Exporting of Tables into local desktop

SQLScript Small Guide

Variables in HANA Studio

Auto Documentation Functionality in HANA Studio

How to use Calculated Attribute

Hiding your HANA Model - while working on a change request

Attribute View creation in SAP HANA(Using Single and Multiple Tables)

Generate Time Data in SAP HANA

Different ways of table creation in SAP HANA

SAP HANA Overview

Reacting In The Retail Moment

In-Memory Computing - SAP HANA Webinar Presentation

One Happy Data Warehouse Family - SAP Business Warehouse, SAP HANA and Sybase IQ

SAP Business Warehouse, SAP HANA and Sybase IQ

IBM SAP In Memory Analytics

SAP In-Memory Appliance (SAP HANA) Software - Innovation through Partnership with HP

SAP HANA Create Calculated Column

SAP HANA - How to Create Analytic Views

SAP HANA Data Preview Feature

How to Do SAP HANA Text Joins

SAP HANA Navigation - First Logging On

SAP ERP Modeling Options with SAP HANA

SAP HANA Navigation View

Improved Patient Care with SAP HANA

HANA Connectivity with Excel

Vishal Sikka: Impromptu on HANA

SAP runs SAP: CIO Oliver Bussmann on In Memory

SAP In-Memory Roadmap with Vishal Sikka

SDN Articles - Integrated Planning

List Of Articles:

Following Integrated Planning For Beginners - Part 1 video demonstrates step-by-step procedure that how to create simple Integrated Planning application and this video designated especially for IP beginners.

Integrated Planning For Beginners - Part 1 (Video)

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

Planning Functions and Characteristic Relationship in Integrated Planning

SDN Articles - BI Reporting

Following are the collection of very good articles related to 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

Using Customer Exit Variables in BW Reports Part - 4

Using Customer Exit Variables in BW Reports Part - 5

Using Customer Exit Variables in BW Reports Part - 6

Using Customer Exit Variables in BW Reports Part - 7

Using Customer Exit Variables in BW Reports Part - 8

Using Customer Exit Variables in BW Reports Part - 9

Using Customer Exit Variables in BW Reports Part - 10

Using Customer Exit Variables in BW Reports Part - 11

Using Customer Exit Variables in BW Reports Part - 12

Using Customer Exit Variables in BW Reports Part - 13

Using Customer Exit Variables in BW Reports Part - 14

Using Customer Exit Variables in BW Reports Part - 15

Using Customer Exit Variables in BW Reports Part - 16

Using Customer Exit Variables in BW Reports Part - 17

Using Customer Exit Variables in BW Reports Part - 18
 

b) RRI (Report to Report Interface) :

Enhance Report-Report Interface - Create Custom Report Type as Receiver

Fetching Data Directly from ECC System in BEX Query using RRI

Report to Report Interface in SAP BI 7.0

RRI - Parameters Not Transferred to R3 Transaction

SAP BW -- Pass Selection Screen Values using Customer Exit Variables in RRI
 

c) Series of articles about Query Designer :

Understanding BEx Query Designer- Part-1 Screen Appearance

Understanding BEx Query Designer: Part-2 Structures, Selections and Formulas

Understanding BEx Query Designer: Part-3 Calculated Key Figures and restricted Key Figures

Understanding BEx Query Designer: Part-4 Conditions & Exceptions

Understanding BEx Query Designer: Part-5 Query Element Properties

Understanding BEx Query Designer: Part-6 Simple Query Design
 

d) Text Variable :

How to Use Text Variables in BW Reports Part - 1

How to Use Text Variables in BW Reports Part - 2

How to use Text Variables in BW Reports Part - 3
 

e) Miscellaneous

BW Text Variables of Type Replacement Path

Calculating the Difference between Created Date and Changed Date in BW-BI Reports

Change the Query Cache Mode

Creating Bucket Scenarios using Exception Aggregation (SAP Netweaver 7.0 BI)

Customer Exit Variables in SAP BW_BI Reports – First day of the Current_ Previous Month

How can a Reference Query Be used?

How to Create Variable for a Given Key Figure

How to Get the List of Queries Having a Particular Variable, Infoobject

How to Make Conditions and Exceptions Work Based on User Defined Values at the Time of Report Execution

How to use Boolean Operations in the Formula as Subsidiary for “IF” Condition

How to Use Cell Definition to Calculate Incentive of Salesmen

Inconsistencies on Reusable Query Elements (Objects) – BI 7.0

Master Text data label display in BEx Query

Populating Virtual Characteristic and Highlighting the Values

Replacement Path Explained with an Illustrated Example

SAP BW - Copy Query Between Mismatch Info Providers and Queries

SAP BW - Dynamic Call Customer Exit Variables Using Same Exit

SAP BW - Virtual Characteristic Ext (RSR00002)

Step by Step Guide on How to Use Cell Definition in BEx Query

Step by Step guide to Fiscal Week and Fiscal Quarter

Step by Step Procedure to Create Broadcasters, to Schedule and to Enhance of SAP- BI Queries from Query Designer

Step By Step Process for Virtual Key Figures and Characteristics through BAdi

The Definitive and Complete Method for using Virtual Characteristics and Key Figures in NetWeaver BI

Variable Exit in Sap BI 7.0 - How to Start
 

2) BEx Analyzer (Report Analyzer) :

How to Use Cell Restrictions in BEx (BI) Reports

Step by Step Procedure of Creating Workbook using Bex Analyzer

Understanding OLAP Processor and RSRT

View the Reports Based on Two Fiscal Definition
 

3) Web Application Desginer (WAD) :

Customizing SAP Delivered BEx Standard Template

Formatting BEx Workbook Template

How To Build a Fast and Flexible Comment Solution for BEx Web Applications

How to Read Variable Values in WAD 7.0 Using JavaScript

Using Radio Button in Web Template

WAD Web Item and Parameter ModificationWeb Application Designer – Tips and Tricks to use Commands

 

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) 

2) Info Package:

Data Selection Types In InfoPackage

How to Write a Routine for 0CALDAY in InfoPackage Selection

How to Write a Routine for 0FISCPER in InfoPackage Selection

Implementing Dynamic Filters in Infopackage - Two Scenarios

3) Transfomrations:

Currency Conversion in BI 7.0

How To Using Expert Routine in Transformation

How to Write Start Routine in Update Rules, Transformations and How to Debug the Routines

Routines in Transformations in SAP BI 7.0

SAP BI Transformation – Rule Type

SAP BW Transformation - Displaying Custom Messages in Data load Monitor

Step by Step Approach for End Routine with Look Up

Transfer Rule or Transformation Migration within the Same BI System

Transformation Rules for SAP BI

4) Miscellaneous

Architecture for Extracting the Custom Hierarchies from Sap R/3 System into BW System 

Data Loading Strategy for Global Data Warehousing Implementation 

Extracting SAP ECC Compounding Hierarchies into SAP BI using Custom Datasource 

Flat File Interface from SAP BW to External System 

How Second Level Delta Machenisam in 3.x and 7.x 

How to Automate Loading Hierarchies from R3 _ECC 

How to Load Hierarchy from Flat File 

Loading Hierarchies Using a Process Chain 

Program to Activate Transformation and DTP 

Restricting Invalid Characters from Loading into SAP BI 7.0 

Special Characters in BI

Technical Aspect of Hierarchy in BW

 

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 1 

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 2: Write-Optimized 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 BI

Insert 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 inECC (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