TZPC10_EN_Col96_FV_Show.pdf

(1)

SAP BusinessObjects Planning and

Consolidation 10.0, Version for SAP

NetWeaver

(2)

Introduction - Delta Changes Summary

Lesson Objectives

After completing this lesson, you will be able to:

Explain all the new SAP BusinessObjects Planning and Consolidation 10.0, version for SAP NetWeaver Delta changes

(3)

Topics Page

1. Architecture

Backend and Frontend changes Connectivity

2. Platform Support and

Authentication

ABAP Application Server Support

3. Administration and EPM Clients

Administration Console

Harmonized Web User Interface and EPM add-in

4. Functional Enhancements

5. Technical Enhancements

(4)

Topics Page

1. Architecture

2. Platform Support and

Authentication

ABAP Application Server Support Client Support

Security

3. Administration and EPM Clients

4. Functional Enhancements

5. Technical Enhancements

(5)

Architecture

Backend and Frontend Changes

The SAP BusinessObjects Planning and

Consolidation 10.0, version for SAP

NetWeaver installation consists of an ABAP

Application server and Client installation.

.NET Server is no longer required Enhanced native SAP ERP and

NetWeaver BW Integration as well as SAP EPM integration Via Financial Information Management

New harmonized UI and common EPM add-in

(6)

Architectural Changes between BPC NW 7.5 and BPC NW

10.0 BPC NW 7.5

Database

Relational Database

(any NW supports) BWA

In memory (optional) NetWeaver BW (Application Server)

Application Logic NetWeaver BW OLAP Engine

MDX

Web Server (IIS) & .NET Application Server

Conversion and Application Services Web Services BPC Clients SQL Admin (Thick) MS Office Clients Web (Thin) Others RFC Calls HTTP/SOAP

BPC NW 10.0

Database Relational Database

(any NW supports) BWA

In memory (optional) NetWeaver BW (Application Server)

Application Logic NetWeaver BW OLAP Engine MDX BPC Clients SQL Admin (Thin) MS Office Clients Web (Thin) Others HTTP/REST

(7)

Architecture

Connectivity

REST (Representational State Transfer) Web Service enables communication

between SAP BusinessObjects Planning and Consolidation Clients and SAP

NetWeaver BW (Application Server).

Also known as RESTFul Web Service, it relies on a stateless, Client / Server,

cacheable communications protocol and in virtually all cases, the HTTP

communication protocol is used.

All services will be exposed as RESTful Web services for internal communication

between BPC 10 NW clients and server.

SOAP (Simple Object Access Protocol) Web services will be used to communicate

with external applications such as EPM Applications (that is FIM).

(8)

Topics Page

1. Architecture

2. Platform Support and

Authentication

Security

3. Administration and EPM Clients

4. Functional Enhancements

5. Technical Enhancements

(9)

Platform Support and Authentication

ABAP Application Server Support

Requires SAP NetWeaver 7.3

Any operating system supported by SAP NetWeaver 7.3 ABAP Web Application Server

VMware for productive usage

Any database supported by SAP NetWeaver 7.3 Web Server: ABAP Web Application server

Language support: Install SAP BusinessObjects Planning and Consolidation on

non-English OS servers in French, German, Japanese, Simplified Chinese, Russian, Spanish, Italian, Portuguese.

(10)

Platform Support and Authentication

Client Support

Windows Vista Client (32 and 64-bit), Windows XP (32-bit) and Windows 7 (32-bit and 64-bit)

Internet Explorer 7 and 8

(11)

Platform Support and Authentication

Security

Key Points about Security:

SAP NetWeaver Authentication Granular security

BPC service user role and BPC User role

Integration into Single Sign-On (SSO) environment Limited access to NW security

Support for NW Users and Matrix Security

(12)

Topics Page

1. Architecture

2. Platform Support and

Authentication

Security

3. Administration and EPM Clients

4. Functional Enhancements

5. Technical Enhancements

(13)

Administration and EPM Clients

Administration Console

The Administration web client provides a new and revolutionized user experience Business User interface is now Flex-based

Developed in Adobe Flex, the Web Client is based on SBC (Shared Business Component) BUI* Framework

Dimension and Dimension members can now be created, edited without Microsoft Excel requirement

(14)

Administration and EPM Clients

Harmonized Web User Interface and EPM Add-in

.NET add-on for Office will be implemented and shared by Excel, Word, and PowerPoint. EPM Office Add-in Excel replaces all existing classic EPM Excel Clients

Both Microsoft Office Clients and Web Client can be used for planning activities Administration Landing page is a Flex-based thin Client and displays

(15)

Topics Page

1. Architecture

2. Platform Support and

Authentication

ABAP Application Server Support

3. Administration and EPM Clients

4. Functional Enhancements

(16)

