Business objects HR RAPID MART XI 3.2 FOR SAP SOLUTIONS 12.2.0.0 User Manual

Download

Page 1

SAP BusinessObjects HR Rapid Mart XI

3.2, version for SAP solutions - User Guide

Version 12.2.0.0

Page 2

October 2009

Trademarks

without the express permission of SAP AG. The information contained herein may be changed without prior notice.

Some software products marketed by SAP AG and its distributors contain proprietary software components of other software vendors.

All rights reserved. SAP, R/3, SAP NetWeaver, Duet, PartnerEdge, ByDesign, SAP Business ByDesign, and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP AG in Germany and other countries.

Business Objects and the Business Objects logo, BusinessObjects, Crystal Reports, Crystal Decisions, Web Intelligence, Xcelsius, and other Business Objects products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of Business Objects S.A. in the United States and in other countries. Business Objects is an SAP company.

All other product and service names mentioned are the trademarks of their respective companies. Data contained in this document serves informational purposes only. National product specifications may vary.

These materials are subject to change without notice. These materials are provided by SAP AG and its affiliated companies ("SAP Group") for informational purposes only, without representation or warranty of any kind, and SAP Group shall not be liable for errors or omissions with respect to the materials. The only warranties for SAP Group products and services are those that are set forth in the express warranty statements accompanying such products and services, if any. Nothing herein should be construed as constituting an additional warranty.

Page 3

Chapter 1 Introduction 9

What is a Rapid Mart? . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 10

Rapid Marts packages accelerate Time to Value . . . . . . . . . . . . . . . . 11

SAP BusinessObjects Rapid Marts packages architecture . . . . . . . . . 12

About this document . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 13

Chapter 2 Overview 15

What you can do with this Rapid Mart . . . . . . . . . . . . . . . . . . . . . . . . . . . . 16

Supported analyses . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 17

Dimensions available to support these analyses . . . . . . . . . . . . . . . . . 19

Related Rapid Marts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 19

Components shared with other SAP BusinessObjects Rapid Marts . . 19

Schema . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 20

Chapter 3 Subject Areas 23

Infotypes Section . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 24

SAP solutions processing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25

Rapid Mart processing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 25

Rapid Mart data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 31

Employee Administration Section . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 33

SAP solutions processing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34

Rapid Mart processing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 34

Rapid Mart data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 39

Organization Hierarchies Section . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41

SAP solutions processing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 41

Rapid Mart processing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 42

Relationship to other sections . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 43

Rapid Mart data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 43

Leave Entitlement Section . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 44

SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide 3

Page 4

Contents

SAP solutions processing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 44

Rapid Mart processing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .44

Rapid Mart data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .46

Benefit Enrollment Section . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 47

SAP solutions processing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 48

Rapid Mart processing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .49

Rapid Mart data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .55

Employee Wage Section . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 56

SAP solutions processing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 56

Rapid Mart processing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .57

Rapid Mart data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .59

Payroll Section . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .60

SAP solutions processing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 60

Rapid Mart processing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .62

Rapid Mart data . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .65

Chapter 4 Reports 67

Employee Administration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .68

Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .68

Recommended Table Joins . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 78

Leave Entitlement . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .87

Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .88

Recommended Table Joins . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 90

Benefit Enrollment . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 93

Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .93

Recommended Table Joins . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 100

Employee Wage . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 109

Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .109

Recommended Table Joins . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 115

Payroll . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 118

Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .118

Recommended Table Joins . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 121

SAP Master Data Reports . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 131

4 SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide

Page 5

Contents

Data Discovery . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 131

Data Auditing . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 144

Recommended table joins . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 145

Chapter 5 Universe 149

Universe Design Principles . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 150

Universe Terminology . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 151

Universe Table Layout . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 153

Join Strategy . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 153

Techniques . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 155

Hierarchies . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 156

Hierarchies Overview . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 156

Geographic Hierarchies . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 157

Time Dimension and Fiscal Period Hierarchies . . . . . . . . . . . . . . . . . 158

Material Product Hierarchy . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 158

Horizontal & Vertical Hierarchies . . . . . . . . . . . . . . . . . . . . . . . . . . . . 158

Hierarchy Filters . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 165

Human Resources Specific Hierarchies . . . . . . . . . . . . . . . . . . . . . . . . . . 170

Accounting Hierarchies . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 170

Additional Hierarchies . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 170

SAP Human Resources Universe . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 171

Universe Design Considerations . . . . . . . . . . . . . . . . . . . . . . . . . . . . 172

Universe Objects & Classes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 173

Common Dimensions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 175

Employee Administration . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 187

Employee Wage . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 191

Benefit Enrollment Detail . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 194

Benefit Enrollment Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 196

Leave Entitlement . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 200

Payroll Detail . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 202

Payroll Summary . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 204

Filters & Techniques . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 207

Sample Measures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 209

SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide 5

Page 6

Contents

Universe Validation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .210

SAP HR Master Data Universe . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .212

Universe Objects & Classes . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .213

Universe Design . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .214

Dimensions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 214

Infotype Tables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .215

Filters & Techniques . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .217

Universe Validation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .218

Universe Objects & Classes - Master Data . . . . . . . . . . . . . . . . . . . . .220

Universe Validation - Master Data . . . . . . . . . . . . . . . . . . . . . . . . . . . 255

Splitting the SAP Human Resources Universe . . . . . . . . . . . . . . . . . .257

Chapter 6 Installing the Rapid Mart 259

Preparing Data Services . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .265

Preparing Target Database Environment . . . . . . . . . . . . . . . . . . . . . .265

Preparing Source Application . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .266

Preparing BusinessObjects Enterprise . . . . . . . . . . . . . . . . . . . . . . . .266

Performance Tuning . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .266

Create Target Schema . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .269

Renaming the Data Stores . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .272

Import ATL File . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .274

Adjusting the Data Stores . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 276

Using Auxiliary Files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .283

Using ABAP Files . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .284

Final Steps . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .288

Import Wizard for Reporting Content BIAR File . . . . . . . . . . . . . . . . .290

Creating Universe Connection . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .306

Chapter 7 Using the Rapid Mart 311

Recovery framework . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .312

Data Services automatic recovery feature . . . . . . . . . . . . . . . . . . . . .312

Rapid Mart recovery framework . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 313

Execution status framework . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .314

6 SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide

Page 7

Contents

The execution status table . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 314

The execution status API . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 315

Executing a job with the Reset option . . . . . . . . . . . . . . . . . . . . . . . . 316

Extraction, transformation and loading process . . . . . . . . . . . . . . . . . . . . 316

Global Variables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 318

Global Variable Cross-Reference . . . . . . . . . . . . . . . . . . . . . . . . . . . 318

Used in All Rapid Marts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 322

Used in 2 to 10 Rapid Marts . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 325

Used in Only 1 Rapid Mart . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 331

Setting Global Variables . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 345

Executing the job . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 349

Initial (First) Extraction and Load . . . . . . . . . . . . . . . . . . . . . . . . . . . . 349

Incremental (Delta) Extraction and Load . . . . . . . . . . . . . . . . . . . . . . 350

Customizing the Rapid Mart . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 351

Chapter 8 Customizing the Rapid Mart 353

Payroll Customization . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 354

Changing the Identification Area . . . . . . . . . . . . . . . . . . . . . . . . . . . . 354

Include All Wage Types . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 356

Adding Additional Wage Types . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 358

Changing the Payroll Structure and Cluster Table . . . . . . . . . . . . . . . 362

Leave Entitlement Customization . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 369

Extract New Infotype PA0261 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 369

Modify Leave Entitlement to use PA0261 . . . . . . . . . . . . . . . . . . . . . 370

Function Calls in Custom ABAP Transforms . . . . . . . . . . . . . . . . . . . . . . 371

PA0167 Example . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 371

Differences Between PA0167 & PA0168 . . . . . . . . . . . . . . . . . . . . . . 376

Conclusion . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 376

Chapter 9 Technical Implementation 377

Common Transformations for Date Effective Sections . . . . . . . . . . . . . . 378

Incremental Load Challenges . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 379

Dimensions With Surrogate Keys . . . . . . . . . . . . . . . . . . . . . . . . . . . 379

SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide 7

Page 8

Contents

Minimum Date Driver . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .382

Dimension Valid Date Range Driver . . . . . . . . . . . . . . . . . . . . . . . . . . 383

Fact Valid Date Range Driver . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 384

Vertical and Horizontal Fact Organization . . . . . . . . . . . . . . . . . . . . . .389

Infotypes Section . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .392

Infotype Validation . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .394

Initial (First) and Incremental (Delta) Loads . . . . . . . . . . . . . . . . . . . . 395

Infotypes 0167 (Health) and 0168 (Insurance) . . . . . . . . . . . . . . . . . .395

Infotype 0008 (Pay History) . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .396

Employee Administration Section . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .397

Leave Entitlement Section . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .403

Leave Deduction Dimension . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .405

Leave Entitlement Fact . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 406

Benefit Enrollment Section . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 407

Employee Wage Section . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 413

Payroll Section . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .417

Initial (First) Load . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 421

Incremental (Delta) Load . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .422

Optimization Techniques . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .422

Table Partitions . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .423

Data Transfer Transform . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .424

Hierarchy Optimizations . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 426

Dealing with NULL values . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .428

Fact Table Stored Procedures . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 430

Fiscal Periods & Time Dim Load . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 431

Chapter 10 Documentation References 433

Data Services Documentation References . . . . . . . . . . . . . . . . . . . . . . . .434

BusinessObjects Enterprise Documentation References . . . . . . . . . . . . . 434

Appendix A Rapid Mart Data Schema 437

8 SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide

Page 9

Introduction

chapter

Page 10

Introduction

What is a Rapid Mart?

SAP BusinessObjects Rapid Marts packages are blueprints for building data marts with SAP BusinessObjects technology:

• Data Services

• Universe Designer

• Web Intelligence.

Rapid Marts packages deliver jump-start ETL (extract, transform & load) mappings, schema, and initial reporting content, accelerating the deployment of BI (business intelligence) for enterprise applications from SAP, PeopleSoft, Oracle, and Siebel.

Each Rapid Mart is designed to address the reporting needs of a specific business area (or department) like accounting, sales, or purchasing. A component-based framework allows conducting analysis across these selected business areas by combining different packages within the same source application suite.

Rapid Marts focus on basic standard configuration of the enterprise applications. They are country and industry neutral templates meant to be easily modified and extended to suit customer specific application implementation and reporting needs.

Rapid Marts incorporate best practices, and provide easily modifiable templates. With Rapid Marts total development time of a data mart solution is greatly reduced.

Each customer situation is different. You will probably encounter one or more of these:

• Customizations you have made to SAP solutions the Rapid Mart does not

cover.

• Standard SAP solutions data fields important for your specific business,

but not included in the Rapid Mart templates.

• Optimization and performance challenges unique to your environment.

• Reporting requirements not covered within the Rapid Mart template

reports.

Rapid Marts are flexible templates that you can adjust to account for these unique situations. It is expected that some customization and optimization will be needed to suit your individual environment. Rapid Marts are not an out-ofthe-box solution.

10 SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide

Page 11

BI tools and analytic tools can access Rapid Mart data through SQL queries. Rapid Marts can be implemented individually, or in any combination, to form a single platform that delivers the infrastructure for your company’s internal and external information needs. They can also serve as a staging area for enterprise analytic applications.

Rapid Marts provide your business with an accelerated time to value through rapid BI deployments because you can implement them quickly and easily customize them to meet specific analytic requirements.

Rapid Marts packages accelerate Time to Value

Rapid Marts are packaged data solutions that you can quickly deploy to address specific areas of business analysis.

Available Rapid Marts packages for SAP solutions include:

Financial Suite:

• SAP BusinessObjects General Ledger Rapid Mart, version for SAP

solutions

• SAP BusinessObjects Accounts Payable Rapid Mart, version for SAP

solutions

• SAP BusinessObjects Accounts Receivable Rapid Mart, version for SAP

solutions

• SAP BusinessObjects Cost Center Rapid Mart, version for SAP solutions

Operational Suite:

• SAP BusinessObjects Inventory Rapid Mart, version for SAP solutions

• SAP BusinessObjects Purchasing Rapid Mart, version for SAP solutions

• SAP BusinessObjects Sales Rapid Mart, version for SAP solutions

Manufacturing Suite:

• SAP BusinessObjects Plant Maintenance Rapid Mart, version for SAP

solutions

• SAP BusinessObjects Production Planning Rapid Mart, version for SAP

solutions

• SAP BusinessObjects Project Systems Rapid Mart, version for SAP

solutions

Human Capital Management (HCM) Suite:

• SAP BusinessObjects HR Rapid Mart, version for SAP solutions

You can combine multiple Rapid Marts packages into a single environment to build the foundation for your data warehouse or use them as a staging area for business intelligence applications.

Introduction

What is a Rapid Mart?

SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide 11

Page 12

Introduction

What is a Rapid Mart?

SAP BusinessObjects Rapid Marts packages architecture

Rapid Marts architecture is driven by SAP BusinessObjects technology. Rapid Mart Architecture:

Rapid Marts packages include the following components:

• Data Movement Jobs - packaged source-to-target mappings and data

transformations. Each job is designed to perform initial and incremental data movement;

12 SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide

Page 13

Introduction

About this document

• Data Model & Schema - set of dat a mart database objects designed with

dimensional data modeling approach. Rapid Marts packages for SAP solutions has a single integrated data model. The schema are available for Oracle, SQL Server IBM DB2, and Teradata;

• Semantic Layer (Universes) - SAP BusinessObjects metadata packages

for efficient query generation. There can be one or more universes per Rapid Mart. Each universe is developed using Rapid Marts design principles to ensure compatibility, code readability, and component reuse. In addition, there is one Master universe for development/ maintenance of multiple use objects (like Customer, Material, Currency, etc.);

• Reports (Samples) - set of 15-20 Web Intelligence reports per Rapid

Mart. They represent answers to mostly asked business questions (for example, in the SAP BusinessObjects Sales Rapid Mart, version for SAP solutions - 'What is the monthly Revenue trend by Division for this year?'). The reports are developed using Rapid Mart color/layout templates. Reports are examples of Web Intelligence best practice development (trends, listing, guided analysis, roll ups and downs, etc.).

About this document

This document describes the SAP BusinessObjects HR Rapid Mart, version for SAP solutions. This document contains information for a variety of users— information that helps you understand the use of the Rapid Mart, the data in the Rapid Mart, the reports you can create with the Rapid Mart, and how to use and update the Rapid Mart.

This document contains the following chapters:

• Chapter 2: Overview — Describes the business problems you can solve

and the types of analyses you can do with this Rapid Mart

• Chapter 3: Subject Areas — Contains detailed information about each

componentized section in the Rapid Mart, including the processes each section captures

• Chapter 4: Reports — Provides examples of reports you can produce

• Chapter 5: Universe — Describes the SAP BusinessObjects Universes

upon which the reports are built.

• Chapter 6: Installing the Rapid Mart — Cont ains the information you need

to install the Rapid Mart

SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide 13

Page 14

Introduction

About this document

• Chapter 7: Using the Rapid Mart — Describes how to execute the Rapid

