Preview only show first 10 pages with watermark. For full document please download

Sap Bpc Life Cycle

Rating
Date

March 2018
Size

2.1MB
Views

306
Categories

Microsoft Excel Sap Se Web Application Areas Of Computer Science Technology

Transcript

SAP Business Planning and Consolidation

A smart overview through the history and the functionalities of SAP BPC tools

Story Board
SAP BPC 7.0, version for the
Microsoft platform

Focus on

SAP BPC 7.5, version for the
Microsoft platform

SAP BPC 7.5, version for
SAP NetWeaver

SAP BPC 10.0, version for
the Microsoft platform

SAP BPC 10.0, version for
SAP NetWeaver

SAP BPC 10.1, version for
the Microsoft platform

SAP BPC 10.1, version for
SAP NetWeaver

SAP BPC 7.5
version for SAP NetWeaver

Architecture
Focus on
 Complex Architecture
 High maintenance costs
 BPC 7.5 NW Utilizes MDX Query
 BPC 7.5 NW Components Did Not Run
Completely on 64-Bit Technology Thus
Limiting Performance
 End of maintenance 31.12.2017

Tier

2.53 and BW7.40.5 system.30.3.53.Net server and client software to the equivalent support package of 7. Upgrade BW system from 7. Upgrade CMPBPC from 7. © 2014 Unisys Corporation. powered by SAP HANA.54 NW (starts from SP02).5 to BPC 10.53 by performing the following steps: 1.0x to SAP NetWeaver 7. as it avoids the disruption and risk of the in-place upgrade.3 to BW 7.3 Upgrade from ABAP version 7. Migrating to new system (From BPC 7. it can be set up with NetWeaver on HANA. but does not include HANA specific performance optimization. Upgrade the Planning and Consolidation .53 3. starting with new hardware. • BPC 7.4 and migrating the database to SAP HANA. 2. In-place upgrade • Complex • Disrupted • High Risk Migrating • Limited Disruption • Limited Risk • Benfit using new hardware A system copy followed by an upgrade is an interesting compromise.x to 7.50 to 7.x) The other option is to procure an entirely new system. are supported and available for productive usage on SAP NetWeaver BW 7. Upgrade SAP NetWeaver 7. It uses HANA in the same way as it does for conventional database. and then adding the HANABPC accelerator. with the exception of the savings on hardware.Upgrading or Migrating Scenario 1.x to 7. FOR INTERNAL USE ONLY. All this without even touching the 7. All rights reserved. The application sets (environments in BPC 10) can be brought over using transaction code UJBR. and the system can be validated. (SAP Note 1923480) 3. then you need to install the BPC 10 ABAP component. Next step is upgrading from BW 7. while keeping its benefits. Once procured.50 to version 7.4 • You need to upgrade first to BPC 7. Upgrade BW system from 7. 6 . Then BPC and its accelerator for HANA can be installed.

which will lower maintenance costs.NET tier has been removed from the architecture making this more consistent with SAP NetWeaver releases.Architecture The . © 2014 Unisys Corporation. FOR INTERNAL USE ONLY. All rights reserved. 9 .

Migration Steps to Classic BPC 10. Migrate features that are not supported by the mapping programs 7. FOR INTERNAL USE ONLY.2 (optional) 3.5 to 10. Deal with problems and unforeseen issues 6.5 FOR SAP NW 10.0 NW SBOP PC 10. All rights reserved. Execute the migration program • 7. Migrate to BW 7.3 or 7.4 (in-place or system copy) 2. Upgrade security and Active Directory or CMS to SAP BW User Accounts • Create SAP BW User Accounts • Assign security roles and authorizzations to the new user accounts • Create a tab-delimeted mapping file for use by migration program to map old user to new users 5.0 BPC Version Official Product Name 7. Migrate to BWA 7. program UJT_MIGRATE_75_TO_101 Next.0 FOR SAP NW First.5 to 10. program UJT_MIGRATE_75_TO_10 • 7.1 tcode: SE38. migrate software components 1.0 tcode: SE38. migrate customer data and features 4. 11 .5 NW SBOP PC 7. Regression test and validate © 2014 Unisys Corporation.

