Ceppek's

Adventures,friends,love,life,art, IT geeks, photography

Belajar SAP BPC

Leave a comment


 

Introduction of BPC

· Introduction sap BPC

· Version MS 7.5

· Strategy and Road Map

· Modeling aspects in BPC

· Architecture and terminology(MS)

Application Set Management, Dimension Management & Application Management

· Creating an application set

· Crating dimensions, properties & maintaining members

· Creating application and applying dimensions

Loading Transaction Data from Source Systems

· Architecture of an application

· Explain the tables, optimization options and compression(MS)

· Explaining the info providers, info objects, BPC namespace in BI ver. 7.5

· Loading transaction data using flat file

· Creating a transformation file & Conversion file

· Using standard data manager packages

Reporting – I

· Working with BPC for excel for reporting

· Using dynamic report templates

· Developing reports using several cell based EV Functions

· Building reports and input schedules using EVDRE()

Reporting – II

· Creation custom buttons and assigning macros

· Advanced formatting options using properties

· Demonstrate building Income Statements, Balance sheet & Trail Balance reports using EVDRE

· Demonstrate building report reading data from multiple applications using EVDRE

· Administration

· Park n Go

· Custom Menus

· Explaining the planning budgeting forecasting process

· Using packages in Planning

· Define the planning model

· Seeding the plan

· Rolling forward forecast

· Calculations using script logic, Dimension logic & worksheet Logic

· Allocations using script logic and process chains in 7.5

· Comments

· Work status settings

Security

· Security setup

· Task profile

· Member access profile

· Users and teams

Data Manager Packages

· Using standard DM packages

· Customizing standard DM Packages

· Creating DM Packages

· Creating SSIS Packages(MS)

Script Logic

· Introduction

· Dimension Logic

· Worksheet Logic

· Script Logic

· Business Rules

BPC for Web

· Live Reports

· Content library

· Publishing

· Distribution and collection wizard

Consolidation

· Details of Ownership and Rate Application

· Data Collection and preparation

· Business Rules for Consolidation Task

· Journal Entries and Balance Carry Forward

· Currency Conversion Setup & Script Logic

· Inter-Company Elimination Setup & Script Logic

· Inter-Company Bookings

· Dynamic Hierarchy

· BPF in Consolidation

Audit Reports and System Landscape & Performance Tuning

· BPC Audit

· System landscape and transports

· Performance, BPC Statistics

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s