Category Archives: Uncategorized

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

Oracle Hyperion Server Access

Hyperion Server Access 24/7 by Spiritsofts, Oracle Hyperion Installation 11.1.2.4 , Infrastructure Training and Job Support and Placement Assistance. We are also providing Training on Hyperion Essbase, Planning, HFM Training, FDMEE, ODI, DRM Training,……….

Hyperion Server Access and Job Support

Hyperion Installation:

Hyperion InstallationOracle Hyperion Installation 11.1.2.4 , Hyperion Essbase Installation 11.1.2.4 , Planning installation 11.1.2.4 , HFM, ODI, DRM FDMEE……

Hyperion Support :

Hyperion Support by SpiritsoftsHyperion Job Support by Spiritsofts with real time Experts, Automation Scripting, And more

  • installation and configurations of Hyperion EPM suite in distributed environment in 11.1.1.3, 11.1.2.1 and 11.1.2.4 versions.
  • version up-gradation.
  • Apply patches to fix bugs.
  • Artifacts backup of EPMA applications using LCM (Automated process).
  • Migrated applications in different environments

Hyperion Infrastructure Course Content :  Click Here

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.

HFM (Hyperion Financial Management) online training USA

Hyperion Financial Management training by Spiritsofts learn HFM training through real time experts with real time scenarios and also providing placement assistance.

Hyperion Financial Management Online training Course content

1. Introduction to Financial Management

  • About Enterprise Performance Management

2. HFM Basics

  • Dimensions
  • Define Application Profile
  • Create application

3. Loading Metadata from a File

  • About Metadata Load Files
  • Loading Metadata
  • Manage Metadata
  • Prepare own Metadata

4. Configuring Accounts and Custom Dimensions

  • Metadata About Accounts and Custom Dimensions
  • Setting Up Account Types and Hierarchies
  • Setting Up Accounts and Custom Dimensions
  • Intercompany Account and Other Account Properties

5. Setting Up Entities, Calendars, and Scenarios

  • Setting up Entities
  • Setting Up Calendars
  • Setting Up Scenarios

6. Loading Data

  • Loading Data Files
  • Extracting Data
  • Copying and Removing Data

7. Creating Tasklist and Data Forms

  • About Data Forms
  • Accessing the Form Builder
  • Defining the Point of View
  • Defining Columns and Rows
  • Setting Row and Column Options
  • Exporting Data to Spreadsheets

8. Entering Data Using Data Grids

  • About Data Grids and Accessing Data Grids
  • Changing the Grid Layout and Display
  • Selecting Members for Dimensions
  • Selecting Members
  • Saving Grid Settings
  • Entering Data and Filling Multiple Cells
  • Spreading and Calculating Data
  • Adding Cell Text and Line-Item Detail

9.Creating Member Lists in Financial Management

  • About Member Lists
  • System and User-Defined Member Lists
  • Creating Member Lists
  • Identifying Member Lists in a File
  • Creating Static Member Lists
  • Creating Dynamic Member Lists for the Entity Dimension and Other Dimensions
  • Loading and Extracting Member Lists

10. Entering Intercompany Data

  • About Intercompany Transactions
  • Intercompany Account Balances
  • Elimination Process
  • Plug Accounts
  • Intercompany Eliminations and the Value Dimension
  • Setting Up Entities and Accounts for Intercompany Data
  • Creating and Running Intercompany Matching Reports

11. Adjusting Data with Journals

  • Journals Review Process and the Value Dimension
  • Creating Journal Templates and Journal Balance Types
  • Creating Journals and Entering Journal Data
  • Creating, Previewing, Running and Viewing Adjustments with the Entity Details Report
  • Setting Journal Report Properties and Selecting Columns and Filters
  • Saving Journal Reports Locally and Remotely

12. Running Consolidations and process management

  • Consolidation Process and Percentages
  • Entering Consolidation Information Using Ownership Management
  • Running Consolidations
  • Checking Consolidation Status
  • Data Translation
  • Entering Exchange Rates

13. Analyzing Data Using Smart View

  • About Smart View
  • Smart View Installation and Components
  • Connecting to a Data Source
  • Entering Data with Web Data Forms
  • Functions in Smart View

14. Rules

  • About Rules and Rules Syntax
  • Rule Types and Rules Files
  • Objects and Functions in Rules
  • Assigning Values to Accounts
  • Account Expressions
  • Setting Values for Multiple Accounts
  • Subcubes, Data Retrieval, and Rules
  • Loading and Extracting Rules

SAP Business Objects Online Training UK