5 Only Allows for a Single Write Back After All Calculations Have Been Evaluated Resulting in Slower Performance of Script Logic Packages (ie Loading Finance Application Data to the Consolidation Application. utilizing BEx query instead of MDX  Script Logic Parallelism  Script Logic processes execute faster due to Parallelism. All rights reserved. Allocations)  BPC 7.5 NW Utilizes MDX Query Which is Less Efficient Than the BEx Query Method Used by BPC 10 NW  BPC 7.5 NW Components Did Not Run Completely on 64-Bit Technology Thus Limiting Performance © 2014 Unisys Corporation.Differences between BPC 7.NET layer  BPC NW10 does not use the . 13 . which enables multiple write back processes at the same time  Removal of the .NET Technology Which Requires Special Knowledge and Increases System Maintenance  BPC 7. FOR INTERNAL USE ONLY.5 NW Requires the Microsoft ASP .5 & BPC 10 Perfomance Driver Key Benefits  Query Change  Up to 50% performance improvement with query change.NET layer which removes potential for performance bottlenecks and decreases system maintenance  Removes 32-bit bottleneck  BPC NW10 runs true 64-bit technology Version Differences  BPC 7.

Comments in BPC 10 Can Be Copied Via a Standard Data Manager Package  Local Members in BPC 10 Allow Users to Create Formulas That Can Be Automatically Detected and Become Part of the Report © 2014 Unisys Corporation.5 NW. All rights reserved. 14 .Differences between BPC 7.5 & BPC 10 User Experience Driver Key Benefits  Member Recognition  Quickly access data with the use of Member Recognition  Local Members  Create complex functions to be evaluated based on EPM functions not hard coded cell references  Enhanced Formatting Capabilities  Apply formatting on a wide range of parameters  Comments  Improved Comment functionality enables copying of comments and better viewing and saving options (as an in-cell Excel comment) Version Differences  BPC 7. FOR INTERNAL USE ONLY.5 NW Uses EVDRE() to Generate Reports Which Requires More Training Than the Intuitive Reporting Options with BPC 10  BPC10 is Capable of Automatically Detecting Dimension Members Entered Directly in Worksheet  BPC 10 Dynamic Formatting Sheets Can Be Shared With Other Workbooks/Reports  Unlike BPC 7.

5 NW Does Not Have a Cube Name Stabilization Feature to Prevent the Cube Name From Changing When Running Full Optimization © 2014 Unisys Corporation. FOR INTERNAL USE ONLY.5 NW Only Allows for a All-Or-None Standard Functionality for BW Transports of Application/Models Developed in DEV and Tested in QAS.5 & BPC 10 System Administration Driver Key Benefits  Centralized. More Accessible and Stable Administrator  Completely redesigned Administration Interface centralizes all system administration and configuration activities into one stable web interface  Granular Transport  New feature to allow for granular transports rather than transporting entire AppSets  Cube Name Stabilization  Cube Name Stabilization Parameter prevents BPC cube technical names from changing during Full Optimization Version Differences  BPC 10 NW Utilizes a Web Based Administration Client  BPC 7. BPC 10 NW Allows for Granular Transport  BPC 7.Differences between BPC 7. 15 . All rights reserved.

5 NW Effectively Only Allows for Full Data Loads. Which Increases Cube Size and Decreases System Performance  Delta Loads Can Be Executed in BPC 10 NW  Utilizing a Hybrid Provider.5 & BPC 10 Data Accessibility Driver Key Benefits  Direct Delta Loads From SAP ERP  BPC 10 now supports direct delta loads from SAP ERP system  Real-Time Data  With BPC 10 on HANA.Differences between BPC 7. FOR INTERNAL USE ONLY. data can be automatically loaded into BPC from ECC Version Differences  BPC 7. BPC 10 NW Allows for Real-Time Data From SAP ERP © 2014 Unisys Corporation. 16 . All rights reserved.

