Category Archives: Uncategorized

SAP SuccessFactors Corporate Training

Enroll for Expert Level SAP SuccessFactors Corporate Training Classes. Spiritsofts Offers Best Corporate Training at your Place. We are providing Success Factors Corporate Training in your Organization Hyderabad, Bangalore, Chennai, Noida, Delhi, Mumbai and Pune in India +91 970 442 9989

Abroad

San Diego, Los Angeles(California), New York City, Illinois(Chicago), Houston(Texas), Philadelphia(Pennsylvania) and Dallas(Texas) in USA +1 872-588-4943

Ontario, Quebec City, Ottawa, Edmonton(Alberta) in Canada.  +1 872-588-4943

Other Countries UK, Australia, Germany, France, Singapore and Malaysia.

For Course Content  Click Here

Hyperion Infrastructure Corporate Training

Enroll for Expert Level Oracle Hyperion Infrastructure Corporate Training Classes. Spiritsofts Offers Best Corporate Training at your Place. We are providing Corporate Training in All locations Like Hyderabad, Bangalore, Chennai, Noida, Delhi, Mumbai and Pune in India.  +91 970 442 9989

Abroad

  San Diego, Los Angeles(California), New York City, Illinois(Chicago), Houston(Texas), Philadelphia(Pennsylvania) and Dallas(Texas) in USA +1 872-588-4943

Ontario, Quebec City, Ottawa, Edmonton(Alberta) in Canada.  +1 872-588-4943

Other Countries UK, Australia, Germany, France, Singapore and Malaysia.

For Course Content  Click Here

Hyperion FDQM Training

Hyperion FDQM Training Course Details

Spiritsofts offers best Oracle Hyperion Financial Data Quality Management (FDQM) is a packaged solution for finance users that helps develop standardized financial data management processes with its Web-based guided workflow user interface and powerful integration engine. It enables organizations to eliminate the data integrity risks associated with collecting, mapping, verifying and moving critical financial data across the entire organization.

Hyperion FDQM Training Curriculum

HBase Training

  • Process Overview
  • Architecture

Creating Applications

  • Create the Application
  • Integrate the Application
  • Populate the Control Tables
  • Create Locations

Mappings

  • Build and Import Maps
  • Exporting and Importing Maps

Import Formats

  • Build Import Format
  • Adding Expressions and Functions
  • Assign Import Group to Locations

Loading Data

  • Import
  • Validate
  • Export

Check Reports

  • About Validation Rules
  • About Validation Entities
  • Assign Validation groups to Locations

Journals

  • Loading Journals
  • Exporting Journals
  • Loading Multi period data

Security

  • Shared Services Set up
  • About object security
  • About Location security
  • Assigning Roles

Scripts

  • Creating Import Scripts
  • Assigning to Locations

Batch Loader

  • Overview
  • Usage
  • Automation

SAP BO Dashboards Design Training

SAP Business Objects Dashboards 4.1 Content

Introduction to Dashboards

  • Creating Interactive Dashboards
  • Using an Embedded Excel Workbook in the Dashboard

Data Visualizations with Charts

  • Using Data in a Range
  • Using data in a series
  • Preparing Future Data by Ignoring End Blanks

Dashboard Distribution

  • Distributing a Dashboard

Single Value Components

  • Using Single Value Components

Alerts

  • Setting Up Alerts

Selectors

  • Using Selectors
  • Setting Default Values for Selectors
  • Selecting Multiple Items

Components Used as Selectors

  • Using the Chart Component as a Selector
  • Using the Map Component as a Selector
  • Using Tables in a Dashboard
  • Using an Interactive Calendar in a Dashboard

Common Components

  • Using Images in a Dashboard
  • Adding a URL to a Dashboard

Format Options

  • Configuring Proportional Size and Position
  • Using Color Schemes or Themes to Apply Formats
  • Using Templates to Apply Formats
  • Applying Globalization

Dynamic Visibility

  • Adding Dynamic Visibility
  • Using Formulas to Create Dynamic Visibility
  • Creating Multi-Layer Dashboards

Dashboard Design Optimization

  • Optimizing Dashboard Design
  • Optimizing the Dashboard for Mobile Devices

Dashboard Connection to Live Data

  • Using Live Data Sources
  • Setting Up an XML Connection
  • Using Web Services to Connect to Data
  • Using the Portal Data Connection to Connect to Data

SSRS Online Training

