SAP NetWeaver Business Warehouse Home

Front-End Component

Checking Precalculation Server issues

Installation of Precalculation Server — This page describes how the Precalculation Server is installed on a Precalculation Server Machine.

RRMX in Business Warehouse 3.5 — This page includes all known issues related to RRMX with BW release 3.5 and below.

RRMX

Using Macro in BEx Analyzer 7x

Creation of 7x Workbooks with or without SAP Default Workbook — This page describes both ways of workbook creation and clarifies when the SAP Default Workbook should be used or not.

Excel settings for using BEx Analyzer 7x — This page contains information about Excel settings for using BEx Analyzer 7x.

Recommendation for using Precalculation Server

Find the Workbook ID — This page explains the meaning of the workbook ID and where you can find it.

Current BI ADDON — Following pages provide information about current and planned SAP GUI patches, Frontend-patches (FEP) and patches for Precalculation Server.

Front-End Component — This section collects some Q&As on BEx Query Designer, BEx Analyzer, BEx Web Application Designer, BEx Report Designer and BEx Broadcaster.

The Statistics Workbook — With the Statistics Workbook you can identify the time consuming events while query/workbook processing in BEx Analyzer 7x.

Single Data Provider Refresh

BEx Analyzer 7x — The BEx Analyzer is a design and analysis tool embedded into Microsoft Excel.

BEx Broadcaster

Important ABAP corrections for Precalculation Services — Following notes need to be implemented for smooth execution of precalculation services.

Checklist for Precalculation Server — This pages includes the information needed by SAP Support to analyze the Precalculation issue.

OLAP Technology

OT-ISET InfoSets

OT-NC 'Non-Cumulative Key Figures'

OT-OLAP-VAR 'Variables'

OT-OLAP-HIER 'Hierarchies'

OT-MultiProvider

OT-VC 'Virtual Providers'

OT-DBIF 'Data Base Interface'

OT-OLAP 'OLAP Core'

OLAP Technology

 EI (Enhanced Infrastructure)

TREX

Configuration Guide for SAP eRecruitment and TREX 7.1

Report TREX_RFC_SEARCH

(ES) Embedded Search Troubleshooting Guide

Report COM_SE_SEARCH_IIF_TEST

TREX for Enterprise Portal

TREX710

RFC Connection for TREX

RFC Connection not working

RFC Connection red alert

RFC Connection in SM59

TREX Admin Tool cannot connect to SAP System

Operations in SAP System such as create RFC destination fail because user has insuficient rights

TREX returns a message saying GW does not exist

SAP System sends incomplete data

TREX700

TREX for CRM

TREX for E-Recruiting

TREX for KM

Troubleshooting Trex issues in an Enterprise Portal Scenario

Queue server is missing in the TREX Monitor

Trex services not showing up in the Trex monitor in the Portal.

Notes in TM

Searching Utilities at SAP

(TREX) Main Page

Embedded Search in SAP SRM

No PHIO document found

How to schedule a periodic delta index - Enterprise Search

Resetting documents in a failed state through Transaction "TREXADMIN"

PLM authorisations fail in ESH_TEST_SEARCH - Enterprise Search

Enable full text search using TREX (Embedded Search - Enterprise Search)

Software Component, an Enhancement Concept - Enterprise Search

USER_AUTHORITY - Enterprise Search

Troubleshooting KM Indexing and Crawler issues

Red Alert Check "inconsistent_logical_indexes" in a Trex and Embedded Search Scenario

Creating and Deleting Indexes in Transaction SES_ADMIN

Recording a Python Trace in Transaction TREXADMIN

Hints for Indexing

Table Esh_Ex_Cpointer - Enterprise Search

Real Time Indexing - Some facts - Enterprise Search

Esh-Cockpit Authorizations - Enterprise Search

Glossary of useful Programes, Tables and Roles - Enterprise Search

WEB JAVA RUNTIME - WJR

BI Java Components in 7.30

