With Qlik SAP Connector version 8.0.2, when extracting data using SAP BW Connector, decimal values are separated by comma instead of point. This issue occurs also in version 8.0.1.
The behavior may depend on regional settings
Example of expected behavior.
Environment
- Qlik Sense Enterprise
- Qlik SAP Connector
Resolution
Bug QB-18820 reported to R&D was closed as fixed. A solution will be available in next release.
Information provided on this defect is given as is at the time of documenting. For up to date information, please review the most recent Release Notes, or contact support with the ID QB-18820 for reference.
Workaround:
Step 1: Download and apply the attached patch
- Navigate to C:\Program Files\Common Files\Qlik\Custom Data\
- Copy "QvSAPBWConnector" folder and save it on another location (ex: desktop).
- Delete "QvSAPBWConnector" folder
- Download file "qvsapbwconnector-1.5.3-6+0e8c250-manual-rel.zip" and extract this file (you will get "qvsapbwconnector" folder)
- Rename this folder "qvsapbwconnector" to "QvSAPBWConnector" and paste it in C:\Program Files\Common Files\Qlik\Custom Data\
- Test and if required, restart Qlik services
Step 2:
- Create a new SAP BW connection
- Check Connection String Properies and then BEx Legacy Mode (datatypes)
Cause
Product Defect ID: QB-18820