Mart, including information about setting parameters and considerations you need to make when customizing the Rapid Mart

• Chapter 8: Customizing the Rapid Mart — Describes customization

challenges unique to the HR Rapid Mart.

• Chapter 9: Technical Implementation —Describes each componentized

section and the work flows that run to load that section

• Chapter 10: Documentation References — Information about where to

find related to the Rapid Mart technical documentation on Data Services and BusinessObjects Enterprise

• Appendix A: Rapid Mart Data Schema — Contains a detailed list of the

tables and views in the Rapid Mart

14 SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide

Page 15

Overview

chapter

Page 16

Overview

This chapter describes the business questions you can answer with the SAP BusinessObjects HR Rapid Mart, version for SAP solutions and the types of analyses you can do with this Rapid Mart. The information in this chapter is useful for those who want a business-level overview of the Rapid Mart and its benefits.

This chapter contains the following sections:

• What you can do with this Rapid Mart

• Supported analyses

• Related Rapid Marts

• Schema

What you can do with this Rapid Mart

The SAP BusinessObjects HR Rapid Mart, version for SAP solutions supports analysis of benefits, payroll and other employment related information. Some of the information in Human Resources may be sensitive and appropriate access controls must be exercised. Analysis of Human Resources helps one to better understand the personnel development and compensation programs within the company.

The SAP solutions HR Module is very flexible, allowing customers around the globe to implement Human Resources according to the rules of their own particular jurisdiction. The SAP BusinessObjects HR Rapid Mart, version for SAP solutions is a flexible template that allows you to customize and localize your Human Resources reporting in according to the same rules.

All Rapid Marts are flexible templates that you can customize for your particular needs. This is especially valuable in the HR Rapid Mart. Human Resources reporting requirements vary greatly from country to country. Each jurisdiction has its own regulatory requirements.

The SAP BusinessObjects HR Rapid Mart, version for SAP solutions is made up of several componentized sections (also called subject areas). Each section supports a subject related to human resources management. The subject areas are presented as U.S. regulatory specific templates that can be customized and localized for other countries and jurisdictions.

• Infotypes: The SAP solutions infotypes (tables PA0000, PA0001,

PA0002, etc.) are used throughout the following sections. They are presented here as they appear in SAP solutions, with minimal

16 SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide

Page 17

Overview

Supported analyses

transformations. These can provide additional analyses not covered elsewhere in the Rapid Mart. They also serve as a starting point for additional Rapid Mart customizations.

• Employee Administration: Helps to analyze personal and employment

related information by employee or by organizational unit. This section addresses information such as age, length of service, annual salary, deadlines and other significant dates and directory of current employees. You can also analyze various employee demographics such as marital status, education, job qualifications, etc.

• Leave Entitlement: Helps analyze employee absences such as

vacation, sick time, personal leave, maternity or paternity leave, etc. The section focuses on US leave entitlement. Modification of the Rapid Mart is required for other countries.

• Benefit Enrollment: Tracks the various fringe benefits of your

employees. These include health care, pension, savings plans, and insurance plans. Enrollment and eligibility information can be analyzed from an employee of benefit plan perspective.

• Employee Wage: Tracks the salaries and wages you pay your

employees. This includes pay rates, pay scales, job descriptions, positions, position hierarchies, and organizational hierarchies.

• Payroll: Assists in analyzing historical and current compensation paid by

various wage types. Compensation amounts are summarized for easy analysis. This section is specific to US payroll. Modification of the Rapid Mart is required for other countries.

Chapter 3: Subject Areas discusses each of these sections in more detail and

how to link them together for complete human resources information across several sections.

Supported analyses

The SAP BusinessObjects HR Rapid Mart, version for SAP solutions supports several types of analyses.

Business function Type of analysis Measures available in the Rapid Mart

Employee Administration Employee demographics Analyze employee length of service and

demographics such as Marital Status, Education, Qualifications, Language Skills, etc.

Benefits Administration Benefit plan enrollment Weekly enrollment and eligibility

statistics by benefit area, benefit group, benefit status, and plan

SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide 17

Page 18

Overview

Supported analyses

Business function Type of analysis Measures available in the Rapid Mart

Employee benefits profile

Dependents Analysis Analysis of employee dependents

Employee Benefit Costs Costing of Benefits by employee or

Compensation Wage and salary

administration

Salary history Average increase in salary versus prior

EEO comparable worth analysis

Payroll Employee pay history Gross-to-net pay by period using

Organizational Planning Turnover analysis Terminations by length of service

Vacancy analysis Length of time to fill positions Head count Drill down or roll up using organizational

Employment Information Employee listing Current employee directory

Event tracking Employee event tracking and date/

Benefit plan coverage options by employee for health insurance, life insurance, spending accounts, savings plans, and credit plans

Changes in employee benefits profiles over time

Benefits census summary by age, gender, marit al status, length of service, location, or other demographic factors

covered by the various benefit plans.

employer contribution. Comparison of salary by job

classification, position, organizational unit, pay scale group

Salary range penetration and comparatio by employee or selected groups of employees

period Average length of time between salary

increases Comparison of salary based on position,

ethnicity, gender, age, seniority, handicapped status or other EEO demographics

organizational hierarchies to drill down or roll up

Cumulative to-date payroll results by month, quarter, and year

hierarchies

deadline reminders

18 SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide

Page 19

Overview

Related Rapid Marts

Business function Type of analysis Measures available in the Rapid Mart

Leave Entitlement Leave Accumulation &

use

Infotype Analysis Infotypes “as found” in

SAP solutions

Track leave time accumulated by employees vs. time taken.

All infotype fields for infotypes used in other sections of the Rapid Mart

Dimensions available to support these analyses

Reporting dimensions available in the Rapid Mart include country, currency, company code, employee groups, personnel areas, payroll areas, pay scale areas, benefit areas, benefit groups, benefit plans and time-related dimensions such as fiscal period, calendar date, month and quarter.

Related Rapid Marts

Most of the components in the SAP BusinessObjects HR Rapid Mart, version for SAP solutions are independent; very few components are shared with the other Rapid Marts. Dimensions used for analysis, such as currency , comp any code, time are shared with the other Rapid Marts. The country component in HR Rapid Mart is different from the country component used in the other Rapid Marts.

Components shared with other SAP BusinessObjects Rapid Marts

The same components can be used in multiple Rapid Marts. For example, a component that extracts information about materials bought, produced, and sold is needed for a Rapid Mart that supports sales analysis and also for a Rapid Mart that supports inventory analysis. Work flows that extract star schema “dimensions” are components. You can add a component to any Rapid Mart using a simple import procedure.

A Data Services job can include multiple instances of a component. For example, each section includes all the required dimension components. Therefore, a job with several sections may include several instances of a particular dimension component. Components are set to execute only once within a job. This “execute once” feature ensures that shared components do not cause duplicate data extraction from SAP solutions. For more information about the “execute once” feature, see the Data Integrator/Data Services Designer Guide.

SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide 19

Page 20

Overview

Schema

Each of the sections listed in “What you can do with this Rapid Mart” on

page 16 are considered components. You can identify a component within a

Data Services job by a “C_” prefix before its name.

The following diagram shows an overview of the SAP BusinessObjects HR Rapid Mart, version for SAP solutions components and their relationships. The central column is the fact tables corresponding to componentized sections; the side columns indicate dimensional components that may apply to multiple sections. Additional diagrams show the SAP solutions Infotype records used, hierarchies, auxiliary , and st age tables. A few dimension tables are stand alone (not joined to a fact table). These are available for additional analyses in certain sections or subject areas.

20 SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide

Page 21

Overview Schema (1 of 2):

Overview

Schema

SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide 21

Page 22

Overview

Schema

Overview Schema (2 of 2):

22 SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide

Page 23

Subject Areas

chapter

Page 24

Subject Areas

Overview

Each section in the SAP BusinessObjects HR Rapid Mart, version for SAP solutions pertains to a particular subject area. This chapter describes each section and the processes each section captures.

The information in this chapter is useful for readers who use the Rapid Mart to design and support a real-time system, such as a Web application, and need to understand the data in the Rapid Mart and how it relates to SAP solutions

This chapter discusses these subject areas:

• Infotypes Section

• Employee Administration Section

• Organization Hierarchies Section

• Leave Entitlement Section

• Benefit Enrollment Section

• Employee Wage Section

• Payroll Section

Infotypes Section

This subject area includes the infotype records used by the other sections in this chapter. Within the Data Services job for the HR Rapid Mart, the infotypes are extracted from SAP solutions before any other subject area. This is to ensure the infotype data is available for the transformations necessary in other subject areas.

Note: This section is not organized as a star schema. The infotype tables are

independent of each other and presented solely as master data. The infotypes are the basis for most of the fact tables in the Rapid Mart. They

are presented here with minimal transformation as a deeper level of detail for Human Resources reporting.

This section includes information about:

• SAP solutions processing

• Rapid Mart processing

• Rapid Mart data

24 SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide

Page 25

SAP solutions processing

Infotypes are the core of the HR module in SAP solutions. They are daterange specific master data covering all types of employee information including:

• Demographics

• Dependents

• Benefits

• Wages

• Taxes

• Numerous Country Specific Requirements

To satisfy the country specific requirements, there are several hundred infotype tables available in SAP solutions. The Data Services job extracts data only from those used to construct the fact tables for the Rapid Mart. Customization is required if other infotypes are used for reporting in your organization.

Because they are date-range specific, correlation of information between the various infotype tables is challenging.

Example: Employee dependent information will change when there is

an event concerning members of an employee’s family such as birth of children, marriage, etc. However employee salary information will only change once a year with annual raises in salary. Thus, the dates of the changes in these two infotypes will rarely coincide.

Chapter 9: Technical Implementation gives details on how the Rapid Mart

combines data from the various infotypes with overlapping date ranges into a consolidated reporting environment.

Subject Areas

Infotypes Section

Rapid Mart processing

The Rapid Mart extracts the following infotype tables with minimal transformations:

SAP solutions Source Table

PA0000 HR_INFOTYPE_0000_ACTION Employee Events records from

PA0001 HR_INFOTYPE_0001_ASSIGNMENT HR Master Data: Organizational

SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide 25

Rapid Mart Target Table Description

Infotype PA0000

Assignment from PA0001

Page 26

Subject Areas

Infotypes Section

SAP solutions Source Table

P A0002 HR_INFOTYPE_0002_PERSONAL HR master data - infotype PA0002 -

PA0005 HR_INFOTYPE_0005_LEAVE HR master data from PA0005

PA0006 HR_INFOTYPE_0006_ADDRESS Load Personnel Address and

PA0007 HR_INFOTYPE_0007_WORKTIME HR Master data: Planned Working

PA0008 HR_INFOTYPE_0008_HISTORY Uses HR_INFOTYPE_0008_PAY

PA0008 HR_INFOTYPE_0008_PAY HR Master data - Basic Pay from

PA0014 HR_INFOTYPE_0014_DEDUCTION HR Master Data, Recurring

PA0015 HR_INFOTYPE_0015_PAYMENT HR Master data: Infotype for

PA0016 HR_INFOTYPE_0016_CONTRACT HR Master Data for Contract

PA0019 HR_INFOTYPE_0019_DATES HR Master data: Monitoring of

P A0021 HR_INFOTYPE_0021_DEPENDENT HR master data - infotype PA0021 -

PA0022 HR_INFOTYPE_0022_EDUCATION HR Master data: Education from

PA0024 HR_INFOTYPE_0024_QUALIFICATION HR infotype Master PA0024 -

PA0041 HR_INFOTYPE_0041_SPEC HR Master: date specification

PA0077 HR_INFOTYPE_0077_PERSONAL HR Master for Additional Personal

PA0094 HR_INFOTYPE_0094_RESIDENCE HR Master for Residence status in

Rapid Mart Target Table Description

- Personal data

infotype - Leave Entitlement;

Communications master data from PA0006, PA0105

Time from PA0007

to create a salary history that stores prior salary, and salary one year ago;

PA0008

Deductions from PA0014

additional payments, PA0015

information from PA0016 infotype

Dates infotype from PA0019

- Dependents Personal data

Infotype PA0022

Personnel Qualifications

inforecord PA0041

Data from PA0077

N/A from PA0094

26 SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide

Page 27

Subject Areas

Infotypes Section

SAP solutions Source Table

PA0167 HR_INFOTYPE_0167_HEALTH HR Master: Health Plans from

PA0168 HR_INFOTYPE_0168_INSURANCE HR Master for Insurance Plans

PA0169 HR_INFOTYPE_0169_SAVINGS HR master data for Savings Plan

PA0170 HR_INFOTYPE_0170_FLEX HR Master data for Flexible

PA0171 HR_INFOTYPE_0171_BENEFIT HR Master data for General

PA0236 HR_INFOTYPE_0236_CREDIT HR Master data for Credit Plans

HRP1000 HR_INFOTYPE_1000_DBTABLE HR Master data for Organizational

HRP1001 HR_INFOTYPE_1001_DBTABLE HR master data - HR objects

HRP1007 HR_INFOTYPE_1007_DBTABLE HR master data - HR objects

N/A

Rapid Mart Target Table Description

Infotype PA0167

from infotype PA0168

from Infotype 0169

Spending Accounts from infotype PA0170

Benefits from infotype PA0171

from infotype PA0236

unit descriptions from the active plan from HPR1000 infotype

details from infotype HRP1001

details from infotype HRP1007

HR_INFOTYPE_VALIDATION

Derived by Data Services Job: Distinct Merge of date-effective records from all infotypes

Note: T able HR_INFOTYPE_V ALIDATION: The table caries a validity flag (1

or 0). If there is more than one record valid at a time (overlapping date ranges) the record with the latest date range has validity flag = 1 and all other overlapping records have validity flag = 0. Records without ovelapping date ranges also have validity flag = 1. The table is used for loading Employee Administration and Benefit Enrollment subject areas

Note: There are no associated dimensions as the infotypes are presented as

master data.

SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide 27

Page 28

Subject Areas

Infotypes Section

Measures

The infotype tables contain the following measure fields that can be used for data analyses:

Table Name Column Name Description

HR_INFOTYPE_0005_ LEAVE

HR_INFOTYPE_0008_ HISTORY

HR_INFOTYPE_0008_ PAY

AMT_LEAVE_ACCOUN TED_01

AMT_LEAVE_ACCOUN TED_02

AMT_LEAVE_ACCOUN TED_03

AMT_LEAVE_ACCOUN TED_04

AMT_LEAVE_ACCOUN TED_05

AMT_LEAVE_ACCOUN TED_06

AMT_LEAVE_ENTITLM NT_01

AMT_LEAVE_ENTITLM NT_02

AMT_LEAVE_ENTITLM NT_03

AMT_LEAVE_ENTITLM NT_04

AMT_LEAVE_ENTITLM NT_05

AMT_LEAVE_ENTITLM NT_06

AMT_SALARY_YR P A0008.ANSAL Annual salary

AMT_SALARY_YR_AGOHR_INFOTYPE_0008_PAY.AMT_SALAR

AMT_SALARY_YR_PREVHR_INFOTYPE_0008_PAY.AMT_SALAR