Functional Enhancements

NW Authorization Integration Books

Work Status Improvements

Journal Reporting Enhancement Business Rules

Consolidation Central Incremental Consolidation Consolidation Monitor Controls

(17)

NW Authorization Integration

Benefits in moving to NW based Authorization instead 7.x’s BPC owned

security implementation:

Better Performance as Security is implemented at the core OLAP engine. Meet the Customer demand for identity management

Solution Manager Integration

Move closer to supporting GRC Access Controls in the future Tighter integration with NW

Native support of Matrix Security

(18)

Books

BPC will provide a business user-friendly approach to distributing performance

results by publishing static set of reports to the server called Books.

A book represents single or multiple predefined reports where the data varies

by dimension members. The data is a snapshot at the time of publication and

serves to provide accessible secured historical data. Books are secured by the

end user “member access” security profile to ensure authorized access via the

Content Library.

Books can be sent to a printer or saved in PDF format

Books can be published to the web client’s Library

A new online Books Viewer is also included in this release

Books can be created in real time or scheduled

(19)

Work Status (WS)

When changing Work State, drop down will now show only valid target statuses

(instead of all configured).

More user friendly Error messages when user violates the configured WS rules.

Work Status will now be configured on Account dimension (MS version does

not allow Account Dimension for WS and will continue to retain the restriction

due to the validation framework of MS version).

(20)

Journals

Faster and easier creation of templates

New interface for easier template creation

Maintain dates as additional header items (effective date requirement)

New web interface for journals

Enhanced interface delivering increased flexibility and usability

New home page displaying list of journals filtered according to the current view with access to all relevant actions

Automatic calculation of totals and live syntax check on members saves time & reduces errors

New options per journal : Balanced by Entity, balanced by Entity Currency (NW only)

New BADI calculations automatically generating new items, displayed in a separate grids Easier creation and usability for posting multiple journal entries

Advanced Query allows end-users to define criteria making it faster and easier to display specific journals

All dimensions and journal options can be used as filters

Filter on text fields “Beginning with…”, “Containing…”, “In List” as well as on Dates : “From… To…”

(21)

Business Rules

Faster and easier creation and maintenance of business rules

New Home Page provides overview of all existing business rules per model in a given environment

Access methods and method-based multipliers (former rules and rules header) in the same interface for easier navigation

Simplified interface for business rules creation and maintenance

New advanced grids for easier maintenance (copy/paste/delete functionalities) New member picker screens for relevant fields

(22)

Consolidation Central

New interface for performing consolidation tasks on the web

New Consolidation Central folder allows consolidators and authorized users to perform their day to day tasks on the web including:

Scope creation and maintenance

Journals data entry

Controls monitoring

(23)

Ownership Manager

Faster and easier creation and maintenance of scopes

The former Dynamic Hierarchy Editor has been renamed “Ownership Manager” New web interface for greater usability

Automatic calculation of Methods and Percentages based upon ownership data entry New contextual menu available when editing a scope (to add an entity in a group, pin/unpin a selected entity)

Use advanced options to copy/cut/paste data using Excel-like functions or using the right click of the mouse

(24)

Consolidation Monitor

New consolidation monitoring interface

New Consolidation Monitor interface enables users to track information for a given group, sub-group or entity:

Control set status

Work status

Currency conversion status

Consolidation status (process to be executed or not)

Run select tasks directly from the Consolidation Monitor interface for selected entities:

Run translation

Run consolidation

View running processes

Incremental currency conversion and consolidation will be available for greater performances

(25)

Incremental Consolidation

Faster than ever Consolidation processing time

Only entities with updated figures are consolidated (and/or converted) Response time is drastically reduced

Instrumental in order to support massive concurrent Consolidation processes How this works?

Internal timestamps will compare last Consolidation and Translation processing versus last data update One or both of the 2 processes will be triggered according to this

What Incremental Consolidation does not consider

Changes in currency rates and/or Ownership data Changes in Business Rules

Changes in Master data

(26)

Controls

New administration interface for controls – Home Page

“Controls” replace the former “Validation business rules” New home page allowing an easy maintenance, thanks to :

Enable / disable controls per model

See overview of existing controls, sets and assignments per model Gain direct access to controls, sets and assignments per model

New administration interface for controls – Controls definitions

New screen provides list of controls that exist for a given model Filter list of displayed controls by control set

Create, edit, delete or print one or multiple controls New properties improve usability and increase flexibility

“Type” property to identify blocking and non-blocking controls, for easier control maintenance

“Threshold” property allows for setting a tolerance level for a control(value or percentage), increasing flexibility “Level” property, linked to the same property in the entity dimension, allows dynamic calculation of the relevant controls for a given entity

(27)

Controls Monitor

New web-based control monitoring interface

