sap bpc online training

.

                                          SAP BPC Online training

                                                       It is a corporate performance management tool that can cater for all types of planning and forecasting from simple small processes to multi layer processes,while also providing consolidation and easy to use reporting.

SAP BPC offers a robust, multiuser platform, which is fully integrated with Microsoft Excel.  Initially leveraging off the power of Microsoft SQL Server and Analysis Services there is now another version that uses SAP Netweaver as its back-end database.

Course duration:30-40 hours

SAP BPC – BUSINESS PLANNING AND CONSOLIDATION ONLINE TRAINING COURSE

Introduction

• What is EPM, BPC, BI-IP
• Architecture BPC-MS ,NW
• Release strategy
• Terminology

Administration

• Creating Applications and Applying Dimensions
• Architecture of an Application
• Explain the Tables, Optimization Options and Compression
• Loading Transaction Data using a FlatFile
• Creating a Transformation File
• Creating a conversion file
• Introduction to Logic/Calculations
• Loading and Validating Data
• Working with BPC for Excel
• Developing Reports
• Developing Input Schedules
• BPC Comments
• Book Publication
• Working with BPC Web
• Working with BPC for Word and BPC for PowerPoint
• Advanced reports using multiple EvDRE
• Creating Custom Buttons and Assigning Macros
• Advanced Formatting options using Properties
• Demonstrate Building Income Statement, Balance Sheet and Trial Balance reports using EVDRE
• Demonstrate building a report reading data from multiple applications using EVDRE
• In-depth study on BPC process flows

Planning

• Explain the Planning Process
• Define the planning Model
• Functional Specifications
• Seeding the Plan
• Rolling Forward Forecast
• Calculations using Script Logic
• Calculations Using Worksheet Logic
• Allocations using Script Logic
• Currency Conversion – Direct and using script logic
• Competitor Analysis
• Cost Center planning dry run

Additional

• Hot Analysis
• ParknGo
• BPC Journals
• BPC Audit
• Comments
• Custom Menu
• Business Process Flows
• Lab Exercises
• Project Exercises

Security Set up

• Task Profile
• Member Access Profiles
• Users and Teams
• Work Status Settings
• Using Standard Data manager Packages
• Creating Custom Data Manager Packages
• Automation of Master Data and Transactional Data

For Further details,

Contact us:

Maxonlinetraining

www.maxonlinetraining.com/

Call:
USA:  +1-940 440 8062
India:  040-6460 7156,
Mobile: +91-953 383 7156

Email: info@maxonlinetraining.com

 

Hyperion planning online training

Hyperion online training

Hyperion Planning Online training:

                                                                                                 Hyperion Planning is a centralized, Excel and Web-based planning, budgeting and forecasting solution that integrates financial and operational planning processes and improves business predictability. Oracle Hyperion Planning provides an in-depth look at business operations and its related impact on financials, by tightly integrating financial and operational planning models. With Oracle Hyperion Planning you can meet your immediate financial planning needs while enabling a platform for future cross-functional expansion and automated process integration.

Course Duration: 30 hours

Course content:

Planning Overview

• Oracle’s Enterprise Performance Management System
• Oracle’s Business Intelligence Suite Enterprise Edition Plus
• Architecture of Planning
• Relationship Between Planning and Essbase
• Navigation of Workspace

Creating Dimensions

• EPM Architect
• Period, Scenario and Version Dimensions
• Entity Dimensions
• Account Dimensions
• Custom Dimensions

Metadata

• Loading Data
• Using Application Views
• Deploying Applications
• Setting Up Exchange Rates

Loading Data and Calculating Database

• Setting Up Data Loads and Calculating
• Loading Data

Security

• Provisioning Users and Groups
• Defining Access Levels

Designing Data Forms

• Creating Forms and Folders
• Customizing

Entering Data

• In Planning
• Using Smart View
• Offline

Business Rules

• Creating Business Rules
• Building Runtime Prompts
• Adding Formulas
• Managing Business Rules

Managing Plan Process

• Approval Process
• Task Lists

Analyzing Planning Data

• Financial Reporting
• Reports in Workspace

15.Working with Financial Controls

• About Financial Controls
• Creating Controls Groups, Sections, and Questions
• Deleting and Restoring Controls Groups, Sections, and Questions
• Assigning Reviewer, Submitter, and Proxy Rights
• Accessing Financial Controls
• Selecting Application Settings for Financial Controls

16.Working with Import Scripts

• About Scripting in FDM
• Working with Scripting Components
• Creating Import Scripts
• Assigning Import Scripts to Import Formats
• Applying Scripting Functions to Import Scripts
• Working with Temporary Variables
• Manually Executing Custom Custom Web Scripts

