350 likes | 362 Views
Web-Based Paperless Reporting. Presented By Mary Madill Walt Disney Pictures & TV & Danny Chen C Logic, Inc. Walt Disney Pictures & TV. Motion Pictures US & World Home Video US & World TV-Network, Foreign, Disney Channel Locations: Burbank, New York, London, Hong Kong
E N D
Web-Based Paperless Reporting Presented By Mary Madill Walt Disney Pictures & TV & Danny Chen C Logic, Inc.
Walt Disney Pictures & TV • Motion Pictures US & World • Home Video US & World • TV-Network, Foreign, Disney Channel • Locations: • Burbank, New York, London, Hong Kong • 300+ Business Units • 400+ Users • 20+ Locations GL - October, 1998 AR - June, 1999 PC - October, 2000
Where We Were 160 standard printed reports Mainframe Report distribution • High Speed Printer • Copy Machine • Overnight Deliver (2-3 days at monthend) • Microfiche for Archived Reports Chopped down too many trees!
Where We Were 5 years ago • Build a Data Warehouse • Basic Query & Downloading to Excel • Classes in Excel – Basic - Formula Advanced MS Query • One on One User Training Still Wouldn’t Give Up Reports
First Week of ParallelUsers agree not to print reports I GIVE UP!
Current Report Volume • 50+ Batch Reports • 100+ Online Queries and Drill Down • Weekly Reports - 50,000+ Pages. • Monthly Reports – 100,000+ Pages • Single Report Up to 30,000+ Pages • Reports Distribute to 400+ Users • Database Size - 100G+ • PS_LEDGER - 26.6 M+ Rows • PS_JRNL_LN - 40.0 M+ Rows
Requirement From Users • Reports Available Online Anytime • Find and Print the Page you Need • Print to Local or Network Printers • Run Reports with Specified Parameters • Retrieve 5 Years Archived Reports Online • Create Archived Report CD • Provide Online Drilldown Function • Reports can be available even if PeopleSoft is Down
Requirement From IT What IT Wants: Don't spend our time writing reports Don’t spend IT resources writing reports!
Requirement From IT What IT Wants • Avoid Users’ runaway queries • Web Based - No Client Maintenance • Flexible Security Mechanism • Open Architecture • Take Care All Company Reports • Easy to Configure and Maintain
Solution: Information Delivery SystemCS LinkfromC Logic, Inc. • Adapt CS-Link From C Logic, Inc. • Web Based Report Delivery System • 3 tier Architecture • Plug and Play • Real Time • Works with heterogeneous environment • Works with existing programs • www.c-logic.com
Solution: Information Delivery SystemCS LinkfromC Logic, Inc. • SYSTEM ARCHITECTURE • PeopleSoft 7.5 • DEC UNIX • Oracle 8.04 • NT/IIS 4.0 • MS SQL 6.5 • CS Link 2.3 • MS IE • Netscape • Others
Solution: Information Delivery SystemCS LinkfromC Logic, Inc. CS Link - Key Features • Plug-and-Play • Online Drilldown Reports • Security at BU, Dept level • View and Print Report on User’s PC • Reports Distribution • Launch SQR Reports from Web • Upload User’s Local Reports • Archive Mechanism • User Submits Requests Online
The JIFF Journey Into Financial Future Main Menu Training Info. News Customized CS Link
JIFFJourney Into Financial Future • On Line Query - Running predefined queries and drilling down to the detail • Run Reports - Submit a request to run a standard batch report from a set list • View Reports - View your standard scheduled and ad hoc reports • On Line Help - On Line User Guide • Contact Us – Submit comment or request
Launch SQR Reports from the Web using CS Link Controlled by Menu Security To Run a Report: 1. Select Run Reports 2. Menu is customized based on user’s SECURITY 3. Select the report you wish to run
Launch SQR Reports from the Web using CS Link 4. Specify Report Parameters Average Run Time User’s security dictates which business units he/she is allowed to run.
Launch SQR Reports from the Web using CS Link 5. Specify Distribution List CS Link Server E-Mail Network Printers 6. Schedule Run Time Once submitted, CS Link will run the report on PeopleSoft server and route the report back to the CS Link server
Launch Reports from the Process Scheduler and Send Back to JIFF 2. PeopleSoft Process Scheduler processes request • 1. User submits • report from • PeopleSoft • panel 3. Upon completion, reports are sent back to CS Link server
View Report From CS Link Server Display Parameters Click View Reports to display report list • Distribute Report • View Log • Delete report Reports will be converted into html, txt, RTF or zipped RTF formats automatically
View Report From CS Link Server Reports can be viewed in various formats such as html, txt Download reports to MS Word and print on your local printer Page level security - Based on their profile, different users view different sections of the same report
Online Drilldown Reports via CS Link User launches an on-line program Drilldown to a different ERP system LINKS may include non-PeopleSoft ERP.
Menu Security using CS Link • In sync with PeopleSoft Security • Users’ Menu Security Assign Reports to Operators or Classes How admin configures What user gets
Report Run Parameter Security • Input Parameter Security By limiting the user’s available parameter options, the reports generated will only reflect what the user is allowed to run. Set up BU security manually or copy from PeopleSoft
CS Link Report Page-Level Security • Based upon their defined security profile, two recipients of the same report will only be allowed to see the data that is pertinent to them. How admin configures What users are allowed to see
CS LinkReport Distribution Key Features • Distribute Reports via • E-Mail • CS Link In-box • Network Printer • Flexible Report Format Conversion • Report Compression • Ability to Distribute Subsets of Report • Apply Page Level Security • Report Upload from Client to Server • nVision Report Distribution
CS LinkReport Distribution Page Range CS LINK user in-box E-Mail Addresses Network Printers
Upload Reports from Client Side • Users can upload their local document to server and distribute to other users Upload a local File View/distribute uploaded file
nVision Reports Distribution Search nVision Reports by BU Year & Period View nVision Online
Archiving and Backup • Standard Reports kept online for 400 days • Move to Archived Directory for 5 Years • Quarterly, master copies of reports to CDs • Cheaper to spend $5,000 on 30G disc than cut custom CDs for 20 business units
Produce CD ROM Archival • Power user select day range to run archival program • Archival program produces CD image with the user security applied.
View Archived Reports From CD Open Web based index page in the CD
Benefits • Find the needed information faster -drilldown • Print only the required information • No waiting for reports in the mail • Easy training for new employees • Reports not misplaced • Increased Security • Less File Room and Binder Shelf Space • Training Schedule Available on line • Online request for new chartfields
Conclusion • Web Based reporting is Strategic • More timely • Easier to control • Less training • Less IT resources • Users, IT and Trees are Happy