2014 user group meeting - maumee bay lodge and convention center
TRANSCRIPT
2014 User Group Meeting - Maumee Bay Lodge and Convention Center
Web Reporting Update
Presented by:Clif Vaughan
Web Reporting Update
PerformanceApplication SecurityActive Directory IntegrationDeployment ProcessSupplier Information Portal
Web Reporting – Performance
Goal: Deliver existing functionality fasterRetain existing report criteriaUnbounded date ranges are challengingLet 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, 0102MySQL tables: Extract_Purchase_Shipments, Extract_Sales_Shipments, Extract_Combined_Freight, Supplier_Master, Customer_Master, etc.
Web Reporting– Business Logic
File AccessAdded index to 8685 Inventory Analysis Extract
Reduced program count Scoreboard from 29 to 11 programs
Streamline Code PathRefactor for MySQL and mixed MySQL/ISAM
Trader Code logicStandardized on the trader at the time of the transaction
Web Reporting–Robustness
Query LimitsNo single query can monopolize the server
Browser Display LimitsStop as soon as possible if there is too much data for the browser to display
Data ChunkingAllows 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 securityBest Practice - Utilize Application Security RolesWeb Release Notes
Requires All BranchesAllows HQ branchAllows Non Trade BranchesLinks between web reports
Web Reporting - Application Security
Eliminated “All Branches” requirementValidates that only authorized branch data is shown
Financial StatementsGL Analysis
Optional “All Branches” requirementFilters branch selection to authorized branchesSplit orders may contain branch data not in authorized branches
Order ManagementBrokerage Order Management
Web Reporting – Active Directory
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 IntegrationApplication Security IntegrationActive Directory Integration for Internal SIPExport to ExcelHosting 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 EfficiencyMulti-TenantReduction of Tomcat JVM Instances
Web Reporting Update
Questions?