Monday 11 June 2012

SAP RDS on 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

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

Check out the below link for latest documents:

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.....































SDN Articles - 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:

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) :












SDN Articles - BI Modelling

List Of Articles:

1) Data Source





2) DSO (Data Store Object)

Step by Step Procedure for DSO Creation

SDN Articles - BI Extraction

List Of Articles:

1) DB Connect



2) Extraction from R3







    2.a) COPA Extraction

    2.b) Generic Extraction














 
    2.c) LO Extraction












3) Flat File Loading









4) UD Connect



5) XML Services