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: BO - Intermediate - Level 2

Length: 2 day course (12 hours)

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

 

Location Addresses: Scheduled Sessions:

Civil Service Commission (CSC)
44 South Clinton Ave.
4th Floor Training Room
Trenton, NJ 08609

 

Fiscal - (CSC)

Human Resources

Office of Information Technology (OIT)
300 River View Plaza
Training Room 101
Trenton, NJ 08611

 Fiscal

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

To register, please complete the following Training Request Form.

If you have any questions please contact the registration team at 609-777-2225.

 
 
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