Skip to Content
Author's profile photo Daniel McCollum

Meter Reading Process Performance in IS-U

This post is a framework to contain my experience in attempting to leverage higher performance in BAU tasks under a rapidly increasing data load.

In my environment, we are entering a phase of increased data granularity. Leveraging the ability to receive & process interval data from meter service providers.

Legacy business processes capable of supporting the low impact requirements for Monthly invoices from register readings have grown to the point were we are on the cusp of invoicing customers on Half Hour data.

During this step change in data granularity we are noticing what worked before is insufficient going forward. I intend to document my findings from a functional perspective with a minor focus on the technical aspects underpinning reading a quarter of a million records a month, to tens of millions of records per day.

IS-U-DM-MR

Meter Reading Upload

Production runtime in seconds

  • 16000

EXADATA runtime in seconds

  • 6000

HANA runtime in seconds

IS-U-BI

Billing & Invoicing

Production Runtime in seconds

  • Billing 2300
  • Invoicing 650
  • Print 5600

EXADATA runtime in seconds

  • Billing 800
  • Invoicing 380
  • Print 1700

HANA runtime in seconds

Assigned Tags

      2 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Astrid Gambill
      Astrid Gambill

      Hi Daniel

      I look forward to the updates for this blog as you go through the process.

      We are still reading bi-monthly and AMI is still a few years down the road, so we'll have to go through something similar.

      Are you planning on using the SAP MDM tool?

      Thanks

      Astrid

      Author's profile photo Former Member
      Former Member

      Looking for more in this....Thank a ton.