5 NW’s Park and Go has been replaced with BPC 10’s Offline feature.5 & BPC 10 Enhanced Functionality Driver Key Benefits  Significantly Improved Business Process Flow  New functionality and interface provides greater control and visibility into the status of each business process  Park and Go  Streamlined into a single feature  Book Publishing  Fully functional Book Publishing feature with new interface allows for automated publication of reports printed to PDF or saved to a network folder.5 NW  BPC 10 NW’s Book Publishing feature is fully functional with a more user friendly interface © 2014 Unisys Corporation.  Controls and Validation  Automated built-in features automatically perform validation to ensure certain criteria rules are met Version Differences  Enhanced user interface and functionality in BPC 10 NW’s Business Process Flow increases user adoption and reviewer/owner visibility  BPC 7. All rights reserved.Differences between BPC 7. FOR INTERNAL USE ONLY. which is not prone to worksheet errors common in BPC 7. 17 .

you can select from your objects. • Library: Provides information about how to access the objects that are saved in the Library view. and retrieve files. create reports and launch client applications. • Documents: Provides information about using the Documents view to post. FOR INTERNAL USE ONLY. and to manage content display • Audit: Provides information about reporting on system information and activity. 18 . – Consolidation Monitor: Generate and monitor consolidated data from data reported by Group and Entity members – Control Monitor: Execute and monitor controls used to validate the reported data – Journals: Create and manage journal entries containing adjustments and eliminations used for correcting reported data – Ownership Manager: Create and Manage ownership-based hierarchies used for performing statutory consolidations © 2014 Unisys Corporation. • Activities: Provides information about using Business Process Flows (Processes). All rights reserved.Web Client The New Web Client has the following Components: • Start Page: Describes the initial Planning and Consolidation web client page. • Consolidation Central: Helps to generate and manage consolidated data. From this page.

and favorites in one convenient page Administration client for version for SAP NetWeaver is fully integrated into the web © 2014 Unisys Corporation. FOR INTERNAL USE ONLY.Look & Feel Start page has been updated to make it a central launch point for applications Delivered workspace integrates core functions. administration client. 19 . All rights reserved. Office Addins.

All rights reserved. It allows you to create periodic-specific hierarchies of corporate entities to use in statutory consolidation. 23 .Consolidation Central Ownership Manager is used to define an ownership-based hierarchy entity structure. © 2014 Unisys Corporation. or in cases where hierarchy changes for an application need to be tracked by Category and Time. FOR INTERNAL USE ONLY.

Dimension • • • All the properties and settings of a Dimension are managed in the Structure view. 26 . All rights reserved. This page allows you to add a dimension property or add the required properties for Consolidation or for Ownership model You can also add the hierarchies to the dimensions © 2014 Unisys Corporation. FOR INTERNAL USE ONLY.

filtering. The maximum length of a Member ID can be 32 characters and can accept dash and underscores but cannot accept any other special characters. FOR INTERNAL USE ONLY. sorting. © 2014 Unisys Corporation. A icon enables to identify the status of the edited members and a tooltip provides the details of the errors.Dimension • • • The members are managed in an “Excel like” grid and you can copy and paste (within the list and from Excel). and so on. Member status is displayed in the row headers of the list of all members that have been edited or changed or added. and ordering column. All rights reserved. 27 .

All rights reserved. FOR INTERNAL USE ONLY.Enhanced Hierarchy Management Administration users can now graphically edit hierarchies to more efficiently maintain their systems Advanced Editing features such as drag and drop and or ‘move up’ and ‘move down are supported © 2014 Unisys Corporation. 28 .

Among the selected dimensions you can also set the secured dimensions (for example.Model • • • You cannot select multiple dimensions of the same type except for the user-defined dimensions. New models can be created either from scratch or by using an existing model as a source. 29 . © 2014 Unisys Corporation. the dimensions that will be used to define the data access profiles for this model). All rights reserved. FOR INTERNAL USE ONLY.

All rights reserved.Security On the front end side there is no change in the BPC 10 security except that the BPC users are NetWeaver users instead of Active Directory users. 30 . FOR INTERNAL USE ONLY. Security settings are more transparent with SAP NetWeaver backend system Dynamically synchronization of security settings with the SAP NetWeaver backend for SAP NetWeaver roles and profiles © 2014 Unisys Corporation.