SAP BOBI Training in UK

SAP Business Objects Online training Course Content.

DATA WAREHOUSING CONCEPTS

  • OLTP vs. OLAP
  • Multi Dimensional modeling
  • Data warehouse Life cycle
  • Star/Snow/Extended Star schema design

Introduction to SAP Business Objects

ARCHITECTURAL OVERVIEW

  • Client tier components
  • Application tier components
  • Intelligence tier
  • Processing tier
  • Data tier
  • Security management Information flow

DATABASE CONCEPTS NEEDED FOR DATA WAREHOUSING
Joins & Cardinality

  • Views/Materialized Views
  • Date/Time Functions
  • Conversion functions
  • Derived table & Stored Procedure

Information Designer Tool /UNIVERSE DESIGN

  • Understanding Business Objects Universes
  • Creating the Core Universe
  • Building the Universe Structure
  • Business Layer
  • Creating Measure Objects
  • Resolving Loops in a Universe
  • Resolving SQL Traps
  • Using List of Values
  • Applying Restrictions on Objects
  • Using @Functions with Objects
  • Deriving Tables & Indexes
  • Working with Aggregate Awareness
  • Designing Advanced Objects
  • Creating Predefined Condition
  • LOVs & Joins
  • Securing Universes
  • Maintaining & Optimizing Universes
  • Creating Multi Universe from Other Data sources
  • Converting UNV files to UNX files

WEB INTELLIGENCE

    • Understand concepts of Web intelligence
    • Create Web Intelligence documents with Queries
    • Restrict data returned by a query
    • Design a report
    • Enhance the presentation of data in reports
    • Format a report
    • Calculate data with formulas and variables
    • Use multiple data sources
    • Analyze data
    • Manage and share Web Intelligence documents
    • Work with Advanced Query techniques
    • Work with calculation contexts
    • Create formulas with character & date string functions
    • Use “If” logic
    • Work with additional reporting techniques
  • Create hyperlinks
  • Multiple query creation

CRYSTAL REPORTS

  • Planning a Report
  • Selecting Records
  • Formatting a Report
  • Representing Data Visually
  • Distributing Reports
  • Creating Basic Formulas
  • Organizing Data on a Report
  • Applying Section Formatting
  • Applying Conditional Reporting
  • Using the Repository
  • Using Report Templates
  • Creating Formulas
  • Building Parameterized Reports
  • Summarizing Data with Cross-Tabs
  • Using Report Sections
  • Managing Reports
  • Presenting Data Visually
  • Add hyperlinks to a report

DASHBOARD

  • Understanding Dashboard Manager
  • Setting Up Dashboard Manager
  • Creating Metrics
  • Automating Dashboards with Rules
  • Creating Analytics
  • Creating Personal Dashboards
  • Creating Corporate Dashboards
  • Guiding Dashboard Navigation

MIGRATION FUNDAMENTALS

  • How Business Objects Enterprise XI 3.0
  • Migration concepts
  • Import Wizard Concepts
  • Understanding object migration
  • Understanding user and group migration
  • Migration planning and assessment
  • After migration with the Import Wizard

ADMINISTRATION

  • Understand the Business Objects
  • Enterprise interface & architecture
  • Manage Business Objects Enterprise content
  • Secure Business Objects Enterprise content
  • Secure application security
  • Schedule content
  • Publish reports
  • Identify Business Objects Enterprise architecture
  • Perform common server management tasks
  • Manage the Business Objects Enterprise servers

QUERY AS WEB SERVICE

  • Configuring the QWS with BO System
  • Creating Web service report from Universes
  • Creating WSDL reports
  • Using WSDL reports in external application

WEBI-RICH CLIENT

  • Installing Web Intelligence Rich Client
  • Web Intelligence Rich Client working modes
  • Launching Web Intelligence Rich Client
  • To set user preferences in Web Intelligence Rich Client
  • Working with documents
  • Working with universes in Web Intelligence Rich Client
  • Accessing Web Intelligence from Info View
  • Working with queries in Web Intelligence Rich Client

SECURITY IMPLEMENTATION

  • Creating Secured users & group
  • Creation secured connections
  • Creation of Secured objects
  • Creation of security at Table, Column &row level
  • Creation of secured restriction set and mapping to users or groups

IMPORT WIZARDPUBLISHING WIZARD

  • Using Import wizard
  • Creation of BIAR
  • Migrating the BO objects
  • From one CMS TO ANOTHER CMS
  • Migrating the objects from one
  • Domain to another (dev/stage/Prod)
  • Backup & Maintenance Deployment

