Business Planning and Analytical Services

243 Pages·2007·2.76 MB·English

Developer’s Guide
SAP NetWeaver 7.0 SPS12

Business Planning

and Analytical

Se rvices

Document Version 4.00 – May 2007
Data contained in this document serves informational

© Copyright 2007 SAP AG. All rights reserved. purposes only. National product specifications may
vary.
No part of this publication may be reproduced or
transmitted in any form or for any purpose without the These materials are subject to change without notice.
express permission of SAP AG. The information These materials are provided by SAP AG and its
contained herein may be changed without prior affiliated companies ("SAP Group") for informational
notice. purposes only, without representation or warranty of
any kind, and SAP Group shall not be liable for errors
Some software products marketed by SAP AG and its or omissions with respect to the materials. The only
distributors contain proprietary software components warranties for SAP Group products and services are
of other software vendors. those that are set forth in the express warranty
statements accompanying such products and
Microsoft, Windows, Outlook, and PowerPoint are services, if any. Nothing herein should be construed
registered trademarks of Microsoft Corporation. as constituting an additional warranty.
IBM, DB2, DB2 Universal Database, OS/2, Parallel
Sysplex, MVS/ESA, AIX, S/390, AS/400, OS/390,

OS/400, iSeries, pSeries, xSeries, zSeries, z/OS,
Disclaimer
AFP, Intelligent Miner, WebSphere, Netfinity, Tivoli,
Some components of this product are based on
Informix, i5/OS, POWER, POWER5, OpenPower and
PowerPC are trademarks or registered trademarks of Java™. Any code change in these components may
IBM Corporation. cause unpredictable and severe malfunctions and is

therefore expressively prohibited, as is any
Adobe, the Adobe logo, Acrobat, PostScript, and
decompilation of these components.
Reader are either trademarks or registered
trademarks of Adobe Systems Incorporated in the
United States and/or other countries. Any Java™ Source Code delivered with this product
Oracle is a registered trademark of Oracle is only to be used by SAP’s Support Services and
Corporation.
may not be modified or altered in any way.

UNIX, X/Open, OSF/1, and Motif are registered
trademarks of the Open Group.
Citrix, ICA, Program Neighborhood, MetaFrame, Documentation on SAP Help Portal
WinFrame, VideoFrame, and MultiWin are
You can find this documentation at
trademarks or registered trademarks of Citrix help.sap.com/nw70
Systems, Inc.

HTML, XML, XHTML and W3C are trademarks or
registered trademarks of W3C®, World Wide Web
Consortium, Massachusetts Institute of Technology.

Java is a registered trademark of Sun Microsystems,
Inc.

JavaScript is a registered trademark of Sun
Microsystems, Inc., used under license for technology
invented and implemented by Netscape.

MaxDB is a trademark of MySQL AB, Sweden.

SAP, R/3, mySAP, mySAP.com, xApps, xApp, SAP
NetWeaver, and other SAP products and services
mentioned herein as well as their respective logos are
trademarks or registered trademarks of SAP AG in
Germany and in several other countries all over the
world. All other product and service names mentioned
are the trademarks of their respective companies.
Typographic Conventions Icons

Type Style Represents Icon Meaning
Example Text Words or characters quoted from Caution
the screen. These include field
names, screen titles, Example
pushbuttons labels, menu

names, menu paths, and menu
Note
options.

Cross-references to other Recommendation
documentation.
Example text Emphasized words or phrases in Syntax
body text, graphic titles, and
table titles.
EXAMPLE TEXT Technical names of system
objects. These include report
names, program names,
transaction codes, table names,
and key concepts of a
programming language when
they are surrounded by body
text, for example, SELECT and
INCLUDE.
Example text Output on the screen. This
includes file and directory names
and their paths, messages,
names of variables and
parameters, source text, and
names of installation, upgrade
and database tools.
Example text Exact user entry. These are
words or characters that you
enter in the system exactly as
they appear in the
documentation.
<Example text> Variable user entry. Angle
brackets indicate that you
replace these words and
characters with appropriate
entries to make entries in the
system.
EXAMPLE TEXT Keys on the keyboard, for
example, F2 or ENTER.
Contents