AMT_P AYMNT_01 PA0008.BET01 W age type 01 amount for

PA0005.UAB01 Leave days accounted (Hours or Days)

PA0005.UAB02 Leave days accounted (Days or Hours)

PA0005.UAB03 Leave days accounted (Days or Hours)

PA0005.UAB04 Leave days accounted

PA0005.UAB05 Leave days accounted (Days or Hours)

PA0005.UAB06 Leave days accounted (Days or Hours)

PA0005.UAN01 Leave entitlement (Hours or Days)

P A0005.UAN02 Leave entitlement (Days or Hours)

P A0005.UAN03 Leave entitlement (Days or Hours)

P A0005.UAN04 Leave entitlement (Days or Hours)

P A0005.UAN05 Leave entitlement (Days or Hours)

P A0005.UAN06 Leave entitlement (Days or Hours)

Y_Y -Lookup annual salary on this day one year ago

Y_YR Previous salary lookup

payments

28 SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide

Page 29

Table Name Column Name Description

HR_INFOTYPE_0008_ PAY

AMT_P AYMNT_02 PA0008.BET02 Wage type 02 amount for

payments

AMT_P A YMNT_03 P A0008.BET03 W age type 03 amount for

payments

AMT_P A YMNT_04 P A0008.BET04 W age type 04 amount for

payments

AMT_P A YMNT_05 P A0008.BET05 W age type 05 amount for

payments

AMT_PAYMNT_06 PA0008.BET06 Wage type 06 amount

for payments

AMT_P A YMNT_07 P A0008.BET07 W age type 07 amount for

payments

AMT_P A YMNT_08 P A0008.BET08 W age type 08 amount for

payments

AMT_P AYMNT_09 PA0008.BET09 Wage type 09 amount for

payments

AMT_PAYMNT_10 PA0008.BET10 Wage type 10 amount

for payments

AMT_P AYMNT_11 PA0008.BET11 Wage type 11 amount for

payments

AMT_P A YMNT_12 P A0008.BET12 W age type 12 amount for

payments

AMT_PAYMNT_13 PA0008.BET13 Wage type 13 amount

for payments

AMT_P A YMNT_14 P A0008.BET14 W age type 14 amount for

payments

AMT_P A YMNT_15 P A0008.BET15 W age type 20 amount for

payments

AMT_P A YMNT_16 P A0008.BET16 W age type 16 amount for

payments

AMT_P A YMNT_17 P A0008.BET17 W age type 17 amount for

payments

AMT_P A YMNT_18 P A0008.BET18 W age type 20 amount for

payments

AMT_P A YMNT_19 P A0008.BET19 W age type 20 amount for

payments

Subject Areas

Infotypes Section

SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide 29

Page 30

Subject Areas

Infotypes Section

Table Name Column Name Description

HR_INFOTYPE_0008_ PAY

HR_INFOTYPE_0014_ DEDUCTION

HR_INFOTYPE_0015_ PAYMENT

HR_INFOTYPE_0022_ EDUCATION

HR_INFOTYPE_0167_ HEALTH

HR_INFOTYPE_0168_I NSURANCE

AMT_P A YMNT_20 P A0008.BET20 W age type 20 amount for

payments

AMT_SALARY_YR P A0008.ANSAL Annual salary

AMT_PAYMNT PA0014.BETRG Amount of payment for

the wage type

AMT_PAYMNT PA0015.BETRG Amount

AMT_COST PA0022.JBEZ1 Course fees

AMT_EMPLEE_COST Monthly Benefit Employee Cost Amount

from Function HR_BEN_GET_PLAN_COST

AMT_EMPLEE_POST_ TAX

AMT_EMPLER_COST_ CREDIT

AMT_IMPUTED_INCOMEBenefits Imputed Income from Function

AMT_PROVIDER_COSTBenefit Provider Cost Amount from

AMT_ALT_COVERAGE PA0168.COVOV - Benefit alternative

AMT_BASIC_COVERAGEBenefit Insurance Coverage Basic

AMT_BENFT_SALARY Annual Benefit Salary from Function

AMT_COVERAGE PA0168.COVOV/ T74FC.COVAM-

AMT_COVERAGE_MAXT74FC.MAXAM - Maximum coverage

Benefits Additional Employee Post-Tax Costs from Function HR_BEN_GET_PLAN_COST

Benefit Employer Cost/Credit Amount from Function HR_BEN_GET_PLAN_COST

HR_BEN_GET_PLAN_COST

Function HR_BEN_GET_PLAN_COST

amount for insurance coverage amount

Amount from Function HR_BEN_EVAL_AMOUNT

HR_BEN_GET_PLAN_SALARY

Coverage amount - Life only when Coverage Group is not defined. Calculated as a lookup on INSURANCE_COVERAGE_RULE

amount. Calculated as a lookup on INSURANCE_COVERAGE_RULE

30 SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide

Page 31

Table Name Column Name Description

HR_INFOTYPE_0168_I NSURANCE

HR_INFOTYPE_0169_ SAVINGS

HR_INFOTYPE_0170_ FLEX

HR_INFOTYPE_0236_ CREDIT

AMT_EMPLEE_COST Monthly Benefit Employee Cost Amount

from Function HR_BEN_GET_PLAN_COST

AMT_EMPLEE_POST_ TAX

AMT_EMPLER_COST_ CREDIT

AMT_IMPUTED_INCOMEBenefits Imputed Income from Function

AMT_INSURANCE_CO VERAGE

AMT_PER_ADDTL_INS URANCE_UNIT

AMT_PROVIDER_COSTBenefit Provider Cost Amount from

AMT_SALARY_OVERR IDE

AMT_PENSION_ADJUSTPA0169.PAAMT - Pension adjustment

AMT_POSTTAX_SAVNGPA0169.PTAMT - Employee post-tax

AMT_PRETAX_SAVNG PA0169.EEAMT Employees pre-tax

AMT_CONTRIBUTN_E MPLEE

AMT_CREDIT PA0236.CRAMO Employees actual credit

Benefits Additional Employee Post-Tax Costs from Function HR_BEN_GET_PLAN_COST

Benefit Employer Cost/Credit Amount from Function HR_BEN_GET_PLAN_COST

HR_BEN_GET_PLAN_COST Benefit Insurance Coverage Amount from

Function HR_BEN_CALC_COVERAGE_AMOUNT

T74FC.ADDUN (via function HR_BEN_GET_RULE_COVERAGE) Benefit Value of each Unit of Additional Insurance Coverage

Function HR_BEN_GET_PLAN_COST PA0168.SALOV- Benefits salary override

amount

savings plan contribution amount

saving contribution amount P A0170.CAMNT - Employee contribution

amount to spending account

amount

Subject Areas

Infotypes Section

Rapid Mart data

The following diagram shows the infotypes

SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide 31

Page 32

Subject Areas

Infotypes Section

Infotypes Schema:

Typical queries: The infotypes are used to provide detailed analyses of information

summarized in the fact tables (other subject ares). Typically this is a drilldown (or sub-query) into specific infotypes for a specific employees.

Example: An Employee Listing report drills down to detail on Employee

Actions (Infotype 0000), Employee Assignments (Infotype 0001), and Employee Pay (Infotype 0008).

32 SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide

Page 33

Employee Administration Section

The employee administration subject area of this Rapid Mart allows you to analyze information about employee attributes, such as age, length of service, and annual salary, and about employee events, such as deadlines and other significant dates. Additional analyses of employee demographics (age, marital status, education, qualifications, etc.) is also available.

This section includes information about:

• SAP solutions processing

• Rapid Mart processing

• Rapid Mart data

Subject Areas

Employee Administration Section

SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide 33

Page 34

Subject Areas

Employee Administration Section

SAP solutions processing

SAP solutions stores employee data in several Personnel Administration (PAPAD) infotypes. Each infotype contains information that inter-related and is likely to change simultaneously. For example, information related to an employee’s home address and phone number is contained in a single infotype (PA0006).

If an employee moves, both address and phone number are likely to change. But, if the move is the result of a transfer and promotion, information contained in other infotypes, such as salary (PA0008), will also change.

Each record in an infotype has effective dates — a beginning date and an ending date. The ending date for the current record is always 12/31/9999. When you insert a new record in an infotype, SAP solutions delimits the date in the record that was current. In other words, SAP solutions updates the previously unspecified ending date (12/31/9999) with the correct ending date—the last date the old record is in effect. The new record has a beginning date that shows when the record becomes effective and an unspecified ending date (12/31/9999).

Maintaining employee information in separate infotypes and delimiting infotypes as they change improves SAP solutions performance and reduces the volume of data required to keep current and historic information for all employee attributes. However, effective dates are not synchronized for different infotypes. Therefore, joining data inside SAP solutions from multiple infotypes for reporting purposes is difficult.

Rapid Mart processing

The Rapid Mart extracts data from the following SAP solutions infotypes:

• PA0000 — Events

• PA0001 — Organizational Assignment

• PA0002 — Personal Data

• PA0007 — Work Schedule

• PA0008 — Basic Pay

• PA0016 — Contract Elements

• PA0019 — Date Monitoring

• PA0022 — Education

• PA0024 — Qualifications

• PA0041 — Date Specifications

• PA0077 — Additional Personal Data

• PA0094 — Residency Status (North America)

34 SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide

Page 35

Subject Areas

Employee Administration Section

• PA0169 — Savings Plans

These tables are extracted without much transformation and are stored in holding tables. The holding tables are available for additional analyses in the

Infotypes Section described later on in this chapter. These holding tables are

used as sources to load the final Rapid Mart tables used for analysis. The target table is EMPLOYEE_ADMINISTRATION_FACT. This section also captures these dimensional attributes and their associated

dimension tables

Attribute Name Dimension Tables

Benefit Area BENEFIT_AREA Benefit Plan BENEFIT_PLAN Benefit Program Group BENEFIT_PROGRAM_GROUP Benefit Termination Rule BENEFIT_TERMINATION_RULE Business Area BUSINESS_AREA Certificate Type CERTIFICATE_TYPE Company Code COMPANY_CODE Contribution Rule CONTRIBUTION_RULE Controlling Area CONTROLLING_AREA Cost Center COST_CENTER Cost Center Hierarchy COST_CENTER_HIER,

COST_CENTER_HIER_BAD, COST_CENTER_HIER_HZ, COST_CENTER_HIER_VR

Country Group & Status COUNTRY_GROUP,

COUNTRY_GROUP_STATUS Monetary Currency CURRENCY Education Type EDUCATION_TYPE Eligibility Rule ELIGIBILITY_RULE Employee EMPLOYEE Employee Group EMPLOYEE_GROUP Employee Subgroup EMPLOYEE_SUBGROUP Ethnic Origin ETHNIC_ORIGIN Gender GENDER Holiday Calendar & Work Calendar HOLIDAY_CALENDAR,

WORK_CALENDAR

SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide 35

Page 36

Subject Areas

Employee Administration Section

Attribute Name Dimension Tables

Identification Type IDENTIFICATION_TYPE Insurance Coverage Rule INSURANCE_COVERAGE_RULE Investment Group INVESTMENT_GROUP Investment Plan INVESTMENT_PLAN Job JOB Language LANGUAGE Service Interval Hr SERVICE_INTERVAL_HR Line Manager Hierarchy LINE_MANAGER_HIER Marital Status MARITAL_STATUS Military Status MILITARY_STATUS Nationality NATIONALITY Organization Key ORGANIZATION_KEY Organization Unit ORGANIZATION_UNIT Organization Unit Hierarchy ORGANIZATION_UNIT_HIER,

Payroll Area PAYROLL_AREA Pay Scale Area PAY_SCALE_AREA Pay Scale Type PAY_SCALE_TYPE Personnel Action Reason PERSONNEL_ACTION_REASON Personnel Action Status PERSONNEL_ACTION_STATUS Personnel Action Type PERSONNEL_ACTION_TYPE Personnel Administrator PERSONNEL_ADMINISTRATOR Personnel Area PERSONNEL_AREA Personnel Date Type PERSONNEL_DATE_TYPE Personnel Subarea PERSONNEL_SUBAREA Personnel Task Status PERSONNEL_TASK_STATUS Personnel Task Type PERSONNEL_TASK_TYPE Position POSITION Position Hierarchy POSITION_HIER,

ORGANIZATION_UNIT_HIER_HZ, ORGANIZATION_UNIT_HIER_VR

POSITION_HIER_HZ, POSITION_HIER_VR

36 SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide

Page 37

Subject Areas

Employee Administration Section

Attribute Name Dimension Tables

Proficiency PROFICIENCY Qualification QUALIFICATION Religion RELIGION Residence Status RESIDENCE_STATUS Salary Range SALARY_RANGE School Type SCHOOL_TYPE Study Branch STUDY_BRANCH Time Dimension TIME_DIM, TIME_DIM_WEEKLY Time Management Status TIME_MANAGEMENT_STATUS Unit Of Time UNIT_OF_TIME Vesting Rule VESTING_RULE Wage Type WAGE_TYPE Work Contract WORK_CONTRACT Work Contract Type WORK_CONTRACT_TYPE Work Permit Type WORK_PERMIT_TYPE

Fact table Fields

The EMPLOYEE_ADMINISTRATION_FACT table contains the following measures:

Column Name Description

AMT_COST_EDUCATN PA0022.JBEZ1 Course fees AMT_PAYMNT_01 PA0008.BET01 Wage type 01

amount for payments AMT_PAYMNT_02 PA0008.BET02 Wage type 02

amount for payments AMT_PAYMNT_03 PA0008.BET03 Wage type 03

amount for payments AMT_PENSION_ADJUST PA0169.PAAMT - Pension

adjustment amount AMT_POSTTAX_SAVNG PA0169.PTAMT - Employee post-t ax

savings plan contribution amount AMT_PRETAX_SAVNG PA0169.EEAMT Employees pre-tax

saving contribution amount

SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide 37

Page 38

Subject Areas

Employee Administration Section

Column Name Description

AMT_SALARY_YR PA0008.ANSAL Annual salary AMT_SALARY_YR_PREV HR_INFOTYPE_0008_PAY.AMT_SA

COUNT_BENEFIC_DEPENDNT Calculated number of savings plan

COUNT_EMPLEE_SVC_INTERVAL _01

COUNT_EMPLEE_SVC_INTERVAL _02

COUNT_EMPLEE_SVC_INTERVAL _03

COUNT_EMPLEE_SVC_INTERVAL _04

COUNT_EMPLEE_SVC_INTERVAL _05

COUNT_EMPLEE_SVC_INTERVAL _06

COUNT_EMPLEE_SVC_UNKNOWNCount of Employees where length of

HOURS_DAY PA0007.ARBST Daily working hours HOURS_DAY_MAX PA0007.MAXTA Maximum number

HOURS_DAY_MIN PA0007.MINTA Minimum number of

HOURS_MONTH PA0007.MOSTD Monthly hours HOURS_MONTH_MAX PA0007.MAXMO Maximum number

HOURS_MONTH_MIN P A0007.MINMO Minimum number of

HOURS_WEEK PA0007.WOSTD Weekly hours HOURS_WEEK_MAX PA0007.MAXWO Maximum number

HOURS_WEEK_MIN PA0007.MINWO Minimum weekly