BUSINESS VIEW MANAGER

  • Creation of Semantic layer for Crystal reports
  • Creation of Dynamic list of values in Crystal reports
  • Creation of Cascading list of values in Crystal reports
  • Creating Data connection and Dynamic data connection
  • Creation of Data foundation
  • Creation of Business Element
  • Creation of Business View
  • Creation of LOV
  • Saving the Business view to repository
  • Accessing the Business View in Crystal reports using Database expert
  • Creation of Crystal reports using Business

LIVE OFFICE REPORTING

  • Describe the benefits of using Live Office
  • Connect to the repository
  • Navigate the Live Office menu
  • Insert charts, crosstabs, and fields from a Crystal report
  • Insert report parts from a Web Intelligence document
  • Insert a new query based on a Universe
  • Insert Live Office objects into an email
  • Navigate and refresh Live Office objects
  • Enable consolidated prompts
  • Set refresh settings for objects
  • Set parameter binding
  • Take a snapshot
  • Save Live Office documents to the repository
  • Open and view Live Office documents from the repository

SAP BW Reporting

  • Creation of Web intelligence reports using Info cube & BW Query
  • Creation of Dash boards using Info cube & BW Query
  • Creation of Crystal reports using Info cube & BW Query
  • Creating BICS and OLAP for BW connections

SAP HANA Reporting

  • Creation of Web intelligence reports
  • Creation of Dash boards
  • Creation of Crystal reports

Business Objects 4.0 Online Training

SAP BOBI 4.2 Training, crystal reports, Lumira

SAP Business Objects Online training Course Content.

DATA WAREHOUSING CONCEPTS

  • OLTP vs. OLAP
  • Multi Dimensional modeling
  • Data warehouse Life cycle
  • Star/Snow/Extended Star schema design

Introduction to SAP Business Objects

ARCHITECTURAL OVERVIEW

  • Client tier components
  • Application tier components
  • Intelligence tier
  • Processing tier
  • Data tier
  • Security management Information flow

DATABASE CONCEPTS NEEDED FOR DATA WAREHOUSING
Joins & Cardinality

  • Views/Materialized Views
  • Date/Time Functions
  • Conversion functions
  • Derived table & Stored Procedure

Information Designer Tool /UNIVERSE DESIGN

  • Understanding Business Objects Universes
  • Creating the Core Universe
  • Building the Universe Structure
  • Business Layer
  • Creating Measure Objects
  • Resolving Loops in a Universe
  • Resolving SQL Traps
  • Using List of Values
  • Applying Restrictions on Objects
  • Using @Functions with Objects
  • Deriving Tables & Indexes
  • Working with Aggregate Awareness
  • Designing Advanced Objects
  • Creating Predefined Condition
  • LOVs & Joins
  • Securing Universes
  • Maintaining & Optimizing Universes
  • Creating Multi Universe from Other Data sources
  • Converting UNV files to UNX files

WEB INTELLIGENCE

    • Understand concepts of Web intelligence
    • Create Web Intelligence documents with Queries
    • Restrict data returned by a query
    • Design a report
    • Enhance the presentation of data in reports
    • Format a report
    • Calculate data with formulas and variables
    • Use multiple data sources
    • Analyze data
    • Manage and share Web Intelligence documents
    • Work with Advanced Query techniques
    • Work with calculation contexts
    • Create formulas with character & date string functions
    • Use “If” logic
    • Work with additional reporting techniques
  • Create hyperlinks
  • Multiple query creation

CRYSTAL REPORTS

  • Planning a Report
  • Selecting Records
  • Formatting a Report
  • Representing Data Visually
  • Distributing Reports
  • Creating Basic Formulas
  • Organizing Data on a Report
  • Applying Section Formatting
  • Applying Conditional Reporting
  • Using the Repository
  • Using Report Templates
  • Creating Formulas
  • Building Parameterized Reports
  • Summarizing Data with Cross-Tabs
  • Using Report Sections
  • Managing Reports
  • Presenting Data Visually
  • Add hyperlinks to a report

DASHBOARD

  • Understanding Dashboard Manager
  • Setting Up Dashboard Manager
  • Creating Metrics
  • Automating Dashboards with Rules
  • Creating Analytics
  • Creating Personal Dashboards
  • Creating Corporate Dashboards
  • Guiding Dashboard Navigation

MIGRATION FUNDAMENTALS

  • How Business Objects Enterprise XI 3.0
  • Migration concepts
  • Import Wizard Concepts
  • Understanding object migration
  • Understanding user and group migration
  • Migration planning and assessment
  • After migration with the Import Wizard

