Winsomesoft

 40 hours of Instructor Training Classes                            24/7 Support

 Lifetime Access to Recorded Sessions                              Practical Approach

 Real World use cases and Scenarios                                 Expert & Certified Trainers

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