Back to achievements

Optimization of Reporting Processes

Practice

Data Visualization Process Review

Team

Laboratoires Pierre Fabre is a French pharmaceutical and dermo-cosmetics group.

Technical environment

Unified reporting

across all entity perimeters and territories

Easier controls

and reconciled discrepancies

Reduced times

for loading, consolidation and data delivery

CHALLENGES

Simplify the existing architecture by merging the CORPO and FRANCE reporting cubes.
HFM splits monthly into two cubes :
The CORPO cube contains all group entities for a consolidated France perimeter.
The FRANCE cube covers the France entities on a detailed geographic perimeter.
Degraded performance due to many axes of analysis.
Significant volumetrics that impact the availability of applications.

SOLUTION

Optimize access to reporting data and facilitate complete and detailed perimeter access through a single application.
Streamline master data management by eliminating double handling.
Factually reconcile the France perimeter currently heterogeneous between the CORPO and FRANCE cubes and a source of discrepancies.
Reduce interfaces from and to HFM.
Simplify the technical administration processes.

BENEFITS

Unified reporting across all entity perimeters and territories within a single repository.
Easier controls and reconciled discrepancies.
Clear improvements:
Reduced loading times.
Reduced consolidation times.
Faster data delivery.
Simplified master data management.
Fewer incoming and outgoing interfaces.
Reduced downtime due to faster backup times and no restructuring delays.