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.
  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.