OVERVIEW

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

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.

Available @ An Expert Guide to new SAP BI Security Features

Nearly every SAP customer who operates an SAP BW or SAP APO system encounters one main challenge - how to control and monitor BW Process Chains?! The definition of Process Chains is normally directly performed with the help of standard BW transactions like RSPC. The scheduling of the Process Chains is then usually also performed directly from within BW. Some customers schedule their Process Chains via external scheduling tools like SAP Central Process Scheduling by Redwood. Then perhaps comes the "toughest" part: How to monitor those Process Chains, especially if you have several hundred or even thousand Process Chains running per day
Part1 Available @ BW Process Chain monitoring with SAP Solution Manager - Part 1


Part2 Available @ BW Process Chain monitoring with SAP Solution Manager - Part 2: Setup Example

This blog describes way to create an extractor based on multiple delta fields. We created generic extractor for Function Location , Equipment and many other generic extractors by using multiple delta fields .


Available @ Delta Using Multiple Fields

Available @ Programs for Activating BW Objects in a Productive System

Available @ How To restrict F4 Help Values for hierarchies in Bex variable screen

Learn how you can integrate SAP BusinessObjects BI tools with SAP NetWeaver BW at a best practice presentation by the SAP Intelligence Platform and NetWeaver RIG. Get the essential information you need to utilize the full range of SAP BI capabilities, and learn best practices when implementing and integrating SAP BusinessObjects BI solutions with SAP NetWeaver BW.


Best Practice on integrating SAP BusinessObjects BI with SAP NetWeaver BW – Webinar Replay

• INTRODUCTION TO SAP BUSINESSOBJECTS BI SOLUTION ARCHITECTURE - RECORDED WEBINAR
• This recorded webinar is providing an overview on the SAP BusinesObjects BI Solution Architecture and the set of customer landscape pattern.
• SAP BUSINESSOBJECTS BI SOLUTION ARCHITECTURE - LANDSCAPE TYPE 1
• This presentation is providing an overview on the SAP BusinesObjects BI 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 without a datawarehouse solution.
• SAP BUSINESSOBJECTS BI SOLUTION ARCHITECTURE - LANDSCAPE TYPE 2
• This presentation is providing an overview on the SAP BusinesObjects BI 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 solutio
• SAP BUSINESSOBJECTS BI SOLUTION ARCHITECTURE - LANDSCAPE TYPE 3
• This presentation is providing an overview on the SAP BusinesObjects BI 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 without a datawarehouse solution.
• SAP BUSINESSOBJECTS BI SOLUTION ARCHITECTURE - LANDSCAPE TYPE 4
• This presentation is providing an overview on the SAP BusinesObjects BI 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 such as PeopleSoft, Siebel, or Oracle e-BusinessSuite with a datawarehouse solution
• SAP BUSINESSOBJECTS BI SOLUTION ARCHITECTURE - LANDSCAPE TYPE 5
• This presentation is providing an overview on the SAP BusinesObjects BI 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 such as PeopleSoft, Siebel, or Oracle e-BusinessSuite with a datawarehouse solution based on SAP NetWeaver BW.
• SAP BUSINESSOBJECTS BI SOLUTION ARCHITECTURE - LANDSCAPE TYPE 6
• This presentation is providing an overview on the SAP BusinesObjects BI 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 such as PeopleSoft, Siebel, or Oracle e-BusinessSuite with combination of datawarehouse solutions - SAP NetWeaver BW and non-SAP based datawarehouse solutions.

System Landscapes for SAP NetWeaver BW and SAP BusinessObjects - Webinar Replay

SAP Network Blog: More than 20 reasons for the BusinessObjects-only customer to attend TechEd

LO Extraction - Update queue - Update methods
--------------------------------------------------

1. Direct Delta
2. Queed Delta
3. Un Serialized Delta Update

1. Direct delta: When a Document is posted it first saved to the application table and also directly saved to the RSA7 (delta queue) from here it is being moved to BW.So you can understand that for Delta flow in R/3 Delta queue is the exit point.
2. Queued Delta: When a document is posted it is saved to application table, and also saved to the Extraction Queue ( here is the different to direct delta) and you have to schedule a V3 job to move the data to the delta queue periodically and from their it is moved to BW.
3. Unserialized V3 Update: This method is largely identical to the serialized V3 update. The difference lies in the fact that the sequence of document data in the BW delta queue does not have to agree with the posting sequence. It is recommended only when the sequence that data is transferred into BW does not matter (due to the design of the data targets in BW). You can use it for Inventory Management, because once a Material Document is created, it is not edited. The sequence of records matters when a document can be edited multiple times. But again, if you are using an ODS in your inventory design, you should switch to the serialized V3 update.

• SAP BI – Introduction to SAP Netweaver 2004s ( 7.0 BI) system

1. Overview
2. BI System upgrade and migration of dataflow from BW 3.x to BI 7.0
3. Transformation & UoM conversions
4. Write routines in transformations and debugging routines
5. DTP & DTP Error handling
6. Concepts – Bi Integrated planning, BI Accelerator and Analysis Process Designer ( APD )

• SAP BI – Data Warehousing ( DW )

1. Overview, Positioning & Fundamentals of Data Warehousing
2. Objects in the BI DW layer
3. Data Acquisition & Transformation from SAP Source Systems
4. Data Acquisition from other systems
5. Business Content
6. Other Info Providers
7. Administration of Data Targets
8. Introduction to Query Performance Optimization

• SAP BI – Reporting & Analysis

1. Introduction to BI Enterprise Reporting
2. Get to know BEx Query Designer
3. Key Figures, Characteristics, Variables, Exceptions and Conditions
4. BEx Analyzer
5. Enterprise Portal Integration and Document integration
6. Report-Report-Interface
7. Managing Query Objects
8. Business Content
9. Further SAP BI Reporting Tools
10. Information Broadcasting

1. Overview of Data Staging in SAP BI-BW Content - Content installation
2. LO Extraction
3. CO-PA extraction
4. Generic Extraction
5. Delta Mechanism & Management
6. Transferring / loading data from flat files
7. Data Mart Interface

1. InfoProvider modeling and administration for performance
2. Optimize and monitor query performance and data acquisition performance
3. Aggregates and roll up
4. Transport Management for BI Objects
5. Process chains – Development & monitoring

1. Authorizations – Setting up for reporting, standard roles and templates
2. Securing data access for administrative tasks in BI, connected source systems
3. Security requirements in SAP BI