Google+ Facebook Twitter MySpace SC

Saturday, August 25, 2012

SAP BO and HANA


SAP BO and HANA

Hello Everyone,

To do the reporting on SAP HANA at present, we can say the best reporting tool available is SAP BO 4.0.
This space deals about 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

go and beowse in help.sap.com you will find lot of information about SAP BO on HANA.

check out the below link for latest documents.


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 - BI Modelling

List Of Articles:


1) Data Source





7) Open Hub Destination (OHD) and APD


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



2) Extraction from R3








    2.a) COPA Extraction



       

    2.b) Generic Extraction
















5) XML Services


XML Data Extraction


SDN Articles - BI Related ABAP


SDN Articles - BI Related ABAP


List Of Articles:

i) Data Source Enhancements:








iii) Routines:













iii) Miscellaneous:












SAP BW on HANA

Informative Blogs:


Info cubes and Data Store Objects ... and HANA

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

List Of Blogs:

How to get selection criteria in Transformations routines?

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

BW 7.30: Transport support in BW landscapes

How to generate a selective deletion program for info provider

Counters in Infoproviders - Boon or Bane ?

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


SDN Blogs Index - BW Part2

List Of Blogs:

Dependency information of Function Modules in BW transformations and DTPs

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

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

General Guidelines for ABAP coding in BW

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