LO Data Extractions

Part 1 - SD Overview

Part 2 - Database Update Logic

Part 3 - Extractor Logic

Part 4 - Update Methods

Part 5 - Datasource Overview

Part 6 - Implementation Methodology

Part 7 - Enhancements

Part 8 - Support Issues

SAP BW 7.3 Online Help

SAP BW 7.3 Online Help

SAP BW 7.3 Data Warehousing

Integrating with SAP Business Objects

SAP NetWeaver Business Warehouse and SAP Business Explorer

SAP BusinessObjects Dashboards E-learning tutorials

SAP BusinessObjects Dashboards E-learning tutorials

SAP BW Extractors

One stage stop to know all about BW Extractors-Part1

One stage stop to know all about BW Extractors-Part2

Financial Accounting: Procedure for Line Item Extraction 

Procurement Data Sources:

Disk Space for Infocube and ODS

A simplified estimation of disk space for the BW can be obtained by using the following formula:


For each cube:

Size in bytes = (n + 3) x 10 bytes + (m x 17 bytes) * [ rows of initial load + rows of periodic load * no. of periods]

n = number of customer created dimensions, m = number of key figures

For each ODS (incl. change log):


Size in bytes = (n x 10 bytes) + (m x 17 bytes) * [ rows of initial load + rows of periodic load * no. of periods]

n = number of character fields, m = number of numeric fields

SAP PCM and BW Integration

How to Bring SAP BusinessObjects Profitability and Cost Management (PCM) Result Table Data to SAP NetWeaver BW Using DB Connect

Cost and Profitability in SAP: PCM deployment: options - when to use PCM ? what to use PCM for ?

SAP BPC

Understanding BPC Terminology in a NetWeaver World

Xcelsius

BusinessObjects and SAP Part 1 of 4 - Creating a Xcelsius Dashboard on top of SAP BI
BusinessObjects and SAP Part 2 of 4 - Creating a Xcelsius Dashboard on top of SAP BI
BusinessObjects and SAP Part 3 of 4 - Creating a Xcelsius Dashboard on top of SAP BI
BusinessObjects and SAP Part 4 of 4 - Creating a Xcelsius Dashboard on top of SAP BI
BusinessObjects and SAP Part 10 - Xcelsius with Universe and Query-as-a-WebService

Crystal Reports

Crystal Reports and SAP BW Hierarchies - Part 1 of 2
Crystal Reports and SAP BW Hierarchies - Part 2 of 2

Whatever you want to know about Crystal and NetWeaver BW without asking for it!