17.Working with Import Integration Scripts

• About Import Integration Scripts
• Creating Import Integration Scripts
• Assigning Import Integration Scripts to Import Formats

18.Working with Event Scripts

• About Event Scripts
• Creating Event Scripts
• Changing Import Formats Dynamically

Hyperion Essbase Online training

Hyperion Essbase Online training

                    Essbase is a multidimensional database management system (MDBMS) that provides a multidimensional database platform upon which to build analytic applications. Essbase, whose name derives from "Extended Spread Sheet dataBASE",began as a product of Arbor Software, which merged with Hyperion Software in 1998.

Course duration:30 hours


Course

1.Essbase Overview

• Multidimensional Analysis
• Oracle’s Enterprise Performance Management System
• Essbase
• Production Environment Components

2.Designing Applications and Databases

• Creating Applications and Databases
• Creating Outlines

3.Designing Data Descriptor Dimensions

• Data Descriptor Dimensions Overview
• Designing Time Dimensions
• Designing Scenario Dimensions
• Outline Calculations
• Designing Accounts Dimensions
• Testing Outline Calculations

4.Optimizing Data Descriptor Dimensions

• Creating Member Aliases
• Dimension Types
• Creating Period-to-Date Totals
• Dynamic Calc Members
• Enhancing Accounts Dimensions
• Optimizing Data Storage

5.Developing Dimension Designs

• Business View Dimensions Overview
• Attributes in Database Design
• Combining Business Views
• Developing Label Outlines

6.Creating Basic Dimension Build Rules Files

• Rules Files Overview
• Creating Dimension Build Rules Files
• Configuring Dimension Maintenance Settings

7.Creating Advanced Dimension Build Rules Files

• Advanced Dimension Build Rules Files Overview
•  Creating Shared Members
•  Manipulating Fields
•  Creating User-Defined Attributes
•  Creating Attribute Dimensions with Rules Files

8. Loading Data

• Data Load Overview
•  Creating Data Load Rules Files
•  Selecting and Rejecting Records
•  Capturing New Members

9.Getting Started with Smart View

•  Navigating Smart View
•  Connecting to Data Sources
•  Creating Ad Hoc Grids
•  Setting the Point of View
•  Associating Data Sources with Worksheets
•  Creating Free-Form Grids

10.Creating Reports with Smart View

• Updating Essbase Data
•  Integrating Essbase Data with Microsoft Office
•  Creating Shared Database Perspectives

For Further details,

Contact us:

Maxonlinetraining

www.maxonlinetraining.com

Call:
USA:  +1-940 440 8062
India:  040-6460 7156,
Mobile: +91-953 383 7156

Email: info@maxonlinetraining.com

Ab intio online training

Ab initio online training

Ab initio online training:

                   
                               

   AB INITIO is a ETL tool which uses the ETL Data Integration platform to extract, transform, and load data and also develops Data Integration Workflows and load processes.Performs data analysis for both Source and Target tables/columns

                                   Ab Initio the tool it self take care of parallelism we have three types of parallelisms in Ab Initio 1. Component 2. Data Parallelism 3. Pipe Line parallelism this is the difference in parallelism concepts.Ab Initio supports different types of text files means you can read same file with different structures.It doesn't need a dedicated administrator, UNIX or NT Admin will suffice, where as other ETL tools do have administrative work.
                                              Error Handling - In Ab Initio you can attach error and reject files to each transformation and capture and analyze the message and data separately. Instant feedback - On execution, Ab Initio tells you how many records have been processed/rejected/etc. and detailed performance metrics for each component.


Duration: 30 Days


Introduction to Abinitio

• Operating system & hardware platform  that Ab Initio supports
• Salient  features of Ab Initio
• Ab Initio high level architecture
• Products of Ab Initio  Corporation
• Job Anatomy of a running job
• Ab Initio terminology

Graph, Component, Port, DML etc……

• Different ports available on overall components
• Standard environment and different parameters
• Multi directory multi file system and ad-hoc multi files
• Parallism and Layout
• Phase & Checkpoint
• Common Functions available in Ab Initio
• Types of flows
• Conditional components and sub graphs
• Watcher file
• Introduction to .dbc file
• Performance improvement processes
• Advanced concepts

For Futher details,

Contact us:

Maxonlinetraining

www.maxonlinetraining.com

Call:
USA:  +1-940 440 8062
India:  040-6460 7156,
Mobile: +91-953 383 7156

Email: info@maxonlinetraining.com