Several EMI reports going offline for a few weeks

  • 256 Views
  • Last post 2 weeks ago
Phil Bishop posted this 12 April 2022

On 20 April 2022 the EMI reports listed below will go offline. Some will be offline for a matter of days while others will potentially be off for some weeks.

We have been transitioning our data platform from SQL Server databases to a Databricks-based Delta Lakehouse over the past several months. Consequently, all of the procedures used to drive the EMI reports have had to be rebuilt and pointed at the Delta Lakehouse. After Easter we are finally going to pull the plug on the SQL Server machine. This means that the last few EMI reports that have yet to be rebuilt will go offline.

In the coming weeks, we will be working to get them back up and operating. Some may even be switched over before the SQL Server machine is decommissioned. First to be restored from the list below are the two win-back reports in the Retail section.

We can prioritise the order of the rest based on demand so if there are reports in the list below that you want to see sooner rather than later, please let us know by posting below.

Wholesale

  • Wholesale price map
  • Business demand trends (also listed in Retail)
  • Vertical integration trends
  • Binding constraints -  binding constraints are available now as a dataset

Forward markets

  • Bid-ask spread trends
  • Market depth (this report hasn't been updating for some time but will restored in the future) 
  • Implied spot price (this report hasn't been updating for some time but will restored in the future)

Dual listed in both Forward markets and Wholesale

  • Location factor map
  • Location factor calculator
  • Physical wholesale position

Retail

  • Consumption data request trends
  • Residential consumption (map and chart)
  • Residential consumption league table
  • Consumer choice
  • Market concentration league table
  • Residential savings league table
  • Business demand trends
  • Consumer choice league table
  • Entry and exit
  • Residential consumption trends
  • Win-back indicator summary
  • Win-back indicator trends

 

Order by: Standard | Newest | Votes
Guy Ross posted this 2 weeks ago

It's on hold at the moment. That dataset involves drilling down to a lower, less reported, level (individual components of ICP metering installations) that we haven't migrated yet, but you're not the first to request this, so we'll see if we can bump it up the list a bit.

tomato592 posted this 2 weeks ago

Hi Phil,

I was wondering if the dataset in retail folder is still updating? It's been two months since last update.

Cheers.

Phil Bishop posted this 4 weeks ago

The Residential consumption (map and chart) and Residential consumption league table reports are likely still two or three weeks away. The underlying EIEP1 data is still being wrangled into shape.

Phil

 

daringodber posted this 4 weeks ago

Hi, following on from this post I am searching for the below two tables but they still appear to be offiline (three months after this post?). Any news on when they will be available?

  • Residential consumption (map and chart)
  • Residential consumption league table