management reporter integration guide 9.05

7/28/2019 Management Reporter Integration Guide 9.05

1/9

Epicor Management Reporter Integration

Epicor 9.05


2/9

Disclaimer

This document is for informational purposes only and is subject to change without notice. This document and itscontents, including the viewpoints, dates and functional content expressed herein are believed to be accurate as of itsdate of publication. However, Epicor Software Corporation makes no guarantee, representations or warranties with

regard to the enclosed information and specifically disclaims any applicable implied warranties, such as fitness for aparticular purpose, merchantability, satisfactory quality or reasonable skill and care. As each user of Epicor software islikely to be unique in their requirements in the use of such software and their business processes, users of this documentare always advised to discuss the content of this document with their Epicor account manager. All information containedherein is subject to change without notice and changes to this document since printing and other important informationabout the software product are made or published in release notes, and you are urged to obtain the current releasenotes for the software product. We welcome user comments and reserve the right to revise this publication and/ormake improvements or changes to the products or programs described in this publication at any time, without notice.The usage of any Epicor software shall be pursuant to an Epicor end user license agreement and the performance ofany consulting services by Epicor personnel shall be pursuant to Epicor's standard services terms and conditions. Usageof the solution(s) described in this document with other Epicor software or third party products may require the purchaseof licenses for such other products. Where any software is expressed to be compliant with local laws or requirementsin this document, such compliance is not a warranty and is based solely on Epicor's current understanding of such laws

and requirements. All laws and requirements are subject to varying interpretations as well as to change and accordinglyEpicor cannot guarantee that the software will be compliant and up to date with such changes. All statements ofplatform and product compatibility in this document shall be considered individually in relation to the products referredto in the relevant statement, i.e., where any Epicor software is stated to be compatible with one product and alsostated to be compatible with another product, it should not be interpreted that such Epicor software is compatiblewith both of the products running at the same time on the same platform or environment. Additionally platform orproduct compatibility may require the application of Epicor or third-party updates, patches and/or service packs andEpicor has no responsibility for compatibility issues which may be caused by updates, patches and/or service packsreleased by third parties after the date of publication of this document. Epicor is a registered trademark and/ortrademark of Epicor Software Corporation in the United States, certain other countries and/or the EU. All othertrademarks mentioned are the property of their respective owners. Copyright Epicor Software Corporation 2011.All rights reserved. No part of this publication may be reproduced in any form without the prior written consent of

Epicor Software Corporation.

Epicor 9.05

Revision: April 27, 2011 12:18 p.m.

Total pages: 9

sys.ditaval


3/9

Contents

1 Welcome and Introduction.................................................................................................4

2 Pre-Installation Steps...........................................................................................................4

2.1 Review Epicor Management Reporter Features...........................................................................................4

2.2 Verify Pre-Requisite Software is Installed.....................................................................................................5

3 Install Microsoft Management Reporter............................................................................5

4 Install Epicor Management Reporter Integration.............................................................5

4.1 Create DSN (ODBC) Connection.................................................................................................................5

4.1.1 For Progress Database......................................................................................................................5

4.1.2 For SQL Database............................................................................................................................6

4.2 Install the Epicor Management Reporter.....................................................................................................6

5 Configure Microsoft Management Reporter.....................................................................7

5.1 Create a New Entity...................................................................................................................................7

5.2 Create Report Definitons............................................................................................................................8

6 Upgrade from FRx 6.7..........................................................................................................8

3Epicor 9.05

ContentsEpicor Management Reporter Integration


4/9

1 Welcome and Introduction

Welcome to the Epicor Management Reporter Integration guide. This document is intended as a starting pointto install and configure Epicor Management Reporter. This document does not describe the installation of the

actual Microsoft Management Reporter software.Epicor Management Reporter allows integrating Microsoft Office PerformancePoint 2007 Management Reporterand the Epicor 9.05 application. Epicor Management Reporter helps you create and generate various financialreports by acting as a data adaptor, or "plug-in", by processing the requests of Microsoft Management Reporterand providing data from the Epicor 9.05 application data base.

2 Pre-Installation Steps