31 .Script Logic Creating scripts is more efficient based on updates to the script logic editor Logic script functions and MDX keywords are available for selection in the new editor. FOR INTERNAL USE ONLY. with the required syntax automatically suggested Adding/Removing Comments can be used to determine what portions of a script are executed Pretty printer can be used to enhance readability © 2014 Unisys Corporation. All rights reserved.

© 2014 Unisys Corporation. The work status also prevents the unwanted data changes (locking) once the data entry is finalized based on the work status. This eliminates the need for a complex security model to lock the data once the data is finalized. The work status feature allows seamless communication and tracking of the work status during the data collection phase. 32 . All rights reserved. FOR INTERNAL USE ONLY.Work Status The work status feature facilitates better information management and approval process by associating configurable and customizable wok status to the combination or intersection of data.

•The lower area renders all instances of a certain activity your are involved in © 2014 Unisys Corporation. All rights reserved. FOR INTERNAL USE ONLY.Business Process Flow (BPF) •The upper area renders all activities you are involved in. 34 .

FOR INTERNAL USE ONLY. 35 . All rights reserved.Simplified Report Creation Business users can easily create web report/input schedule Ad-hoc Web reports are easy to create within a workspace or reports can be created by themselves and published Charts and graphs can be added with a click of a button Drag and drop is enabled for report creation and data can be dynamically retrieved as it is being designed © 2014 Unisys Corporation.

books and dashboards. input schedules. © 2014 Unisys Corporation.Streamlined Library and Document Actions Accessing the library and storing documents are even easier with the new user interface Library interface makes it simple to add content such as workspaces. Favorites can be saved in the library for the initial launch page Document page has also been updated to improve the user experience. All rights reserved. 36 . reports. FOR INTERNAL USE ONLY.

37 . version for SAP NetWeaver or version for the Microsoft platform through ODBO or Web Service SAP BusinessObjects Enterprise : Connection can also be established to SAP PCM or FC10 via ODBO Local : Through ODBO Excel add-in can also be connected to Analysis service or Hyperion Essbase or SAP BW © 2014 Unisys Corporation. All rights reserved.EPM Add-in Multiple connections can co-exists in a single worksheet Planning and Consolidation : Excel add-in can be connected to SAP BusinessObjects Planning and Consolidation. FOR INTERNAL USE ONLY.

FOR INTERNAL USE ONLY.Look & Feel EPM-Add in menu streamlined to be more intuitive to end user New ribbon with set of action buttons for creating reports. action button for performing planning function. All rights reserved. managing and formatting reports. 38 . action button for publishing workbooks Context bar provides a user friendly way of selecting members © 2014 Unisys Corporation. action button for save and refresh data.

SAP BusinessObjects Planning and Consolidation automatically recognizes the members © 2014 Unisys Corporation. FOR INTERNAL USE ONLY.Simplified Report Creation Business users have multiple ways of creating a report/input schedule Report Editor facilitates wizard based creation of report with simple drag and drop dimension EPM Window facilitates users to create quick reports by dropping the dimension to the respective window Direct Member Entry: User can directly enter the member into Excel grid. All rights reserved. 39 .

Show Source Data in Comments enables to view parent level value which is stored in the backend as comments. All rights reserved. 40 . © 2014 Unisys Corporation. FOR INTERNAL USE ONLY. Calculate Parents in Hierarchies enables instantaneous calculation of the parent member based on the child node values instead of fetching values from the backend.Enhanced What-If Capabilities Use parent member formulas to improve what-if planning scenarios Keep Formula on Data enables having the excel summation against the Parent member.

All rights reserved. FOR INTERNAL USE ONLY. 41 . This option is very useful to create relative periods Member property : allows selecting a dimension member thanks to a property value of another dimension member of the same dimension Multiple Option: In addition it has multiple other options to select members dynamically © 2014 Unisys Corporation.Enhanced Member Selector New member selector more powerful and intuitive to use Member off-set : allows selecting dimension members relatively to another dimension member (at the same hierarchy level or a different one).

