Skip navigation
All Places > All Things PI - Ask, Discuss, Connect > Blog > Author: mziegler


Last year at the User’s Conference closing keynote in our futures section we announced Project Rubik. Rubik was an end-user oriented tool to create reports and models using the PI System and SQL Server BI easily with little configuration. When we finished prototyping and gathering customer feedback we took the time to make sure we were still headed in the right direction and we learned some things. One of those things is that we were building the wrong product so we have cancelled Project Rubik.

Several themes have emerged or intensified since we started working on Rubik. Mobile devices continue to increase in importance and the PI Systems lacks a good reporting experience suited for mobile use. BI and Big Data are evolving and expanding instead of converging. Enterprise reporting use to be just putting the data into a fast and scalable data warehouse engine and perhaps wrapping around an OLAP engine for speed. Reporting and analytics now encompasses a much wider range of diverse data sources and end user experiences. You may have heard about streaming data, unstructured data, map-reduce, No SQL, or Hadoop. While the specifics of each of these may be unclear to you, the importance of them collectively is that we now have technology available to analyze and understand a much wider variety of data sources at a much larger scale than before. It is no longer enough to get only one system’s data into a fast reporting engine.

So what do we do? Surprisingly or not surprisingly we are refocusing our efforts around Microsoft Excel and aligning our strategy there. Excel continues to be the best place to aggregate and analyze diverse data sets from a variety of sources that is universally understandable and universally deployed. One strength of the PI System is that individuals can get value out of the system with very little if any training in a short period of time. This is Microsoft’s message and vision around self-service BI and Excel – empowering individuals to do new things with familiar tools.

Our vision is to release technology built upon the Office App (formerly Agave) model which focuses on bringing PI System data to the entire Excel ecosystem from desktop, to Office 365, to SharePoint, to PowerPivot, to SQL Server and all platforms including desktop, browser, tablet, phone, and cloud. We will bring PI System data into native Excel formats such as tables or OData feeds so that our customers can leverage the unique capabilities of PI and Excel along with data from any other sources they choose that can get into Excel. The new Excel is exciting, it goes everywhere, and is backed up by the power of the cloud.

Effort is already underway and we will share more of our vision this year at vCampus Live. View our announcement from User's Conference 2013.
We are already listening to your feedback and have made improvements to our tag searching capabilities, made search results return faster, and are introducing PI Event Frames to PI DataLink.


PI DataLink 2014

Analyze and build reports using PI Event Frames with the new Event Frame Data functions
  • Display results in event hierarchy format for exploration or comparison format for pareto analysis
  • Add relevant operational data and related attributes directly to the report
  • Search and display events by time range, asset, event frame and asset templates, status, and duration

Search Enhancements
  • Simultaneously search name and description fields with different search filters
  • Filter based on additional tag configuration properties and PI AF attribute properties
  • Improved performance delivering first search hits in under 2 seconds and streaming of additional search results

Create reports and perform event comparisons using Event Relative Time in sampled data functions (coming later)



Signup here!

Filter Blog

By date: By tag: