BPM Country Reports

Reporting Setup

This section describes the workflow for setting up statutory reports.

Note: For more information about installing, setting up and using Maconomy Business Performance Management (BPM) Reporting, refer to the BPM Admin Guide.

To use the BPM and statutory reports, you must first set them up using the instructions below.

Beginning with 2.4.3, you must set up the Maconomy system parameters and coupling service to run all statutory reports.

Note: Proper setup must be followed or statutory reports will not work as intended.

Workflow for Setup

1 Set System Parameters
2 Set Data Export Path and Server Timeout
3 Configure Background Task
4 Trusted Authentication Setup
5 Restart Programs
6 Follow Country-Specific Instructions

Update System Parameters

BPM reports and data exports require a connection to an SAP BusinessObjects Server with the BPM package installed. This connection is managed through system parameters that allow Maconomy to communicate with BusinessObjects using universes. Universes are essential for running Web Intelligence (WebI) reports, BPM reports, and data exports, which are implemented as Java extensions in Maconomy.

To set up system parameters for BPM Reporting:

  1. Go to the Setup » System Setup » System Parameters.
  2. Locate the BPM system parameters. They have 'BPM' in the Description text, as follows:
    • BPM Server REST API URL
    • BPM Server URL
  3. Select each parameter and update the server URL fields with the appropriate value. For example:

    https://Servername:Port (or http://Servername:Port)

    Note: Deltek recommends that you use https:// for a more secure connection.
  4. Save both parameters.
  5. Restart the Coupling Service to apply the changes.
Note: The BPM system parameter, Enable Silent Sign-In, ensures that when a user logs into Maconomy, they are automatically authenticated in BusinessObjects, eliminating the need for a login prompt when running reports. This applies to all interactions with BusinessObjects, including opening BI LaunchPad, accessing BPM reports, and performing data exports. This parameter is not selected by default.

Set Data Export Path and Server Timeout

  1. In the Maconomy installation folder, go to the designated Coupling Service configuration folder in relation to the Maconomy shortname. For example:

    C:\Maconomy\<Maconomy Install DIR>\CouplingService\Configuration\Settings

  2. Select and open the Extension.ini file.
  3. Locate server.timeout and change the value from 600 (default for 10 minutes) to 2400 (40 minutes).
  4. Locate filepath.<file-path-id> = <file path>. This will serve as a template to the BPM export path.
  5. Create a new uncommented line following the template above and with the file path ID as bpmexportpath. For example:

    filepath.bpmexportpath.<Shortname of Maconomy installation>=C:\BPMSTATFOLDER

  6. Make sure that system.maintenance is set to false.
  7. Save the file.
  8. Restart the coupling service.

For Maconomy versions 2.4.5, 2.5, and 2.5.1, you may encounter an error ("The system cannot find the path specified.") while trying to generate a report. The background task does not create the BPMSTATFOLDER folder automatically.

To manually create the export folder:

  1. On the system where the coupling server is hosted, locate the Maconomy folder.

    For example on a Windows system, go to C:\Maconomy.

  2. Create the folder BPMSTATFOLDER.

    Stick to upper case or lower case for the folder name to make sure it runs properly across operating systems.

Configure Background Task

The statutory reports run as background tasks to extract huge amounts of data without compromising simultaneous entry. Background Tasks are enabled by default. Set the task duration as described below.

To set the Task Duration:

  1. Go to Setup » Background Tasks » Management » System Defaults.
  2. In Default Max. Task Duration, enter 40 minutes.

Trusted Authentication Setup

The steps in this section are necessary to allow Trusted Authentication in REST API to run the statutory reports.

To configure Trusted Authentication for statutory reports:

  1. On the BO server, log in to the Central Management Console (CMC) with administrative rights.
  2. Go to Servers area of the CMC Client and open the properties for the Web Application Server.
  3. In the Command Line Parameters textbox, look for the parameter -Dbobj.trustedauth.home.
  4. Note down its corresponding value. For example:

    "-Dbobj.trustedauth.home=C:/Program Files (x86)/SAP BusinessObjects/SAP BusinessObjects Enterprise XI 4.0/java/pjs/container/bin"

  5. Go to the Authentication Management area of the CMC Client. On the Enterprise tab, scroll down to the Trusted Authentication section.
  6. Under Trusted Authentication:
    1. Click Trusted Authentication is enabled.
    2. Click New Shared Secret.
    3. Enter the number of days for the Shared Secret Validation Period and timeout for the Trusted Authentication request.
    4. Click Update to save the settings.
    5. Reopen the Enterprise tab.
    6. Click Download Shared Secret.

      The File Download dialog box displays.

    7. Click Save and copy the file, TrustedPrincipal.conf to the following folder:

      <INSTALLDIR>\SAP BusinessObjects Enterprise XI 4.0\win32_x86\ <INSTALLDIR>\SAP BusinessObjects Enterprise XI 4.0\win64_x64\

      This is Trusted Authentication Home folder as mentioned in Step 3, for example:

      C:/Program Files (x86)/SAP BusinessObjects/SAP BusinessObjects Enterprise XI 4.0/java/pjs/container/bin

    8. Restart the Server Intelligence Agent (SIA).
Note: There is a chance the generated Shared Secret will be too long and will cause an unnecessary line break. If this happens, generate a new Shared Secret.

After this is completed, you must enable Trusted Authentication on the Coupling Service.

Follow these steps:

  1. Update the OSGi settings in MConfig.
  2. Select the Trusted Authentication check box.
  3. Copy the value of the shared secret in TrustedPrincipal.conf to the Password from the preceding list.

Restart Programs

After the Trusted Authentication setup, you must restart the following programs:

  1. Tomcat
  2. Server Intelligence Agent (SIA)

Follow Country-Specific Instructions

  1. Click Ctrl + F to search for the country.
  2. Follow the country-specific setup instructions as needed.