ebook img

Business Planning and Analytical Services PDF

243 Pages·2007·2.76 MB·English
by  
Save to my drive
Quick download
Download
Most books are stored in the elastic cloud where traffic is expensive. For this reason, we have a limit on daily download.

Preview Business Planning and Analytical Services

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

Description:
Enhancements using function exits and BAdIs ABAP proficiency . Both tools are Web dynpro-based applications that have to be installed on the SAP J2EE . IF_RSPLFA_SRVTYPE_IMP_CHECK serves this purpose. For more information, see the F1 Help for the input field for the. ABAP class name.
See more

The list of books you might like

Most books are stored in the elastic cloud where traffic is expensive. For this reason, we have a limit on daily download.