1 / 32

CPC - SPE - SQS Service Quality System An oversized OLAP tool

CPC - SPE - SQS Service Quality System An oversized OLAP tool. SPE BI: Providing the right info to the right person at the right time in the right format. A bit of history. Outdated mainframe ETL and DI. Signature Capture Web Site. Tech Web. SPE Web Site. CURSORS.

dermot
Download Presentation

CPC - SPE - SQS Service Quality System An oversized OLAP tool

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. CPC - SPE - SQSService Quality SystemAn oversized OLAP tool SPE BI: Providing the right info to the right person at the right time in the right format.

  2. A bit of history Outdated mainframe ETL and DI

  3. Signature Capture Web Site Tech Web SPE Web Site CURSORS Actual Output Systems

  4. Current state Data Sources .txt files Outputs Service UNEX IBM Standards SPE SPE Website Website R Roll up Tables Std/Adhoc Std/Adhoc R SPE/CQM Field Reports Reports Reporting, & Diagnostics EST R U PDT PDT All products & services S SAS R E Reports Reports Programs R EM SQS SQS Mainframe SAS D production ROSS Databases System Signature Signature D Web Web AMS D Tech Web Tech Web D = Data SPE PDT ’ s R = Formatted Reports

  5. IPC/UNEX International U S E R EM ROSS EST Data Mart New BI System Integrated Web Site OLAP, EG Analysis & diagnostics RI/IBM Lettermail Admail Future state

  6. SPE BI tools: Enterprise Guide

  7. SPE BI tools: Web OLAP

  8. SPE BI tools: SPE SQS

  9. Welcome Page Menu Reports Sub reports SQS: a 4 layer approach

  10. Export to Excel Step 1 To Export to Excel Left click on any left title for options. Select: Export table data to Excel. Export to excel Step 2 Click OK

  11. To Print : 1 : select- File 2 : select- print Will open the current report formatted in PDF & you can print this report to your default printer

  12. Q & A’s

More Related