Have complete visibility of control statuses for entities you are responsible for Launch control calculations for selected entities

View details of controls for a selected entity For a selected member:

View detailed expression of a selected control

(28)

Topics Page

1. Architecture

2. Platform Support and

Authentication

Security

3. Administration and EPM Clients

4. Functional Enhancements

5. Technical Enhancements

(29)

Technical Enhancements

Shared Query Engine Improvements Script Logic Improvements

Content Delivery Granular Transport

(30)

Shared Query Engine (SQE) Improvements

SQE will use native BW Query (Bex Query) to calculate Periodic, QTD and

YTD measures for Periodic Applications instead of MDX. Engineering testing

shows that 50% performance improvement in some cases.

Similar implementation on YTD Storage Application might be implemented.

Custom measures for both Storage Application will NOT be supported.

(31)

Script Logic Improvements

Script Logic will now support parallelization by packaging scoped data based

on customer mentioned dimension (through new keyword XDIM_PACKAGEBY

and no of parallel process provided from DM prompt.

(32)

Content Delivery

Contains templates, examples, blueprints, best practice templates, demo

packages, regulations, rules. It is an example how a customer uses an

Application Add-on.

Benefits of Content:

Every customer demands a solution for content— current answer is that content has to be developed as part of implementation (what customers hear: slow and expensive)

Binds partners to SAP

Enables Best Practice and “Application” delivering through content Enables scaling, fast and more flexible go to market

Customers can reduce the implementation effort

Customers have access to dramatically more expertise from the partner ecosystem (as partners can create, package and ship content)

(33)

Granular Transport

BPC NW 10.0 will support Granular transport to move any given BPC object

from customer development system to QA & Production systems. In 7.x,

customers need to transport whole AppSet every time.

Customers & Consultants will still need to manually make sure logical

sequence manually if they are transporting one AppSet’s objects in multiple

transports.

Objects can be collected to a transport from BW Administrative Bench

(34)

Topics Page

1. Architecture

2. Platform Support and

Authentication

Security

3. Administration and EPM Clients

4. Functional Enhancements

5. Technical Enhancements

6. Integration Enhancements

ERP BW

(35)

ERP Integration

BPC Data Manager will now support loading directly from SAP ERP system both

in FULL & DELTA mode through SAP Delivered ERP Extractors.

Business user will now have ability to load data directly from SAP ECC through already replicated & configured data sources (like 0EC_PCA_1, 3FI_SL_xx_TT, 0FI_GL_1, 0FI_GL_10, etc.) of underlying BW system to BPC Application

Users can provide specific selection (For example, specific Company Code) for the data load and they can load data both in full & delta (only changes from prior loading) mode. Customers can load both master & transactional data from SAP ECC.

(36)

BW Integration

BPC Data Manager will now support loading directly from BW’s Data Store

Objects (DSO) both in FULL & DELTA mode.

BPC 7.x supported only loading from Cubes. Now, customers can load from DSO (Typically, EDW layer within BW).

Users can provide specific selection (For example, specific Company Code) for the data load and they can load data both in full & delta (only changes from prior loading) mode. Customers can NOT load master data from DSO to BPC dimension. They can only load to BPC Application.

Delta loading & Selections from BW Cubes will be supported.

In Summary:

Full load is supported for Standard Cube, Virtual Cube, Multi-provider, Standard DSO, Write-optimized DSO.

Delta load is supported for Standard Cube, Standard DSO, Write-optimized DSO. Selection will be supported for Standard Cube, Virtual Cube, Multi-provider, Standard DSO, Write-optimized DSO during both Fully & Delta loads.

(37)

Introduction - Delta Changes Summary

Lesson Summary

You should now be able to:

Explain all the new SAP BusinessObjects Planning and Consolidation 10.0, version for SAP NetWeaver Delta changes

(38)

No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP AG. The information contained herein may be changed without prior notice.

Some software products marketed by SAP AG and its distributors contain proprietary software components of other software vendors.

Microsoft, Windows, Excel, Outlook, and PowerPoint are registered trademarks of Microsoft Corporation.

IBM, DB2, DB2 Universal Database, System i, System i5, System p, System p5, System x, System z, System z10, System z9, z10, z9, iSeries, pSeries, xSeries, zSeries, eServer, z/VM, z/OS, i5/OS, S/390, OS/390, OS/400, AS/400, S/390 Parallel Enterprise Server, PowerVM, Power Architecture, POW ER6+, POW ER6, POW ER5+, POW ER5, POW ER, OpenPower, PowerPC, BatchPipes, BladeCenter, System Storage, GPFS, HACMP, RETAIN, DB2 Connect, RACF, Redbooks, OS/2, Parallel Sysplex, MVS/ESA, AIX, Intelligent Miner, WebSphere, Netfinity, Tivoli and Informix are trademarks or registered trademarks of IBM Corporation.

Linux is the registered trademark of Linus Torvalds in the U.S. and other countries. Adobe, the Adobe logo, Acrobat, PostScript, and Reader are either trademarks or registered trademarks of Adobe Systems Incorporated in the United States and/or other countries.

Oracle is a registered trademark of Oracle Corporation.

UNIX, X/Open, OSF/1, and Motif are registered trademarks of the Open Group.

Citrix, ICA, Program Neighborhood, MetaFrame, WinFrame, VideoFrame, and MultiWin are trademarks or registered trademarks of Citrix 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.

SAP, R/3, SAP NetWeaver, Duet, PartnerEdge, ByDesign, SAP BusinessObjects Explorer, StreamWork, 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 other countries.

© 2011 SAP AG. All rights reserved

Business Objects and the Business Objects logo, BusinessObjects, Crystal Reports, Crystal Decisions, Web Intelligence, Xcelsius, and other Business Objects products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of Business Objects Software Ltd. Business Objects is an SAP company.

Sybase and Adaptive Server, iAnywhere, Sybase 365, SQL Anywhere, and other Sybase products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of Sybase, Inc. Sybase is an SAP company.

All other product and service names mentioned are the trademarks of their respective companies. Data contained in this document serves informational purposes only. National product specifications may vary.

The information in this document is proprietary to SAP. No part of this document may be reproduced, copied, or transmitted in any form or for any purpose without the express prior written permission of SAP AG.

This document is a preliminary version and not subject to your license agreement or any other agreement with SAP. This document contains only intended strategies, developments, and functionalities of the SAP® product and is not intended to be binding upon SAP to any particular course of business, product strategy, and/or development. Please note that this document is subject to change and may be changed by SAP at any time without notice. SAP assumes no responsibility for errors or omissions in this document. SAP does not warrant the accuracy or completeness of the information, text, graphics, links, or other items contained within this material. This document is provided without a warranty of any kind, either express or implied, including but not limited to the implied warranties of

merchantability, fitness for a particular purpose, or non-infringement.

SAP shall have no liability for damages of any kind including without limitation direct, special, indirect, or consequential damages that may result from the use of these materials. This limitation shall not apply in cases of intent or gross negligence.

The statutory liability for personal injury and defective products is not affected. SAP has no control over the information that you may access through the use of hot links contained in these materials and does not endorse your use of third-party Web pages nor provide any warranty whatsoever relating to third-party Web pages.

(39)

SAP BusinessObjects Planning and

Consolidation 10.0, Version for Microsoft

(40)

Introduction - Delta Changes Summary

Lesson Objectives

After completing this lesson, you will be able to:

Explain all the new SAP BusinessObjects Planning and Consolidation 10.0, version for Microsoft Delta changes

(41)

1. Architecture and Platform Support

Server

Client and Browser

2. EPM Clients

Web User Interface

EPM Office Add-in

(42)

1. Architecture and Platform Support

Server

Client and Browser

2. Administration and EPM Clients

Administration Console Web User Interface

3. Functional Enhancements

Automated Variance Analysis (AVA) Journal reporting enhancement

(43)

Architecture and Platform Support: Server Side

64-bit support for all Microsoft Operating systems and components

Windows server 2008 & R2 series (64 bit only)

Standard/Enterprise/DataCenter IIS 7.0/7.5

.NET 3.5 framework

SQL server 2008 ( including R2 ) Enterprise edition only

Support Globalization/Multiple language server Operating System

Microsoft SQL Server Reporting Services no more required

Faster data input and retrieval with optimized Shared Query Engine

Use of global cache to improve performance and scalability

(44)

1. Architecture and Platform Support

Server

Client and Browser

2. EPM Clients

Web User Interface EPM Office Add-in

3. Functional Enhancements

(45)

Architecture and Platform Support: Client and Browser

BPC Client supports the following clients:

Windows XP (32-bit)

Windows Vista (32-bit & 64-bit)

Windows 7 (32-bit & 64-bit)

BPC Web supports the following web browsers:

Internet Explorer 8.0

Internet Explorer 7.0

BPC Office supports the following versions of Microsoft Office:

Microsoft Office 2003 (32 bit and 64 bit)

Microsoft Office 2007 (32 bit and 64 bit)

Microsoft Office 2010 (32 bit and 64 bit)

Common EPM Client for SAP BusinessObjects Analyzer, SAP BusinessObjects

Planning and Consolidation 10 (Version Microsoft and SAP NetWeaver ).

(46)

1. Architecture and Platform Support

Server

Client and Browser

2. EPM Clients

Web User Interface

EPM Office Add-in

3. Functional Enhancements

(47)

EPM Clients: Web User Interface

• Two types of Web report: Reports and Input Forms

• Use Report designer to create either a Report or Input

Form

• Ability to add , manage and review comments history

• Possibility to build and format Charts within Web

reports

(48)

1. Architecture and Platform Support

Server

Client and Browser

2. EPM Clients

Web User Interface

EPM Office Add-in

3. Functional Enhancements

(49)

EPM Clients: EPM Office Add-in

EPM Context bar displays dimensions and members Create, modify reports using EPM Pane

Flash object insertion

Asymmetric reports are not supported in Microsoft Office Word and Microsoft Office PowerPoint

The EPM Add-in is an add-in to Microsoft Excel, Microsoft Word and Microsoft

PowerPoint. Designed to give access to SAP Business Objects EPM Solutions'

product data, the EPM Add-in helps analyze data from EPM solutions. It is also used

to submit data into SAP BusinessObjects Planning and Consolidation Models using

appropriate connection.

(50)

1. Architecture and Platform Support

Server

Client and Browser

2. EPM Clients

3. Functional Enhancements

Automated Variance Analysis (AVA)

(51)

Functional Enhancements:

Automated Variance Analysis (AVA)

Automated Variance Analysis will facilitate business users to

view variances (For example, Plan Vs. Actual)

AVA navigates Application data automatically, determining key

contributors of performance, without manual investigation.

AVA results are calculated on the fly.

Flow of operations within AVA:

AVA can be accessed from the Web to

run Live Reports

(52)

1. Architecture and Platform Support

Server

Client and Browser

2. EPM Clients

3. Functional Enhancements

Automated Variance Analysis (AVA)

(53)

Functional Enhancements:

Journal Reporting Enhancement

Ability to post multiple Journal entries

The new web and enhanced interface delivers more flexibility and displays a list of

Journals that can filtered based on the Context View.

Advanced Query allows end-users to define criteria making it faster and easier to

display specific journals

All dimensions and journal options can be used as filters

Filter on text fields “Beginning with…”, “Containing…”, “In List” as well as on Dates

: “From… To…”

(54)

Introduction - Delta Changes Summary

Lesson Summary

You should now be able to:

Explain all the new SAP BusinessObjects Planning and Consolidation 10.0, version for Microsoft Delta changes

(55)

© 2011 SAP AG. All rights reserved

(56)

SAP BusinessObjects Planning and

Consolidation 10.0, Version for SAP

NetWeaver

(57)

New BPC NW Administration UI Overview

Lesson Objectives

After completing this lesson, you will be able to:

Describe the new BPC NW Administration UI Describe the new Web Client and features Explain the new terminology

Explain Environment features Explain Model Features

Explain Security new Features Explain Rules

Explain Features

(58)

New BPC NW Administration UI Overview

New Terminology and Differences Between BPC 7.x Version

BPC 10

BPC 7.5

Environment

Appset

Dimensions

Models

Applications

Business Rules

Control settings

Validation Rules

Logic Script

Script logic

Work Status settings

Journal Templates

(59)

New BPC NW Web Client

New Web Client

Business Objects Planning and Consolidation 10 version for NetWeaver Web

Client:

When you open the web client, you are presented with the Home Workspace. The home workspace is always available, and contains a menu with all the components that you are

(60)

New BPC NW Web Client

New Web Client

The New Web Client has the following Components:

Start Page: Describes the initial Planning and Consolidation web client page. From this page, you can select from your objects, create reports and launch client applications. Activities: Provides information about using Business Process Flows (Processes).

Library: Provides information about how to access the objects that are saved in the Library view.

Documents: Provides information about using the Documents view to post, and retrieve files, and to manage content display

Audit: Provides information about reporting on system information and activity. Consolidation Central: Helps to generate and manage consolidated data.

– 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

(61)

New BPC NW Web Client

(62)

New BPC NW Web Client

Control Monitor

The Controls Monitor is a workspace for executing and monitoring controls. Control monitor displays control status with entity breakdown

Control monitor displays control status for one entity

Control monitor displays detailed control status for one entity Control monitor runs controls for the selected entity or entities

(63)

New BPC NW Web Client

Journals

Journals - Following tasks may be performed:

Create a journal entry Modify a journal entry

(64)

New BPC NW Web Client

Ownership Manager

Ownership Manager:

Ownership Manager is used to define an ownership-based hierarchy entity structure. It allows you to create periodic-specific hierarchies of corporate entities to use in statutory consolidation, or in cases where hierarchy changes for an application need to be tracked by Category and Time.

(65)

New BPC NW Administration UI Overview

New Admin Web Client

On the Web Client page you have to click the Planning and Consolidation Administration hyperlink in order to open the Administration web client in a separate workspace

The Administration console is now a full Web Administration client. All the administration tasks are now available through a Web Client.

(66)

New BPC NW Administration UI Overview

New Admin Web Client

Navigational Panel on the left side of UI enables to access all the administration views that are grouped by consistent domains.

For each view, the first level of navigation is a main list of all the objects of the current view (For example, the list of dimensions, Models, Users, and so on.

(67)

New BPC NW Administration UI Overview

Environment

On the Administration web client page, you can see two hyperlinks to manage and change the environments.

Appsets are renamed as the “Environments” in BusinessObejcts Planning and Consolidation 10.0, version for NetWeaver.

If you click the “Change Environment” hyperlink then you can change to a different environment based on your access.

(68)

New BPC NW Administration UI Overview

Environments

Manage Environment:

In this page you can Copy a Environment, Create a New Environment, and Delete an Environment. Even though the UI has changed, the functionality is still the same as 7.X versions.

(69)

New BPC NW Administration UI Overview

Dimension

Enhanced Dimension maintenance capabilities:

The new user interface of the Dimensions enables to manage a Dimension through three distinct pages:

– The structure of Dimension

(70)

New BPC NW Administration UI Overview

Dimension

All the properties and settings of a Dimension are managed in the Structure view. This page allows you to add a dimension property or add the required properties for Consolidation or for Ownership model

(71)

New BPC NW Administration UI Overview

Dimension

The members are managed in an “Excel like” grid and you can copy and paste (within the list and from Excel), sorting, filtering, and ordering column, and so on.

The maximum length of a Member ID can be 32 characters and can accept dash and underscores but cannot accept any other special characters.

Member status is displayed in the row headers of the list of all members that have been edited or changed or added. A icon enables to identify the status of the edited members

(72)

New BPC NW Administration UI Overview

Dimension

Excel has been dropped in this release and dimension members are maintained in the Excel like new interface.

Delete and Revert buttons are used to undo the changes done to the dimension members but only if the changes are not confirmed.

In order to use the dimension formulas, you need to check the “Allow Member Formulas” in the “Structure of Dimension” page.

(73)

New BPC NW Administration UI Overview

Dimension Member Formula

In order to create dimension formulas, you need to use the new Formula editor under the “Rules” option. But first activate the “Allow Dimension formulas” option for the dimension on which you want to create the formulas. In this release, a new Formula editor has been

(74)

New BPC NW Administration UI Overview

Model

The term “Application” in Business Planning and Consolidation for 7.X NetWeaver versions has been renamed as “Model” in Business Objects Planning and Consolidation 10.0 for NetWeaver .

You can access the “Models” view by selecting “Model” under the “Dimensions and Models” domain in the left side panel.

(75)

New BPC NW Administration UI Overview

Model

Model Type

There are 2 types:

Reporting

– Standard – (called as “Generic” in 7.X version)

– Financial

– Consolidation

Drivers and Rates (called as “Non-Reporting” in 7.X versions)

– Exchange Rates (called as “Rate” in 7.X versions)

– Ownership

– Generic

YTDINPUT parameter has a new label “Data Entry Mode” in the Administration console and the value can be set now directly when creating a Model using the

(76)

New BPC NW Administration UI Overview

Model

In step 4 while creating Model

In this step, the dimensions will be added to the model.

A status panel at the bottom of the wizard gives the information about the missing dimension types.

If the source is a blank model then all the required dimensions need to be added to the Model.

You cannot select multiple

dimensions of the same type except for the user-defined dimensions. Among the selected dimensions you can also set the secured

dimensions (for example, the dimensions that will be used to define the data access profiles for this model).

(77)

New BPC NW Administration UI Overview

Model

COMMENT parameter has a new label “Enabled Comments” in the Administration console and the value can be set and changed now directly in the structure page and settings of a Model.

In the previous 7.X versions, comments were enabled for an Application using the Web Application parameters but this has been changed in the current release.

(78)

New BPC NW Administration UI Overview

Model

APPROVALORG parameter has a new label “Hierarchy” in the Administration console and the value can be set and changed now directly in the Data Locking Settings dialog of a Model (Work Status feature).

In the previous 7.X releases this

parameter was part of the Web application parameter but has been changed in the current versions.

(79)

New BPC NW Administration UI Overview

Security

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.

SAP BusinessObjects Planning and Consolidation 10.0 NW version, uses the NetWeaver users to login into BPC. It doesn’t support AD users, CMS users anymore.

From a functional perspective, the main changes in the security

configuration are related to the new user experience which enables to improve the way to manage users, teams, and profiles and also allows mass maintenance.

(80)

New BPC NW Administration UI Overview

Security

It lists all the users assigned to the environment

We can add, remove, or edit a user.

Mass maintenance of users and teams are also allowed. Multiple edition of users is allowed to enable to modify several users simultaneously.

You can see in this list the ID’s of the users, their last and first

names and also their email address. These properties are those from the NW users and cannot be changed on the front-end .

(81)

New BPC NW Administration UI Overview

Business Rules

Business Rules:

Like BPC 7.x version, you no longer need to select the business rules to activate when creating a Model or modifying a Model. Activation of

Business rules activation is done directly within the Business Rules view which you can access under the “Rules” domain.

(82)

New BPC NW Administration UI Overview

Logic Script

In SAP BusinessObjects Planning and Consolidation 10.0, for

NetWeaver, enhancements are made to the Logic script editor. Basically Logic Scripts are defined in a brand new script editor.

You can access the “Logic Scripts” view under the “Rules” domain. A list of Planning and Consolidation keywords (K2 functions) and also MDX keywords are available for selection and insertion.

You can use the “Pretty Print” function to make the whole script more readable by adding

indentations and using upper case for keywords.

(83)

New BPC NW Administration UI Overview

Logic Script

A tooltip describing the valid syntax is displayed for each of them

You can insert a keyword from the list into the text editor by drag and drop, double click or by using the “Insert Keyword” button.

Categories of keywords and wrong syntax are highlighted with specific color coding

– Keywords are highlighted with a Blue color

– Constant values are highlighted with a Green color

– Comments are highlighted with a Grey color

– Everything else is highlighted with a Black color

(84)

New BPC NW Administration UI Overview

Work Status

Work Status:

There are no functional changes done to work status in this release other than the new user experience to configure the work status.

Work status can be accessed from the “Features” domain

An overview of the Work Statuses defined for the Environment and the Data locking settings by Model is available as the main page of this view.

(85)

New BPC NW Administration UI Overview

Work Status

Work Status:

You can activate the locking process for a Model directly within this view. Also you can configure the email notification settings directly within this view.

(86)

New BPC NW Administration UI Overview

Context Defaults

Context Defaults:

This is the new feature introduced in the BusinessObjects Planning and Consolidation 10.0, NetWeaver .

“Context Defaults” is available under the “Features” domain. This enables you to specify what the defaults are used for the scope context.

(87)

New BPC NW Administration UI Overview

Context Defaults

Context Defaults:

In the Context Defaults main page, you can specify the default model that will be used when initializing the scope context.

In the bottom panel of the main page of this view, you can edit and then specify the defaults per Dimension of the selected Model.

The scope context will be initialized with the defaults of the relevant dimensions:

– The default Member in a Report

– The default Member in Data Input document

– Whether the Dimension is displayed in the scope context or not

– The Description of the Dimension is displayed instead of the ID

(88)

New BPC NW Administration UI Overview

Audit Capabilities

Audit Capabilities:

Changes in the Dimension members are audited if the audit of the Administration activity is enabled on this page.

(89)

New BPC NW Administration UI Overview

Drill Through

Drill-through:

There are no functional changes but only a new user experience to configure the Drill-throughs.

The overall list of Drill-throughs of the Environment is available in a dedicated view which you can access under “Features”

(90)

New BPC NW Administration UI Overview

Multi-user Object Locking

Multi-users accessing the same object:

Multiple users when accessing the same Administration objects like the Dimensions,

Models, Security, BPF’s and so on, would result in locking the objects. For example, when the Category dimension is being edited by user “A”, at the same time if user “B” tries to access the Category dimension then user “B” would get an error message saying that the object is being edited by another user.

(91)

New BPC NW Administration UI Overview

Technical Parameter

Some of the Application and Appset specific parameters which were part of the BPC for Web in 7.X versions have been moved to backend BW side.

All the other parameters (mainly technical parameters) are now managed in IMG (SIMGH transaction), following the SAP Product Standards requirements.

In IMG, some parameters are set at the Environment level or Model level but also in both levels for few parameters.

In addition, some parameters are called “global parameters”. They are set at an upper level than the Environment. For example, they are applied to all the Environments.

(92)

New BPC NW Administration UI Overview

Lesson Summary

You should now be able to:

Describe the new BPC NW Administration UI Describe the new Web Client and features Explain the new terminology

Explain Environment features Explain Model Features

Explain Security new Features Explain Rules

Explain Features

(93)

(94)

SAP BusinessObjects Planning and

Consolidation 10.0, Version for SAP

NetWeaver

(95)

Dimensions

Lesson Objectives

After completing this lesson, you will be able to:

Manage Dimensions

Explain how to enter members Manage Dimension members Manage Dimension Structure Manage Dimension Formulas Define properties and hierarchies

(96)

Dimensions

Dimensions Overview

The main overview page contains the list of all the dimensions in the environment In the new Admin Web Client, you can access the “Dimensions” view by selecting the “Dimensions” under the Dimensions and Models domain in the left side panel.

(97)

Dimensions

Dimensions Overview

On the right side you can see the Dimension ID, its description, Type and Status.

– Dimension ID: The name of the Dimension

– Dimension Description: Description of Dimension

– Dimension Type: Specifies the type of Dimension

– Status: Indicates the status of dimension like whether the dimensions needs to be processed (yellow icon) or not (green icon)

When you select the Dimension, the toolbar with actions gets activated.

– “New”: This action enables to create a dimension

– “Edit Members”: This action enables to edit the list of members

– “Edit Structure”: This action enables to edit the structure of the dimension to manage its properties

– “Delete”: This action enables to delete a dimension by copying a selected dimension

(98)

Dimensions

Create a New Dimension

Create a New Dimension:

In order to create a Dimension, you need to access and select the “Dimensions” view under the “Dimensions and Models” domain in the navigational panel.

Click on the “New” button in the toolbar to create a new dimension. Upon clicking new button a dialogs box opens in which you can specify

– ID (Mandatory) – Name of the Dimension

– Description (Optional) – Dimension Description

(99)

Dimension

Dimension Types

Below are the different dimension types: Account – (A)

Category – (C)

Audit – (D) - (“Data Source” in 7.5 version) Entity – (E) Group – (G) Intercompany – (I) Currency – (R) Subtables – (S) Time – (T)

(100)

Dimension

Structure of Dimension

The new dimension is created and directly opens up the structure of the Dimension where some specific system properties are automatically generated.

System generated properties will be highlighted with a blue background which means that they cannot be modified nor deleted.

You can add some properties, some hierarchies and set some other settings like “Allow dimension formulas”

(101)

Dimension

Structure of Dimension

There are 2 ways to open up the structure of the Dimension:

– You can edit the structure of a dimension from the list of dimensions – Edit Structure command in the toolbar

(102)

Dimension

Add Dimension Properties

In all types of dimensions, you can manually add a new user-defined property by using the “Add New Property” menu option.

A user-defined property can be deleted. You have to select the property and then use the “Remove” command to delete the property.

You can also change the name and the number of characters directly in the cells of the list of properties. The same for the ID but only if the new property has not been saved yet.

(103)

Dimension

Add a Dimension Property

Required Properties for Consolidation, Ownership and Rate:

Depending on the type of the Dimension, you can automatically add a set of required properties for Consolidation and / or Ownership and / or Rate Model.

You can use the “Add Required Properties for Consolidation (or Ownership or Rate model) menu in the toolbar to add the required properties. These properties are user-defined and can be changed or removed.

(104)

Dimension

Add Hierarchies

In the Structure page of a dimension, hierarchies can be defined by clicking on the “Add” Button which opens a dialog box in which you must specify the name of the hierarchy. The name of the hierarchy is just a caption (display name) and not the ID. In Business Objects Planning and Consolidation 7.5 NW version, the ID of the type “PARENTH#” is automatically generated by the system.

In 10.0 version, you can have breaks in the sequence of hierarchy ID’s ( PARENTH1, PARENTH3, PARENTH4 , and so on)

You can change the Name by editing the field directly and can also remove the Hierarchy by selecting it in the list and use the ‘Remove” command.

(105)

Dimension

Dimension Settings

Referential integrity setting:

Depending on the type of the dimension, you can specify a dimension which will be used as a referential for validating the values for a specific property.

Referential integrity is same as the

“Reference Dimension” in the 7.5 version.

Allow Member Formulas setting:

This option must be checked in order to be able to specify some member formulas for the dimension in the “Member Formulas” view. If this option is not checked, the dimension is not available in this “Member Formulas” view

(106)

Dimension

Manage Dimension Members

You can edit the list of members directly from the list of dimensions (Edit members command in the toolbar) or from the Structure page of the dimension (hyperlink)

(107)

Dimensions

Manage Dimension Members

The members are managed in an “Excel like” grid in which you can use the main features that are expected for the tasks like manually entering the dimension member, copy and paste (within the list and from Excel), sorting, filtering and ordering columns.

(108)

Dimensions

Create Dimension Member

You can create a dimension member by entering a valid ID.

Once saved the ID cannot be changed anymore. The max length of an ID is now up to 32 characters.

Also dimension member ID can accept Dash and Underscores but it cannot accept the special characters.

(109)

Dimension

Create a Dimension Member

A member status is displayed in the row headers of the list for all the Members that have been edited (new or modified members)

A specific icon enables to identify the status of these members:

– Member has been inserted

– Member to be saved

– Errors

– A tooltip provides a description of the status and details for errors

You can identify cells which have been edited

The cells which have been edited will have the background color as yellow which helps in easily identifying the edited properties/cells

(110)

Dimension

Manage Dimension Member

Revert:

You can revert the changes made to the members as long as these changes are not confirmed when saving.

Select the rows for which you want to abort the changes and click on the “Revert”