Selective deletion in Process chains

Before loading the data to InfoCube, sometimes we need to delete the particular date range data in InfoCube based on some selections i.e. using selective deletion and then load the data to InfoCube
Download

Demand forecasting and statistics_Basic guide

Statistics and forecasts are a matter of our daily business and private life. Therefore, a basic knowledge of the statistical key-figures and the forecast methods often used is required. The paper illustrates the statistical key figures of mean values, variance and standard deviation, Normal and Poisson distribution. It explains basic forecast methods such as moving average, exponential smoothing and linear regression.
Download

How to delete baseline forecast in APO DP Planning book when Macro is not working fine

This is not a standard procedure. 

Its simple by copying a keyfigure which has zero values in future (like Base history) to the Baseline forecast keyfigure. The transaction used is "/sapapo/tscopy".

For target and source give the same planning area and version. Select the period that need to be deleted. Select the keyfigure assignment and give the target and source description.

Dont check propose keyfigures. Execute and check the log. Now go b

ack to your planning book. Its clean :))))

SAP APO an overview

The SAP Advanced Planner and Optimizer builds on
the SAP Business Framework to improve information
flow by incorporating real-time collaborative decision
support, advanced planning, and optimization into the
SAP R/3 System. SAP APO uses a powerful memory
resident analytical engine and highly specialized, highly
configurable data objects that offer major new
components:

>> Supply Chain Cockpit

>> Demand Planning

>> Supply Network Planning and Deployment

>> Production Planning and Detailed Scheduling

>> Global Available-to-Promise

SAP - Advanced Planner and Optimizer (SAP APO)

Slide

Model, Monitor and Manage the supply chain with a graphical “bird’s eye” view of activities

•Demand Planning - analyze patterns, etc. to create demand forecasts.

•Supply Network Planning & Deployment - load balancing - match purchasing, production and transportation processes to demand

Remote cubes

Unlike with BasisCubes however, no data is physically stored in SAP BW. The data is taken from the source systems only after a query has been executed. There are three types of remote cube. They can be distinguished by the way in which they retrieve data. 

Types of Remote cubes:

Virtual Cube Types -SAP RemoteCube
A SAP RemoteCube allows you to define queries with direct access to transaction data in other SAP systems.

-General RemoteCube:

A general Remote Cube allows reporting using data from non-SAP systems. The external system transfers the requested data to the OLAP processor via the BAPI.

-Virtual InfoCube with Services:

For a virtual InfoCube with services, a user-defined function module is used as the data source.

For more information you can go through the link below which will take APO/BW as an example:

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/5f229690-0201-0010-84ba-9ee5a8958a05

Information Broadcasting

Information Broadcasting

Purpose

Information broadcasting allows you to make objects with Business Intelligence content available to a wide spectrum of users, according to your own requirements.

Notes on Implementation

The documentation on information broadcasting is structured according the requirements of users so that you are provided with role-specific guides to support you in performing tasks. For example, if you belong to the implementation team, you require the installation guide and the configuration guide. As a system administrator, the administration guide is available.

Before users can use information broadcasting, you have to install the necessary components (installation guide), make the necessary configuration settings (configuration guides), consider security recommendations (security guide), and make the necessary settings in system administration (administration guide).

Configurations and Settings

Information Broadcasting (Click Here)

Pre-Calculation Service (Click Here)