LARY_YR Previous salary lookup

dependents Count of Employees with length of

service within Interval 1 Count of Employees with length of

service within Interval 2 Count of Employees with length of

service within Interval 3 Count of Employees with length of

service within Interval 4 Count of Employees with length of

service within Interval 5 Count of Employees with length of

service within Interval 6

service is not known (Employee Original Hire Date is missing).

of work hours per day

work hours per day

of work hours per month

work hours per month

of work hours per week

working hours

38 SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide

Page 39

Column Name Description

HOURS_WORK PA0008.DIVGV Hours worked per

HOURS_YEAR PA0007.JRSTD Annual working

HOURS_YEAR_MAX PA0007.MAXJA Maximum number

HOURS_YEAR_MIN PA0007.MINJA Minimum number of

Rapid Mart data

The following diagram shows the employee administration section and the components used as dimensions and their associated hierarchies:

Employee Administration Schema:

Employee Administration Section

accounting period

hours

of work hours per year

work hours per year

Subject Areas

The universe (semantic layer) joins the organization unit and position hierarchies with the fact table to allow analyses of the demographics summarized by hierarchy levels.

SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide 39

Page 40

Subject Areas

Employee Administration Section

You can analyze the data in this subject area along any of the dimensions or hierarchies listed above.

Typical queries include:

• What are the salary ranges by gender within each department?

• List employees with more than three years in the company and with

• What is the distribution of employees by age groups: below 20, between

• Are there any current employees qualified for the new opening in my

• Which employees have doctoral degree in the R&D Department?

• What is the average tenure of salaried employees vs. hourly employees?

• What is the employee head count within Sales and Marketing

• Which managers have more than ten people directly to reporting them?

annual salary less than $40,000?

21 and 40, and above 40 years old?

department?

organization shown as a hierarchy (organization chart)?

40 SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide

Page 41

Organization Hierarchies Section

The Organization Hierarchies of this Rapid Mart enables analysis of information in other sections within this Rapid Mart summarized at any level of the organization or position hierarchies.

This chapter includes information about:

• SAP solutions processing

• Rapid Mart processing

• Relationship to other sections

• Rapid Mart data

SAP solutions processing

Using SAP solutions’s Personnel Development Organizational Management sub-module (PD-OM), Human Resources planners can build and maintain organizational structures that reflect the company’s current and planned work force. Organizational hierarchies show chain-of-command relationships between various entities within an enterprise. SAP solutions maintains other types of relationships for many different kinds of organizational entities.

Subject Areas

Organization Hierarchies Section

SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide 41

Page 42

Subject Areas

Organization Hierarchies Section

The SAP BusinessObjects HR Rapid Mart, version for SAP solutions concentrates on the “reports to” relationship within the organizational unit and the employee position hierarchies. The following diagram shows an example of an organizational hierarchy that represents the Sales & Marketing division of a U.S. subsidiary. Each node is identified by an organizational unit ID.

Rapid Mart processing

The organization hierarchies are stored in these infotype tables:

• HRP1000 table. It contains information about jobs, positions and

organizational units within the company. This is the source for the Position Hierarchy

• HRP1001 table. It contains the relationship between different levels

within jobs, positions and organizational units. This is the source for the Organization Unit Hierarchy

These two tables are extracted as holding tables and from them the Rapid Mart tables in this section are extracted. They are also used to create the organizational dimensions used in this and other subject areas of the Rapid Mart

42 SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide

Page 43

Relationship to other sections

The hierarchies are presented as dimension tables used by other subject areas in the Rapid Mart. The hierarchies in this section can be used to analyze the data in the other sections based on position or organizational hierarchical levels.

Rapid Mart data

The Rapid Mart represents the organization unit and position hierarchies in three tables each. Depending on the reporting requirements, one may be more suitable than the others.

Organization Unit Hierarchy

• ORGANIZATION_UNIT_HIER — A direct mapping from the SAP

solutions organizational unit hierarchies

• ORGANIZATION_UNIT_HIER_VR — A vertically flattened version of the

organizational unit hierarchies

• ORGANIZATION_UNIT_HIER_HZ — A horizontally flattened version of

the organizational unit hierarchies.

Subject Areas

Organization Hierarchies Section

Position Hierarchy

• POSITION_HIER — A direct mapping from the SAP solutions position

hierarchies

• POSITION_HIER_VR — A vertically flattened version of the position

hierarchies

• POSITION_HIER_HZ — A horizontally flattened version of the position

hierarchies

For information about SAP solutions hierarchies and hierarchy flattening methods used in the Rapid Mart, see the section on Hierarchies in Chapter 5:

Universe.

You can use data in this section to answer demands like:

• Show the hierarchical employee head count within Sales and Marketing

organization

• List employees who have more than ten people directly to reporting them.

SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide 43

Page 44

Subject Areas

Leave Entitlement Section

The leave entitlement subject area of this Rapid Mart allows you to analyze information about employee absences, such as vacations, sick leave, jury duty, maternity leave, etc. You can correlate accrued leave time vs. leave taken. You can also analyze the information by the organization, cost center, and position hierarchies.

This section includes information about:

• SAP solutions processing

• Rapid Mart processing

• Rapid Mart data

SAP solutions processing

SAP solutions stores leave data in several Personnel Administration (PAPAD) infotypes. Leave infotypes are like any other infotypes: they are effective date specific, and each may change independently of the others. The same challenges in extracting and reporting infotype information hold true for Leave Entitlement as other subject areas.

Rapid Mart processing

The Rapid Mart extracts data from the following SAP solutions infotypes:

• PA0000 — Events

• PA0001 — Organizational Assignment

• PA0005 — Leave Entitlement

These tables are extracted without much transformation and are stored in holding tables. The holding tables are available for additional analyses in the

Infotypes Section described later on in this chapter. These holding tables are

used as sources to load the final Rapid Mart tables used for analysis. The target table is LEAVE_ENTITLEMENT_FACT. This section also captures these dimensional attributes and their associated

dimension tables

Attribute Name Dimension Tables

Business Area BUSINESS_AREA Company Code COMPANY_CODE Controlling Area CONTROLLING_AREA

44 SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide

Page 45

Subject Areas

Leave Entitlement Section

Attribute Name Dimension Tables

Cost Center COST_CENTER Cost Center Hierarchy COST_CENTER_HIER,

COST_CENTER_HIER_BAD,

COST_CENTER_HIER_HZ,

COST_CENTER_HIER_VR Country Group & Status COUNTRY_GROUP,

COUNTRY_GROUP_STATUS Employee EMPLOYEE Employee Group EMPLOYEE_GROUP Employee Subgroup EMPLOYEE_SUBGROUP Holiday Calendar & Work Calendar HOLIDAY_CALENDAR,

WORK_CALENDAR Job JOB Leave Deduction LEAVE_DEDUCTION Leave Type LEAVE_TYPE Line Manager Hier LINE_MANAGER_HIER Organization Key ORGANIZATION_KEY Organization Unit ORGANIZATION_UNIT Organization Unit Hierarchy ORGANIZATION_UNIT_HIER,

ORGANIZATION_UNIT_HIER_HZ,

ORGANIZATION_UNIT_HIER_VR Payroll Area PAYROLL_AREA Personnel Administrator PERSONNEL_ADMINISTRATOR Personnel Area PERSONNEL_AREA Personnel Subarea PERSONNEL_SUBAREA Position POSITION Position Hierarchy POSITION_HIER,

POSITION_HIER_HZ,

POSITION_HIER_VR Time Dimension TIME_DIM, TIME_DIM_WEEKLY Work Contract WORK_CONTRACT

SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide 45

Page 46

Subject Areas

Leave Entitlement Section

Fact table Fields

The LEAVE_ENTITLEMENT_FACT table contains the following measures. These detail the amounts of leave accrued:

Column Name Description

AMT_LEAVE_ACCOUNTED PA0005.UAB01-6 Leave days

accounted (Hours or Days)

AMT_LEA VE_ENTITLMNT PA0005.UAN01- 6 Leave entitleme nt

(Hours or Days) Leave type 01-06

COUNT_WRKDAY Calculated as count of number of

working days from WORKING_CALENDAR dimension based on LEA VE_START_DATE and LEAVE_END_DATE

DAYS_LEAVE_DEDUCT PURLT.ANZH1 - Amount - Deducted

Leave in Days

HOURS_LEAVE_DEDUCT PURLT.ANZHL - amount - Deducted

leave in Hours

The LEAVE_DEDUCTION stand alone dimension contains the following measures. These detail the amounts of leave taken:

Column Name Description

DAYS_LEAVE PURLT.ANZH1 - Amount HOURS_LEAVE PURLT.ANZHL - Amount LEAVE_YEAR PURLT.URLJJ - Leave year

Rapid Mart data

The following diagram shows the employee administration section and the components used as dimensions and their associated hierarchies:

46 SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide

Page 47

Subject Areas

Benefit Enrollment Section

Leave Entitlement Schema

You can analyze the data in this subject area along any of the dimensions or hierarchies listed above.

Typical queries include:

• How much productivity has been lost to sick days by cost center this

month?

• Which employees have the highest accrued vacation?

• Which employees take the most sick days?

• Is absenteeism more prevalent in certain parts of the organization?

• How many employees do not have enough vacation time to cover the

upcoming one week shutdown of the company?

Benefit Enrollment Section

With the benefit enrollment section of this Rapid Mart, you can analyze information about the enrollment in and usage of company benefits. You can use the SAP BusinessObjects HR Rapid Mart, version for SAP solutions to analyze benefit plan enrollment from two perspectives. First, you can analyze enrollment from the employee perspective, listing plans and coverage options by employee personnel number. Second, you can analyze enrollment from

SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide 47

Page 48

Subject Areas

Benefit Enrollment Sectio n

the plan perspective, listing point-in-time statistics by plan and showing enrollment, eligibility, and other measures such as average number of beneficiaries.

This section includes information about:

• SAP solutions processing

• Rapid Mart processing

• Rapid Mart data

SAP solutions processing

The SAP solutions Personnel Benefits Administration (PA-Ben) sub-module stores information about each employee’s eligibility for and enrollment in various benefit plans. SAP solutions also stores information on plan options, cost, coverage, employee/employer contributions, dependent coverage, vesting rules, and investment options.

Benefit infotypes are like any other infotypes: they are effective date specific, and each may change independently of the others. The same challenges in extracting and reporting infotype information hold true for Benefit Enrollment as other subject areas.

Each benefits infotype contains a subtype field that divides the information into groups of related data. For example, the health plans infotype (PA0167) has subtypes for medical, dental, and vision plans.

48 SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide

Page 49

SAP solutions uses time constraints to define and manage validity periods for time-dependent data. SAP solutions assigns the general benefits infotype to time constraint 1 and all other benefit infotypes to time constraint 2. In infotypes assigned time constraint 1, SAP solutions allows exactly one record to be valid for a given employee at a given time and permits no gaps and no overlaps. In infotypes assigned time constraint 2, SAP solutions allows gaps in time sequence but no overlaps. Therefore, in an infotype with time constraint 2, an employee may have no valid record at a given time, but will never have more than one valid record at a given time.

Rapid Mart processing

Specifically, the Rapid Mart extracts employee benefit information from these infotypes:

• PA0001 — Organizational Assignment

• PA0167 — Health plans

• PA0168 — Insurance plans

• PA0169 — Savings plans

• PA0170 — Spending accounts (United States)

• PA0171 — General benefits data

• PA0236 — Credit plans

These tables are extracted without much transformation and are stored in holding tables. The holding tables are available for additional analyses in the

Infotypes Section described later on in this chapter. These holding tables are

used as sources to load the final Rapid Mart tables used for analysis. Employees who can enroll in plans must have a record in the general benefits

data infotype (PA0171). This infotype contains the employee’s benefit group assignment, which determines plan options, cost, and eligibility criteria.

The target tables are BENEFIT_ENROLLMENT_FACT, and BENEFIT_ENROLL_SUMMARY_FACT.

This section also captures these dimensional attributes and their associated dimension tables:

Subject Areas

Benefit Enrollment Section

Attribute Name Dimension Tables

Benefit Area BENEFIT_AREA Benefit Cost Rule BENEFIT_COST_RULE Benefit Plan BENEFIT_PLAN Benefit Program Group BENEFIT_PROGRAM_GROUP Benefit Spending Account BENEFIT_SPENDING_ACCOUNT

SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide 49

Page 50

Subject Areas

Benefit Enrollment Sectio n

Attribute Name Dimension Tables

Benefit Termination Rule BENEFIT_TERMINATION_RULE Business Area BUSINESS_AREA Company Code COMPANY_CODE Contribution Rule CONTRIBUTION_RULE Controlling Area CONTROLLING_AREA Cost Center COST_CENTER Cost Center Hierarchy COST_CENTER_HIER,

COST_CENTER_HIER_BAD, COST_CENTER_HIER_HZ, COST_CENTER_HIER_VR

Country Group & Country Group Status

Monetary Currency CURRENCY Dependent Coverage DEPENDENT_COVERAGE Eligibility Rule ELIGIBILITY_RULE Employee EMPLOYEE Employee Group EMPLOYEE_GROUP Employee Subgroup EMPLOYEE_SUBGROUP Enrollment Type ENROLLMENT_TYPE Health Plan HEALTH_PLAN Holiday Calendar & Work Calendar HOLIDAY_CALENDAR,

Insurance Coverage Group INSURANCE_COVERAGE_GROUP Insurance Coverage Rule INSURANCE_COVERAGE_RULE Insurance Option INSURANCE_OPTION Investment Group INVESTMENT_GROUP Investment Plan INVESTMENT_PLAN Job JOB Leave Deduction LEAVE_DEDUCTION Line Manager Hierarchy LINE_MANAGER_HIER Organization Key ORGANIZATION_KEY Organization Unit ORGANIZATION_UNIT

COUNTRY_GROUP, COUNTRY_GROUP_STATUS

WORK_CALENDAR

50 SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide

Page 51

Attribute Name Dimension Tables

Organization Unit Hierarchy ORGANIZATION_UNIT_HIER,

Payroll Area PAYROLL_AREA Personnel Administrator PERSONNEL_ADMINISTRATOR Personnel Area PERSONNEL_AREA Personnel Subarea PERSONNEL_SUBAREA Position POSITION Position Hierarchy POSITION_HIER,

Time Dim, Time Dim Weekly TIME_DIM, TIME_DIM_WEEKLY Vesting Rule VESTING_RULE Work Contract WORK_CONTRACT

Fact table Fields

The BENEFIT_ENROLLMENT_FACT, and BENEFIT_ENROLL_SUMMARY_FACT tables contain the following measures:

Subject Areas

Benefit Enrollment Section

ORGANIZATION_UNIT_HIER_HZ,

ORGANIZATION_UNIT_HIER_VR

POSITION_HIER_HZ,

POSITION_HIER_VR

Table Name Column Name Description

BENEFIT_ENROLL_ SUMMARY_FACT

AMT_BENFT_SALARY_AVG Average Annual Benefit Salary from Function

AMT_BENFT_SALARY_MAX Max Annual Benefit Salary from Function

