1 / 18

Web Reporting Update

Web Reporting Update. Presented by: Clif Vaughan. Web Reporting Update. Performance Application Security Active Directory Integration Deployment Process Supplier Information Portal. Web Reporting – Performance. Goal: Deliver existing functionality faster Retain existing report criteria

amber-lopez
Download Presentation

Web Reporting Update

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. Web Reporting Update Presented by: Clif Vaughan

  2. Web Reporting Update • Performance • Application Security • Active Directory Integration • Deployment Process • Supplier Information Portal

  3. Web Reporting – Performance • Goal: Deliver existing functionality faster • Retain existing report criteria • Unbounded date ranges are challenging • Let the user know as soon as possible if request is too big

  4. Web Reporting – File Elimination • Files: 8383, 8385, 8483, 8485, 1601, 1270, 1370, 0701, 0102 • MySQL tables: Extract_Purchase_Shipments, Extract_Sales_Shipments, Extract_Combined_Freight, Supplier_Master, Customer_Master, etc.

  5. Web Reporting– Business Logic • File Access • Added index to 8685 Inventory Analysis Extract • Reduced program count • Scoreboard from 29 to 11 programs • Streamline Code Path • Refactor for MySQL and mixed MySQL/ISAM • Trader Code logic • Standardized on the trader at the time of the transaction

  6. Web Reporting–Robustness • Query Limits • No single query can monopolize the server • Browser Display Limits • Stop as soon as possible if there is too much data for the browser to display • Data Chunking • Allows very long date ranges by breaking into month long chunks.

  7. Performance – Results • Purchase Analysis • Scoreboard • Margin Analysis • Purchase Profitability • Check Pay History • Commercial Position • Scheduled Position • Freight Analysis • Driver ID • Peddler Analysis • Purchase Ticket Listing • Top 100 • Purchase History • Scale Purchases • Purchases By Day

  8. Web Reporting - Application Security • Review – CRES80 Web and dl4term applications share common security • Best Practice - Utilize Application Security Roles • Web Release Notes • Requires All Branches • Allows HQ branch • Allows Non Trade Branches • Links between web reports

  9. Web Reporting - Application Security • Eliminated “All Branches” requirement • Validates that only authorized branch data is shown • Financial Statements • GL Analysis • Optional “All Branches” requirement • Filters branch selection to authorized branches • Split orders may contain branch data not in authorized branches • Order Management • Brokerage Order Management

  10. Web Reporting – Active Directory

  11. Web Reports - Deployments • Scripted build from Mercurial Source Code Control System. • All programs updated to current versions. • Change Log included in deployment requests. • Web Master INI files updated with each deployment.

  12. Supplier Information Portal Update • Information Center Integration • Application Security Integration • Active Directory Integration for Internal SIP • Export to Excel • Hosting Efficiency

  13. Supplier Information Portal • Information Center Integration

  14. Supplier Information Portal • Application Security Integration

  15. Supplier Information Portal • Active Directory Integration for Internal SIP

  16. Supplier Information Portal • Export to Excel

  17. Supplier Information Portal • Hosting Efficiency • Multi-Tenant • Reduction of Tomcat JVM Instances

  18. Web Reporting Update • Questions?

More Related