All rights reserved. 10 also eliminates the . 10 now uses the in-memory database to make applications run faster. Version 10 now offers packaged solutions for specific lines of business and industry areas. Specific Industry or Line of Business Packaged Solutions. Improved System Performance. Expanded Mobile Delivery Options. SAP effectively re-developed the entire BPC solution to better fit into the SAP landscape. The improved user experience will increase the speed of planning and consolidations by increasing the numbers of people contributing. Enhanced Manageability. 10 also improves reporting drag and drop functionality.Why upgrade to BPC 10 1. 5. 10’s transformational architecture changes eliminate manual reporting efforts. ERP software. and Harmonized User Experience. web-based frontend with an improved query manager that allows users to better investigate entries. intuitive. One of the more obvious improvements of version 10 is its new and improved look and feel. objects and information stored and aggregated in one BusinessObjects application can be shared more widely with another. drag and drop hierarchy builds. 7. 42 . Streamlined. It increases data handling and business intelligence (BI) capabilities. Enhanced Journal Management. 10 enhances manageability and reduces cost of ownership by improving integration with the SAP NetWeaver technology platform. The more visually appealing. and even the SAP environment. Integrity and Maintenance. 6. Version 10 offers expanded mobile device support for the Apple iPAD and RIM BlackBerry PlayBook tablets. © 2014 Unisys Corporation. Journals are now entered via a new. New functionality in 10 allows simple. Backend system improvements yield industry-leading validation and monitoring of data integrity. browser-driven user interface is unified with SAP’s other EPM products. Now. 3. 10’s new user console pulls functionality into one central user interface offering users more intuitive. 8. helping transform the way people work. FOR INTERNAL USE ONLY. creating a common interface and seamless user experience throughout the EPM suite. and other business analytics applications. Improved Reporting. 4. 2. streamlined control. 10 enables users to create seamless links to other reporting applications improving the function of drilling down to detailed information outside of BPC applications. Simplified Hierarchy Maintenance. Unified.NET server on the NetWeaver platform. streamlining the hardware architecture and better integrating security with the NetWeaver backend.

