Symptom
When data are extracted in delta mode with delta process ‘AIED’ (see transaction RSA2) via the datasource 0FI_GL_10 (or customer defined 3FI_GL_*) it seems that too much data are extracted.
Examples:
1) records are extracted that have an old (and therefore not relevant) TIMESTAMP
2) records are extracted with only zero values in it
3) although data for [...]
Symptom
The IGS zipper interpreter is outdated
Other terms
Zipper, Broadcaster, BW, RFC, Internet, Graphic, Service
Reason and Prerequisites
Performance Tuning
Solution
The IGS zipper class CL_IGS_ZIPPER is outdated. Please use the ABAP classes CL_ABAP_ZIP and / or CL_ABAP_GZIP in your custom developments in order to provide zipping functionalities in your applications. For more details about these classes please consult [...]
Symptom
You are using a datasource for the leading ledger (e.g. 0FI_GL_10, 0FI_GL_11, 0FI_GL_12) and you want to reconcile the extracted BI data with the ERP data.
Other terms
delta extraction reconciliation 0FI_GL_RECON
Solution
By using datasource 0FI_GL_RECON via a Remote Cube, the ERP data are extracted online from the ERP system and available in this Remote Cube.
These [...]
Symptom
If you observe one or more of the following issues in your BW Accelerator:
- Deletion of BWA Indexes takes a very long time
- Filling of BWA Indexes takes a very long time
- Queries/Fill jobs seem to hang or come back with a timeout error
Then one reason could be OCFS2. The following issues we observed in [...]
Symptom
You want to map the document history for your EBP procurement process in SAP BW.
Other terms
Document history, 0BBP_DOC, 0BBP_DOC_HDR_1, 0BBP_DOC_ITM_1
Reason and Prerequisites
You are using BW 3.0B with EBP 3.0 or 3.5 or SRM 2.0 or SRM 4.0.
Solution
See the documentation on document flow – “How to Track Documents in E-Procurement”, on the SAP Service Marketplace (www.service.sap.com).
> [...]
Symptom
Poor Peformance for ODS request activation
RSODSO_SETTINGS, RSODSO_PROCESSING 017, RSODSO_PROCESSING 019, RSODSO_PROCESSING 023, RSODSO_PROCESSING 041, background processes
Reason and Prerequisites
- Activating many requests together with a large number of records in each
- Not enough free BTC-Processes available in a system
- DataStore configuration (RSODSO_SETTINGS) is not optimal and/or does not reflects the server configuration or [...]
Symptom
Not all key figures are filled with the BI Data collection tool in SAP Solution Manager
Other terms
SAP Solution Manager, BI Data Collection, SAP EarlyWatch Alert
Solution
There is a new BI strategy with SAP Solution Manager EhP1 (SP18). The BI Data collection of data from SAP EarlyWatch Alert is no longer supported. There are a [...]
Symptom
Refer to the general information about the Critical Patch Updates (CPU) in the CPU composite note 850306.
Oracle 10.2.0.4
The following patch molecules are installed with CPUOct2009:
7155248 – DB-10.2.0.4-MOLECULE-001-CPUJUL2008
7155249 – DB-10.2.0.4-MOLECULE-002-CPUJUL2008
7155250 – DB-10.2.0.4-MOLECULE-003-CPUJUL2008
7155251 – DB-10.2.0.4-MOLECULE-004-CPUJUL2008
7155252 – DB-10.2.0.4-MOLECULE-005-CPUJUL2008
7155253 – DB-10.2.0.4-MOLECULE-006-CPUJUL2008
7155254 – DB-10.2.0.4-MOLECULE-007-CPUJUL2008
7197583 – DB-10.2.0.4-MOLECULE-008-CPUJUL2008
7375611 – DB-10.2.0.4-MOLECULE-009-CPUOCT2008
7375613 – DB-10.2.0.4-MOLECULE-0010-CPUOCT2008
7375617 – DB-10.2.0.4-MOLECULE-0011-CPUOCT2008
7609057 – DB-10.2.0.4-MOLECULE-0012-CPUJAN2009
7609058 – DB-10.2.0.4-MOLECULE-0013-CPUJAN2009
8309587 – DB-10.2.0.4-MOLECULE-014-CPUAPR2009
8309592 – DB-10.2.0.4-MOLECULE-015-CPUAPR2009
8309623 [...]
Symptom
You get either of the following symptoms:
You encounter a short dump while loading data using 3.X datasource in the source system as ‘TYPELOAD_NEW_VERSION’. The details say as ‘A newer version of data type “/BIC/CC*” was found than one required’.You see the error in the BW system in the request monitor as:Errors Error occurred [...]
Symptom
This note contains a hotfix to note 1272736.
Additionally it is described how to upgrade or install the BI 7.X precalculation Service.
Other terms
SAP BW Precalculation Service, Precalculation Server 7.X, BI 7.0, GUI 710, How to, FCS, FEP 1000, 1001
Reason and Prerequisites
Following are the pre-requisites:
1. Access to the Service Marketplace2. You have successfully installed the BI [...]
Symptom
Correction for your issue will be delivered with a BI JAVA Support Package or Patch for SAP EHP1 for NetWeaver 7.0 (7.01).
Other terms
BI Java Runtime, SCA, BIBASES, BIWEBAPP,
Reason and Prerequisites
Code correction in BI JAVA for SAP EHP1 for NetWeaver 7.0 (7.01).
Solution
BI JAVA corrections are delivered via Support Packages and BI JAVA Patches.BI JAVA Support Packages [...]
Symptom
After the upgrade, performance problems occur due to the implicit use of the “formula exception aggregation” feature.You can no longer generate a query with implicit formula exception aggregation.
Other terms
7.x , FAGGR , exception aggregation, formula , calculated key figure
Reason and Prerequisites
The formula calculation was completely revised in SAP NetWeaver BI 7.0 (NW 2004s) to [...]
Symptom
You want to activate a CPIC trace for TREX or BW Accelerator.
Other terms
TREX, BWA, BIA, accelerator, CPIC trace, RFC, network, communication
Reason and Prerequisites
You have an RFC communication issue with your TREX or BW Accelerator and want to check if it is due to a CPIC problem.
Solution
To activate the CPIC trace, perform the following steps:
1. Add”CPIC_TRACE=“in [...]
Symptom
This note describes the pre-requisites for the BI 7.x Standalone Frontend and BW 3.5 Add-on with SAP GUI 710.
Other terms
requirements, setup, Business Intelligence, Business Information Warehouse Frontend, System.NullReferenceException: Object reference not set to an instance of an object, at System.Windows.Forms.ComboBox.set_Text
Solution
There are 2 Business Explorer versions which are delivered as part of the [...]
Symptom
You want to extract the moving average price from the tables MBEW, EBEW, QBEW and OBEW into the BW. Since the moving average price is not in the material document, you cannot extract the moving average price in the delta method (during the material document creation) into the BW delta queue.
The moving [...]
Symptom
The BEx Web Application Designer (WAD) 3.X cannot be executed in Windows 7.
Other terms
dhtml edit control, Vista
Reason and Prerequisites
You are using the operating system Windows 7 (successor of Windows Vista).
The WAD 3.X is using the DHTMLedit control of Microsoft, which has several security gaps when being used in the Internet Explorer. Therefore, this [...]
Symptom
This note refers to Support Package02for BI Release 7.11 (part of NetWeaver 7.1 Enhancement Package 01).
Other terms
SAPBWNEWS, Support Packages for 7.11, BW 7.1, BI 7.10, BW Patches, BI, BI 7.1, SAPBINEWS
Solution
This note contains the SAPBINews for ABAP Support Package 02 for SAP NetWeaver 7.1 Enhancement Package 01.
It provides a list of all notes describing the [...]
Symptom
This note refers to Support Package 01 for BI Release 7.11 (part of NetWeaver 7.1 Enhancement Package 01).
Other terms
SAPBWNEWS, Support Packages for 7.1, BW 7.1, BI 7.10, BW Patches, BI, BI 7.11, SAPBINEWS
Solution
This note contains the SAPBINews for ABAP Support Package 00 for SAP NetWeaver 7.1 Enhancement Package 01.
It provides a list of all notes [...]
Symptom
You execute a BW 3.X Web template. The Internet Explorer only displays incomprehensible characters.
Other terms
Unicode, charset, META tag, Chinese characters, Japanese characters, Microsoft, KB956844, Internet Explorer (IE), BEx Web Application Designer 3.x (WAD 3.x)
Reason and Prerequisites
1. The PC on which the BEx Web Application Designer 3.x (WAD 3.x) is installed has the operating [...]
Symptom
The variable screen in BI 7.0 Web runtime accepts characteristic values only in External format.
Other terms
conversion routine not executed, internal format in variable screen, internal format not accepted
Reason and Prerequisites
Reason:
BI Consumer services Variables infrastructure in BI 7.0 always accepts the characteristic values in “External format” from variable screen in Web.
This is by design and [...]