text only siteskip to main contentskip to main navigation
State of New Jersey, Civil Service Commission
Governor Phil Murphy • Lt.Governor Sheila Oliver

Scheduled Date:
Fiscal Advanced

Thursday, May 10, 2018
Friday, May 11, 2018                            

Civil Service Commission
44 S. Clinton Ave
Trenton, NJ 08625

Cost per Person: $499

Pre- Requisite: B. O. Intermediate - Level 2

Length: 2 day course (12 hrs)

Time: 8:30am - 4:00pm


Course Description

This two- day, instructor led course is delivered in the classroom. Participants will gain the comprehensive programming skills needed to access, analyze and share data using SAP Business Objects state universes through BI portal, Infoview.

After the course, participants will be able to access state information through various available universes and effectively manage documents (reports). They will be able to 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. Enhanced presentation techniques, drilling hierarchies, user-defined input controls and dynamic data manipulation are covered. Study of advanced SQL traps, composite query analysis, joins, intersection, minus, ranks and merge will be explored. SQL sub queries and nested queries are extensively used in this course.

Participants will be able to query the data in most efficient mode with high performance and accuracy. Features like multiple universe data access and merging dimensions is covered in this class. A detailed study of advanced querying and reporting methodology is performed.

Registration Information

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 the Civil Service Commission (CSC) Office of Training Registration.

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

Training Authorization Form

OPRA - Open Public Records Act NJ Home Logo
Department: CSC Home  |  Job Seekers  |  Current Employees  |  Appointing Authorities and Employers  |  About Us
Statewide: NJHome  |  Services A to Z  |  Departments/Agencies  |  FAQs
Copyright © State of New Jersey, 1996 - 2011