Semiconductor manufacturing

Thirty business-critical reporting models kept changeable through an ERP change freeze

Client profile

a global semiconductor company · Finance and factory reporting · Embedded data engineers · SAP HANA and Azure Databricks

Semiconductor · SAP HANA · Databricks

Book a meeting

01 / Inside the engagement

Situation

An enterprise ERP program put the SAP HANA reporting environment under a change freeze. Existing reports would keep running, but no model could change and nothing new could be built at the source. Factory dashboards, finance tracking and downstream Power BI and Power Apps all depended on those models.

Conceptual delivery summary

Before

  1. SAP HANA models
  2. Change freeze
  3. Existing reports still running

After

  1. Critical HANA models
  2. Databricks daily refresh
  3. Changeable reporting

Simplified workflow. The case text describes the contribution, delivery stage and evidence.

Explore the full conceptual diagram
Thirty business-critical reporting models kept changeable through an ERP change freezeBefore: SAP HANA models to Change freeze to Existing reports still running. After: Critical HANA models to Databricks daily refresh to Changeable reporting. BEFORE AFTER SAP HANAmodels Changefreeze Existing reportsstill running Critical HANAmodels Databricksdaily refresh Changeablereporting
Conceptual illustration of the engagement. The delivery stage and measurement scope are described in this case study.

02 / Inside the engagement

What UTIS did

  • Before the freeze, identified the 30 business-critical HANA models out of 50.
  • Enabled them in Databricks with automated daily refresh, and automated a manual inbound-delivery lookup-and-notify workflow along the way.
  • A second UTIS engineer delivered a separate report change ahead of the freeze date, avoiding the change-board delay.

03 / Inside the engagement

Results

  • 30 of 50 models live in Databricks and refreshing daily.
  • The business kept modifying and extending its reporting throughout the freeze instead of waiting a year.

Why it matters to you

A source-system freeze does not have to freeze the business. A refreshed reporting layer with a clear boundary around the models it covers keeps the essential reporting moving while the ERP program runs.

Stack

SAP HANAAzure DatabricksSpotfirePower BIPower Apps

How we measured it: model count and refresh status on the platform.

Meet with UTIS

Discuss a similar project.

Tell us what you need to improve. We’ll discuss the relevant experience, the constraints and a practical next step.

Choose a preferred time

Book a meeting

UTIS will review your preferred time and confirm the meeting by email.