SSRS Training by Experts, Learn Microsoft BI Training Online MSBI Training Material in Hyderabad USA UK Australia SSAS, SSIS, SQL Server Reporting Services Online Training ✓Job Support ✓Real time Scenarios ✓Pay Installments*

 

 

MSBI Online Training course Content

SSIS Management and Security
SSRS Development
Advanced Reports
Managing Reports

SSAS

Building and Modifying an OLAP Cube
Extending the Cube with Hierarchies
Exploiting Advanced Dimension Relationships
Designing Optimal Cubes
Performing Advanced Analysis with MDX
Securing Cube Data
Gaining Business Advantage with Data Mining
SSIS
SSIS Architecture
Advanced SSIS Development

SAP BW HANA Training

SAP BW HANA Training Course Content

BW/4HANA is an evolution of BW that is completely optimized and tailored to SAP HANA. The BW/4HANA code can only run on SAP HANA as it is interwoven with SAP HANA engines and libraries. The ABAP part is several million lines of code smaller compared to BW-on-HANA.

 

Highlights of training:

  • Real time Industry Experienced Trainer
  • Interactive Training session using web conferencing tool
  • Normal track, weekend and fast track classes
  • Class Recordings
  • Training Material, Exercises and Real time examples with case studies
  • Resume preparation and Certification Guidance

Introduction to Data Warehousing :

  • Architecture of Data Warehousing
  • OLTP Vs OLAP
  • Multi-Dimensional Modeling/ Star Schema Vs Entity Relationship Modeling
  • Enterprise Reporting, Query and Analysis
  • ETL and Reporting Tools
  • Evolution of SAP BW/BI and HANA Landscape

Introduction to SAP BW/BI :

  • Evolution of HANA
  • Evolution and Architecture of SAP BW with HANA
  • Modeling, Extraction and Reporting
  • Installation of SAP HANA Studio and SAP GUI

MODELING of SAP BW 7.5 with SAP HANA :

  • Introduction of basic terminology and objects
  • Data Extraction and Data Flows

Info Providers:

  • Master Data – Attributes, Texts, Hierarchies
  • Standard, Write-optimized , Direct Update DSO’s
  • Standard Info Cube and Virtual Provider
  • Logical Layers: Info Set and Multi Provider
  • Open Hub Destination
  • Analysis Process designer

HANA Optimized Objects

  • HANA-Optimized InfoCube
  • Semantically Partitioned Object
  • Advanced Data Store Object
  • Open ODS Views
  • Composite Provider
  • HANA Analysis Process

Importing SAP BW models in SAP HANA

Importance of Business Content ,Installation and Activation

Data Acquisition/Extraction :

  • Flat file Extraction
  • Overview of ECC6.0 Extractions
  • Master Data extraction Customer, Vendor, Material
  • Finance(FI), Sales and Distribution(SD) and Material Management modules
  • Generic Data Extraction using Master and Transaction data tables

Process Chains:

  • Process Chains and Process Types
  • Administration activities
  • Real time scenarios from support projects

Transport Mechanism :

  • Review of system Landscape
  • Creating Transports
  • Releasing, Importing and Monitoring Transports

Reporting :

  • Business Explorer Query Designer and Analyzer
  • Reusable Query Elements
  • Filters, Columns & Rows
  • Characteristic Restrictions & Free Characteristics
  • Formulas & Calculated Key Figures
  • Restricted Key figures and Variables with Texts
  • Report to Report Interface or Jump Starts
  • Exceptions, Conditions, Structures, Cell Definitions
  • Business Explorer Analyzer
  • Introduction to Business Explorer Analyzer
  • Filtering
  • Properties available in Analyzer

Performance Improvement

  • Column Store and Row Store
  • Aggregates
  • Compression
  • Partitioning
  • Indexes and DB Statistics
  • Read Mode & OLAP cache
  • Line Item Dimension & High Cardinality

Introduction to SAP ABAP

  • SAP ERP Introduction and Architecture
  • SAP ABAP

ABAP Programming Techniques:

  • ABAP Development Workbench Tools
  • Object Navigator
  • Workbench Organizer and Data Dictionary
  • ABAP Dictionary
  • Tables
  • Views
  • Lock Objects
  • Reports Statement
  • Declarations
  • Tables
  • Includes
  • Variables (Data Types and Data Objects)
  • Structures

ABAP for SAP BI requirements:

  • Field level Routine
  • Start Routine
  • End Routine
  • Expert Routine
  • Infopackage level Routine
  • DataSource Enhancements

SAP FICO Training

