Utilities challenges and opportunities are heavily dependent on data accessibility:

SAP Analytics and reporting challenges:
  1. Very complex transactional oriented data structure.
  2. Hundreds of normalized tables with complex relationships.
  3. Need to join many tables on-line for each report.
  4. Submitting report is time and resources consuming.
  5. Rigid system (Performance limitations, Security rules).
  6. No built in flexible tool to “play” with the data (“Sandbox” concept).
  7. Complex programming environment (ABAP) – Not suitable for analysts.
  8. Very long and expensive “Time-to-Market” for reports and analytics.
  9. Most users are not able to analyze the raw data using SE16N transaction but are limited to predefined set of SAP transactions which usually shows one object at a time.
  10. BW/BO tools are not sufficient for real-life analytical needs. Every report has to be downloaded for additional manual and costly Excel manipulations.
  11. SAP is not a self-service BI environment.

SAP/ISU objects are complex to understand and has complex structure of inter-relationships:

SAP/ISU Objects

SAP/ISU contains hundreds of tables with peculiar names:

SAP/ISU Tables


SIGMA Approach:
The Concept:
  1. Identify relevant SAP R/3 tables/fields and extract them completely on a daily basis into the target environment.
  2. Solve and “denormalize” all complex SAP relationships within the target environment.
  3. Build “SIGMA Business Data Models” aimed for end-users and business analysts,
  4. Automate the process and tune for performance excellence .
  5. Deploy a sandbox GUI tool that allow end-users to: Explore, Visualize, Manipulate, OLAP, Report, Chart, Model, Simulate, Import, Export and more…
The Benefits:
  1. Single point, single version of the truth of business data easily accessible by every analyst.
  2. An outside Sandbox solution that allow end-users to easily exploit the transactional data hidden in SAP with no limitations and with maximum flexibility.
  3. Quick “out-of-the box” deployment and implementation.
  4. Minimal support is needed. Reports and analytics are completely done by end-users.
  5. Gives the power of mastering the data in the hands of those who needs it, rather than in the expensive hands of SAP/ABAP programmers.

More resources:

Learn how Sigma for Utilities has been implemented in Israel Electric Company …

Learn about Sigma Data Models concept …

Explore Sigma libraries of ISU and CRM Data Models …

Learn about Big Data implementation options …

Learn about analytical tools options …

Learn about the professional SandBox solution Sigma/Studio …

Want to learn More ?
Please send us your contact details and we will be happy to discuss with you how Sigma for Utilities can be implemented at your company. POC can also be discussed.