120 likes | 240 Vues
Revolutionize Your Lawson Reporting. Using the Dashboard Gear Reporting Toolkits. Dashboard Gear. Founded in 2007 Based in Minneapolis, MN Started selling our products in 2009 Financial Reporting Toolkit HCM Reporting Toolkit Procurement/Supply Chain Toolkit
E N D
Revolutionize Your Lawson Reporting Using the Dashboard Gear Reporting Toolkits
Dashboard Gear • Founded in 2007 • Based in Minneapolis, MN • Started selling our products in 2009 • Financial Reporting Toolkit • HCM Reporting Toolkit • Procurement/Supply Chain Toolkit • Reporting and Data Warehousing Consulting Services • Lawson Product Partner As Of Jan. 2010
3 Layers of a BI Implementation DATA LAYER CONTENT CREATION LAYER DISTRIBUTION LAYER
Dashboard Gear System Overview Reporting and Analytics Server Lawson Server Reporting Database Lawson Database OLAP Cube Relational Data Mart Database Views and Procedures
What are the Reporting Toolkits? A Financial and Human Resources database application which uses your Lawson Data to build and maintain: • A Relational Reporting Database • Star Schema Datamart • Microsoft Analysis Services OLAP Cubes • Manage Common Views against Lawson • Ability to Create a Shared Library of KPI’s
Why is it needed? • Lawson data is undocumented and complex • Many tables to join to get simple reports • At least a half dozen joins to get a basic report. • Organizational hierarchy is difficult • Chart hierarchy is difficult • Difficult to compare across years/periods
Why Continued…… • Account balance data is difficult to obtain • Performance and security concerns of reporting off live production data
Reporting Tools The choice of tools is yours. Reporting and Analysis on the data output have been written using: • Crystal Reports/Business Objects • Microstrategy/Cognos/Qlikview • Microsoft Reporting Services/Performance Point • Lawson Business Intelligence Tools (LBI) • MS Excel / Office • Hyperion
Sample of Measures: • Actual/Budget Period Amounts/Units • Prior Period Amounts/Units • Period End Balances • YTD Balances • Variances between Actual Budget and Prior Period • Turnover/Headcount • Payroll Amounts/Hours • PO/RQ Amounts/Quantities
Typical Implementation • Live available for report writing in less than 1 week • Provide an existing report or set of check figures to validate against.
Q & A Rich Bendickson Rich.Bendickson@DashboardGear.com 612.619.8753