SAP BO 4.2 with BW 7.5 Integration



Course Description

Business Objects Business Intelligence (BI) platform provides flexible systems management for an enterprise SAP BI standard that allows administrators to confidently deploy and standardize their BI implementations on a proven, scalable, and adaptive service-oriented architecture

SAP Business Objects (BO) 4.0 suite is here with Seven major Enhancements.

  1. BO Universe (semantic layer) can now be sourced from multiple databases, overcoming a major obstacle of previous versions.
  2. Universe can now access MOLAP (cubes from Microsoft Analysis Services, Essbase etc.)
  3. Data sources directly via MDX without having to “flatten them out” first. In prior versions, Universe could only access SQL sources.
  4. There’s now a more common look and feel to individual BI products, including Crystal, Webi, Explorer, and Analysis (former BEx). This is another step in the right direction to unify SAP BI products, but it’s still not a complete solution. It will be a while before all SAP BI products are fully and seamlessly integrated, as well as other BI tools/platforms that grew more organically.
  5. All SAP BI tools, including Xcelsius (Dashboards in 4.0), that did not have access to BO Universe now do.
  6. There’s now a tighter integration with BW via direct exposure of BW metadata (BEx queries and Info Providers) to all BO tools.
  7. Improved BI/BW performance. This is the one I can’t validate until I talk with some customers. But SAP claims that, starting with 4.0, BW will have a unique set of proprietary SAP APIs that are 4+ times faster than APIs that are available to the other BI tools. I am assuming that what this means is that from now on, BW access by Business Objects will be faster than by any other BI tool.
  8. Last but not least, 4.0 is the first version highly optimized for the HANA in-memory appliance. Previous versions and other BI tools will also work with HANA; that should not be the primary factor in your decision whether to upgrade to 4.0 or not, but it’s indeed another variable in the mix. What does “optimized” mean in this case? Remember, all of your BI applications (with the exception of in-memory specific BI apps) were written and optimized for accessing disk-based RDBMS. Chunks of code that were written specifically for that purpose can now be removed, and that code can be optimized for direct memory data access. That’s indeed what SAP claims they did in version 4.0.

Course Duration :     30-35 hrs

Mode of Training :    Live Instructor-led hands on Training

Course Contents

  • Multi Dimensional Modeling Of SAP BW 7.3
  • Info Providers in  SAP BW 7.3:   Cubes, DSO's ,Multi Providers, Infosets
  • Data Flow in BW 7.3 and Activating Business Content Cube.
  • Business Explorer (Bex) Queries in BW 7.3 

  • Architectural overview
  • Client tier components
  • Application tier components
  • Intelligence tier
  • Processing tier
  • Data tier
  • Security management

  • Understand concepts of Web intelligence
  • Create Web Intelligence documents
  • Restrict data returned by a query
  • Design a report
  • Enhance the presentation of data in reports
  • Creation of Web intelligence report with auto scheduling
  • Calculate data with formulas and variables
  • Use multiple data sources
  • Analyze data
  • Manage and share Web Intelligence documents
  • Work with Advanced Query technique
  • Creation of Web intelligence reports using Info cube & BW Query

  • Understanding Business Objects Universes (.UNV  and  .UNX)
  • Designing , Building  and Creating the Course Universe
  • Creating Dimension Objects, Measure Objects
  • Creating Predefined Condition
  • Resolving Loops in a Universe
  • Resolving SQL Traps
  • Using List of Values
  • Applying Restrictions on Objects
  • Using Hierarchies
  • Deriving Tables & Indexes
  • Working with Aggregate Awareness
  • Securing Universes
  • Implementing Universe Life Cycle Mgmt

  • Creation of OLAP Universe by connecting to an Info cube
  • Updating the OLAP Universe (Cube)
  • Creating the Custom Hierarchies in OLAP Universes.
  • Accessing multiple info cubes to create an OLAP Universe

  • 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

  • Creating a Model
  • Adding Interactivity to a Model
  • Creating a Connected Model
  • Connect to Crystal Reports data and create Dashboard
  • Connect to Web intelligence report data and
  • Create Dashboard
  • Connect to Business Objects Universes
  • Using Query as a web service and create Dashboard
  • Use Live Office data and create Dashboard
  • Use other connectivity components and create Dashboard

  • 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

  • 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 InfoView
  • Working with queries in Web Intelligence Rich Client
  • Working with reports

  • Getting Started with Business Objects Voyager
  • Using Queries to Analyze Cube Data
  • Using Charts to Visualize Data
  • Selecting Members to Display in Crosstabs and Charts
  • Sorting, Filtering, and Ranking Data
  • Highlighting Exceptions in Data
  • Saving and Sharing Voyager Workspaces

  • 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

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

  • 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

  1. Resume Preparation Guidelines and Tips
  2. Mock Interviews and Interview Preparation Tips
  3. Certification Guidance
  4. Mini Project

int(10) int(0) array(3) { ["status"]=> bool(false) ["debug"]=> string(28) "{"course_id":10,"user_id":0}" ["warnings"]=> array(0) { } }

Course Assignments

News forum

Comments are closed.