AMT_CONTRIBUTN_EMPLEE_AVGAverage PA0170.CAMNT - Employee

AMT_CONTRIBUTN_EMPLEE_MAXMax PA0170.CAMNT - Employee contribution

AMT_COVERAGE_AVG Average PA0168.COVOV/ T74FC.COVAM-

AMT_COVERAGE_MAX Average PA0168.COVOV/ T74FC.COVAM-

HR_BEN_GET_PLAN_SALARY

contribution amount to spending account OR Benefit Employee Cost Amount from Function HR_BEN_GET_PLAN_COST

amount to spending account OR Benefit Employee Cost Amount from Function HR_BEN_GET_PLAN_COST

Coverage amount - Life only when Coverage Group is not defined. Calculated as a lookup on INSURANCE_COVERAGE_RULE

SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide 51

Page 52

Subject Areas

Benefit Enrollment Sectio n

Table Name Column Name Description

BENEFIT_ENROLL_ SUMMARY_FACT

AMT_EMPLEE_POSTTAX_INSUR_ AVG

AMT_EMPLEE_POSTTAX_INSUR_ MAX

AMT_EMPLEE_POSTX_HEALTH_AVGAverage Benefits Additional Employee Post-Tax

AMT_EMPLEE_POSTX_HEALTH_ MAX

AMT_EMPLER_COST_AVG Average Benefit Employer Cost/Credit Amount

AMT_EMPLER_COST_MAX Max Benefit Employer Cost/Credit Amount from

AMT_IMPUTED_INCOME_AVG A verage Benefits Imputed Income from Function

AMT_IMPUTED_INCOME_MAX Max Benefits Imputed Income from Function

AMT_INSUR_COVERAGE_AVG Average Benefit Insurance Coverage Amount

AMT_INSUR_COVERAGE_MAX Max Benefit Insurance Coverage Amount from

AMT_PER_ADDTL_INSUR_UNIT_ AVG

AMT_PER_ADDTL_INSUR_UNIT_ MAX

AMT_POSTTAX_SAVNG_AVG Average PA0169.PTAMT - Employee post-tax

AMT_POSTTAX_SAVNG_MAX Max PA0169.PTAMT - Employee post-tax

AMT_PRETAX_SAVNG_AVG PA0169.EEAMT Average Employees pre-tax

AMT_PRETAX_SAVNG_MAX PA0169.EEAMT Max Employees pre-tax saving

AMT_PROVIDER_COST_AVG Average Benefit Provider Cost Amount from

AMT_PROVIDER_COST_MAX Max Benefit Provider Cost Amount from

Average Benefits Additional Employee Post-Tax Costs from Function HR_BEN_GET_PLAN_COST

Max Benefits Additional Employee Post-Tax Costs from Function HR_BEN_GET_PLAN_COST

Costs from Function HR_BEN_GET_PLAN_COST

Max Benefits Additional Employee Post-Tax Costs from Function HR_BEN_GET_PLAN_COST

from Function HR_BEN_GET_PLAN_COST

Function HR_BEN_GET_PLAN_COST

HR_BEN_GET_PLAN_COST

from Function HR_BEN_CALC_COVERAGE_AMOUNT

Function HR_BEN_CALC_COVERAGE_AMOUNT

T74FC.ADDUN (via function HR_BEN_GET_RULE_COVERAGE) - Average Benefit Value of each Unit of Additional Insurance Coverage

T74FC.ADDUN (via function HR_BEN_GET_RULE_COVERAGE) - Max Benefit Value of each Unit of Additional Insurance Coverage

savings plan contribution amount

saving contribution amount

contribution amount

Function HR_BEN_GET_PLAN_COST

52 SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide

Page 53

Table Name Column Name Description

BENEFIT_ENROLL_ SUMMARY_FACT

BENEFIT_ENROLLM ENT_FACT

COUNT_BENEFIC_DEPENDNT_AVGAverage Number of Dependents or beneficiaries

COUNT_BENEFIC_DEPENDNT_MAXMax number of dependents or beneficiaries

COUNT_BENEFIC_DEPENDNT_TTLTotal Number of Dependents or beneficiaries

COUNT_EMPLEE_ENROLL Number of employees enrolled in plan - based

PRCNT_POSTTAX_SAVNG_AVG Average PA1069.PTPCT - Employee post-tax

PRCNT_POSTTAX_SA VNG_MAX Max PA1069.PTPCT - Employee post-tax saving

PRCNT_PRETAX_SAVNG_AVG Average PA1069.EEPCT - Employees pre-tax

PRCNT_PRETAX_SAVNG_MAX Max PA1069.EEPCT - Employees pre-tax

QTY_ADDTL_INSUR_UNITS_AVG PA0168.ADDNO - Average Benefit Number of

QTY_ADDTL_INSUR_UNITS_MAX PA0168.ADDNO - Max Benefit Number of

AMT_ALT_COVERAGE PA0168.COVOV - Benefit alternative amount

AMT_BASIC_COVERAGE Benefit Insurance Coverage Basic Amount from

AMT_BENFT_SALARY Annual Benefit Salary from Function

AMT_CONTRIBUTN_EMPLEE PA0170.CAMNT - Employee contribution

AMT_CONTRIBUTN_MAX T5UBG.RMAXA Maximum contribution to

AMT_CONTRIBUTN_MIN T5UBG.RMINA Minimum contribution to

AMT_COVERAGE PA0168.COVOV/ T74FC.COVAM- Coverage

AMT_COVERAGE_MAX T74FC.MAXAM - Maximum coverage amount.

listed on plan (from PA0168/0167/169/170/171/

236)

(from PA0168/0167/169/170/171/236)

listed on plan (from PA0168/0167/169/170/171/

236)

on eligibility date and participation date.

saving plan contribution percentage

plan contribution percentage

savings plan contribution percentage

Additional Insurance Coverage Units

for insurance coverage amount

Function HR_BEN_EVAL_AMOUNT

HR_BEN_GET_PLAN_SALARY

amount to spending account OR Benefit Employee Cost Amount from Function HR_BEN_GET_PLAN_COST

spending account (Lookup on table BENEFIT_SPENDING_ACCOUNT)

amount - Life only when Coverage Group is not defined. Calculated as a lookup on INSURANCE_COVERAGE_RULE

Calculated as a lookup on INSURANCE_COVERAGE_RULE

Subject Areas

Benefit Enrollment Section

SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide 53

Page 54

Subject Areas

Benefit Enrollment Sectio n

Table Name Column Name Description

BENEFIT_ENROLLM ENT_FACT

AMT_CREDIT PA0236.CRAMO Employees actual credit

AMT_EMPLEE_POSTTAX_HEALTH Benefits Additional Employee Post-Tax Costs

AMT_EMPLEE_POSTTAX_INSURA NCE

AMT_EMPLER_COST Benefit Employer Cost/Credit Amount from

AMT_IMPUTED_INCOME Benefits Imputed Income from Function

AMT_INSURANCE_COVERAGE Benefit Insurance Coverage Amount from

AMT_PENSION_ADJUST PA0169.PAAMT - Pension adjustment amount

AMT_PER_ADDTL_INSURANCE_U NIT

AMT_POSTTAX_SAVNG PA0169.PTAMT - Employee post-tax savings

AMT_PRETAX_SAVNG PA0169.EEAMT Employees pre-tax saving

AMT_PROVIDER_COST Benefit Provider Cost Amount from Function

AMT_SALARY_OVERRIDE PA0168.SALOV- Benefits salary override

PRCNT_INVESTMNT_01 PA0169.IPT01 Investment percentage

PRCNT_INVESTMNT_02 PA0169.IPT02 Investment percentage

PRCNT_INVESTMNT_03 PA0169.IPT03 Investment percentage

PRCNT_INVESTMNT_04 PA0169.IPT04 Investment percentage

PRCNT_INVESTMNT_05 PA0169.IPT05 Investment percentage

PRCNT_INVESTMNT_OTHER PA0169.ITP06-ITP20Remaining percent

PRCNT_POSTTAX_SAVNG PA1069.PTPCT - Employee post-tax saving plan

PRCNT_PRETAX_SAVNG PA1069.EEPCT - Employees pre-tax savings

amount

from Function HR_BEN_GET_PLAN_COST Benefits Additional Employee Post-Tax Costs

from Function HR_BEN_GET_PLAN_COST

Function HR_BEN_GET_PLAN_COST

HR_BEN_GET_PLAN_COST

Function HR_BEN_CALC_COVERAGE_AMOUNT

T74FC.ADDUN (via function HR_BEN_GET_RULE_COVERAGE) - Benefit Value of each Unit of Additional Insurance Coverage

plan contribution amount

contribution amount

HR_BEN_GET_PLAN_COST

investment not covered by IPT1-5. Check SAP for remaining percentages

contribution percentage

plan contribution percentage

54 SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide

Page 55

Table Name Column Name Description

BENEFIT_ENROLLM ENT_FACT

QTY_ADDTL_INSURANCE_UNITS PA0168.ADDNO - Benefit Number of Additional

RATE_SALARY_MULTIPLR T74FC.COVFA - Benefits factor for calculating

Insurance Coverage Units

insurance coverage base on Salary (Multiplier). Calculated as a lookup on INSURANCE_COVERAGE_RULE

Rapid Mart data

The following diagram shows the benefit enrollment section and the components used as dimensions

Benefit Enrollment Schema.

Subject Areas

Benefit Enrollment Section

You can analyze the data in this subject area along any of the dimensions or hierarchies listed above.

Typical queries that can be answered with this section include:

• What percentage of employees opt for additional Life Insurance coverage

broken down by Organization Hierarchy?

• What is the count of employees who enroll in 401(k) savings plans within

the Position hierarchy?

• What is the employer’s cost for health care by cost center this fiscal year?

SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide 55

Page 56

Subject Areas

Employee Wage Section

• How many employees do not have health care insurance?

• Which health care insurance policy is most popular by Cost Center

hierarchy?

Employee Wage Section

The employee wage section lets you correlate employee wage information (wage types, pay scales, etc.) with certain organizational aspects (position, organization, job, etc.). Payment amounts for each Wage Type are the key measure in this section.

The key difference between the Employee Wage Section and the Payroll

Section is that Employee Wages shows history of the gross wage or salary

amounts from the perspective of your organization’s pay and deduction structures and internal set-up. The Payroll shows the actual payments generated from this internal setup. It records the actual payments made each payday to your employees. It includes information on deductions for taxes, various benefits, etc. The Payroll perspective is for external consumption by various government agencies as well as the employees themselves.

This section includes information about:

SAP solutions processing Rapid Mart processing Rapid Mart data

SAP solutions processing

SAP solutions stores Wage data in several Personnel Administration (PAP AD) infotypes. W age infotypes are like any other infotypes: they are effective date specific, and each may change independently of the others. The same challenges in extracting and reporting infotype information hold true for Employee Wages as other subject areas.

The SAP solutions personnel administration and payroll sub-module (PAPAY) calculates gross compensation for each employee based on wage type payment structures. SAP solutions also uses wage types to calculate deductions in pay due to employee contributions, benefit plan costs, involuntary deductions, and taxes. There are two kinds of wage types: primary and secondary. Primary wage types are those entered as employee master data. Secondary wage types are those created by SAP solutions during a payroll run. Secondary wage types have a slash (/) prefix.

56 SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide

Page 57

In SAP solutions, wage types have three fields: amount, rate, and number of units. When pay is a fixed amount, SAP solutions uses these fields individually to determine pay. When pay is time based, SAP solutions combines the fields to determine pay (that is, pay equals amount times rate times number of units). When SAP solutions computes pay based on table values stored elsewhere, these wage type fields may be left blank. Wage type valuation based on master data within the infotype is called direct valuation. Wage type valuation based on table lookups is called indirect valuation.

Rapid Mart processing

The Rapid Mart extracts data from the following SAP solutions infotypes:

• PA0001 — Organizational Assignment

• PA0008 — Basic Pay

• PA0014 — Recurring benefits and deductions

• PA0015 — Additional payments

These tables are extracted without much transformation and are stored in holding tables. The holding tables are available for additional analyses in the

Infotypes Section described later on in this chapter. These holding tables are

used as sources to load the final Rapid Mart tables used for analysis. The target table is EMPLOYEE_WAGE_FACT. This section also captures these dimensional attributes and their associated

dimension tables:

Subject Areas

Employee Wage Section

Attribute Name Dimension Tables

Business Area BUSINESS_AREA Company Code COMPANY_CODE Controlling Area CONTROLLING_AREA Cost Center COST_CENTER Cost Center Hierarchy COST_CENTER_HIER,

COST_CENTER_HIER_BAD,

COST_CENTER_HIER_HZ,

COST_CENTER_HIER_VR Country Group & Status COUNTRY_GROUP,

COUNTRY_GROUP_STATUS Monetary Currency CURRENCY Employee EMPLOYEE Employee Group EMPLOYEE_GROUP

SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide 57

Page 58

Subject Areas

Employee Wage Section

Attribute Name Dimension Tables

Employee Subgroup EMPLOYEE_SUBGROUP Job JOB Line Manager Hierarchy LINE_MANAGER_HIER Organization Key ORGANIZATION_KEY Organization Unit ORGANIZATION_UNIT Organization Unit Hierarchy ORGANIZATION_UNIT_HIER,

ORGANIZATION_UNIT_HIER_HZ,

ORGANIZATION_UNIT_HIER_VR Payroll Area PAYROLL_AREA Pay Scale Area PAY_SCALE_AREA Pay Scale Type PAY_SCALE_TYPE Personnel Administrator PERSONNEL_ADMINISTRATOR Personnel Area PERSONNEL_AREA Personnel Subarea PERSONNEL_SUBAREA Position POSITION Position Hierarchy POSITION_HIER,

POSITION_HIER_HZ,

POSITION_HIER_VR Salary Range SALARY_RANGE Time Dimension TIME_DIM, TIME_DIM_WEEKLY Unit Of Time UNIT_OF_TIME Wage Type WAGE_TYPE Work Contract WORK_CONTRACT

Fact Table Fields

The EMPLOYEE_WAGE_FACT table contains the following measures:

Column Name Description

AMT_PAYMNT PA0014.BETRG Amount of payment for the wage type QTY_UNIT PA0014.ANZHL an amount or number (and also a unit)

for wage type 01

58 SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide

Page 59

Rapid Mart data

The following diagram shows the Employee Wage section and the components used as dimensions and their associated hierarchies:

Employee Wage Schema:

Subject Areas

Employee Wage Section

You can analyze the data in this subject area along any of the dimensions or hierarchies listed above.

Typical queries include:

• What is the monthly trend in net to gross pay ratio by employee group?

• How many employees receive a housing allowance (wage type MA20)?

• What is the count of employees by salary by cost center?

• Who are the top 10 highest paid employees this year vs. last year?

• What was the average hourly wage this year vs. last year?

SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide 59

Page 60

Subject Areas

Payroll Section

Using the employee payroll section of this Rapid Mart, you can analyze information about different wage types. Each payment or deduction in a paycheck is a wage type. Typically, a company’s payroll process calculates remuneration based on wage types and a country-specific set of rules. Companies cumulate wage types that represent individual payments or deductions to determine gross pay. Payment wage types include basic pay, bonuses, special pay, and so forth. Net pay calculations handle countryspecific adjustments to gross pay. Adjustments and deductions may be voluntary , such as charit able contributions, or statutory, such as taxes. Finally, the payroll process combines results of previous payroll runs with the current results to get cumulative gross and net pay amounts.