Complete the following steps before you start the Epicor Management Reporter Integretion installation.

2.1 Review Epicor Management Reporter Features

Use these steps to review the features, functionality and limitations of the Epicor Management Reporter.

1. Review the following features of Epicor Management Reporter:

a. calculate balances based on all segments

b. select various drill-down levels: financials, accounts or transaction

c. compare data from multiple financial years due to cross-year reports

2. Review the access to functionality that Epicor Management Reporter provides to its users:

Epicor financial periods (calendars)

Chart of Accounts

General Ledger transactions

Actual and budget data (scenarios)

Various balance and transaction attributes

3. Review the report generation limits of the Epicor Management Reporter: Only posted transactions are used for generating reports.

Since Epicor contains only balances and not budgeting transactions, you cannot combine actual dataand budget data on the transaction level.

Reports can be generated in the General Ledger book currency.

Rollups are not supported.

Tree import is not supported.

Epicor Management Reporter Data Adaptor configuration wizard is provided in English only.

Epicor 9.054

Epicor Management Reporter IntegrationWelcome and Introduction


5/9

2.2 Verify Pre-Requisite Software is Installed

Use these steps to verify the necessary software versions are installed.

1. Verify you have the Epicor 9.05 application installed. Use the Epicor 9.05 Installation Guide for instructions.

2. If you use SQL, verify you have SQL Server 2005 Express Edition SP2 or higher (if available) installed.

3. Verify you have installed MS WSE 3.0.

3 Install Microsoft Management Reporter

Use the following steps to install Microsoft Management Reporter.

1. Verify you have completed the prerequisites steps.

2. Insert the Microsoft Professional Management Reporter DVD into the DVD drive of your server whereyour Epicor application is installed.

3. Install Microsoft Management Reporter using the documentation provided on the Microsoft website. Thedocumentation is called Microsoft Office PerformancePoint Professional 2007 Management ReporterInstall Guide.

4 Install Epicor Management Reporter Integration

Use the following steps to install the Epicor Management Reporter Integration.

4.1 Create DSN (ODBC) Connection

Use these steps to create a DSN (ODBC) connection to the Epicor application database. Use one of the followingsections based on whether you have a Progress or SQL database.

4.1.1 For Progress Database

1. To create an ODBC connection, from Control Panel, select Administrative Tools. Open the Data Sources(ODBC) administrator program.

2. Select the type of Data Source Name (DSN) to set up. To do this, click on either the User, System, or Filetab.

3. Select the Data Source Name and click Add.

5Epicor 9.05

Install Microsoft Management ReporterEpicor Management Reporter Integration


6/9

4. Select the Progress OpenEdge 10.2a driver from the list of drivers. Click Finish. Note that the client shouldhave this driver previously installed.

5. In the ODBC Driver Setup dialog, enter the following and then click OK.

Data Source Name. Any name assigned.

Host Name. Server name where the Progress database is located.

Port Number. Port number of the Progress database server. Database Name. Full path to the Progress database file as it is located on the database server.

4.1.2 For SQL Database

1. To create an ODBC connection, from Control Panel, select Administrative Tools. Open the Data Sources(ODBC) administrator program.

2. Select the type of Data Source Name (DSN) to set up. To do this, click on either the User, System, or Filetab.

3. Select the Data Source Name and click Add.

4. Enter the Name and Description of your data source.

5. Select a SQL Server to which you want to create a connection. Click Next.

6. Select either With Integrated Windows authentication or With SQL Server authentication to definethe authenticity method for the login ID. Click Next.

7. Verify the Change the default database check box is selected and your SQL Server database is selected.Click Next.

8. Click Finish to complete the ODBC connection configuration.

4.2 Install the Epicor Management Reporter

Use the following steps to install the Epicor Management Reporter data adaptor.

1. Log on to EPICweb and go to the Customer Portal Page. Navigate to Support > Epicor 9 > Downloads.

Note You can use this link: https://epicweb.epicor.com/Support/epicor9/Downloads.

2. Navigate to Epicor 9 > Version 9.05.600 > Third Party Products > Management Reporter.

