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

Many people spend days creating a single report on their Lawson Financial System.  Our solution significantly reduces the time it takes to build reports, run queries, and analyze your financial data.  This toolkit creates a star schema data mart, an OLAP Cube, common reporting views, and a number of denormalized relational tables which are optimized for easy report creation from your Lawson General Ledger data.

The 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 - You select the companies 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.  Includes the capability to handle multiple charts.
• Fiscal Years - All fiscal years you have available and choose to include
• Periods - All fiscal years and periods you have available and choose to include
• Account Unit List -
• Account Number List -
• User Defined - Up to 9 user-defined dimensions based on General Ledger Attributs 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 Year-to-Date Amounts
• Annual Amounts
• Period End Balance

Because the data is output into industry stand 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.