1 BUSINESS PLANNING AND ANALYTICAL SERVICES.................................................1
2 GETTING INVOLVED........................................................................................................2
2.1 Working with the Development Environment............................................................2
2.2 Release and Upgrade Management.........................................................................2
2.2.1 Continuing to Work with BW-BPS..................................................................3
2.2.2 Migration of BW-BPS to BI Integrated Planning.............................................4
3 GO AND CREATE.............................................................................................................5
3.1 Modeling Planning Scenarios....................................................................................6
3.2 Implementing Planning Function Types....................................................................9
3.3 Creating an Analysis Process.................................................................................12
3.4 Creating, Changing, and Activating a Model...........................................................12
4 CORE DEVELOPMENT TASKS.....................................................................................15
4.1 Developing User Interfaces.....................................................................................15
4.2 Developing Business Logic.....................................................................................15
4.2.1 BI Integrated Planning..................................................................................16
4.2.2 Analysis Process Designer.........................................................................133
4.2.3 Data Mining................................................................................................165
4.3 Developing Persistency.........................................................................................192
4.3.1 Real-Time InfoCubes..................................................................................192
4.3.2 MultiProviders.............................................................................................195
5 ENSURING QUALITY....................................................................................................198
5.1 Testing...................................................................................................................198
5.2 Logging and Tracing.............................................................................................198
5.2.1 BI Query Runtime Statistics.......................................................................199
5.2.2 Trace Tool Environment.............................................................................221
6 REFERENCE.................................................................................................................237
6.1 Interface Overview................................................................................................237
6.1.1 Analysis Process Designer.........................................................................239
6.2 Tutorials.................................................................................................................239
6.3 Checklist for Business Planning............................................................................239
Business Planning and Analytical Services May 2007
Working with the Development Environment
1 Business Planning and Analytical Services
Purpose
Various BI interfaces and tools are available if you want to modify the Business Planning and
Analytical Services scenario.
Advantages for Application Development
Business planning allows developers to create and operate planning scenarios or other
applications. Business planning provides the following planning tools for these purposes:
• BI Integrated Planning, a solution that is completely integrated into the BI system
• BW-BPS (Business Planning and Simulation)
We recommend that you use the new BI Integrated Planning functionality when you
implement new scenarios. We only recommend that you continue to use BW-BPS for small
enhancements to existing BW-BPS solutions. For more information, see Business Planning
and Simulation (BW-BPS) [External].
For a comparison of BW-BPS and BI Integrated Planning, see Release and Upgrade
Management [Page 2].
Also see the information in the SAP NW Technical Operations Manual about the Migration of
BW-BPS to BI Integrated Planning [Page 4].
BI Integrated Planning and analysis process design (for data mining solutions, for example)
are now explained in more detail.
BI Integrated Planning
• You can develop your own data models and planning-specific metadata objects for
your business planning.
• You can use the BEx Query Designer to define input-ready queries for the manual
entry of plan data.
• In the BEx Analyzer and Web Application Designer, you can develop planning
applications that support manual data entry and automatic changes to data.
• With the SAP enhancement concept, you can make enhancements to the standard in
the BI system. Within the BI system, you can use customer exits and BAdIs to make
enhancements in the Query Designer and the Web Application Designer.
Analysis Process Design
• You use the Analysis Process Designer to define analysis processes that explore and
identify hidden or complex relationships between BI data.
• You use the Data Mining Workbench to create models. This allows you to apply the
methods according to your requirements.
Prerequisites
Area Prerequisites
BI Integrated Planning: Modeling the data basis -
Business Planning and Analytical Services 1
Getting Involved May 2007
Working with the Development Environment
BI Integrated Planning: Modeling planning- -
specific metadata objects
BI Integrated Planning: Definition of an input- -
ready query
BI Integrated Planning: Creating Web Proficiency in standard markup languages
templates
Enhancements using function exits and BAdIs ABAP proficiency
Analysis process design -
Data mining -

