SAP Analytics Cloud

Data Backup and Recovery Cockpit

Client Profile

Industry: Audience Measurement and Data Analytics

Company Size: 13,000+ employees globally

Revenue: $3.5 Billion (2022)

Stakeholders

Chief Technology Officer
Interim Chief Financial Officer
Senior FP&A Leadership
Line of Business Leaders

Related Skills

Data Governance
Data Resilience Strategy
Logic Configuration
User Interface Development

Requirements Gathering
Project Management

Business Problem

This firm, using SAP Analytics Cloud, discovered a gap in their data resiliency when a vast majority of their CapEx, OpEx, and Workforce planning data were lost due to user deletion. This brought to light the need for a disaster recovery process for their planning data.

Solution

I developed an easy to use automated solution to replicate planning data using a near-line archive process that backups their planning data each day automatically and retains the record for 30 days. Should the data need to be restored, an administrator can use the custom built cockpit to view the archive data and compare it the records that exist in the planning model. With a few clicks of a button, the data can be restored. The cockpit also facilitates replicating planning data in an ad-hoc manner, allowing for wider use and flexibility.

Impact

Reduced disaster recovery time by 90% (From days to hours)
Improved data accuracy after recovery
Significantly reduced planning rework after recovery
Solution adoption across 75% of our clients among all industries
Considered a new best practice in all SAP Analytics Cloud planning implementations
New product offering as a pre-packaged solution

Page updated

Report abuse