ADMINISTRATION

  • Understand the Business Objects
  • Enterprise interface & architecture
  • Manage Business Objects Enterprise content
  • Secure Business Objects Enterprise content
  • Secure application security
  • Schedule content
  • Publish reports
  • Identify Business Objects Enterprise architecture
  • Perform common server management tasks
  • Manage the Business Objects Enterprise servers

QUERY AS WEB SERVICE

  • Configuring the QWS with BO System
  • Creating Web service report from Universes
  • Creating WSDL reports
  • Using WSDL reports in external application

WEBI-RICH CLIENT

  • Installing Web Intelligence Rich Client
  • Web Intelligence Rich Client working modes
  • Launching Web Intelligence Rich Client
  • To set user preferences in Web Intelligence Rich Client
  • Working with documents
  • Working with universes in Web Intelligence Rich Client
  • Accessing Web Intelligence from Info View
  • Working with queries in Web Intelligence Rich Client

SECURITY IMPLEMENTATION

  • Creating Secured users & group
  • Creation secured connections
  • Creation of Secured objects
  • Creation of security at Table, Column &row level
  • Creation of secured restriction set and mapping to users or groups

IMPORT WIZARDPUBLISHING WIZARD

  • Using Import wizard
  • Creation of BIAR
  • Migrating the BO objects
  • From one CMS TO ANOTHER CMS
  • Migrating the objects from one
  • Domain to another (dev/stage/Prod)
  • Backup & Maintenance Deployment

BUSINESS VIEW MANAGER

  • Creation of Semantic layer for Crystal reports
  • Creation of Dynamic list of values in Crystal reports
  • Creation of Cascading list of values in Crystal reports
  • Creating Data connection and Dynamic data connection
  • Creation of Data foundation
  • Creation of Business Element
  • Creation of Business View
  • Creation of LOV
  • Saving the Business view to repository
  • Accessing the Business View in Crystal reports using Database expert
  • Creation of Crystal reports using Business

LIVE OFFICE REPORTING

  • Describe the benefits of using Live Office
  • Connect to the repository
  • Navigate the Live Office menu
  • Insert charts, crosstabs, and fields from a Crystal report
  • Insert report parts from a Web Intelligence document
  • Insert a new query based on a Universe
  • Insert Live Office objects into an email
  • Navigate and refresh Live Office objects
  • Enable consolidated prompts
  • Set refresh settings for objects
  • Set parameter binding
  • Take a snapshot
  • Save Live Office documents to the repository
  • Open and view Live Office documents from the repository

SAP BW Reporting

  • Creation of Web intelligence reports using Info cube & BW Query
  • Creation of Dash boards using Info cube & BW Query
  • Creation of Crystal reports using Info cube & BW Query
  • Creating BICS and OLAP for BW connections

SAP HANA Reporting

  • Creation of Web intelligence reports
  • Creation of Dash boards
  • Creation of Crystal reports

SAP Business Objects Online Training India

SAP Business Objects Online Training India

SAP Business Objects Online training Course Content.

DATA WAREHOUSING CONCEPTS

  • OLTP vs. OLAP
  • Multi Dimensional modeling
  • Data warehouse Life cycle
  • Star/Snow/Extended Star schema design

Introduction to SAP Business Objects

ARCHITECTURAL OVERVIEW

  • Client tier components
  • Application tier components
  • Intelligence tier
  • Processing tier
  • Data tier
  • Security management Information flow

DATABASE CONCEPTS NEEDED FOR DATA WAREHOUSING
Joins & Cardinality

  • Views/Materialized Views
  • Date/Time Functions
  • Conversion functions
  • Derived table & Stored Procedure

Information Designer Tool /UNIVERSE DESIGN

  • Understanding Business Objects Universes
  • Creating the Core Universe
  • Building the Universe Structure
  • Business Layer
  • Creating Measure Objects
  • Resolving Loops in a Universe
  • Resolving SQL Traps
  • Using List of Values
  • Applying Restrictions on Objects
  • Using @Functions with Objects
  • Deriving Tables & Indexes
  • Working with Aggregate Awareness
  • Designing Advanced Objects
  • Creating Predefined Condition
  • LOVs & Joins
  • Securing Universes
  • Maintaining & Optimizing Universes
  • Creating Multi Universe from Other Data sources
  • Converting UNV files to UNX files