Set up Repository Manager for BI Documents and BI Metadata

Web Application Designer (WAD) - BW-BEX-ET-WJR-AD

BI Java Export Services - BW-BEX-ET-WJR-EXP

WEB JAVA RUNTIME - WJR

XCELSIUS INTEGRATION

Xcelsius Integration Basics

ABAP WEB RUNTIME

ABAP Web Runtime

Frequently Asked Questions

Performance issue during DSO request activation

FAQ — Frequently asked questions (FAQ) for SAP NetWeaver BI.

BW Accelerator (BWA)

Inventory Management - Marker Update, No Marker Update (BW-BCT-MM-IM)

BW Table Types (MD tbl, SID tbl, DIM tbl, etc)

New Lines in a PlanQuery

Compression in BW InfoCubes

BW reports (alphabetic order)

DTPs cannot be changed in a closed system

Implementation/Project Management

Implementation and Project Management — The items on this topic page provides information useful to manage a BI project and explain the different aspects involved in the implementation phase.

Downloads& Business Content Examples

Downloads — Find here a list of BI downloads.

SAP DemoContent

BI Content

Bibliography

Bibliography — In this section you can find a list of books about and related to SAP NetWeaver BI.

Planning

Demand Planning functionality wishlist

Ulises Mar

SCM APO Promotional Planning

Sheldon Edelstein

Bibliography — This section contains links to books related to Supply chain Management including APO.

Download Planning data into excel

Differences between SNP Heuristics modes

Financial and Capacity planning Graphs based on IGS

BPC Macros Becoming Disabled Automatically

Disaggregation in Demand Planning

Manual planning folder limited at 9999 rows

Financial Planning Consulting Solutions

Administering users in BPC 10 for SAP Netweaver

What is Fiddler Tool

APO Demand Planning Forecast Interface

APO Planning Book Viewer

BW-BPS Use of macros in planning layout

LTP Run to create and run Planning scenarios

Project System - Excel based Cost Planning

Process flow for Material Requirements Planning with MRP Areas

How to hide 0 values in BW-IP WAD

Overview of Packages within the BPC for Netweaver Data Manager

Top 15 BW transactions useful for BPC NW

General customizing for online planning integration from controlling

What is rescheduling and how does it work

How to set up BPC MS 7 Management Console with IIS 7

Warehouse Management

Common Issues with Open Hub

SID generation during DSO request activation

Change Status of DTP Request

Business Content

BC-BW. Necessary Corrections for the source system

Different results when loading to BW and in the extractor checker (RSA3)

BC-BW

Business_Content

Learning Map by Topic

Modeling — The items on this topic page represent the guidelines and best practices used by SAP's internal Business Content development teams, but also best practices from SAP partners and customers, to model data and to develop reporting interfaces to that data.

BI Certification Info-Links — Links and information about the certifications offered by SAP in the BI Space. Common questions regarding BI certification are addressed and relevant links provided.

Tables, transactions, programs in BI —

Programming in BW — SAP BI is based on the Netweaver platform , which has a lot of programming options. Links to programming SAP BI maingthe most of the Netweaver platform are referenced here

BW T-Codes (alphabetic order)

Data Extraction — In this section you can find relevant information about Data Exraction and books , links , blogs and how tos regarding the same.

Performance Tuning and Statistics — h2. {color:#333399}Purpose{color}

New Lines in a PlanQuery

Characteristic Relationships in a PlanQuery

Reporting — SAP BI has come from object based analysis to analysis authorizations. Analysis authorizations being markedly different in approach to the older object based aproach. This page provides a collection of Authorization related information on SAP BI

Beginner Section — How do you get started on SAP BI - this wiki section offers you pages updated by SCN members on how and where you can get started with SAP BI

Acronyms & Glossary

Acronyms
Glossary

Interesting References / Links

Links — Many experts have already posted articles and blogs about SAP NetWeaver BI on the SDN and other online magazines. Find here a collection of some of the most interesting.