SAP FICO Training By Experts,  Online SAP FICO Training with Certification Material. Best institute for Live SAP FICO Online Training classes in Hyderabad Bangalore USA, ✓Certification Material  ✓Free Demo ✓Job Support ✓Pay Installments*

 

 

 

SAP FICO Training Course Contents

 

Overview of SAP FICO

  • What is Finance and Controlling
  • Sub modules in Finance and Controlling
  • Introduction to General Ledger Accounting
  • Introduction to Accounts Receivables
  • Introduction to Accounts Payables
  • Introduction to Assets Accounting
  • Introduction to Controlling
  • Concepts of Integration with MM and SD and CO

 

Financial Accounting

 

Global Parameters-Basic Configuration Steps

  • Company and Company Code
  • Business Area and Credit Control Area
  • Field Year Varian-Types of Fiscal Years
  • Chat of Accounts-Types of COA
  • Account Groups
  • Posting Period Variant
  • Document Types
  • Field Status Variants & Groups
  • Multiple Currencies
  • Introduction to Multiple Ledgers
  • Other Aspects of Global Parameters G/L & new
  • Tolerances for employee groups

 

General Ledger Concepts

  • Retained Earnings and importance of Retained Earnings
  • Tolerance Groups for Employees
  • Exchange Rate Maintenance
  • Foreign Currency Valuation and Translation
  • Financial Statement Version
  • Transfer Balances and Carry Forward( Balance Sheet & P&L ltems)
  • Posting keys
  • Documents in G/L – Park & Posy, Hold, Recurring, Account Model etc…
  • G/L Reports
  • Month end closing and year end closing

 

End user Activities with respect to GL Accounting

  • Posting of GL documents
  • Multiple Line item Posting
  • Document parking and Holding
  • Blocking and Unblocking of GL Accounts
  • Reference Documents
  • Fast Data Entry
  • Reversal of Documents, Single and Multiple Reversals
  • Posting in Foreign Currency transactions
  • Generating GL related reports

 

New GL Concept

  • Importance and advantages of using of New GL in FI
  • Activating Document Splitting
  • Parallel Ledges
  • Posting in parallel legers
  • Define Currency for Additional Ledgers

 

Accounts Receivables

  • Customer Account Groups
  • Document Types for Customers
  • Number Range assignment for Customer Account groups
  • Customer Master Data
  • Reconciliation Account for customer and Vendor Master Data
  • Posting of Customer Invoices
  • Treatment of Customer Down payments
  • Treatment of Bills of Exchange
  • Dunning
  • Treatment of Customer Discounts
  • Customer Credit Notes
  • Generating Customer Party statement of Account
  • Interest Calculations on Customer
  • Integration between SD and FI modules
  • Management information Reports

 

Accounts Payables

  • Vendor Account Groups
  • Document Types for Vendors Documents
  • Number Range assignment for Account groups
  • Vendor Master Data
  • Reconciliation Accounts for Vendor Account groups
  • Posting of Vendor Invoices
  • Down Payments to Vendors
  • Bank Guarantees with special GL indicators
  • Tax Calculation Procedure
  • Detailed Configuration of Extended withholding Tax
  • Automatic determination of G/L accounts for Taxes,
  • Automatic Payment program (APP) and House Banks
  • Cheque Register, Cheque Maintenance,
  • Management Information Reports for Vendor
  • Integration between FI and MM modules.

 

Bank Accounting

  • Configuration of House Banks
  • Electronic and Manual Bank statement
  • BRS entries.

 

Asset Accounting

  • Chart of Depreciation
  • Define 0% tax Codes for Asset Accounting
  • Asset Classes and Account determination of Asset Classes
  • Depreciation Areas
  • Screen Layout Rules and Number Range Assignments
  • Group Assets
  • Asset Master data (Main and Sub Assets), low value assets
  • Assets Acquisition (direct and AuC)
  • Asset retirement (Scrapping, with Revenue with Customer and without Customer)
  • Inter and Intra Asset Transfers
  • Asset Reports/ with Different variants and Asset explorer
  • Strategy on data Migration related to Assets ( Legacy Assets- Upload Process)

 

