text only siteskip to main contentskip to main navigation
State of New Jersey, Civil Service Commission
Governor Chris Christie • Lt.Governor Kim Guadagno

Cost per Person: $499

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

2 day course (12 hrs)

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


Class Time: 
8:30 am to 4:00 pm


Scheduled Session:
Fiscal Advanced
Thursday, November 16, 2017
Friday, November 17, 2017 

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

Enrollment is secured once your agency completes, signs and returns the following form to the Civil Service Commission. 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