Note: The Payroll section is designed to meet U.S. payroll requirements.

Customization of the Rapid Mart is required for other countries. The key difference between the Employee Wage Section and the Payroll

Section is that Employee Wages shows history of the gross wage or salary

This section includes information about:

• SAP solutions processing

• Rapid Mart processing

• Rapid Mart data

SAP solutions processing

The SAP solutions personnel administration and payroll sub-module (PAPAY) calculates gross remuneration for each employee based on wage type payment structures. SAP solutions also uses wage types to calculate deductions in pay due to employee contributions, benefit plan costs, involuntary deductions, and taxes. There are two kinds of wage types: primary and secondary. Primary wage types are those entered as employee master data. Secondary wage types are those created by SAP solutions during a payroll run. Secondary wage types have a slash (/) prefix.

60 SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide

Page 61

Subject Areas

Payroll Section

The payroll process uses primary wage types as input and generates secondary wage types as output.

Primary wage types used as input Secondary wage types created as output

M001 – Hourly Rate /101 – Total Gross Pay MM01 – Basic Overtime /401 – Withholding Tax D240 – Life Insurance Deduction /110 – Employee Deductions

SAP solutions stores payroll results in data structures called PCL clusters. Clusters are grouped based on a relation ID (RELID). SAP solutions stores payroll accounting results in PCL2 clusters. Individual country payroll results are grouped according to relation id “Rn” where n refers to a human resources country indicator. The default version of the SAP BusinessObjects HR Rapid Mart, version for SAP solutions supports relation id “RU,” where “U” refers to the United States.

SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide 61

Page 62

Subject Areas

Payroll Section

SAP solutions assigns a sequence number to each employee in the payroll accounting results. The sequence number is associated with a payroll period and depends on the pay frequency of the employee. Each payroll period is associated with three dates:

• For period —Indicates the period for which the pay applies

• In period — Indicates the period in which the payroll run occurred

• Actual date — Indicates the payroll date

Retroactive changes to master data can affect prior payroll calculations. When retroactive changes occur, SAP solutions recalculates payroll and cumulative payroll results to reflect the changes.

Rapid Mart processing

The Rapid Mart extracts payroll data from three SAP solutions payroll cluster tables:

• PC207 — Payroll results table

• PC22Y — Payroll cumulated results table (USA)

• PC261 — Cluster directory for import and export of payroll results

The target tables are PAYROLL_FACT and PAYROLL_SUMMARY_FACT. This section also captures these dimensional attributes and their associated

dimension tables:

Attribute Name Dimension Tables

Business Area BUSINESS_AREA Company Code COMPANY_CODE Controlling Area CONTROLLING_AREA Cost Center COST_CENTER Cost Center Hierarchy COST_CENTER_HIER,

COST_CENTER_HIER_BAD,

COST_CENTER_HIER_HZ,

COST_CENTER_HIER_VR Country Group & Status COUNTRY_GROUP,

COUNTRY_GROUP_STATUS Monetary Currency CURRENCY Employee EMPLOYEE Employee Group EMPLOYEE_GROUP Employee Subgroup EMPLOYEE_SUBGROUP

62 SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide

Page 63

Subject Areas

Payroll Section

Attribute Name Dimension Tables

Job JOB Line Manager Hierarchy LINE_MANAGER_HIER Organization Key ORGANIZATION_KEY Organization Unit ORGANIZATION_UNIT Organization Unit Hierarchy ORGANIZATION_UNIT_HIER,

ORGANIZATION_UNIT_HIER_HZ,

ORGANIZATION_UNIT_HIER_VR Payroll Area PAYROLL_AREA Payroll Cumulation Type PAYROLL_CUMULATION_TYPE Payroll Period PAYROLL_PERIOD Payroll Period Parameter PAYROLL_PERIOD_PARAMETER Payroll Status PAYROLL_STATUS Payroll Type PAYROLL_TYPE Personnel Administrator PERSONNEL_ADMINISTRATOR Personnel Area PERSONNEL_AREA Personnel Subarea PERSONNEL_SUBAREA Position POSITION Position Hierarchy POSITION_HIER,

POSITION_HIER_HZ,

POSITION_HIER_VR Time Dimension TIME_DIM, TIME_DIM_WEEKLY Unit Of Time UNIT_OF_TIME Wage Type WAGE_TYPE Work Contract WORK_CONTRACT

Fact Table Fields

The PAYROLL_FACT and PAYROLL_SUMMARY_FACT tables contain the following measures:

Table Name Column Name Description

PAYROLL_FACT AMT_PAYROLL PC207.BETRG - Payroll Amount PAYROLL_FACT NUM_OF_UNITS PC207.ANZHL - HR payroll: Number - used for non-

pay wage types such as absences

SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide 63

Page 64

Subject Areas

Payroll Section

Table Name Column Name Description

PAYROLL_SUM MARY_FACT

AMT_PAYROLL PC22Y.BETRG - Period-to-date payroll amount

NUM_OF_UNITS PC22Y.ANZHL - Number of units in cumulative

payroll amount

64 SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide

Page 65

Rapid Mart data

The following diagram shows the payroll section and the components used as dimensions

Payroll Schema.

Subject Areas

Payroll Section

You can analyze the data in this subject area along any of the dimensions or hierarchies listed above.

Typical queries include:

• What is the monthly trend in net to gross pay ratio by employee group?

• How many employees receive a housing allowance (wage type MA20)?

• What is the count of employees by salary by cost center?

• Who are the top 10 highest paid employees this year vs. last year?

• What was the average hourly wage this year vs. last year?

Example:

SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide 65

Page 66

Subject Areas

Payroll Section

66 SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide

Page 67

Reports

chapter

Page 68

Reports

Overview

You can use the SAP BusinessObjects HR Rapid Mart, version for SAP solutions to produce many kinds of reports. This chapter provides examples of reports you could produce. The information in this chapter is useful for those who analyze and produce reports with the Rapid Mart data.

This chapter provides a sample report and the recommended joins for each componentized section in the Rapid Mart:

• Employee Administration

• Leave Entitlement

• Benefit Enrollment

• Employee Wage

• Payroll

SAP Master Data Reports are also described at the end of this chapter . These

reports are common across all Rapid Marts and are intended for hierarchy discovery and record validation.

Note: All report SQL is located in the Rapid Mart installation directory under

"\Sample\DML".

Employee Administration

Reports

Employee administration allows for a variety of detail, trend, and high level analysis. Below is a list of the reports included here for analysis:

• Employee Listing

• Company Employee Analysis

• Employee 360 Overview

• Employee Change History (Valid Between Dates)

68 SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide

Page 69

• Employee 360 Snapshot (As Of)

Employee Listing

View employee listing for the selected Company Code and Personnel Area. Includes a hyperlink on Person Id to view Employee 360 Overview.

Listing by Personnel Subarea

View employee listing by Personnel Subarea.

Reports

Employee Administration

Listing by Org Unit

View employee listing by Org Unit.

SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide 69

Page 70

Reports

Employee Administration

Top 10 Years of Service

View Top 10 employees (based on years of service) for each personnel subarea.

Calculations

• TTL Years of Service = [Years Of Service]

Report SQL

All report SQL is located in the Rapid Mart installation directory under "\Sample\DML".

Company Employee Analysis

View Company statistics for a selected Company Code and Personnel Area (all time vs. point in time) for Head Count, Turnover , New Hires, and Length of Service. Includes a hyperlink in the report header to view Employee Listing.

70 SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide

Page 71

Reports

Employee Administration

Summary

View company employee counts for each Personnel Subarea for the Current Date compared to the prompted As Of Date.

SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide 71

Page 72

Reports

Employee Administration

Length of Service

View employee length of service by interval (0-6 mo., > 6 mo. <= 1yr, > 1 yr. <= 3 yrs., etc.). Results are shown by employee count in each interval.

Calculations

• % New Hires (All To Date) = If([EMPL ADMIN - Num Current Employees]

<> 0; [EMPL ADMIN - Num New Hires]/[EMPL ADMIN - Num Current Employees]; 0)

• % New Hires (Point in Time) = If([EMPL ADMIN - Num (Point in Time)

Employees] <> 0; [EMPL ADMIN - Num (Point in Time) New Hires]/ [EMPL ADMIN - Num (Point in Time) Employees]; 0)

72 SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide

Page 73

Reports

Employee Administration

