Client Profile
The client is among the top three private banks in Indonesia with more than 1,000 branches across the country and around 14,000 employees.
Client Requirements
- Acquire related SAP HR data into Management Reporting Server using group standard ETL tools
- Provide high-level data view and functionality to review data quality to HR Users
- Enable business users to access their LOB/Segment/Unit/Cost Centre
| Manpower cost analysis |
Overtime |
Tax Report |
| Attrition Scorecard |
Employee Benefits |
Incentive |
| Recruitment Scorecard |
Indonesian Provident Fund |
Executive Summary |
| Employee Profiles |
Pension |
Training |
Solution Overview
- The solution consisted of extraction of data from the enterprise's HR and financial systems coupled with user input through Excel files. The data was validated by users and transformed into an Essbase cube.
- Solution used Hyperion Planning System 9.2.0 (Hyperion Essbase, Planning and Report)
Technology
- Informatica/SAP Connector
- Hyperion Planning System 9.2.0
Pricing Model
Project Duration
Service Excellence. Delivered
- Dashboard (Graphic, Chart, Pie Chart, Table, Spreadsheet etc.)
- Interactive (Drag & Drop, Drill Down, Pivot, Filter)
- Web analysis document (Spreadsheet, Pin board, Horizontal Combo, Vertical Combo etc.)
- Export full fidelity report to MS Office (Excel, Word, Power Point, Outlook) & Adobe
- Direct access import from MS Office (Excel, Word, Power Point, Outlook)
Key Benefits
- Reduced complexity in retrieving data from SAP and matching with other enterprise systems
- Reduction of 14 days in monthly report generation
- Reduction of 8 FTEs