• Skip to main navigation
  • Skip to main content
Washington State Human Resources
Contact Us About Us Topic Index A-Z Forms Reports & Publications Calendar
Go Search
  • Home
  • Workforce Data & Planning
  • Compensation & Class
  • Training
  • Recruitment
  • Rules
  • Diversity
  • Payroll
  • Employee Assistance Program EAP
  • More Services
Payroll - HRMS 
Skip Navigation Links
HRMS Support
Payroll Calendars & Schedules
HRMS-Related TrainingExpand HRMS-Related Training
On-Line Quick Reference
Year End
Business Intelligence Training
Course Manuals
Scroll up
Scroll down

Home > Payroll > Human Resource Management System > HRMS-Related Training > Business Intelligence Training

Print Friendly

Business Intelligence Training 

Welcome to SAP Business Intelligence (BI) Training.

  • BW/BI End Users and BI Power Users: The BI Self-Paced Learning Materials will provide a general understanding of BI, including basic report functionality and steps for running reports via the HRMS Portal.
  • BW/BI Power Users: The BI Power User workshop materials will provide an overview for creating Ad Hoc queries using the BEx reporting tools and an opportunity for BI Power Users to develop Ad Hoc queries with the assistance of BI Report Developers.

The BW/BI Self-Paced Learning Materials will provide a general understanding of BI, including basic report functionality and steps for running reports via the HRMS Portal.

BW/BI End User and BI Power User Workshops. Additional workshops will be scheduled as training rooms become available.

   

BW/BI Course Schedule Course Code

Updated

BW/BI Power User Workshops
(For BW/BI Power Users only-see prerequisites)
01-04-BI01 4/30/2012 
BW/BI End User Workshops
(For accessing & running BI reports via the HRMS Portal & covers the same content as the Self-Paced Learning Materials)
01-04-BI02 5/15/2012



BW/BI Self-Paced Learning Materials (for BW/BI Power and End Users):

These lessons are most effective when you have access to the BW/BI application, but you may find some useful as a tool for understanding how the BI application is designed. The lessons are designed to be taken in sequence, but will work great as a reference for less frequent users of the BI application.

BW/BI Self-Paced Learning Materials

Format

Updated

BW/BI Introduction

PDF

6/16/11

BW/BI Concepts and Security

PDF

6/16/11

BW/BI Architecture

PDF 

6/16/11

BW/BI Custom Reports

PDF 

6/16/11

BW/BI Logging on to the HRMS Portal

PDF

6/16/11

BW/BI Running Reports from HRMS Portal

PDF

6/16/11

BW/BI Elements of a Report

PDF

6/16/11

BW/BI Report Context Menu

PDF

6/16/11

BW/BI Printing Report Results

PDF 

6/16/11

BW/BI Exporting Report Results

PDF 

6/16/11

BW/BI Basic Glossary of Terms

PDF 

6/16/11

BW/BI Additional Info Getting Help

PDF 

6/16/11

BW/BI Additional Info/FAQ

PDF 

6/16/11

BW/BI Financial InfoCube (AFRS InfoProvider)

PDF 

6/16/11

BW/BI Grievance InfoCube

PDF

6/16/11


BW/BI Power User Workshop Materials (for BI Power Users only):

 

 

The Materials will be listed according to the BW/BI Power User Workshop Outline below.  

BW/BI Power User Workshop Outline 

Format

Updated
BI PU Workshop Outline

PDF

3/23/09

 

BW/BI Power User Modules

Format

Updated
BW/BI PU Workshop - Introduction 

 PDF

9/19/11
BW/BI PU Workshop - Concepts

PDF

9/19/11
BW/BI PU Workshop - Environment

PDF

9/19/11
BW/BI PU Workshop - Business Explorer (BEx) 

PDF

9/19/11
BW/BI PU Workshop - BEx Ad Hoc Query Fundamentals-Part I 

PDF

9/19/11
BW/BI PU Workshop - BEx Ad Hoc Query Fundamentals-Part II

PDF

9/19/11
BW/BI PU Workshop - BEx Query Designer

PDF

9/19/11
BI PU Workshop - BEx Ad Hoc Query Fundamentals - Part III

PDF

9/19/11
BW/BI PU Workshop - Security 

PDF

9/19/11
BW/BI PU Workshop - BEx Query Analyzer 

PDF

9/19/11



BW/BI Power User Non-Financial Demo

Format

Updated

Demo1: BW/BI PU Workshop - Basic Query

PDF

9/19/11
Demo2: BW/BI PU Workshop - Modifying a Basic Query 

PDF

9/19/11
Demo3: BW/BI PU Workshop - Adding Confidential Info Objects 

PDF

9/19/11
Demo4: BW/BI PU Workshop - Deleting an Existing Ad Hoc Query

PDF

9/19/11

 

 

  

BW/BI Power User Financial Demo

Format

Updated
FI Demo1: BI Creating a Basic Ad Hoc Query

PDF

9/19/11
FI Demo2: BI Modifying a Basic Ad Hoc Query

PDF

9/19/11
FI Demo3: BI Adding Confidential Info Objects

PDF

9/19/11

 

BW/BI Data Crosswalks

Format

Updated
AFRS Payroll (Financial) (ZPY_C51)

PDF   Excel

6/21/11
Employee Specific Payroll Data (ZPY_M01)

PDF   Excel

6/16/11
Employee Specific Payroll Data with Personnel Actions (ZPY_M02)

PDF   Excel

6/22/11
Headcount and Personnel Actions with Education Data (ZPA_M50)

PDF   Excel

8/29/11
Headcount and Personnel Actions (ZPA_C01)

PDF   Excel

8/29/11
Headcount and Personnel Actions with Military Service Date (ZPA_M60)

PDF   Excel

8/29/11
Quota (ZPT_M02)

PDF   Excel

6/23/11
Staffing Assignments (ZPAOS_C01)

PDF   Excel

6/16/11
Time and Labor (ZPT_M01)

PDF   Excel

6/22/11
Grievance (ZGR_M01)

PDF   Excel

6/27/11


» Top

Contact Us
360-664-6400 or E-Mail

Related Links
Business Intelligence
Personnel/Payroll Assoc
©2012 DES
Visit access.wa.gov | Site Feedback | Privacy Statement | Accessibility | 360 664-1960