• % Staff Growth (All To Date) = If([EMPL ADMIN - Num Current

Employees] <> 0; ([EMPL ADMIN - Num New Hires]-[EMPL ADMIN Num T ermina ted Employees])/[EMPL ADMIN - Num Current Employees];

• % Staff Growth (Point in Time) = If([EMPL ADMIN - Num (Point in Time)

Employees] <> 0; ([EMPL ADMIN - Num (Point in Time) New Hires][EMPL ADMIN - Num (Point in Time) Terminated Employees])/[EMPL ADMIN - Num (Point in Time) Employees]; 0)

• % T erminates (All To Date) = If([EMPL ADMIN - Num Current Employees]

<> 0; [EMPL ADMIN - Num Terminated Employees]/[EMPL ADMIN Num Current Employees]; 0)

• % Terminates (Point in Time) = If([EMPL ADMIN - Num (Point in Time)

Employees] <> 0; [EMPL ADMIN - Num (Point in Time) Terminated Employees]/[EMPL ADMIN - Num (Point in Time) Employees]; 0)

• As Of Date = T oDate(Lef t([UR Point In Time Date];Pos([UR Point In Time

Date]; " ")-1); "MM/dd/yyyy")

• Current Date = CurrentDate()

Report SQL

All report SQL is located in the Rapid Mart installation directory under "\Sample\DML".

Employee 360 Overview

View current Employee administration information (no filter is set on Valid To and Valid From dates). Detailed information is also included for employee actions, organizational assignment changes, and basic pay.

Includes hyperlinks (in the report header) to related reports, including:

• Employee Listing

• Employee Wage History

• Benefits Participation Details

SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide 73

Page 74

Reports

Employee Administration

Employee Details

View employee information as well as detailed information about employee actions and organizational assignment changes.

74 SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide

Page 75

Employee Administration

Compensation

View employee information as well as full history of basic pay changes.

Calculations

• TTL Years of Service = [Years Of Service]

Reports

Report SQL

All report SQL is located in the Rapid Mart installation directory under "\Sample\DML".

SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide 75

Page 76

Reports

Employee Administration

Employee Change History (Valid Between Dates)

View Employee administration information between Valid To and Valid From dates. Detailed information is also included for employee actions, organizational assignment changes, and basic pay.

Employee Details

View employee information as well as detailed information about employee actions and organizational assignment changes.

Compensation

View employee information as well as full history of basic pay changes.

76 SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide

Page 77

Calculations

• TTL Years of Service = [Years Of Service]

Report SQL

All report SQL is located in the Rapid Mart installation directory under "\Sample\DML".

Employee 360 Snapshot (As Of)

View Employee administration information as of the selected date. Detailed information is also included for employee actions, organizational assignment changes, and basic pay.

Employee Details

View employee information as well as detailed information about employee actions and organizational assignment changes.

Reports

Employee Administration

SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide 77

Page 78

Reports

Employee Administration

Compensation

View employee information as well as full history of basic pay changes.

Calculations

TTL Years of Service = [Years Of Service]

Report SQL

All report SQL is located in the Rapid Mart installation directory under "\Sample\DML".

Recommended Table Joins

To analyze Employee Administration data you will need to create joins between the fact and dimension tables as follows:

Fact Table Dimension Table Join Expression

EMPLOYEE_ADMINIS TRATION_FACT

78 SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide

BENEFIT_AREA BENEFIT_AREA.BENFT_AREA_ID =

EMPLOYEE_ADMINISTRATION_FACT. BENFT_AREA_ID

BENEFIT_PLAN EMPLOYEE_ADMINISTRATION_FACT.

BENFT_PLAN_KEY = BENEFIT_PLAN.BENFT_PLAN_KEY

Page 79

Fact Table Dimension Table Join Expression

EMPLOYEE_ADMINIS TRATION_FACT

BENEFIT_PROGRAM_ GROUP

BENEFIT_TERMINATI ON_RULE

BUSINESS_AREA BUSINESS_AREA.BUS_AREA_ID =

CERTIFICATE_TYPE CERTIFICATE_TYPE.CERTIFICATE_TY

COMP ANY_CODE COMP ANY_CODE.CMPNY_CODE_ID =

BENEFIT_PROGRAM_GROUP.BENFT_ AREA_ID = EMPLOYEE_ADMINISTRATION_FACT. BENFT_AREA_ID and BENEFIT_PROGRAM_GROUP.PROGR AM_GRP_ID = EMPLOYEE_ADMINISTRATION_FACT. PROGRAM_GRP_ID_01 and BENEFIT_PROGRAM_GROUP.PROGR AM_CODE = '01'

BENEFIT_TERMINATION_RULE.BENFT _AREA_ID = EMPLOYEE_ADMINISTRATION_FACT. BENFT_AREA_ID AND BENEFIT_TERMINATION_RULE.TERMI NATN_RULE_ID = EMPLOYEE_ADMINISTRATION_FACT. TERMINAT N_RULE_ID

EMPLOYEE_ADMINISTRATION_FACT. BUS_AREA_ID

PE_ID = EMPLOYEE_ADMINISTRATION_FACT. CERTIFICATE_TYPE_ID

EMPLOYEE_ADMINISTRATION_FACT. CMPNY_CODE_ID

Reports

Employee Administration

SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide 79

Page 80

Reports

Employee Administration

Fact Table Dimension Table Join Expression

EMPLOYEE_ADMINIS TRATION_FACT

CONTRIBUTION_RULECONTRIBUTION_RULE.BENFT_AREA_

ID = EMPLOYEE_ADMINISTRATION_FACT. BENFT_AREA_ID and CONTRIBUTION_RULE.BENFT_PLAN_ ID = EMPLOYEE_ADMINISTRATION_FACT. BENFT_PLAN_ID and CONTRIBUTION_RULE.CONTRIBTN_R ULE_ID = EMPLOYEE_ADMINISTRATION_FACT. CONTRIBTN_RULE_ID_EMPLEE and CONTRIBUTION_RULE.CONTRIBTN_C ODE = 'EMPLEE'

CONTRIBUTION_RULECONTRIBUTION_RULE.BENFT_AREA_

ID = EMPLOYEE_ADMINISTRATION_FACT. BENFT_AREA_ID and CONTRIBUTION_RULE.BENFT_PLAN_ ID = EMPLOYEE_ADMINISTRATION_FACT. BENFT_PLAN_ID and CONTRIBUTION_RULE.CONTRIBTN_R ULE_ID= EMPLOYEE_ADMINISTRATION_FACT. CONTRIBTN_RULE_ID_EMPLER and CONTRIBUTION_RULE.CONTRIBTN_C ODE = 'EMPLER'

CONTROLLING_AREA CONTROLLING_AREA.CTRL_AREA_ID

= EMPLOYEE_ADMINISTRATION_FACT. CTRL_AREA_ID

COST_CENTER COST_CENTER.CTRL_AREA_ID =

EMPLOYEE_ADMINISTRATION_FACT. CTRL_AREA_ID AND COST_CENTER.COST_CNTR_ID = EMPLOYEE_ADMINISTRATION_FACT. COST_CNTR_ID

COST_CENTER_HIER _HZ

EMPLOYEE_ADMINISTRATION_FACT. CTRL_AREA_ID=COST_CENTER_HIE R_HZ.CTRL_AREA_ID and EMPLOYEE_ADMINISTRATION_FACT. COST_CNTR_ID=COST_CENTER_HIE R_HZ.COST_CNTR_ID

80 SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide

Page 81

Fact Table Dimension Table Join Expression

EMPLOYEE_ADMINIS TRATION_FACT

COST_CENTER_HIER _VR

COUNTRY_GROUP COUNTRY_GROUP.COUNTRY_GRP_I

CURRENCY CURRENCY.CURR_ID =

EDUCATION_TYPE EDUCATION_TYPE.EDUCATN_TYPE_I

ELIGIBILITY_RULE ELIGIBILITY_RULE.BENFT_AREA_ID =

EMPLOYEE EMPLOYEE.EMPLOYEE_KEY =

EMPLOYEE_GROUP EMPLOYEE_GROUP.EMPLOYEE_GRP

EMPLOYEE_SUBGROUPEMPLOYEE_SUBGROUP.EMPLOYEE_

ETHNIC_ORIGIN ETHNIC_ORIGIN.COUNTRY_GRP_ID =

EMPLOYEE_ADMINISTRATION_FACT. CTRL_AREA_ID=COST_CENTER_HIE R_VR.CTRL_AREA_ID and EMPLOYEE_ADMINISTRATION_FACT. COST_CNTR_ID=COST_CENTER_HIE R_VR.CHILD_ID

D = EMPLOYEE_ADMINISTRATION_FACT. COUNTRY_GRP_ID

EMPLOYEE_ADMINISTRATION_FACT. CURR_ID

D = EMPLOYEE_ADMINISTRATION_FACT. EDUCATN_TYPE_ID

EMPLOYEE_ADMINISTRATION_FACT. BENFT_AREA_ID AND ELIGIBILITY_RULE.ELIGIBLTY_RULE_I D = EMPLOYEE_ADMINISTRATION_FACT. ELIGIBLTY_RULE_ID

EMPLOYEE_ADMINISTRATION_FACT. EMPLOYEE_KEY

_ID = EMPLOYEE_ADMINISTRATION_FACT. EMPLOYEE_GRP_ID

SUBGRP_ID = EMPLOYEE_ADMINISTRATION_FACT. EMPLOYEE_SUBGRP_ID

EMPLOYEE_ADMINISTRATION_FACT. COUNTRY_GRP_ID AND ETHNIC_ORIGIN.ETHNIC_ORIGIN_ID = EMPLOYEE_ADMINISTRATION_FACT. ETHNIC_ORIGIN_ID

Reports

Employee Administration

SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide 81

Page 82

Reports

Employee Administration

Fact Table Dimension Table Join Expression

EMPLOYEE_ADMINIS TRATION_FACT

GENDER GENDER.GENDER_ID =

EMPLOYEE_ADMINISTRATION_FACT. GENDER_ID

IDENTIFICATION_TYPEIDENTIFICATION_TYPE.COUNTRY_GR

P_ID = EMPLOYEE_ADMINISTRATION_FACT. COUNTRY_GRP_ID AND IDENTIFICATION_TYPE.IDENTIFICTN_ TYPE_ID = EMPLOYEE_ADMINISTRATION_FACT.I DENTIFICTN_TYPE_ID

INVESTMENT_GROUP INVESTMENT_GROUP.BENFT_AREA_I

D = EMPLOYEE_ADMINISTRATION_FACT. BENFT_AREA_ID AND INVESTMENT_GROUP.INVESTMNT_G RP_ID = EMPLOYEE_ADMINISTRATION_FACT.I NVESTMNT_GRP_ID

INVESTMENT_PLAN INVESTMENT_PLAN.BENFT_AREA_ID

= EMPLOYEE_ADMINISTRATION_FACT. BENFT_AREA_ID AND INVESTMENT_PLAN.INVESTMNT_PLA N_ID = EMPLOYEE_ADMINISTRATION_FACT.I NVESTMNT_PLAN_ID_01

JOB JOB.JOB_KEY =

EMPLOYEE_ADMINISTRATION_FACT.J OB_KEY

LANGUAGE LANGUAGE.LANG_ID =

EMPLOYEE_ADMINISTRATION_FACT.L ANG_ID

82 SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide

Page 83

Fact Table Dimension Table Join Expression

EMPLOYEE_ADMINIS TRATION_FACT

LINE_MANAGER_HIER LINE_MANAGER_HIER.POSITION_ID =

EMPLOYEE_ADMINISTRATION_FACT. POSITION_ID AND LINE_MANAGER_HIER.PERSON_ID = EMPLOYEE_ADMINISTRATION_FACT. PERSON_ID andLINE_MANAGER_HIER.VALID_FRO M_DATE <= EMPLOYEE_ADMINISTRATION_FACT. VALID_FROM_DATE_POSTN andLINE_MANAGER_HIER.VALID_TO_ DATE >= EMPLOYEE_ADMINISTRATION_FACT. VALID_TO_DATE_POSTN

MARITA L_STATUS EMPLOYEE_ADMINISTRATION_FACT.

MARITAL_STATUS_ID = MARITAL_STATUS.MARITAL_STATUS_I D

MILITARY_STATUS MILITARY_STATUS.COUNTRY_GRP_ID

= EMPLOYEE_ADMINISTRATION_FACT. COUNTRY_GRP_ID AND MILITARY_STATUS.MILITARY_STATUS _ID = EMPLOYEE_ADMINISTRATION_FACT. MILITARY_STATUS_ID

NATIONALITY EMPLOYEE_ADMINISTRATION_FACT.

NATIONALITY_ID = NATIONALITY.NATIONALITY_ID

ORGANIZATION_KEY ORGANIZATION_KEY.ORG_KEY_ID =

EMPLOYEE_ADMINISTRATION_FACT. ORG_KEY_ID

ORGANIZATION_UNIT ORGANIZATION_UNIT.ORG_UNIT_KEY

= EMPLOYEE_ADMINISTRATION_FACT. ORG_UNIT_KEY

ORGANIZATION_UNIT _HIER_HZ

ORGANIZATION_UNIT_HIER_HZ.ORG_ UNIT_KEY = EMPLOYEE_ADMINISTRATION_FACT. ORG_UNIT_KEY

Reports

Employee Administration

SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide 83

Page 84

Reports

Employee Administration

Fact Table Dimension Table Join Expression

EMPLOYEE_ADMINIS TRATION_FACT

ORGANIZATION_UNIT _HIER_VR

PAY_SCALE_AREA PAY_SCALE_AREA.COUNTRY_GRP_I

P AY_SCALE_TYPE PAY_SCALE_TYPE.COUNTRY_GRP_ID

P AYROLL_AREA P AYROLL_AREA.PAYROLL_AREA_ID =

PERSONNEL_ACTION _REASON

PERSONNEL_ACTION _STATUS

PERSONNEL_ACTION _TYPE

EMPLOYEE_ADMINISTRATION_FACT. ORG_UNIT_KEY = ORGANIZATION_UNIT_HIER_VR.CHIL D_KEY

D = EMPLOYEE_ADMINISTRATION_FACT. COUNTRY_GRP_ID AND PAY_SCALE_AREA.PAY_SCALE_AREA _ID = EMPLOYEE_ADMINISTRATION_FACT. P AY_SCALE_AREA_ID

= EMPLOYEE_ADMINISTRATION_FACT. COUNTRY_GRP_ID AND P AY_SCALE_TYPE.PAY_SCALE_TYPE _ID = EMPLOYEE_ADMINISTRATION_FACT. P AY_SCALE_TYPE_ID

EMPLOYEE_ADMINISTRATION_FACT. PAYROLL_AREA_ID

PERSONNEL_ACTION_REASON.ACTI ON_TYPE_ID = EMPLOYEE_ADMINISTRATION_FACT. ACTION_TYPE_ID AND PERSONNEL_ACTION_REASON.ACTI ON_REASON_ID = EMPLOYEE_ADMINISTRATION_FACT. ACTION_REASON_ID

PERSONNEL_ACTION_STATUS.STATU S_CATEG_ID = EMPLOYEE_ADMINISTRATION_FACT. STATUS_CATEG_ID_EMPLMNT AND PERSONNEL_ACTION_STATUS.STATU S_ID = EMPLOYEE_ADMINISTRATION_FACT. STATUS_ID_EMPLMNT

EMPLOYEE_ADMINISTRATION_FACT. ACTION_TYPE_ID = PERSONNEL_ACTION_TYPE.ACTION_ TYPE_ID

84 SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide

Page 85

Fact Table Dimension Table Join Expression

EMPLOYEE_ADMINIS TRATION_FACT

PERSONNEL_ADMINI STRATOR

PERSONNEL_AREA PERSONNEL_AREA.PERSONNEL_AR

PERSONNEL_DATE_T YPE

PERSONNEL_SUBAREAPERSONNEL_SUBAREA.PERSONNEL

PERSONNEL_TASK_S TATUS

PERSONNEL_TASK_T YPE

POSITION POSITION.POSITION_KEY =

POSITION_HIER_HZ EMPLOYEE_ADMINISTRATION_FACT.

POSITION_HIER_VR EMPLOYEE_ADMINISTRATION_FACT.

PERSONNEL_ADMINISTRATOR.ADMI N_GRP_CODE = EMPLOYEE_ADMINISTRATION_FACT. ADMIN_GRP_CODE AND PERSONNEL_ADMINISTRATOR.ADMI N_ID = EMPLOYEE_ADMINISTRATION_FACT. ADMIN_ID_HR

EA_ID = EMPLOYEE_ADMINISTRATION_FACT. PERSONNEL_AREA_ID

EMPLOYEE_ADMINISTRATION_FACT. DATE_TYPE_ID_01 = PERSONNEL_DATE_TYPE.DATE_TYP E_ID

_AREA_ID = EMPLOYEE_ADMINISTRATION_FACT. PERSONNEL_AREA_ID AND PERSONNEL_SUBAREA.PERSONNEL _SUBAREA_ID = EMPLOYEE_ADMINISTRATION_FACT. PERSONNEL_SUBAREA_ID

PERSONNEL_TASK_STATUS.TASK_ST ATUS_ID = EMPLOYEE_ADMINISTRATION_FACT. TASK_STATUS_ID

PERSONNEL_TASK_TYPE.TASK_TYP E_ID = EMPLOYEE_ADMINISTRATION_FACT. TASK_TYPE_ID

EMPLOYEE_ADMINISTRATION_FACT. POSITION_KEY

POSITION_ID=POSITION_HIER_HZ.PO SITION_ID

POSITION_ID=POSITION_HIER_VR.CH ILD_ID

Reports

Employee Administration

SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide 85

Page 86

Reports

Employee Administration

Fact Table Dimension Table Join Expression

EMPLOYEE_ADMINIS TRATION_FACT

PROFICIENCY PROFICIENCY.PROFICIENCY_ID =

EMPLOYEE_ADMINISTRATION_FACT. PROFICIENCY_ID

QUALIFICATION QUALIFICATION.QUALIFICTN_ID =

EMPLOYEE_ADMINISTRATION_FACT. QUALIFICTN_ID

RELIGION RELIGION.RELIGION_ID =

EMPLOYEE_ADMINISTRATION_FACT. RELIGION_ID

RESIDENCE_STATUS RESIDENCE_STATUS.COUNTRY_GRP

_ID = EMPLOYEE_ADMINISTRATION_FACT. COUNTRY_GRP_ID AND RESIDENCE_STATUS.RESIDENCE_ST ATUS_ID = EMPLOYEE_ADMINISTRATION_FACT. RESIDENCE_STATUS_ID

SALARY_RANGE SALARY_RANGE.SALARY_RANGE_KE

Y = EMPLOYEE_ADMINISTRATION_FACT. SALARY_RANGE_KEY

SCHOOL_TYPE SCHOOL_TYPE.SCHOOL_TYPE_ID =

EMPLOYEE_ADMINISTRATION_FACT. SCHOOL_TYPE_ID

SERVICE_INTERVAL_HREMPLOYEE_ADMINISTRATION_FACT.

SERVICE_INTERVAL_ID=SERVICE_IN TERVAL_HR.SERVICE_INTERVAL_ID

STUDY_BRANCH STUDY_BRANCH.STUDY_BRANCH_ID

= EMPLOYEE_ADMINISTRATION_FACT. STUDY_BRANCH_ID

TIME_DIM EMPLOYEE_ADMINISTRATION_FACT.

ORIGINAL_HIRE_DATE = TIME_DIM.CALENDAR_DATE

TIME_MANAGEMENT_ ST ATUS

UNIT_OF_TIME UNIT_OF_TIME.UOT_ID =

TIME_MANAGEMENT_STATUS.TIME_ MGMT_STATUS_ID = EMPLOYEE_ADMINISTRATION_FACT. TIME_MGMT_STATUS_ID

EMPLOYEE_ADMINISTRATION_FACT. UOT_ID_01

86 SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide

Page 87

Fact Table Dimension Table Join Expression

EMPLOYEE_ADMINIS TRATION_FACT

VESTING_RULE VESTING_RULE.BENFT_AREA_ID =

EMPLOYEE_ADMINISTRATION_FACT. BENFT_AREA_ID AND VESTING_RULE.VESTNG_RULE_ID = EMPLOYEE_ADMINISTRATION_FACT. VESTNG_RULE_ID

WAGE_TYPE EMPLOYEE_ADMINISTRATION_FACT.

WAGE_TYPE_KEY_01 = WAGE_TYPE.WAGE_TYPE_KEY

WORK_CONTRACT WORK_CONTRACT.COUNTRY_GRP_I

D = EMPLOYEE_ADMINISTRATION_FACT. COUNTRY_GRP_ID AND WORK_CONTRACT.CONTRACT_ID = EMPLOYEE_ADMINISTRATION_FACT. CONTRACT_ID

WORK_CONTRACT_T YPE

WORK_PERMIT_TYPE WORK_PERMIT_TYPE.COUNTRY_GR

WORK_CONTRACT_TYPE.CONTRACT _TYPE_ID = EMPLOYEE_ADMINISTRATION_FACT. CONTRACT_TYPE_ID

P_ID = EMPLOYEE_ADMINISTRATION_FACT. COUNTRY_GRP_ID AND WORK_PERMIT_TYPE.WORK_PERMIT _TYPE_ID = EMPLOYEE_ADMINISTRATION_FACT. WORK_PERMIT_TYPE_ID

Reports

Leave Entitlement

The leave entitlement subject area of this Rapid Mart allows you to analyze information about employee absences, such as vacations, sick leave, jury duty, maternity leave, etc.

Reports

Leave entitlement allows for a variety of detail, trend, and high level analysis. Below is a list of the reports included here for analysis:

• Leave Entitlement Listing

• Leave Entitlement Details

SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide 87

Page 88

Reports

Leave Entitlement

Leave Entitlement Listing

View listing of employee leave entitlement for the selected Company Code, Leave Year, As Of Date, and Personnel Area.

Report SQL

All report SQL is located in the Rapid Mart installation directory under "\Sample\DML".

Leave Entitlement Details

View employee leave entitlement details selected Employee, Company Code, Leave Year, As Of Date, and Personnel Area. Displays similar details as found in SAP Transaction PA20.

88 SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide

Page 89

Calculations

• SSN = Left([Identification Num];3)+" - "+Substr([Identification Num];4;2)+"

- "+Right([Identification Num];4)

Report SQL

All report SQL is located in the Rapid Mart installation directory under "\Sample\DML".

Recommended Table Joins

To analyze Leave Entitlement data you will need to create joins between the fact and dimension tables as follows:

Fact Table Dimension Table Join Expression

LEAVE_ENTITLEMENT _FACT

BUSINESS_AREA BUSINESS_AREA.BUS_AREA_ID =

LEAVE_ENTITLEMENT_FACT.BUS_AR EA_ID

COMP ANY_CODE COMP ANY_CODE.CMPNY_CODE_ID =

LEAVE_ENTITLEMENT_FACT.CMPNY_ CODE_ID

CONTROLLING_AREA CONTROLLING_AREA.CTRL_AREA_ID

= LEAVE_ENTITLEMENT_FACT.CTRL_A REA_ID

COST_CENTER COST_CENTER.CTRL_AREA_ID =

LEAVE_ENTITLEMENT_FACT.CTRL_A REA_ID AND COST_CENTER.COST_CNTR_ID = LEAVE_ENTITLEMENT_FACT.COST_C NTR_ID

COST_CENTER_HIER _HZ

COST_CENTER_HIER _VR

LEAVE_ENTITLEMENT_FACT.CTRL_A REA_ID=COST_CENTER_HIER_HZ.CT RL_AREA_ID and LEAVE_ENTITLEMENT_FACT.COST_C NTR_ID=COST_CENTER_HIER_HZ.CO ST_CNTR_ID

LEAVE_ENTITLEMENT_FACT.CTRL_A REA_ID=COST_CENTER_HIER_VR.CT RL_AREA_ID and LEAVE_ENTITLEMENT_FACT.COST_C NTR_ID=COST_CENTER_HIER_VR.CH ILD_ID

Reports

Leave Entitlement

SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide 89

Page 90

Reports

Leave Entitlement

Fact Table Dimension Table Join Expression

LEA V E_ENTITLEMENT _FACT

COUNTRY_GROUP COUNTRY_GROUP.COUNTRY_GRP_I

D = LEAVE_ENTITLEMENT_FACT.COUNTR Y_GRP_ID

EMPLOYEE EMPLOYEE.EMPLOYEE_KEY =

LEAVE_ENTITLEMENT_FACT.EMPLOY EE_KEY

EMPLOYEE_GROUP EMPLOYEE_GROUP.EMPLOYEE_GRP

_ID = LEAVE_ENTITLEMENT_FACT.EMPLOY EE_GRP_ID

EMPLOYEE_SUBGROUPEMPLOYEE_SUBGROUP.EMPLOYEE_

SUBGRP_ID = LEAVE_ENTITLEMENT_FACT.EMPLOY EE_SUBGRP_ID

JOB JOB.JOB_KEY =

LEAVE_ENTITLEMENT_FACT.JOB_KE Y

LEAVE_TYPE LEAVE_TYPE.LEAVE_TYPE_KEY =

LEAVE_ENTITLEMENT_FACT.LEAVE_T YPE_KEY

LINE_MANAGER_HIER LINE_MANAGER_HIER.POSITION_ID =

LEAVE_ENTITLEMENT_FACT.POSITIO N_ID AND LINE_MANAGER_HIER.PERSON_ID = LEAVE_ENTITLEMENT_FACT.PERSON _ID andLINE_MANAGER_HIER.VALID_FRO M_DATE <= LEAVE_ENTITLEMENT_FACT. VALID_FROM_DATE_POSTN andLINE_MANAGER_HIER.VALID_TO_ DA TE >= LEAVE_ENTITLEMENT_FACT. VALID_TO_DATE_POSTN

ORGANIZATION_KEY ORGANIZATION_KEY.ORG_KEY_ID =

LEAVE_ENTITLEMENT_FACT.ORG_KE Y_ID

ORGANIZATION_UNIT ORGANIZATION_UNIT.ORG_UNIT_KEY

= LEAVE_ENTITLEMENT_FACT.ORG_UN IT_KEY

90 SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide

Page 91

Fact Table Dimension Table Join Expression

LEAVE_ENTITLEMENT _FACT

ORGANIZATION_UNIT _HIER_HZ

ORGANIZATION_UNIT _HIER_VR

P AYROLL_AREA P AYROLL_AREA.PAYROLL_AREA_ID =

PERSONNEL_ADMINI STRATOR

PERSONNEL_AREA PERSONNEL_AREA.PERSONNEL_AR

PERSONNEL_SUBAREAPERSONNEL_SUBAREA.PERSONNEL

POSITION POSITION.POSITION_KEY =

POSITION_HIER_HZ LEAVE_ENTITLEMENT_FACT.POSITIO

ORGANIZATION_UNIT_HIER_HZ.ORG_ UNIT_KEY = LEAVE_ENTITLEMENT_FACT.ORG_UN IT_KEY

LEAVE_ENTITLEMENT_FACT.ORG_UN IT_KEY = ORGANIZATION_UNIT_HIER_VR.CHIL D_KEY

LEAVE_ENTITLEMENT_FACT.PAYROL L_AREA_ID

PERSONNEL_ADMINISTRATOR.ADMI N_GRP_CODE = LEAVE_ENTITLEMENT_FACT.ADMIN_ GRP_CODE AND PERSONNEL_ADMINISTRATOR.ADMI N_ID = LEAVE_ENTITLEMENT_FACT.ADMIN_I D_HR

EA_ID = LEAVE_ENTITLEMENT_FACT.PERSON NEL_AREA_ID

_AREA_ID = LEAVE_ENTITLEMENT_FACT.PERSON NEL_AREA_ID AND PERSONNEL_SUBAREA.PERSONNEL _SUBAREA_ID = LEAVE_ENTITLEMENT_FACT.PERSON NEL_SUBAREA_ID

LEAVE_ENTITLEMENT_FACT.POSITIO N_KEY

N_ID=POSITION_HIER_HZ.POSITION_I D

Reports

Leave Entitlement

SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide 91

Page 92

Reports

Benefit Enrollment

Fact Table Dimension Table Join Expression

LEA V E_ENTITLEMENT _FACT

POSITION_HIER_VR LEAVE_ENTITLEMENT_FACT.POSITIO

N_ID=POSITION_HIER_VR.CHILD_ID

WORK_CONTRACT WORK_CONTRACT.COUNTRY_GRP_I

D = LEAVE_ENTITLEMENT_FACT.COUNTR Y_GRP_ID AND WORK_CONTRACT.CONTRACT_ID = LEAVE_ENTITLEMENT_FACT.CONTRA CT_ID

Benefit Enrollment

With the benefit enrollment section of this Rapid Mart, you can analyze information about employee enrollment and usage of company benefits.

Reports

Benefit enrollment allows for a variety of detail, trend, and high level analysis. Below is a list of the reports included here for analysis:

• Benefits Participation

• Benefits Participation Details

• Benefit Enrollment Analysis

Benefits Participation

View employee benefits participation cost s/coverage summary and employee listing for the selected Benefit Area and time period. Replicates similar functionality to Human Resources Benefits Participation report HRBEN0072.

92 SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide

Page 93

Benefit Enrollment

Costs & Coverage Summary

View breakdown of costs and coverage amounts by benefit plan.

Reports

SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide 93

Page 94

Reports

Benefit Enrollment

Listing

View benefits employee participation listing by Benefit Plan Type.

Calculations

• Employee Participation Date = If(FormatDate([Participation Date]; "MM/

dd/yyyy") = [Null Date T ext]; " "; FormatDate([Particip ation Date]; "MM/dd/ yyyy"))

• Employee Valid From Date =If(FormatDate([Valid From Date - PK]; "MM/

dd/yyyy") = [Null Date Text]; " "; FormatDate([Valid From Date - PK]; "MM/ dd/yyyy"))

• Employee Valid To Date = If(FormatDate([Valid To Date - PK]; "MM/dd/

yyyy") = [Null Date Text]; " "; FormatDate([Valid To Date - PK]; "MM/dd/ yyyy"))

• Forever Date Text = "12/31/9999"

• Null Date Text = "01/01/1900"

Report SQL

All report SQL is located in the Rapid Mart installation directory under "\Sample\DML".

Benefits Participation Details

View employee benefit plan details for the selected Person Id, Period Start, and Period End date. Employee dependent master data is also shown (although not linked to the benefit plans).

94 SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide

Page 95

Reports

Benefit Enrollment

Participation

View employee info, employee dependents, and in which benefit plans the employee participates (current and previous).

SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide 95

Page 96

Reports

Benefit Enrollment

Costs and Coverage Summary

View employee’s benefit plan cost and coverage summary. In particular see detailed employee, employer, and provider costs; as well as, view employee insurance coverage amounts.

Calculations

• Current Benefit = "Current Benefit Plan"

• Employee Participation Date = If(FormatDate([Participation Date]; "MM/

dd/yyyy") = [Null Date T ext]; " "; FormatDate([Particip ation Date]; "MM/dd/ yyyy"))

• Employee Valid From Date = If(FormatDate([Valid From Date - PK]; "MM/

dd/yyyy") = [Null Date Text]; " "; FormatDate([Valid From Date - PK]; "MM/ dd/yyyy"))

• Employee Valid To Date = If(FormatDate([Valid To Date - PK]; "MM/dd/

yyyy") = [Null Date Text]; " "; FormatDate([Valid To Date - PK]; "MM/dd/ yyyy"))

• Empty String =""

• Forever Date Text = "12/31/9999"

• Null Date Text = "1/1/1900"

• Previous Benefit = "Previous Benefit Plans"

96 SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide

Page 97

Report SQL

All report SQL is located in the Rapid Mart installation directory under "\Sample\DML".

Benefit Enrollment Analysis

View Benefits Summary statistics and trend analysis for the selected Benefit Area and Calendar Year.

Participation

View number of employees and dependents enrolled in each benefit plan.

Reports

Benefit Enrollment

SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide 97

Page 98

Reports

Benefit Enrollment

Costs

View average costs to employees, the employer, and the provider by benefit plan.

98 SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide

Page 99

Benefit Enrollment

Coverages

View average coverage and insurance amounts by benefit plan.

Reports

Report SQL

All report SQL is located in the Rapid Mart installation directory under "\Sample\DML".

Recommended Table Joins

To analyze Benefit Enrollment data you will need to create joins between the fact and dimension tables as follows:

Fact Table Dimension Table Join Expression

BENEFIT_ENROLL_SU MMARY_FACT

SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide 99

BENEFIT_AREA BENEFIT_AREA.BENFT_AREA_ID =

BENEFIT_ENROLL_SUMMARY_FACT.B ENFT_AREA_ID

BENEFIT_PLAN BENEFIT_ENROLL_SUMMARY_FACT.B

ENFT_PLAN_KEY = BENEFIT_PLAN.BENFT_PLAN_KEY

Page 100

Reports

Benefit Enrollment

Fact Table Dimension Table Join Expression

BENEFIT_ENROLL_SU MMARY_FACT

BENEFIT_PROGRAM_ GROUP

BENEFIT_TERMINATI ON_RULE

COMP ANY_CODE COMP ANY_CODE.CMPNY_CODE_ID =

CONTROLLING_AREA CONTROLLING_AREA.CTRL_AREA_ID

COST_CENTER COST_CENTER.CTRL_AREA_ID =

BENEFIT_PROGRAM_GROUP.BENFT_ AREA_ID = BENEFIT_ENROLL_SUMMARY_FACT.B ENFT_AREA_ID and BENEFIT_PROGRAM_GROUP.PROGR AM_GRP_ID = BENEFIT_ENROLL_SUMMARY_FACT.P ROGRAM_GRP_ID_01 and BENEFIT_PROGRAM_GROUP.PROGR AM_CODE = '01'

BENEFIT_TERMINATION_RULE.BENFT _AREA_ID = BENEFIT_ENROLL_SUMMARY_FACT.B ENFT_AREA_ID AND BENEFIT_TERMINATION_RULE.TERMI NATN_RULE_ID = BENEFIT_ENROLL_SUMMARY_FACT.T ERMINATN_RULE_ID

BENEFIT_ENROLL_SUMMARY_FACT. CMPNY_CODE_ID

= BENEFIT_ENROLL_SUMMARY_FACT. CTRL_AREA_ID

BENEFIT_ENROLL_SUMMARY_FACT. CTRL_AREA_ID AND COST_CENTER.COST_CNTR_ID = BENEFIT_ENROLL_SUMMARY_FACT. COST_CNTR_ID

100 SAP BusinessObjects HR Rapid Mart XI 3.2 for SAP solutions User Guide

Business objects HR RAPID MART XI 3.2 FOR SAP SOLUTIONS 12.2.0.0 User Manual

Specifications and Main Features

Frequently Asked Questions

User Manual

Contents

Introduction

What is a Rapid Mart?

Rapid Marts packages accelerate Time to Value

SAP BusinessObjects Rapid Marts packages architecture

About this document

Overview

Overview

What you can do with this Rapid Mart

Supported analyses

Related Rapid Marts

Dimensions available to support these analyses

Components shared with other SAP BusinessObjects Rapid Marts

Schema

Subject Areas

Overview

Infotypes Section

SAP solutions processing

Rapid Mart processing

Measures

Rapid Mart data

Employee Administration Section

SAP solutions processing

Rapid Mart processing

Fact table Fields

Rapid Mart data

Organization Hierarchies Section

SAP solutions processing

Rapid Mart processing

Relationship to other sections

Rapid Mart data

Organization Unit Hierarchy

Position Hierarchy

Leave Entitlement Section

SAP solutions processing

Rapid Mart processing

Fact table Fields

Rapid Mart data

Benefit Enrollment Section

SAP solutions processing

Rapid Mart processing

Fact table Fields

Rapid Mart data

Employee Wage Section

SAP solutions processing

Rapid Mart processing

Fact Table Fields

Rapid Mart data

Payroll Section

SAP solutions processing

Rapid Mart processing

Fact Table Fields

Rapid Mart data

Reports

Reports

Overview

Employee Administration

Employee Listing

Company Employee Analysis

Employee 360 Overview

Employee Change History (Valid Between Dates)

Employee 360 Snapshot (As Of)

Recommended Table Joins

Reports

Leave Entitlement

Leave Entitlement Listing

Leave Entitlement Details

Recommended Table Joins

Reports

Benefit Enrollment

Benefits Participation

Benefits Participation Details

Benefit Enrollment Analysis

Recommended Table Joins