Integration

  • FI – MM Integration (Configuration from MM to attain PO, GR and IR
  • Account Assignment Categories PO and business process to be used with different Account Assignment Categories.
  • Valuation Area, Valuation class and its importance in Material Master.
  • Accounting Aspects from Material Master
  • Material Movement Types
  • OBYC and G/L account assignments from MM process
  • FI-SD Automatic Accounts determination
  • Revenue Reorganization Process in FI and SD Integration

 

Controlling

  • Basic settings in Controlling Area
  • Define Controlling Area
  • Number Ranges in Controlling Area
  • Concept of Versions in Controlling Area
  • Assignment of Controlling area to Company Codes
  • Importance of Different Fields in controlling Area
  • Controlling & Cost Element Accounting
  • Activity Type
  • Activity type categories
  • Planning and Budgeting of cost Elements
  • Cost Elements Categories
  • Cost Elements groups
  • Cost Elements groups

 

Cost Center Accounting

  • Cost Center Hierarchy
  • Cost Center Groups
  • Cost Center Categories
  • Posting entries in Cost Centers
  • Manual Reposting of Costs
  • Distribution and Assessment
  • Cost Center Planning
  • Information system Cost Center Reports

 

Internal Orders

  • Order Management in Controlling Area
  • Define and Assign Number ranges to Order Groups
  • Internal order Planning, budgeting.
  • AuC (Assets) Process with Internal Order (Real)
  • Information System (Reports) for Internal Orders

 

Profit Center Accounting

  • Maintain Profit Center and Activation of Company Codes in Profit Center
  • Control Parameters for Actual data
  • Plan Versions
  • Profit Center Groups
  • Distribution & Assessment
  • Repots in Profit Center Accounting.

 

SAP HANA Training

SAP HANA Training by Experts Live Instructor Led Classes with Certification Material SAP HANA Online Training Course in USA UK Canada and Australia Free Demo Pay In Installments Project Scenarios Job Support.

SAP HANA  Training Course Content.

1.SAP HANA Introduction

  • In-Memory Computing
  • Evolution of In-Memory computing at SAP
  • History HANA
  • HANA Hardware Sizing
  • Product Availability Matrix
  • HANA compare to BWA

2.SAP HANA Overview

  • Architectural overview
  • Row Store
  • Column Store
  • Persistency Layer

3. SAP HANA Versions and Studio overview

  • SAP HANA Version
  • History of Service pack details
  • Studio Overview
  • HANA Studio Preferenc
  • es
  • HANA Studio Prospective

4. SAP HANA Engines

  • Column Store Engine
  • Row Store Engine
  • Join Engine
  • OLAP Engines
  • Calculation Engine
  • Calculation Engine’s Non-RelationalBehavior
  • SAP HANA General Modeling Principles

SAP HANA Modeling
Attribute View

  • How to connect tables using
  • Inner Join
  • Left Outer Join
  • Right Outer Join
  • Full Outer Join
  • Text Join
  • Referential Join
  • Union
  • Filter
  • Calculated Column

Analytic View

  • Structural Overview
  • Data Foundation
  • Logical View
  • Define View Semantics
  • Left Outer Join – Attribute View
  • Inner Join – Analytical View
  • Right Outer Join – Analytical View
  • Referential Join – Analytical View
  • run-time object: column view
  • Calculated Attribute
  • Calculated Measure
  • Restricted Measure
  • Filter
  • Input Parameter

Tables in HANA

  • Column Store Table
  • Row Store Table
  • Table type

SQL in HANA

  • Basic SQL Knowledge
  • Select Statement
  • From Clause
  • Where Clause
  • Group By clause
  • Having Clause
  • Order by Clause
  • Top N clause

SQL Procedure in HANA

  • How to create Procedure
  • Elements of the Procedure
  • Procedures using Column Store Views
  • IF-ELSE Logic
  • For Loop Logic
  • Cursor in HANA
  • Dynamic Filter

CE based Script in HANA

  • CE_COLUMN_TABLE
  • CE_JOIN_VIEW
  • CE_OLAP_VIEW
  • CE_CALC_VIEW
  • CE_JOIN
  • CE_LEFT_OUTER_JOIN
  • CE_RIGHT_OUTER_JOIN
  • CE_FULL_OUTER_JOIN
  • CE_PROJECTION
  • CE_CALC
  • CE_AGGREGATION
  • CE_UNION_ALL

Calculation View

  • Graphical Calculation View
  • Calculation SQL Script method
  • GraphicalCalculation View Working with Nodes
  • Graphical Calculation View Define View Result Set
  • Graphical Calculation View Define View Semantics
  • How to call Calculation view using SQL into Calculation Views
  • Script-based CV: output column structure import
  • Scenario redesign: replace node / replace data sources
  • Extract semantics from data sources
  • Table function as data sources
  • Debugging Views with drill-down analysis
  • Calculation View limitations in Designing and performance issues
  • Select count (*) statement on top of a HANA graphical Calculation View leads to unexpected number ofrecords in the result set.

Miscellaneous

  • Delivery Units
  • Transport Individual HANA Models
  • How to load Excel data into HANA using Studio
  • Export/Import
  • How to create Sequence
  • How to create Synonym
  • How to create Trigger
  • How to create View

Performance Tuning

  • Index creation
  • Partitioning
  • Hash Partition
  • Merge Partition
  • Round Robin Partition
  • Multi-Level Partition
  • Table Redistribution

Security & User Management

  • Creating Users
  • Creating Roles
  • Privileges
  • Authorization challenges
  • User Administration
  • Backup & Recovery
  • Collecting traces

Data Provisioning

  • SAP Data Services extraction
  • SAP SLT Replication
  • Smart Data Access
  • AP HANA-Direct Extractor Connection (DXC)

SAP Data Services Overview

  • What is SAP Data Services
  • SAP Data Services Architecture
  • SAP Data Services objects (Job, Data Flow, Work Flow, Transformations)

SAP Data Services Extraction

  • Loading Data from SAP ECC to SAP HANA DB
  • Loading Data from SAP BW to SAP HANA DB
  • Loading Data from MSSQL Server DB to SAP HANA DB
  • Loading Data from Excel to SAP HANA DB
  • How to load data from HANA Information Models to MSSQL DB

SAP SLT Data provisioning overview

  • What is SAP SLT
  • SAP SLT License options
  • SAP SLT system sizing
  • SAP SLT system landscape preparation

SAP SLT Schema configuration

  • How to configure SLT Schema for SAP Source system
  • How to configure SLT Schema for Non-SAP Source system
  • No.of Data transfer Jobs configuration
  • How to improve Initial data loading
  • Tables configuration in SLT using Data Provisioning

SAP SLT Performance tuning technics

  • Monitoring Replication in SLT
  • Access Plan
  • Reading Types
  • Adding Entry in the table IUUC_PRECALC_OBJ
  • Adding Entry in the table IUUC_PERF_OPTION
  • MWBMON
  • How to do Partition in SLT
  • How to restrict the tables that are allowed for replication
  • HANA Supported Data Types
  • How to change the standard mapping

HANA Advanced Analytics

HANA Reporting BO Tools

    • How to Connect with IDT
    • How to create Universe using HANA Tables
    • How to create Webi Reports
    • Webi Functions
    • How to schedule Webi reports
    • How to assign the WebI reports to the End users

HANA Reporting with Crystal Reports 2013

  • Report Designer
  • Report creation wizard
  • Sections
  • Sorting and Grouping
  • Chart expert
  • Formulas
  • Sub reports

HANA Reporting with Crystal Reports for Enterprise

  • How to Connect HANA with Crystal Reports for Enterprise
  • How to create reports

HANA Reporting with SAP Dashboards

  • How to Connect HANA with Dashboards
  • How to create Dashboard Reports

HANA Reporting with SAP Lumira

  • How to Connect HANA with SAP Lumira
  • How to Explore HANA Data with Lumira
  • Publish Lumira report

HANA Reporting with SAP Design Studio

  • SAP Design Studio Overview
  • How to create reports

HANA Reporting with SAP Predictive Analysis

  • SAP Predictive Analysis Overview
  • How to Explore data with Predictive Analysis

BW 7.3 powered by HANA Overview

    • BW 7.3 powered by HANA Overview
    • BW7.30-HANA Optimized Info Cube
    • BW7.30-HANA Optimized Info DSO
    • Importing SAP BW7.30 Models into HANA Modeling environment
    • Publish Standalone HANA Models into SAP BW 7.30 on HANA
    • BW on HANA Migration activities

SAP HANA as Secondary Database

  • Architectural Concept

SAP HANA End to End Mock Implementation Project

  • How configure SAP 150 ECC tables using SLT Replication
  • How to configure Data loads using SAP Data Services from Oracle DB
  • How Create HANA Information models based on Business Requirement
  • Creating HANA Models using Combination of multiple Sources
  • How to generate SAP BO reports and Assign to End User
  • Creating 3 HANA Implementation projects Proof of Concepts
  • Guidance to Create HANA models Architecture for Implementation project

SAP HANA Certification Guidance

  • SAP HANA Exam Code C_HANAIMP141
  • HA100 and HA300 Documents can be provide for certification preparation purpose.
  • SAP HANA Exam Dumps can be provided, to clear certification exam.