Symptom
This note consists of questions and answers about indexes in MaxDB/liveCache /content server/SAP DB databases.
General and frequent questions about indexes are answered, although this note does not claim to be exhaustive.
1. What is an index?2. What are indexes used for?3. What is the technical structure of indexes?4. Is the primary key for MaxDB also stored [...]
Symptom
Data records are deleted from the data package in the start routines of InfoSources 2LIS_02_SCL, 2LIS_03_BX and 2LIS_03_BF.
Other terms
2lIS_02_SCL;2LIS_03_BF;2LIS_03_BX
Reason and Prerequisites
The start routines were implemented to explode structured articles in mySAP ERP 2005.
Solution
The start routines prevent the extracted transaction data in SAP BW from being updated several times, which would lead to incorrect values.
The [...]
Symptom
If you change an extraction structure in the Customizing Cockpit (transaction LBWE) by importing a support package or a transport or by carrying out an upgrade, if this had already been activated for update for a certain time, various errors may occur:
The initialization of data that was created before the change no longer [...]
Symptom
You use ME85 to aggregate and renumber schedule lines for a scheduling agreement. When you look at the data in business warehouse, the changes to these schedule lines has not registered.
There is no delta update of BW from ME85.
Other terms
OLI3BW, setup, scheduling lines, delta update
Reason and Prerequisites
This is the normal behaviour of the system.
It [...]
Symptom
You load a Datastore object (DSO) using either of the following scenario:
You use 3.x mode of loading using Infopackage andTransfer rulesandUpdate ruleswithStart RoutineYou use the 7.x mode of loading using Data Transfer Process (DTP),TransformationusingStart Routine,End RoutineorExpert Routine
You may end up in incorrect results for the characteristics which have not been used as key fields [...]
Symptom
A query that has a numeric variable with a replacement path attribute takes a long time to run. Large volumes of data are processed both in the data manager and in the online analytical processing (OLAP) processor.
Other terms
Query, FAGGR, replacement path
Reason and Prerequisites
The OLAP processor must read the data so that the reference [...]
Symptom
Compatible source code adjustments to support future releases.
Other terms
CL_RSD_DTA, factory, UPARI_BUDGA, Budgetmonitor, UPARI_REL, Release-Workbench
Reason and Prerequisites
To be compatible with future releases the instantiation of objects of class CL_RSD_DTA is done by a static public method FACTORY and not by the statement CREATE OBJECT anymore.
Solution
Apply the attached correction instructions.
Symptom
Access to http://metalink.oracle.com
Other terms
Oracle Metalink
Oracle Metalink Notes
TAR
ITAR
metalink
metalink note
Reason and Prerequisites
Use Metalink as additional means for error analysis or to retrieve background information on a particular problem.
Solution
Oracle Metalink now is also accessible for SAP customers that do not have an additional oracle License with oracle. The type of access that is available to customers [...]
Symptom
When you extract transaction data from the profitability analysis, the system displays error message RD 159 “Incorrect field name for selection”, or RD 117 “Syntax error in generated program”.
Other terms
RD159, RD 159
Reason and Prerequisites
When you change the structure of the operating concern (by deleting fields, for example), the system does not adjust the [...]
Symptom
The filling of a BWA index fails with error code “1994″
Other terms
BIA, BWA, Explorer, Polestar, filling, indexing, date, invalid data
Reason and Prerequisites
Filling of BWA index fails due to a not valid data format in an attribute of type DATE. You can find the following trace entries in traces of TREXIndexServer:
DateAttributeValue::set(): attribute value is not [...]
Symptom
This note provides detailed information about what has changed regarding the Hierarchy/Attribute Change Run (CR) with BW7x. In combination with note 903886 (which is only valid for BW releases BW3x) it should give you a good overview of this important BW process from a technical point of view.
Other terms
attribute and hierarchy change [...]
Symptom
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
This note is released as a Hot News.
You must check the note regularly for updates. Otherwise, you will not [...]
Symptom
This note gives you an overview of the most important factors which influence performance that you must take into account when you create planning applications in BI planning. The note discusses the following topics:
1.Background knowledge for BI planning architecture2.Important influencing factors for performance3.Recommendations for modeling4.Availability of optimizations
Other terms
BI planning, planning modeler, input-ready query, [...]
Symptom
You load data into a file using an InfoSpoke. The internal format is always used for this. This can have the following undesired effects
1. If there are negative numbers under the extracted data, the minus sign is positioned after the number in the output file. However, you want the minus sign to be positioned [...]
Symptom
When embedding a BEx Query via the SAP NW BI Connection you receive the error message 2032 immediatly after the BEx query selection dialog.
Please note that this is only relevant during Xcelsius design time and not during launching of the Xcelsius Dashboard (runtime).
Other terms
Xcelsius Design Time, Federated Portal Network, Error 2032, FPN,
Reason and [...]
Symptom
When embedding a BEx Query via the SAP NW BI Connection you receive the error message 2032 immediatly after the BEx query selection dialog.
Other terms
Xcelsius, Error 2032, Java Support Package, Web Service, BicsRemote, version
Reason and Prerequisites
The Xcelsius Designer calls the Web Service BicsRemote to retreive Bex Query Meta Data. If the Web Service [...]
Symptom
Sie verwenden Merkmalsbeziehungen und/oder Datenscheiben in real-time InfoCubes, die in InfoProvider vorkommen, die f黵 eingabebereite Queries genutzt werden. Das System pr黤t dann jede laut Query Designer potentiell eingabebereite Zelle, ob diese zur Laufzeit eingabebereit sein kann.
Folgende Arten von Pr黤ungen werden vorgenommen, wenn diese f黵 den InfoProvider relevant sind, auf den die [...]
Symptom
The Manage option through Context Menu in the InfoCube shows a request loaded with a yellow status and data is not available for reporting. The light remains yellow and the data never becomes available for reporting…
Other terms
yellow request
Reason and Prerequisites
A load into an Infocube was finished with success. The monitor shows everything [...]
Symptom
Error in Business Explorer Componenten like Analyzer, Browser, Formatted Reporting, Web Application Designer, Query Designer, Map, OLE DB for OLAP Provider
Other terms
Version, sapservX, Setup, Patch, Installation, Frontend, BW, Business Explorer, OCS
Reason and Prerequisites
.
Solution
General Information
This note contains information about NetWeaver 7.0 BI Add-On front-end
Support Package SP 8. It contains the most important information about:
o [...]
Symptom
You’ve configured a RRI jump to a R/3 transaction. If you do the RRI jump in the web the ITS window throws an error message like this:
Transaction RSBBS_WEB+RSRR_WEB-H is unknown
The issue occurs after applying a new support package to the R/3 target system.
Other terms
web RRI, transaction unknown, RSBBS_WEB+, ITS
Reason and Prerequisites
The issue is caused [...]