User Tools

Site Tools


implementation:wms:hana_report_setting

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revision Previous revision
Next revision
Previous revision
implementation:wms:hana_report_setting [2019/10/30 17:09]
vise
implementation:wms:hana_report_setting [2020/07/01 14:51] (current)
vise [2.1. Saving reports with 32-bit]
Line 1: Line 1:
 ======HANA Report Setting Tool====== ======HANA Report Setting Tool======
-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.+On MSSQL, the connection data is replaced dynamically when printing and there is no need to save the report with the actual connection data. 
  
-With the HANA Report Setting ​tool it is possible to modify the connection data for multiple reports ​by proceeding as follows.+On SAP HANA, the connection data is not replaced dynamically and it is necessary to save the selected reports with the actual connection to the right database and schema. ith the HANA Report Setting ​Tool it is possible to modify the connection data for multiple reports.
  
 =====1. Configuration===== =====1. Configuration=====
Line 10: Line 10:
 The file can be found in the Produmex Tools folder, for example: //​C:​\Program Files\Produmex\Produmex Tools.// 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.//+Note: The file is only installed during a HANA installation.
  
 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):​
  
-Database 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 \\+  ​* ​Company DB: the name of the database used by SAP Business One \\
  
 {{ :​implementation:​wms:​tools:​hanareport:​main_screen.png |HANA Report Setting Tool}} {{ :​implementation:​wms:​tools:​hanareport:​main_screen.png |HANA Report Setting Tool}}
  
-**1.2. Configure the 32 Bit section**+**1.2. Configure the 32-bit section**
  
-32 bit OBCD Driver: ​\\ +  * 32-bit OBCD Driver: When you open the tool, it automatically displays your 32-bit OBCD Driver ​  set as default.
-When you open the tool, it automatically displays your 32-bit OBCD Driver ​  set as default.+
  
-Folder of 32 bit RPT files: ​\\ +  * Folder of 32-bit RPT files: This is the source folder of the reports ​that you want to modify and this is where the modified reports are 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 if the default folder contains RPT files, they are displayed in the Report Files grid
-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.+    * If the source folder does not contain any RPT file, the grid is empty. 
 +    * If you want to change the setting, browse another folder.
  
-If the source folder does not contain any RPT file, the grid is empty.+{{ :​implementation:​wms:​tools:​hanareport:​configuration_32_bit.png |32-bit section}}
  
-In case you want to change the setting, browse another folder.+**1.3. Configure the 64-bit section**
  
-{{ :implementation:​wms:​tools:​hanareport:​configuration_32_bit.png |Configuration 32 bit}}+  * 64-bit ODBC DriverWhen you open the tool, it automatically displays your 64-bit OBCD Driver set as default.
  
-**1.3. Configure ​the 64 Bit section**+  ​Folder of 64 bit RPT files: This is the folder where the generated 64-bit reports are saved.  
 +    ​By default, no folder is setCreate 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. ​
  
-64 Bit ODBC Driver\\ +NoteMake sure that you have two different folders for the 32-bit and for the 64-bit ​RPT files.
-When you open the tool, it automatically displays your 64-bit ​OBCD Driver set as default.+
  
-Folder of 64 bit RPT files\\ +{{ :implementation:​wms:​tools:​hanareport:​configuration_64_bit.png |Configuration ​64 bit}}
-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+=====2Saving reports=====
  
-Make sure that you have **two different folders** for the 32-bit ​and for the 64-bit RPT files.+====2.1. Saving reports with 32-bit====
  
-{{ :implementation:wms:​tools:​hanareport:​configuration_64_bit.png |Configuration 64 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.
  
-=====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. \\ 
 Now all the reports from your source folder are listed in the grid.  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  ''​Update Selected Reports to the New Connection Settings.''​.+3. Click  ''​Update Selected Reports to the New Connection Settings''​.
  
-4. Now the tool starts ​modifying ​the reports into 32 bit versions. In the log window the process is displayed step by step:+4. The tool starts ​converting ​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. \\ 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+It overwrites the report files by conveting ​them into 32-bit versions. Once the process is finished, you can find the 32-bit versions in your source folder.
- +
-5. The tool displays the successful actions per report on the Last Action column of the grid.+
  
-{{ :​implementation:​wms:​tools:​hanareport:​saving_reports_with_32_bit.png |Saving Reports with 32 Bit}}+5. The tool displays the successful actions per report in the Last Action column of the grid.
  
-====2.2. Saving ​reports ​with 64 bit====+{{ :​implementation:​wms:​tools:​hanareport:​saving_reports_with_32_bit.png |Saving ​Reports ​with 32-bit}}
  
-With this function the tool modifies the 32-bit RPT files into 64-bit ​versions.+====2.2. Saving reports with 64-bit====
  
-In case you have a 64-bit ​HANA environment and you need 64-bit RPT files, proceed as follows.+With this function the tool generates ​64-bit ​RPT files from the 32-bit RPT files.
  
 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 and Update All 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 generate 64-bit RPT files from the 32-bit RPT files 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:​hanareport:​saving_reports_with_64_bit.png |Saving Reports with 64 Bit}}+{{ :​implementation:​wms:​tools:​hanareport:​saving_reports_with_64_bit.png |Saving Reports with 64-bit}}
  
-=====3. ​Setting ​the report path in SAP B1=====+=====3. ​Defining ​the report path=====
  
-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.+Set the appropriate report path in SAP Business One so that the system knows where to find the reports whenever you want to generate a new report in SAP Business One.
  
 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.1572455356.txt.gz · Last modified: 2019/10/30 17:09 by vise