Dashboard Gear

The Financial Reporting Toolkit is a complete Lawson financial reporting solution which integrates directly with the Lawson Business Intelligence (LBI) and Lawson Enterprise Financial Management systems. 

Our solution significantly reduces the time it takes to build reports, run queries, and analyze financial data.  This toolkit creates a star schema data mart, an OLAP Cube, common reporting views, and a number of de-normalized relational tables which are optimized for easy report creation from your Lawson General Ledger data.

This solution creates a data mart of your Lawson General Ledger system with complete coverage of actual amounts and units, budget amounts and units, as well as, prior year comparisons.  It consists of a set of relational tables optimized for report creation along with a star schema design of the data which can be used for reporting and analysis as well as a Microsoft Analysis Services OLAP Cube.

 It allows for reporting and analyzing of your General Ledger Data by the following dimensions:

REPORTING AND ANALYSIS DIMENSIONS:

• Companies- your select the companies you want to include.

• Account Units- your complete Account Unit Structure including all Summary Levels automatically rolled up into a hierarchy.

• Accounts- the complete chart of accounts including Summary Accounts and optionally sub-accounts. This includes the capability to handle multiple charts.

• Fiscal Years- all fiscal years you have available and choose to include.

• Periods- all fiscal years and period you have available and choose to include.

• User Defined- up to 9user defined dimensions based on General Ledger Attributes. Such as person responsible, geography, hospital, etc.

INCLUDED MEASURES:

•  Actual Amounts and Units

• Budget Amounts and Units

• Prior Year Amounts and Units

• Prior Year Budget Amounts and Units

• Actual to Prior Amounts and Units

• Actual to Budget Amounts and Units

• Year-to-Date Amounts

• Prior Year-to-Date Amounts

• Annual Amounts

• Period End Balance

Because the data is output into industry standard formats, the data may be output using a variety of tools, including but not limited to:

• Lawson Business Intelligence (LBI)
• Microsoft Excel
• Microsoft Reporting Services
• Crystal Reports
• Microsoft Word and the other Office Components

System Requirements 

The system works with Lawson General Ledger 8.x and 9.x systems.  The reporting and solution requires a Microsoft SQL Server system with ODBC/OLEDB connectivity to the source Lawson tables.  The system will require the ability to create a database on the SQL Server environment and take full ownership of that database including the ability to create, drop, and alter tables on that database.

Optionally, if Microsoft Analysis Services Cubes are desired the requirements of the reporting solution must be met.  In addition, Microsoft Analysis Services and SQL Server Integration Services must be installed and a Local OLAP Administrator user must be available to create Analysis Databases and Cubes.