3. Download the Epicor9MMR.exe file to your server.

4. Double-click the file to start the installation.

5. On the Welcome dialog, click Next.

6. To accept the default destination folder, click Next. You can click Browse to select a different folder.

Epicor 9.056

Epicor Management Reporter IntegrationInstall Epicor Management Reporter Integration
https://epicweb.epicor.com/Support/epicor9/Downloadshttps://epicweb.epicor.com/Support/epicor9/Downloads


7/9

7. To accept the Data Integration default configuration file location, click Next. You can click Browse to selecta different folder.

8. To begin the installation, click Next. The files are installed.

9. When complete, click Finish. The Epicor Management Reporter closes.

5 Configure Microsoft Management Reporter

Use the following steps to configure Microsoft Management Reporter, including creating a new entity and reportdefinitions.

5.1 Create a New Entity

Use these steps to create a new entity in Microsoft Management Reporter.

1. Open the Microsoft Management Reporter.

2. From the Entity menu, select Entities > New.

3. In the New Entity dialog, enter the following:

Entity Name. Enter the name of the new entity.

Entity Description. Enter a concise description of the new entity.

Source System. Select Epicor 9.05 v1.1 from the drop-down list. This option was installed as a sourcesystem was the Epicor Management Reporter was installed.

4. Click the Settings button next to the Source System.

5. If you use SQL, specify your connection settings using the following:

Data Source Type. Select SQL Server r from the drop-down list.

Server Name. Enter the name of the SQL database server where your Epicor database is located.

For login information, select either the Use Windows authentification or Use SQL Serverauthentification check box to define the level of desired security.

Database. Select the proper database from the drop-down list.

Test Connection. Click this button to verify your connection is set up correctly.

Click Next.

6. If you use Progress, specify your connection settings using the following:

Data Source Type. Select Progress from the drop-down list.

Data Source Name. Select the DSN to Progress database where your Epicor application database islocated.

User Name / Password. Enter the login information to connect to the Progress database. For example,you may have a user name created called SysProgress.

7Epicor 9.05

Configure Microsoft Management ReporterEpicor Management Reporter Integration


8/9

Test Connection. Click this button to verify your connection is set up correctly.

Click Next.

Select a Company and Book Code from the drop-down lists. Click Next.

On the summary page, review the connection settings. Click Finish.

The New Entity dialog displays. Click OK.

Select the Set as Default check box to set this entity as the default. Click Close.

5.2 Create Report Definitons

Use these steps to create report definitions in Microsoft Management Reporter.

1. Open the Microsoft Management Reporter.

2. Use the Report Set Up Wizard to create report definitions.

6 Upgrade from FRx 6.7

For existing customers, use the following section to migrate your current Microsoft FRx 6.7 to use MicrosoftManagement Reporter. The migration tool converts much of your Microsoft FRx 6.7 configuration to ManagementReporter.

1. In Report Designer, from the Tools menu, select Migration > Migrate.

2. In the Migrate dialog, browse to the FRxSys32.mdb for the configuration that you want to migrate. Click

Migrate.The information in the Migrate dialog indicates the conversion progress. Based on the amount of data tobe migrated, the conversion may take some time.

3. After the migration completes, click Close.

4. Review the log file that displays to determine if any errors occured during the conversion. As needed, editthe affected building block to correct any errors.

5. Use Management Reporter to create new entities.

6. In Report Designer, on the Tools menu, click Migration > Validate.

The information in the Validate dialog box indicates the validation progress. Based on the amount of datato be checked, the validation may take some time.

7. After the validation completes, review the Report Designer navigation section. If an exclamation point iconappears next to any building block, Management Reporter was not able to validate that building block. Inthese cases, open that building block and correct the errors.

Epicor 9.058

Epicor Management Reporter IntegrationUpgrade from FRx 6.7


9/9

Additional information is available at the Education andDocumentation areas of the EPICweb Customer Portal. To access

this site, you need a Site ID and an EPICweb account. To create anaccount, go to http://support.epicor.com.
http://support.epicor.com/http://support.epicor.com/

management reporter integration guide 9.05

Documents