SAP BOBJ
SAP BusinessObjects information management solutions also provide a number of Rapid Marts packages, which are predefined data models with built-in jobs for use with business intelligence (BI) and online analytical processing (OLAP) tools. Contact your sales representative for more information about Rapid Marts.
Course Contents
- Data warehousing/Dimensional modeling Practical Concepts
- OLTP vs. OLAP
- Types of OLAP
- Dimensional modeling
- Data mart/Data warehouse Life cycle
- Star/Snow/Extended Star schema design
- Database Concepts needed for Data warehousing
- Joins & Cardinality
- Views/Materialized Views
- Date/Time Functions
- Conversion functions
- Package
- Derived table & Stored Procedure
- BOXIR3 Architecture
- Architectural overview
- Client tier components
- Application tier components
- Intelligence tier
- Processing tier
- Data tier
- Security management
- Information flow
- Universe Design
- Understanding Business Objects Universes
- Creating the Course Universe
- Building the Universe Structure
- Creating Dimension Objects
- Creating Measure Objects
- Resolving Loops in a Universe
- Resolving SQL Traps
- Using List of Values
- Applying Restrictions on Objects
- Using @Functions with Objects
- Using Hierarchies
- Deriving Tables & Indexes
- Working with Aggregate Awareness
- Designing Advanced Objects
- Creating Predefined Condition
- LOVs & Joins
- Securing Universes
- Implementing Universe Life Cycle Mgmt
- Maintaining & Optimizing Universes
- Creating Universe from Other Data sources
- 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
- 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
- Xcelsius(SAP Dashboard Design)
- 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
- 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
- Widgets
- Installing BI Widgets
- Using BI Widgets to Access BI Content
- Working with widgets
- BI Widgets Content Authoring Guidelines
- Auto refresh of Widgets
- Desktop Intelligence
- Introduction to desktop intelligence
- Scope of analysis
- ZABO
- Report creation
- Saving the reports in local repository
- Publishing the report
- Report conversion (desktop) to (Webi)
- 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 InfoView
- Working with queries in Web Intelligence Rich Client
- Working with reports
- Query as Web service
- Configuring the QWS with BO System
- Creating Webservice report from Universes
- Creating WSDL reports
- Using WSDL reports in external application
- Voyager
- 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
- 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
- OLAP Universe
- 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
- Import Wizard\Publishing 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
- View
- Performance Management
- Creation of Metric Universe
- Creation of Metrics & Analytics
- Creation of Dashboard using Metric
- Creating Performance dashboards using set analysis
- 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
- BO-SAP Integration Series
- Understanding BO-SAP Integration kit
- Configuring single sign on authentication
- Creating SAP Authentication in BO
- Importing the roles of SAP into BO
- Entitlement settings of SAP & BO System
- SAP Webi/Dashboard Reporting:
- Creation of Web intelligence reports using Info cube & BW Query
- Comparison of all BO Versions (5.x/6.5/XIR1/XIR2/XIR3)
- Architecture changes
- Report creation charges
- Universe level changes
- Security level changes
- Addition of new features
- Performance Tuning of Database w.r.t BO
- BO Query tuning
- BO Execution plan/Tracing
- Combined Query
- Views/Derived tables
- Performance Tuning of BO
- Universe Tuning
- Webi report Tuning
- Database Tuning
- Deployment methods
- Crystal reports tuning
- BO Query optimization & Customizatio
- Polestar/Business Explorer
- Creating Polestar Reports
- Configuring Pole star with BO Syste
Online Training - Corporate Training - CLassroom Training
Hyderabad : +91-8143111555
India : 040-64643304/06
USA : +1-703-445-4802
UK : +44-203-468-0685
Email: training@ecorptrainings.com