2 Getting Involved
This section provides an overview of the concepts and the development environment.

2.1 Working with the Development Environment
Purpose
The BI system provides heterogeneous development environments for the Business Planning
and Analytical Services scenario.
Area Development Environment
BI Integrated Planning: Modeling the data basis Data Warehousing Workbench
BI Integrated Planning: Modeling planning- Planning Modeler
specific metadata objects
BI Integrated Planning: Definition of an input- BEx Query Designer
ready query
BI Integrated Planning: Creating Workbooks BEx Analyzer

BI Integrated Planning: Creating Web BEx Web Application Designer
templates
Analysis process design Analysis Process Designer
Data mining Data Mining Workbench, Analysis Process
Designer

2.2 Release and Upgrade Management
Business Planning with SAP NetWeaver Business Intelligence allows business experts to
accelerate the decision-making process, predict future trends on the basis of historic
Business Planning and Analytical Services 2
Getting Involved May 2007
Release and Upgrade Management
analyses, and provide all decision makers with a central point of access to data and
information.
To create and use planning scenarios or other applications, business planning with SAP
NetWeaver Business Intelligence offers the following planning tools:
• BI integrated planning, a solution that is completely integrated into the BI system
• BW-BPS (Business Planning and Simulation)

We recommend that you use the new BI integrated planning functionality when
you implement new scenarios. For more information, see Business Planning
[External].
Note the following in relation to the behavior of the two planning tools:
BW-BPS Versus BI Integrated Planning
In BI integrated planning, most of the BEx and OLAP analysis functions are also available for
planning applications. In comparison with BW-BPS, you need a smaller number of objects (for
example, by using the same variables in analysis and planning) and tools (Query Designer
and Web Application Designer).
Since a large number of BW-BPS concepts are also used in BI integrated planning (such as
planning levels, planning functions, planning sequences, characteristic relationships, data
slices), these can, if necessary, be switched to BI integrated planning from BW-BPS with
minimal effort.
BW-BPS Versus BI Integrated Planning in Parallel
Both planning tools use the same data basis and can be operated in parallel in one system. It
is not necessary to migrate existing planning applications.
Some functions (such as, lock procedure and formulas) are used by both BW-BPS and BI
integrated planning.

2.2.1 Continuing to Work with BW-BPS
Authorizations
The authorization concept for the planning objects such as planning levels, planning functions
or maps, has not changed; migration is therefore not required.

For more information, see Authorizations for Business Planning and Simulation
[External].
The authorizations for the used data are analysis authorizations. Note the information about
the migration of reporting authorizations to the new concept.

For more information, see Reporting Authorizations - > Analysis Authorizations
[External].
Business Planning and Analytical Services 3
Getting Involved May 2007
Release and Upgrade Management
Lock Management
BW-BPS and BI integrated planning use the same lock management for transaction data. The
settings for lock management are made using transaction RSPLSE. For more information
about possible settings, see the information text for this transaction.
If, in earlier releases, you made special settings for the BPS lock management in BW-BPS by
using SAP Note 635244, you must manually maintain these settings in transaction RSPLSE.
This affects, for example, the maintenance of characteristics relevant for the lock.
Transaction RSPLSE also serves as a lock monitor; the UPC_ENQUEUE_READ report for
reading the locked selections is now obsolete.

See also:
For more information about the functions of Business Planning and Simulation (BW-BPS),
see Business Planning and Simulation (BW-BPS) [External].

2.2.2 Migration of BW-BPS to BI Integrated Planning
Authorizations
The authorizations that users require for BI Integrated Planning are the same authorizations
they require to analyze the data in a query. In addition to the authorization for displaying data,
the authorization for changing data is also required in the analysis authorizations.

