This two-day course builds on the skills and concepts taught in Business Objects Intermediate. Participants will gain the comprehensive programming skills needed to access, analyze, and share data using SAP Business Objects NJ State universes through BI portal, Infoview.

Learning Objectives:

• Apply knowledge to access State information through various available universes
• Effectively manage documents (reports)
• Restrict data using conditions and filters
• Present and analyze data
• Use advanced query techniques through query optimization
• Use calculation and programmable contexts, formulas, and functions
• Access merged data sources across multiple universes
• Use advanced slice and dice data operations, using conditional, iterative and error operators and utilities
• Enhance presentation techniques
• Review drilling hierarchies, user-defined input controls and dynamic data manipulation
• Review advanced SQL traps, composite query analysis, joins intersection, minus, ranks, and merge
• Use SQL sub queries and nested queries
• Review multiple universe data access and merging dimensions
• Perform a detailed study of advanced querying and reporting methodology

Please complete the HR-1 Training Authorization Form to request classroom training. Your direct supervisor, departmental training coordinator and fiscal officer must approve the form. HR-1's received without proper approval will be returned to the Department's Training Coordinator.

You are not scheduled for the requested classroom training until you receive an official email confirmation from CLIP.

Fax your form to 609-777-2336. For any questions, please call the Registration Team at 609-777-2225.

Training Authorization Form