1 / 12

Revolutionize Your Lawson Reporting

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

charlton
Download Presentation

Revolutionize Your Lawson Reporting

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. Revolutionize Your Lawson Reporting Using the Dashboard Gear Reporting Toolkits

  2. 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. A Few of our Customers

  4. 3 Layers of a BI Implementation DATA LAYER CONTENT CREATION LAYER DISTRIBUTION LAYER

  5. Dashboard Gear System Overview Reporting and Analytics Server Lawson Server Reporting Database Lawson Database OLAP Cube Relational Data Mart Database Views and Procedures

  6. 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

  7. 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

  8. Why Continued…… • Account balance data is difficult to obtain • Performance and security concerns of reporting off live production data

  9. 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

  10. 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

  11. Typical Implementation • Live available for report writing in less than 1 week • Provide an existing report or set of check figures to validate against.

  12. Q & A Rich Bendickson Rich.Bendickson@DashboardGear.com 612.619.8753

More Related