180 likes | 414 Views
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
E N D
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 • Unbounded date ranges are challenging • Let the user know as soon as possible if request is too big
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.
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
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.
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
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
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
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.
Supplier Information Portal Update • Information Center Integration • Application Security Integration • Active Directory Integration for Internal SIP • Export to Excel • Hosting Efficiency
Supplier Information Portal • Information Center Integration
Supplier Information Portal • Application Security Integration
Supplier Information Portal • Active Directory Integration for Internal SIP
Supplier Information Portal • Export to Excel
Supplier Information Portal • Hosting Efficiency • Multi-Tenant • Reduction of Tomcat JVM Instances
Web Reporting Update • Questions?