WEB INTELLIGENCE

    • Understand concepts of Web intelligence
    • Create Web Intelligence documents with Queries
    • Restrict data returned by a query
    • Design a report
    • Enhance the presentation of data in reports
    • Format a report
    • Calculate data with formulas and variables
    • Use multiple data sources
    • Analyze data
    • Manage and share Web Intelligence documents
    • Work with Advanced Query techniques
    • Work with calculation contexts
    • Create formulas with character & date string functions
    • Use “If” logic
    • Work with additional reporting techniques
  • Create hyperlinks
  • Multiple query creation

CRYSTAL REPORTS

  • Planning a Report
  • Selecting Records
  • Formatting a Report
  • Representing Data Visually
  • Distributing Reports
  • Creating Basic Formulas
  • Organizing Data on a Report
  • Applying Section Formatting
  • Applying Conditional Reporting
  • Using the Repository
  • Using Report Templates
  • Creating Formulas
  • Building Parameterized Reports
  • Summarizing Data with Cross-Tabs
  • Using Report Sections
  • Managing Reports
  • Presenting Data Visually
  • Add hyperlinks to a report

DASHBOARD

  • Understanding Dashboard Manager
  • Setting Up Dashboard Manager
  • Creating Metrics
  • Automating Dashboards with Rules
  • Creating Analytics
  • Creating Personal Dashboards
  • Creating Corporate Dashboards
  • Guiding Dashboard Navigation

MIGRATION FUNDAMENTALS

  • How Business Objects Enterprise XI 3.0
  • Migration concepts
  • Import Wizard Concepts
  • Understanding object migration
  • Understanding user and group migration
  • Migration planning and assessment
  • After migration with the Import Wizard

ADMINISTRATION

  • Understand the Business Objects
  • Enterprise interface & architecture
  • Manage Business Objects Enterprise content
  • Secure Business Objects Enterprise content
  • Secure application security
  • Schedule content
  • Publish reports
  • Identify Business Objects Enterprise architecture
  • Perform common server management tasks
  • Manage the Business Objects Enterprise servers

QUERY AS WEB SERVICE

  • Configuring the QWS with BO System
  • Creating Web service report from Universes
  • Creating WSDL reports
  • Using WSDL reports in external application

WEBI-RICH CLIENT

  • Installing Web Intelligence Rich Client
  • Web Intelligence Rich Client working modes
  • Launching Web Intelligence Rich Client
  • To set user preferences in Web Intelligence Rich Client
  • Working with documents
  • Working with universes in Web Intelligence Rich Client
  • Accessing Web Intelligence from Info View
  • Working with queries in Web Intelligence Rich Client

SECURITY IMPLEMENTATION

  • Creating Secured users & group
  • Creation secured connections
  • Creation of Secured objects
  • Creation of security at Table, Column &row level
  • Creation of secured restriction set and mapping to users or groups

IMPORT WIZARDPUBLISHING WIZARD

  • Using Import wizard
  • Creation of BIAR
  • Migrating the BO objects
  • From one CMS TO ANOTHER CMS
  • Migrating the objects from one
  • Domain to another (dev/stage/Prod)
  • Backup & Maintenance Deployment

BUSINESS VIEW MANAGER

  • Creation of Semantic layer for Crystal reports
  • Creation of Dynamic list of values in Crystal reports
  • Creation of Cascading list of values in Crystal reports
  • Creating Data connection and Dynamic data connection
  • Creation of Data foundation
  • Creation of Business Element
  • Creation of Business View
  • Creation of LOV
  • Saving the Business view to repository
  • Accessing the Business View in Crystal reports using Database expert
  • Creation of Crystal reports using Business

LIVE OFFICE REPORTING

  • Describe the benefits of using Live Office
  • Connect to the repository
  • Navigate the Live Office menu
  • Insert charts, crosstabs, and fields from a Crystal report
  • Insert report parts from a Web Intelligence document
  • Insert a new query based on a Universe
  • Insert Live Office objects into an email
  • Navigate and refresh Live Office objects
  • Enable consolidated prompts
  • Set refresh settings for objects
  • Set parameter binding
  • Take a snapshot
  • Save Live Office documents to the repository
  • Open and view Live Office documents from the repository

SAP BW Reporting

  • Creation of Web intelligence reports using Info cube & BW Query
  • Creation of Dash boards using Info cube & BW Query
  • Creation of Crystal reports using Info cube & BW Query
  • Creating BICS and OLAP for BW connections

SAP HANA Reporting

  • Creation of Web intelligence reports
  • Creation of Dash boards
  • Creation of Crystal reports