User Tools

Site Tools


implementation:wms:hana_report_setting

HANA Report Setting Tool

On MSSQL, the connection data will be replaced dynamically when printing, there is no need to save the report with the actual connection data. In contrast, the connection data is not replaced dynamically on HANA, therefore it is necessary to save the selected reports with the actual connection to the right database and schema.

With the HANA Report Setting tool it is possible to modify the connection data for multiple reports by proceeding as follows.

1. Configuration

1.1. Run the Produmex.Sbo.Logex.Tools.HanaReportSettingTool.exe.

The file can be found in the Produmex Tools folder, for example: C:\Program Files\Produmex\Produmex Tools.

Please note that the file is only installed during a HANA installation.

Opening the tool

When the tool opens, the following fields are prefilled based on the configuration file of the tool (Produmex.Sbo.Logex.Tools.HanaReportSettingTool.exe.config):

Server section
DB Server: the name of the database server

Database section
Company DB: the name of the database used by SAP BO
PMX Extra DB: the Produmex extra database

1.2. Configure the 32 Bit section

32 bit OBCD Driver:
When you open the tool, it automatically displays your 32-bit OBCD Driver set as default.

Folder of 32 bit RPT files:
This is the source folder of the reports you want to modify and this is where the modified reports will be saved.
The default setting for the source folder is C:\Produmex or C:\Produmex\Reports and in case the default folder contains RPT files, you will see the files listed on your start screen:

Folder of 32 bit RPT files

If the source folder does not contain any RPT file, the grid will be empty.

In case you want to change the setting, you can browse another folder.

1.3. Configure the 64 Bit section

64 Bit ODBC Driver:
When you open the tool, it automatically displays your 64-bit OBCD Driver set as default.

Folder of 64 bit RPT files:
This is where the modified, 64-bit reports will be saved. By default, no folder is set.

In case you have a 64-bit HANA environment, create your new folder for the 64-bit reports, for example C:\Produmex\Reports\Reports64bit, and browse it for the Folder of 64 bit RPT files field.

Make sure that you have two different folders for the 32-bit and for the 64-bit RPT files.

64-bit section

2. Saving reports with 32 bit and 64 bit

2.1. Saving reports with 32 bit

1. Copy the necessary reports from your installation folder (for example: C:\Install\Produmex_WMS_19_1.x64\Reports\HANA) into your 32-bit RPT file source folder.
At this point all the reports from your source folder will be listed in the grid of the tool window.

2. Select the necessary report files in the grid. \\You can select all of them by clicking the Select All button or select the necessary ones one by one.

3. Click Assign PMX Extra DB to selected reports.

4. Click Set selected reports with 32 bit ODBC.

At this point the tool starts modifying the reports into 32 bit versions. In the log window the process is displayed step by step:

Modifying reports with 32 bit OBCD

The tool creates a new folder named OLD within your 32-bit RPT file source folder and saves a copy of the selected report files into the OLD folder.
Hereinafter, it overwrites the report files by modifying them into 32 bit versions. Once the process is finished, you will find the 32 bit versions in your source folder.

2.2. Saving reports with 64 bit

With this function the tool modifies the 32-bit RPT files into 64-bit versions.

In case you have a 64-bit HANA environment and you need 64-bit RPT files, proceed as follows.

1. Select the necessary 32-bit report files in the grid.

2. Click Copy selected reports with 64 bit ODBC.

The steps of the process is displayed in the grid.
The tool starts to modify the 32-bit RPT files into 64-bit versions and saves them to your 64-bit RPT files folder.

Modifying reports with 64-bit OBCD

3. Setting the report path in SAP BO

After modifying the reports, you need to set the appropriate report path in SAP BO. In this way the system will know where to find them whenever you want to generate a report in SAP BO.

1. Open your organization structure and select the Reports tab.

2. Provide the path of your 32-bit RPT files folder or your 64-bit RPT files folder in the Report path field.

3. Click OK.

The Report path

implementation/wms/hana_report_setting.txt · Last modified: 2019/03/25 10:31 by vise