Migration Steps to Classic BPC 10.5 NW SBOP PC 7.1 BPC Version Official Product Name 7.3 or 7.1 FOR SAP NW (Classic & Unified First. migrate software components 1.0 to 10.5 FOR SAP NW 10. Upgrade security and Active Directory or CMS to SAP BW User Accounts • Create SAP BW User Accounts • Assign security roles and authorizzations to the new user accounts • Create a tab-delimeted mapping file for use by migration program to map old user to new users 5.1 NW SAP PC 10.4 (in-place or system copy) 2. Migrate to BW 7. Regression test and validate © 2014 Unisys Corporation.0 FOR SAP NW 10.1 tcode: SE38. FOR INTERNAL USE ONLY. program UJT_MIGRATE_75_TO_101 • 10. All rights reserved. migrate customer data and features 4. Migrate features that are not supported by the mapping programs 7.1 tcode: SE38.0 NW SBOP PC 10. Migrate to BWA 7.5 to 10. Deal with problems and unforeseen issues 6. Execute the migration program • 7. 46 . program UJT_MIGRATE_10_TO_101 Next.2 (optional) 3.

1 a new data model is introduced that combines the strength of the different planning components • SAP BPC NW for end-user friendliness and flexibility • SAP BW-IP for feature richness and integrated data consistency • SAP HANA for blazingly high performance The former was focusing on line-of-business driven scenarios with a strong focus on flexibility and end-user friendliness. It sits on SAP BW. The add-on also provides connectivity to the EPM EXCEL add-in. it also requires the BPC NW license. the ‘standard’ and the ‘embedded’ models for modelling and runtime.What’s New on BPC 10. The collaboration-capabilities were adjusted to this architecture and moved into SAP BW (grey component).1 product. FOR INTERNAL USE ONLY. Doing so. This ensures a unified end-user experience. These add-ons are not required for the BPC NW ‘embedded’ model. In addition a new interface is contained in SAP BW to connect to the EPM add-in. © 2014 Unisys Corporation. in particular using its new HTML5 web-client for administration and runtime as well as the EPM EXCEL add-in.1 Unified Model ? With SAP BPC NW 10. The BPC HTML5 web-client has also moved to SAP BW and connects to both. The ‘embedded’ model complements the existing BPC NW data model which is called ‘standard’. 47 . For BPC NW ‘standard’ (orange components). the ‘BPC add-on’ is required. in addition to the existing connections to Analysis Office and Design Studio. Finally SAP HANA is mandatory for the BPC ‘embedded’ model to facilitate best performance on highly flexible data models. All rights reserved. It rather fully uses the reporting and planning capabilities of BW as well as its data warehousing and data management. which contains the specific planning and reporting logic of BPC and collaboration features. hiding many of the technical details. but only uses its reporting and some of its data management capabilities. An additional add-on is available to make use of HANA for specific functions and acceleration purposes. The new model is completely integrated into the BPC NW 10.

validations can also be implemented using Script Logic Characteristic Relationships (methods CHECK. in addition display hierarchies in BW queries Infoproviders InfoCube as a pure storage build in BW concepts. parent-child relations BPC hierarchies. CREATE). correspond to BW hierarchies with postable nodes BW hierarchies. validations can also be implemented using FOX or exit planning functions Data protection BPC Work Status Data Slices. BPC Work Status (mapped to technical data slices at run time) EPM Add-in Direct access to BPC Model and Data Requires a Bex query acting as a data provider to support EPM Add-in User Interface EPM Add-in and Web EPM Add-in (via Bex Query). only one techncial key figure in BPC generated BW InfoCube Key Figures. with respect to BW time characteristics or currency/unit characteristics Constraints for persistence BPC Rules (known as 'validations‘ in other products). Analysis for MS Office . 48 . fiscal) • currency/unit characteristics • compounded Representation of values Measure. of various types •amounts linked to a currency characteristic •units linked to a unit characteristic •numbers of various technical types. Bex and Web More information on SAP SCN © 2014 Unisys Corporation. time Hierarchies. CATE model: • Category (version) • Account (to model the measures) • Time (nothing to do with BW time characteristics) • Entity (mainly consolidation) • plus generic dimensions Characteristics • pure generic. All rights reserved. with different node types. •date. except • 13 time characteristics (calendar. FOR INTERNAL USE ONLY.Difference between Standard & Embedded Concept BPC standard BPC embedded Name space All objects have Standard name space /CPMB All BW name space (no transfer dato from BW name space to /CPMB objects) Representation of dimensions Dimensions. DERIVE.

1 Unified Model • • • • • • • • • • BW Data Model Bex Planning Functionality Fox Formula Calculation PAK HANA based Functions EPM Add-In HTML 5 Admin Client HTML 5 Web Based Planning BPF Audit Work Status The approach they seem to have taken is to merge the IP back-end with some of the SAP BPC front-end functionality. All rights reserved. FOR INTERNAL USE ONLY. work status and data auditing are available. © 2014 Unisys Corporation.Features BW-IP BPC • BW Data Model • Bex Planning Functionality • Fox Formula Calculation • PAK HANA based Functions • EPM Add-In • HTML 5 Admin Client • HTML 5 Web Based Planning • BPF • Audit • Work Status BPC 10. using BW infoobjects. 49 . For example: •The underlying SAP BW cubes are modelled like IP cubes. such as BPFs.1 web front end is the web portal for interacting with the unified planning model •Certain BPC 10. rather than BPC dimensions •Planning functions are still developed using the IP functionality •The EPM Add-In is the front end for interacting with the unified planning model •The BPC 10.1 features.

50 . All rights reserved. PAK functions running directly on HANA: • Copy • Repost • Revaluation • Delete • Delete Invalid Combinations • Set Key Figure Values • Distribution by Reference Data • Generate Combinations • Repost on Basis of Characteristic Relationships • Distribution With Keys • Formula (FOX) –With restrictions • Disaggregation within the Query *Note 1637199 Contains full details © 2014 Unisys Corporation.What is PAK? The Planning Application KIT allows for planning functions to run within HANA. FOR INTERNAL USE ONLY.

0 NW SAP BPC 10. 52 .Bibliography SAP BPC 7.1 NW Product Availability Matrix (PAM) Enterprice Performance Management (EPM) EPM (Wiki) EPM Add-in Academy © 2014 Unisys Corporation.5 NW SAP BPC 10. FOR INTERNAL USE ONLY. All rights reserved.

Sap Bpc Life Cycle

Rating

Date

Size

Views

Categories

Share

Transcript

SAP Business Planning and Consolidation