For more information, see Authorizations for BI Integrated Planning [External].
Lock Management
Lock management is new in BI Integrated Planning; it is also used by BW-BPS. You make the
relevant settings in transaction RSPLSE. For more information about possible settings, see
the information text for this transaction.
Data Modeling
In BI Integrated Planning, the Data Warehousing Workbench objects that are used are the
same as those used in BW-BPS. Migration is therefore not required for the following objects:
• InfoCubes
• InfoObjects (characteristics and indicators)
• Hierarchies
Note that transactional InfoCubes are now referred to as real-time InfoCubes.
Objects for the Planning Model
Objects that you created in the planning workbench (transaction BPS0) for BW-BPS must be
migrated to the new objects in the planning modeler. Once any necessary remodeling is
complete, you have to create the objects as new objects in the planning modeler. You can
use the old objects as templates. The objects in the planning model relate to each other as
follows:
BW-BPS BI Integrated Planning
Planning area InfoCube settings
Business Planning and Analytical Services 4
Go and Create May 2007
Release and Upgrade Management
Characteristic relationship Characteristic relationship
Data slice Data slice
Planning level Aggregation level
Package Filter
Planning function Planning function
Planning layouts are replaced by input-ready queries.

For more information, see Modeling Planning Scenarios [Page 19].
Creation of Planning Applications
One significant concept change affects the interface. Planning layouts, planning folders and
Web interfaces cannot be migrated. The functions must be rebuilt using tools from the BI
suite: the BEx Query Designer, the BEx Web Application Designer, and the BEx Analyzer.

For more information, see Creation of Planning Applications [Page 87] and Performing
Manual Planning [Page 119].
Retractors
In BI Integrated Planning, no new retractors are shipped.
In BI Integrated Planning, you can only use some of the retractors that are used in BW-BPS:
you can use any retractors that work according to the pull principle (COPA and Public Sector)
without changing them. Other retractors cannot be used directly in BI Integrated Planning;
retraction is only possible using BW-BPS.
Status and Tracking System (STS)
If you use BI Integrated Planning, you can use the STS of BW-BPS.

For more information, see Integrating BI Integrated Planning [External].

3 Go and Create
We provide instructions for first development in the following areas:
BI Integrated Planning: Modeling Planning Scenarios
You use the planning modeler and the planning wizard to model, administer, and test all the
metadata that belongs to a planning scenario.
For information about creating planning models, see Modeling Planning Scenarios [Page 19].
BI Integrated Planning: Implementing Planning Function Types
Planning function types are parameterizable processes that change transaction data within BI
Integrated Planning.
Business Planning and Analytical Services 5
Go and Create May 2007
Modeling Planning Scenarios
For information about creating planning function types, see Implementing Planning Function
Types [Page 85].
Analysis Process Design
Analysis processes allow you to explore and identify complex relations between BI data in a
simple way.
For information on creating a simple analysis process using the Analysis Process Designer,
see Creating Analysis Processes [Page 137].
Data Mining
You create a model for a data mining method so that you can apply the method according to
your business requirements.
For information on creating a model in the Data Mining Workbench, see Creating, Changing
and Activating Models [Page 180].

3.1 Modeling Planning Scenarios
Purpose
To model your planning scenarios, BI Integrated Planning provides you with the Planning
Modeler and the Planning Wizard.
Both tools are Web dynpro-based applications that have to be installed on the SAP J2EE
Server. You can allow access to these applications using links or iViews in the portal. It is not
necessary, therefore, to install the SAP front end locally.
Planning Modeler
You use the planning modeler to model, manage, and test all the metadata that belongs to a
planning scenario.
Interface
The tab pages InfoProvider, Aggregation Levels, Filters, Planning Functions and Planning
Sequences are structured in such a way that in the upper part of the screen you have the
option to search using objects that can be selected in the system, and a table which displays
the results of the search. If you select or create an entry, in the lower part of the screen the
system displays the properties of the respective object and provides the user with options to
edit the object.
You can modify the interface as required by hiding or showing the subareas.
To modify the table layout, you can:
• Choose Filter On and enter descriptions in the input-ready rows by which the table
columns are filtered.
• Choose Settings and select table columns and define the sequence and the general
settings for the table layout. When you upgrade, it cannot be guaranteed that the user-
specific settings for the table views in the planning modeler will be retained, or that you
will be able to reuse them if you have saved them locally.
Functions
The planning modeler provides the following functions:
...
Business Planning and Analytical Services 6