implementation:wms:hana_report_setting
Differences
This shows you the differences between two versions of the page.
| Both sides previous revision Previous revision | |||
|
implementation:wms:hana_report_setting [2019/03/25 10:31] vise upogarding to v19.1 |
implementation:wms:hana_report_setting [2019/09/18 10:13] (current) vise upgarding to v19.2 |
||
|---|---|---|---|
| Line 1: | Line 1: | ||
| ======HANA Report Setting Tool====== | ======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. | + | On MSSQL, the connection data is replaced dynamically when printing and there is no need to save the report with the actual connection data. In contrast, the connection data is not replaced dynamically on HANA and 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. | With the HANA Report Setting tool it is possible to modify the connection data for multiple reports by proceeding as follows. | ||
| Line 11: | Line 11: | ||
| //Please note that the file is only installed during a HANA installation.// | //Please note that the file is only installed during a HANA installation.// | ||
| - | |||
| - | {{ :implementation:wms:tools:1._opening_the_tool.png |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): | 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 \\ | + | Database section \\ |
| - | DB Server: the name of the database server | + | DB Server: the name of the database server \\ |
| + | Company DB: the name of the database used by SAP B1 \\ | ||
| - | Database section \\ | + | {{ :implementation:wms:tools:hanareport:main_screen.png |HANA Report Setting Tool}} |
| - | 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** | **1.2. Configure the 32 Bit section** | ||
| Line 29: | Line 26: | ||
| Folder of 32 bit RPT files: \\ | 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. \\ | + | This is the source folder of the reports you want to modify and this is where the modified reports are 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: | + | The default setting for the source folder is //C:\Produmex// or //C:\Produmex\Reports// and if the default folder contains RPT files, they are displayed in the Report Files grid. |
| - | {{ :implementation:wms:tools:1.b_opening_the_tool.png |Folder of 32 bit RPT files}} | + | If the source folder does not contain any RPT file, the grid is empty. |
| - | If the source folder does not contain any RPT file, the grid will be empty. | + | In case you want to change the setting, browse another folder. |
| - | In case you want to change the setting, you can browse another folder. | + | {{ :implementation:wms:tools:hanareport:configuration_32_bit.png |Configuration 32 bit}} |
| **1.3. Configure the 64 Bit section** | **1.3. Configure the 64 Bit section** | ||
| Line 44: | Line 41: | ||
| Folder of 64 bit RPT files: \\ | Folder of 64 bit RPT files: \\ | ||
| - | This is where the modified, 64-bit reports will be saved. By default, no folder is set. | + | This is where the modified, 64-bit reports are 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. | 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. | ||
| Line 50: | Line 47: | ||
| Make sure that you have **two different folders** for the 32-bit and for the 64-bit RPT files. | Make sure that you have **two different folders** for the 32-bit and for the 64-bit RPT files. | ||
| - | {{ :implementation:wms:tools:3._64_bit_section.png |64-bit section}} | + | {{ :implementation:wms:tools:hanareport:configuration_64_bit.png |Configuration 64 bit}} |
| =====2. Saving reports with 32 bit and 64 bit===== | =====2. Saving reports with 32 bit and 64 bit===== | ||
| Line 57: | Line 54: | ||
| 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. \\ | 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. | + | Now all the reports from your source folder are listed in the grid. |
| 2. Select the necessary report files in the grid. | 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. | \\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. | + | 3. Click ''Update Selected Reports to the New Connection Settings.''. |
| - | 4. Click ''Set selected reports with 32 bit ODBC''. | + | 4. Now the tool starts modifying the reports into 32 bit versions. In the log window the process is displayed step by step: |
| - | At this point the tool starts modifying the reports into 32 bit versions. In the log window the process is displayed step by step: | + | 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. \\ |
| + | Then it overwrites the report files by modifying them into 32 bit versions. Once the process is finished, you can find the 32 bit versions in your source folder. | ||
| - | {{ :implementation:wms:tools:4._modifying_with_32_bit_obcd.png |Modifying reports with 32 bit OBCD}} | + | 5. The tool displays the successful actions per report on the Last Action column of the grid. |
| - | 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. \\ | + | {{ :implementation:wms:tools:hanareport:saving_reports_with_32_bit.png |Saving Reports with 32 Bit}} |
| - | 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==== | ====2.2. Saving reports with 64 bit==== | ||
| Line 81: | Line 78: | ||
| 1. Select the necessary 32-bit report files in the grid. | 1. Select the necessary 32-bit report files in the grid. | ||
| - | 2. Click ''Copy selected reports with 64 bit ODBC''. | + | 2. Click ''Copy and Update All reports with 64 bit ODBC''. |
| The steps of the process is displayed in the grid. \\ | 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. | The tool starts to modify the 32-bit RPT files into 64-bit versions and saves them to your 64-bit RPT files folder. | ||
| - | {{ :implementation:wms:tools:5._modifying_with_64_bit_obcd.png |Modifying reports with 64-bit OBCD}} | + | {{ :implementation:wms:tools:hanareport:saving_reports_with_64_bit.png |Saving Reports with 64 Bit}} |
| - | =====3. Setting the report path in SAP BO===== | + | =====3. Setting the report path in SAP B1===== |
| - | 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. | + | After modifying the reports, set the appropriate report path in SAP B1. In this way the system knows where to find the reports whenever you want to generate a new report in SAP B1. |
| 1. Open your organization structure and select the //Reports// tab. | 1. Open your organization structure and select the //Reports// tab. | ||
implementation/wms/hana_report_setting.txt · Last modified: 2019/09/18 10:13 by vise
