ATC-SAMBO - SAP Application Maintenance in Business Objects

Overview

Duration: 8.0 days

SAP BOBI is a collection of front-end applications that enables business persons to view and analyze BI information. SAP BO BI provides an agile management system for a company Business Intelligence standard that enables the corporate world to confidently make use of it and standardize their Business Intelligence implementations. We deliver SAP Business Objects Training that includes detailed knowledge of working with the Business Intelligence tool of the SAP family. Curriculum paths include the Web Intelligence 4.1 Business Objects Explorer 4.2 Enhancement of BO 4.1, Crystal reports for enterprise software. The SAP BOBI solutions can help you simplify the way your decision makers use information.

Objectives

• Get end to end knowledge on implementing SAP BO/BI Solution 
• Understand the best practices for SAP Crystal Reports, SAP BusinessObjects Web Intelligence. Dashboards and application building: SAP BusinessObjects Design Studio, SAP Dashboards.  
• Gain Knowledge on SAP BI, SAP BO and data provisioning tools 
• Acquire complete knowledge on Information Design Tool (IDT) and Universe Design Tool (UDT)  
• Attain capability to Create Web Intelligence documents with queries 
• Resolve case Studies based on Real-time project based

Content

Unit 1: Data warehousing/Dimensional modeling/ SAP BW 7.3 Concepts

1. OLTP vs. OLAP
2. Types of OLAP
3. Multi-Dimensional Modeling Of SAP BW 7.3
4. SAP BW 7.3 Cubes, DSO’s, Multi Providers, Infosets
5. Business Explorer (Bex) Queries in BW 7.3 system as Data sources
6. Data Flow in BW 7.3 and Activating Business Content Cube

Unit 2: Database Concepts needed for Data warehousing
1. Joins & Cardinality
2. Views/Materialized Views
3. Date/Time Functions

Unit 3: BOBI 4.2 Architecture
1. Architectural overview
2. Client tier components
3. Application tier components
4. Intelligence tier
5. Processing tier
6. Data tier
7. Security management
8. Information

Unit 4: Information Design Tool (IDT)
1. Understanding Business Objects Universes
2. Creating the Course Universe
3. Building the Universe Structure
4. Creating Dimension Objects
5. Creating Measure Objects
6. Resolving Loops in a Universe
7. Resolving SQL Traps
8. Using List of Values
9. Applying Restrictions on Objects
10. Using @Functions with Objects
11. Using Hierarchies
12. Deriving Tables & Indexes
13. Working with Aggregate Awareness
14. Designing Advanced Objects
15. Creating Predefined Condition
16. LOVs & Joins
17. Securing Universes
18. Implementing Universe Life Cycle Mgmt
19. Maintaining & Optimizing Universes
20. Creating Universe from Other Data sources
21. Designing Universes on SAP HANA tables and views
22. Designing Universes on SAP HANA for COPA scenario, Sales Scenario, Procurement Scenarios

Unit 5: Universe Designer Tool (UDT)
1. Understanding Business Objects Universes
2. Creating the Course Universe
3. Building the Universe Structure
4. Creating Dimension Objects
5. Creating Measure Objects
6. Resolving Loops in a Universe
7. Resolving SQL Traps
8. Using List of Values
9. Applying Restrictions on Objects
10. Using @Functions with Objects
11. Using Hierarchies
12. Deriving Tables & Indexes
13. Working with Aggregate Awareness
14. Designing Advanced Objects
15. Creating Predefined Condition
16. LOVs & Joins
17. Securing Universes
18. Implementing Universe Life Cycle Mgmt
19. Maintaining & Optimizing Universes
20. Creating Universe from Other Data sources
21. Designing Universes on SAP HANA tables and views
22. Designing Universes on SAP HANA for COPA scenario, Sales Scenario, Procurement Scenarios

Unit 6: Web intelligence
1. Understand concepts of Web intelligence
2. Create Web Intelligence documents with Queries
3. Restrict data returned by a query
4. Design a report
5. Enhance the presentation of data in reports
6. Creation of Web intelligence report with auto scheduling
7. Creation of Corporate dashboard for Supply chain mgmt/Banking Domain
8. Format a report
9. Calculate data with formulas and variables
10. Use multiple data sources
11. Analyze data
12. Manage and share Web Intelligence documents
13. Work with Advanced Query techniques
14. Work with calculation contexts
15. Create formulas with character & date string functions
16. SUse “If” logic
17. Work with additional reporting techniques
18. Create hyperlinks
19. Designing Webi reports Based on BEX query as Source.
20. Designing Webi Reports Based on SAP HANA UNX universes.