Crystal Reports and BW Connectivity ((BW MDX (BW cubes and queries))

There are two sets of transport files, which can be used with BusinessObjects Enterprise Integration Kit for SAP. One set is ANSI and the other set is Unicode enabled.

The set of transports you must use depends on the BASIS system your SAP system is running on. Additionally, each transport consists of a data file and a cofile, which are listed in brackets behind the transport names.
If your SAP system is running on a BASIS system earlier than 6.20, you must use the files listed below:

(These files are ANSI.)
* Open SQL Connectivity transport (K900084.r22 and R900084.r22)
* Info Set Connectivity transport (K900085.r22 and R900085.r22)
* Row-level Security Definition transport (K900086.r22 and R900086.r22)
* Cluster Definition transport (K900093.r22 and R900093.r22)
* Authentication Helpers transport (K900088.r22 and R900088.r22)

If your SAP system is running on a 6.20 BASIS system or later, you must use the files listed below:
(These files are Unicode enabled.)
* Open SQL Connectivity transport (K900574.r21 and R900574.r21)
* Info Set Connectivity transport (K900575.r21 and R900575.r21)
* Row-level Security Definition transport (K900576.r21 and R900576.r21)
* Cluster Definition transport (K900585.r21 and R900585.r21)
* Authentication Helpers transport (K900578.r21 and R900578.r21)

The following files must be used on an SAP BW system:
(These files are Unicode enabled.)
* Content Administration transport (K900579.r21 and R900579.r21)
* Personalization transport (K900580.r21 and R900580.r21)
* MDX Query Connectivity transport (K900581.r21 and R900581.r21)
* ODS Connectivity transport (K900582.r21 and R900582.r21)

Importing the Transport Files for the SAP Integrated Solutions XI 3.1

Web Intelligence

Web Intelligence SP2 - Query on Query
Types of Query Filters in Web Intelligence
Web Intelligence Rich Client Custom Data Provider Plug-in - Tracking Forest Fires
XI 3.1 Service Pack 2 - Web Intelligence Calculation Extension Points API
Using Web Intelligence to Connect your data silos
Better Performance For Universe-Based Access To BW
Web Intelligence Year in Review: A Sort of Homecoming
When is a large document too large? Some rules of thumb for sizing Web Intelligence.
Track changes of time dependent hierarchies in Web Intelligence

SAP Business Objects and Integration to SAP

BusinessObjects and SAP Part I
BusinessObjects and SAP Part 2
BusinessObjects and SAP Part 3
BusinessObjects and SAP Part 4
BusinessObjects and SAP Part 5
BusinessObjects and SAP Part 6 - Web Intelligence and SAP BI
BusinessObjects and SAP Part 7 - OLAP Universe change management
TechEd Las Vegas - Are you up for the Business Objects Community Xcelsius Challenge
BusinessObjects and SAP Part 9 - Xcelsius with Crystal Reports and Live Office

SAP BusinessObjects Useful Links

Docupedia

SAP BusinessObjects Portfolio:
SAP BusinessObjects offers a broad portfolio of tools and applications designed to help you optimize business performance by connecting people, information, and businesses across business networks.

Solutions for Large Enterprises
· SAP BusinessObjects business intelligence solutions – Leverage SAP BusinessObjects business intelligence (BI) solutions that can empower your users to make effective, informed decisions based on solid data and analysis.
o SAP BusinessObjects Explorer – Take advantage of an intuitive path to quickly search and explore data for instant insight into your business.
· SAP BusinessObjects information management solutions – Take advantage of SAP BusinessObjects information management (IM) solutions that can help you deliver integrated, accurate, and timely data – both structured and unstructured – across your enterprise.
· SAP BusinessObjects enterprise performance management solutions – Capitalize on the value of your corporate data, enabling your organization to become more agile and competitive by providing organizational alignment, visibility, and greater confidence.
· SAP BusinessObjects governance, risk, and compliance solutions – Promote corporate accountability by unifying corporate strategy, control initiatives, opportunity discovery, and loss mitigation across the extended enterprise.
Solutions for Small Businesses and Midsize Companies
· SAP BusinessObjects Edge solutions – Benefit from interactive, open business intelligence and performance management solutions for midsize companies.
· Crystal Reports – Leverage a complete report management solution for small companies.
· Xcelsius – Leverage dynamic and customizable data visualization software.

SAP BusinessObjects business intelligence solutions:

SAP BusinessObjects business intelligence (BI) solutions provide comprehensive business intelligence functionality that can empower your users to make effective, informed decisions based on solid data and analysis. All users, from the high-end analyst to the casual business user, have access to the information they need -with minimal dependence on IT resources and developers.
With these powerful solutions, users throughout your enterprise can access, format, analyze, navigate, and share information across the organization. SAP BusinessObjects BI solutions enable the following:
1. Advanced analytics: Designed for financial and business analysts, advanced analytic tools create real-world value from your information assets. Relying on sophisticated analytic engines that can access both numeric and text data, these tools interrogate complex historical data to look for trends, outliers, and patterns through a visual interface.
SAP BusinessObjects Voyager – Explore online analytical processing (OLAP) data using a tool designed specifically for financial and business analysts – one that delivers a full range of functions to analyze multi-dimensional data sets.
SAP BusinessObjects Predictive Workbench – Using predictive analysis, mine your information assets to turn insight into action.
SAP BusinessObjects Set Analysis – Define, track, and analyze segments, such as good customers, bad suppliers, and at-risk customers, and how they impact your business.

2. Dashboards and visualization:
SAP BusinessObjects can help you illuminate your business with holistic views of key metrics and information. Transform how you view your business by interacting with sophisticated visual representations of processes and performance. Perform what-if analysis with your dashboards to gain new insights – and make informed decisions.
Learn more about the following:
SAP BusinessObjects Xcelsius Enterprise – Leverage a point-and-click data visualization tool specifically designed to create interactive analytics and dashboards with secure, live connections to SAP BusinessObjects Enterprise or SAP BusinessObjects Edge BI Series.
Xcelsius Engage – Create business dashboards and data presentations from spreadsheets and live data sources.
Xcelsius Present – Engage, inform, and persuade your audience and transform complex data into insightful and engaging presentations.
SAP BusinessObjects Dashboard Builder – Get instant insight into your business activities by viewing reports, gauges, charts and more in one consolidated dashboard view.
SAP BusinessObjects VizServer – Easily set up visual environments to explore relationships, trends, and timelines.
SAP BusinessObjects StarTree Software Development Kit (SDK) – Visualize and explore large hierarchies and relationships in your applications.
SAP BusinessObjects TableLens SDK – Visualize large amounts of data, spot trends, and make assumptive correlations.
SAP BusinessObjects TimeWall SDK – Visualize long time horizons, even while focusing on a specific time of interest

3. Information infrastructure : Meet all of your strategic business intelligence (BI) requirements on a single information infrastructure while ensuring delivery of the right information to the right users at the right time.
Learn more about the following:
SAP BusinessObjects Enterprise – Make it easy for everyone to discover and share insight for optimal decision making. Built on a service-oriented architecture, SAP BusinessObjects Enterprise supports the most extensive set of tools on a single platform and allows IT departments to extend BI to any application or process.

4. Ad hoc Query, reporting, and analysis : Let end users interact with business information and answer ad hoc questions themselves – without having to understand complex database languages and underlying structures. SAP BusinessObjects offers software that supports query generation and integrated analysis, as well as basic report authoring and information-sharing over intranets and extranets.
Learn more about the following:
SAP BusinessObjects Desktop Intelligence – View standard reports, analyze data, perform ad hoc queries to gather new data, and create your own reports.
SAP BusinessObjects Web Intelligence – Benefit from self-service access to information and intuitive analysis in one integrated product, enabling better decision making.

5. Reporting : Today, most organizations face a similar challenge: The information you need exists – but it's stored in disparate, inaccessible sources, in a format that's not usable. Reporting serves as a foundation for a broader BI strategy, helping you provide the most requested information – reliably, securely, and in the required format.
Learn more about the following:
Crystal Reports – Connect to virtually any data source, design and format interactive reports, and share them internally and externally. Securely deliver and explore your reports via SAP BusinessObjects Enterprise, Crystal Reports Viewer, and Microsoft Office documents.

6. Search and exploration: Simplicity of exploration and speed of search define these user-friendly search and navigation tools. Locate information hidden in hundreds of internal and external sources to find the most relevant information needed to answer your critical business questions. Leverage and extend your organization's existing business intelligence, search, and content investments to increase productivity and insight with:
SAP BusinessObjects Explorer – Combine the simplicity and speed of search with the trust and power of business intelligence. Plus, an accelerated version can empower you with the performance and scalability of in-memory analytics. SAP BusinessObjects Intelligent Search – Save time and find more with a single federated search, clustering, and alerts.

SAP BusinessObjects BI product offerings include:
· BusinessObjects Edge
· BusinessObjects Enterprise
· Crystal Reports
· Explorer
· Integration Solutions
· iPoint
· Live Office
· Mobile
· Polestar
· Portal Integration kits
· Process Tracker
· Web Intelligence
· Xcelsius

Documentation help:
SAP BusinessObjects Explorer overview
SAP BusinessObjects Explorer deployment scenarios
Business Objects Explorer XI 3.2 user guide
SAP BusinessObjects Data Services Designer Guide
SAP BusinessObjects Explorer and the SAP NetWeaver BW Accelerator

Data Federator
How SAP BusinessObjects Explorer works with SAP BusinessObjects Enterprise

BW Accelerator 7.20 for Business Warehouse Administration Guide
BW Accelerator_ Key Steps for Deploying a successful BWA Project
What is the SAP NetWeaver BW Accelerator?
SAP NetWeaver BW Accelerator & SAP BusinessObjects Explorer

SAP Business Planning and Consolidation 7.0

SAP BusinessObjects Planning and Consolidation 7.5

SAP GRC Access Control 5.3

SAP BusinessObjects Data Services

• SAP BusinessObjects Data Services Getting Started Guide
• SAP BusinessObjects Data Services Designer Guide
• SAP BusinessObjects Data Services Integrator's Guide
• SAP BusinessObjects Data Services Tutorial
• SAP BusinessObjects Data Services Reference Guide

Desktop Intelligence

1. Desktop Intelligence Access and Analysis Guide
2. Desktop Intelligence Developer Guide
3. Desktop Intelligence Users Guide Reporting Techniques and Formatting

WebIntelligence

1. Getting Started with WebIntelligence
2. Interacting with WebIntelligence Reports
3. Performing On-Report Analysis with Web Intelligence
4. Query as a Web Service
5. Using Functions, Formulas and Calculations in Web Intelligence
6. Building Queries with Web Intelligence Query - HTML
7. Building Reports with Web Intelligence Rich Client

BusinessObjects Voyager

1. BusinessObjects Voyager Administrator's Guide
2. BusinessObjects Voyager User's Guide
3. BusinessObjects Voyager User’s Guide

SAP BusinessObjects Xcelsius

1. SAP BusinessObjects Xcelsius 2008 User Guide
2. SAP BusinessObjects Xcelsius 2008 Installation Guide

Universe Designer

1. Universe Designer
2. Using SAP NetWeaver Business Intelligence in Universe Designer
3. Using SAP BW in Universe Designer
4. BusinessObjects Universe Builder Guide

BusinessObjects Polestar

1. BusinessObjects Polestar Administration and Deployment Guide

BusinessObjects Live Office

1. BusinessObjects Live Office XI 3.1 User Guide
2. BusinessObjects Live Office XI 3.1 SP2 User Guide

BusinessObjects Explorer:

1. SAP BusinessObjects Explorer Online Help
2. SAP BusinessObjects Explorer at a Glance
3. Master Guide SAP® BusinessObjects Explorer – Accelerated Version
4. SAP BusinessObjects Explorer Master Guide
5. SAP BusinessObjects Explorer Installation Guide