Unit 7: Crystal Reports 2011 Crystal Reports 2011
1. Planning a Report
2. Selecting Records
3. Formatting a Report
4. Representing Data Visually
5. Distributing Reports
6. Creating Basic Formulas
7. Organizing Data on a Report
8. Applying Section Formatting
9. Applying Conditional Reporting
10. Using the Repository
11. Using Report Templates
12. Creating Formulas
13. Building Parameterized Reports
14. Summarizing Data with Cross-Tabs
15. Using Report Sections
16. Managing Reports
17. Presenting Data Visually
18. Add hyperlinks to a report
19. Depreciation Forecast.
20. Designing Crystal reports i reports Based on BEX query as Source
21. Designing Crystal reports Reports Based on SAP HANA UNX universes

Unit 8: Dashboard Design Tool
1. Creating a Model
2. Adding Interactivity to a Model
3. Creating a Connected Model
4. Connect to Crystal Reports data and create Dashboard
5. Connect to Web intelligence report data
6. Create Dashboard
7. Connect to Business Objects Universes
8. Using Query as a web service and create Dashboard
9. Use Live Office data and create Dashboard
10. Use other connectivity components and create Dashboard
11. Designing Dashboard reports Based on BEX query as Source using QUERY BROWSER
12. Designing Dashboard reports Based on SAP HANA UNX universes QUERY BROWSER

Unit 9: Query as Web service
1. Configuring the QWS with BO System
2. Creating Webservice report from Universes
3. Creating WSDL reports
4. Using WSDL reports in external application

Unit 10: BO Analysis 4.2
1. Get Started with Business Objects Analysis BW 7.3, SAP HANA as Source.
2. Creating Analysis Workspace using OLAP EDITION, BO analysis MS EXCEL, MS PPT.
3. Using Charts to Visualize Data
4. Selecting Members to Display in Crosstabs and Charts
5. Sorting, Filtering, and Ranking Data
6. Highlighting Exceptions

Unit 11: BO Explorer 4.2
1. Creating Information Spaces based on SAP HANA Analytical view, Spread sheets, UNX Universes.
2. Exploring the data Based on Information Spaces.

Unit 12: Widgets
1. Installing BI Widgets
2. Using BI Widgets to Access BI Content
3. Working with widgets
4. BI Widgets Content Authoring Guidelines
5. Auto refresh of Widgets

Unit 13: Administration
1. Understand the Business Objects
2. Enterprise interface & architecture
3. Manage Business Objects Enterprise content
4. Secure Business Objects Enterprise content
5. Secure application security
6. Schedule content
7. Publish report
8. Identify Business Objects Enterprise architecture
9. Perform common server management tasks
10. Manage the Business Objects Enterprise servers

Unit 14: Security Implementation
1. Creating Secured users & group
2. Creation secured connections
3. Creation of Secured objects
4. Creation of security at Table, Column & row level
5. Creation of secured restriction set and mapping to users or groups

Unit 15: OLAP Universe
1. Creation of OLAP Universe by connecting to an Info cube
2. Updating the OLAP Universe (Cube)
3. Creating the Custom Hierarchies in OLAP Universes.
4. Accessing multiple info cubes to create an OLAP Universe

Unit 16: Live Office Reporting
1. Describe the benefits of using Live Office
2. Connect to the repository
3. Navigate the Live Office menu
4. Insert charts, crosstabs, and fields from a Crystal report
5. Insert report parts from a Web Intelligence document
6. Insert a new query based on a Universe
7. Insert Live Office objects into an email
8. Navigate and refresh Live Office objects
9. Enable consolidated prompts
10. Set refresh settings for objects
11. Set parameter binding
12. Take a snapshot 13. Save Live Office documents to the repository
14. Open and view Live Office documents from the repository

Unit 17: BO-SAP Integration/Edge Series
1. Understanding BO-SAP Integration kit
2. Configuring single sign on authentication
3. Creating SAP Authentication in BO
4. Importing the roles of SAP into BO
5. Entitlement settings of SAP & BO System

Unit 18: SAP Webi/Dashboard Reporting
1. Creation of Web intelligence reports using Info cube & BW Query

Unit 19: Installation of BOXI 4.0 suite with System/Audit/Performance mgmt Polestar/Business Explorer
1. Creating Polestar Reports
2. Configuring Pole star with BO System

Audience

• Any graduate can enroll this SAP BOBI training, this professional certification course is best suitable for Business Intelligence professionals, Business Analyst, SAP BO ETL & SAP BO SQL 
• ETL and SQL Developers and Administrator data warehousing specialists 
• Any professional looking for a career in BUSINESS OBJECTS for SAP customers or non-SAP customers

Prerequisites

• Basics of SQL, Database & Data Warehouse  
• Understanding of Business processes related to Manufacturing, Production Planning, Sales, and Shipping industry would be an advantage. 
• Fundamental knowledge in SAP NetWeaver BW 7.0

Certification

Trainocate Certificate of Attendance