SAP Netweaver Business Intelligence BI / BW

Symptom
Additions to the guidelines
Other terms
Partitioned tables, bitmap indexes, clustered indexes, Encoded Vector Index (EVI), SMIGR_CREATE_DDL, partitioning
Reason and Prerequisites
You want to copy an NW system homogeneously or heterogeneously using R3load.
A heterogeneous database migration to INFORMIX is not supported.
Solution
Contents
——1. General prerequisites for SAP kernel 6.402. Tasks before the export3. Tasks after the export4. Tasks after the import5. [...]

Symptom
Additions to the guidelines
Other terms
UNICODE conversion, partitioned tables, bitmap indexes, clustered indexes, Encoded Vector Index (EVI)
Reason and Prerequisites
You want to use R3load to copy a BW3.0B/3.1C system.
Note that as of 01.01.2007, BW3.0B/3.1C is subject to customer-specific maintenance. For more information, see Note 52505.
Solution
Contents
——1. General prerequisites for SAP kernel 6.202. Tasks before the export3. Tasks after [...]

Symptom
You want to upgrade your Microsoft Office to Office 2007 and you use Web layouts in Business Planning and Simulation (BPS) that use the Office Web Component (OWC).
Note that the OWC in Office 2007 is NO longer developed by Microsoft and is not part of the standard delivery. It is only delivered with [...]

Symptom
This note provides answers to the most frequently asked questions about MaxDB Update Statistics.
1. What is ‘Update Statistics’?2. What are table statistics and column statistics?3. What is an ‘UPDATE STATISTICS TABLE’?4. What is an ‘UPDATE STATISTICS COLUMN’?5. Is it useful to generate column statistics for non-indexed columns as a precaution?6. Why do I require optimizer [...]

Symptom
As of Release 7.02 or Release 7.01 Support Package 05, formulas can be switched to ready for input for input-ready queries in the Query Designer. In this case, rules must be defined with regard to how the system should invert an input-ready formula to the input-ready operands of the formula. Corresponding inverse [...]

Symptom
Loading the DataStore object 0DF_DS11 takes a disproportionately long time.
Other terms
RSA1, RSDFPS_EXT_INTERVAL_MERGE
Reason and Prerequisites
Implement the corrections from Note 1370387.
Solution
Implement the following corrections manually if the problem that was supposed to be corrected by Note 1370387 (update termination CX_SY_PROVIDE_TABLE_NOT_SORTED) still occurs. If this is the case, the DataStore object (DSO) contains overlapping time slices within [...]

Symptom
Data is not updated into the ODS when you load certain data records of the 2LIS_03_BF extractor.
Other terms
ODS, 2LIS_03_BF, 2LIS_03_UM, 2LIS_03_BX, 2LIS_40_S278, 0STORNO, ROCANCEL, RODMUPDMOD, 0RECORDMODE, Inventory Management, 0IC_C03,
Application 03, Logistics Extraction Cockpit, LBIW
Reason and Prerequisites
The 2LIS_03_BF extractor does not return any “connected” after and before images, as in the SD extraction, for example.
Originally, the [...]

Symptom
You wish to drilldown from the financial statement (Financial Datamart) or from the profitability analysis reports in BI to the corresponding documents in the Bank Analyzer and require information on how to set this up.
Other terms
Financial Datamart drillthrough Bank Analyzer BI_CONT Profitability Analysis
Reason and Prerequisites
Banking Services from SAP 6.0 (FSAPPL 200) or Banking [...]

Symptom
The range plan data that are not saved are lost when the user clicks on the create product button within the range plan.
Other terms
Assortment Plan, Range Plan
Solution
The following is the customizing correction for range plan view so that a popup for saving is shown before entering the create product view. Hence, preventing [...]

Symptom
This note contains questions that are frequently asked by SAP staff and customers.
It provides answers and refers you to other information sources.
The note is in no way complete.
1. Which information is written into the log area of the MaxDB database?2. What does the log configuration in a MaxDB database consist of?3. What do I need [...]

Symptom
Reorganizing workbooks can be necessary for the following reasons:
Variables cannot be deleted because they are being used in queriesQueries cannot be deleted because they are being used in workbooks…Workbooks are available in roles or favorites, but cannot be found in the document storage
However, the corresponding workbooks do not exist in any role and they [...]

Symptom
When lauchning an Xcelsius Dashboard from the NW BW system you receive the following error message:
com.sap.ip.bi.base.exception.BIBaseRuntimeException: The Web template
“0DASHBOARD_TEMPLATE” does not exist in the master system
Other terms
0DASHBOARD_TEMPLATE; RSTCO_ADMIN; Content Activation; Xcelsius
Reason and Prerequisites
Launching an Xcelsius Dashboard from the NW BW system requires the existence of the template 0DASHBOARD_TEMPLATE in active version (A).
Starting from NetWeaver [...]

Symptom
You have user(s) who have personalized variable values for a web application. You want to broadcast such a web application. You save broadcaster settings for this user with personalized variable values. Now these personalized values are changed by user himself or via other means. You expect the new value should be [...]

Symptom
You have users who have authorization to view reporting objects like queries, web templates, workbooks etc. You want to prevent these users from broadcasting this information. Although, these users donot have authorization object S_RS_BCS, they are able to broadcast these reports.
Other terms
Broadcaster, authorization.
Solution
The only authorization necessary for the online execution of [...]

Symptom
This note lists the Support Package Stacks that we recommend you use for SAP NetWeaver BI 7.0. The recommendations vary according to the different scenarios. This note is updated constantly (including areas that have already been described), therefore we recommend that you read the information described here regularly.
In addition, this note describes [...]

Symptom
Corrections/additions to system texts and documentation for objectc contained in the InfoArea Financial Services, release BI_CONT 705 sp01.
Other terms
BI Content for SAP Account Origination and SAP Leasing
Solution
Implement support package 1 for release BI_CONT 705.

Symptom
The field PLIKZ (plan/actual indicator) in profitability analysis is mapped to field WRTTP in the extract structure, the currency type in field PALEDGER is split to fields CURTYPE and VALUTYP. No selection is possible for these fields.
Other terms
PLIKZ WRTTP 0VTYPE CURTYPE VALUTYP PALEDGER
Reason and Prerequisites
The InfoObject 0VTYPE assigned to the plan/actual indicator of [...]

Symptom
You experience problems with create index or alter index rebuild online.
1. Create/Rebuild online reports the following ORA errors:
ORA-08104: this index object is being online built or rebuilt
ORA-08106: can not create journal table SAPR3.SYS_JOURNAL_2. A create/rebuild online locks the entire table.
A create/rebuild online does not use any CPU resources and appears to hang.3. The [...]

Symptom
Note: For BW 7.0, program’Z_RS_SCRSYSTEM_R3_CHECK’was completely revised due to the 7.0 DataSource. This was done with correction instruction 564599.As of SAPI Release PI_BASIS 2005_1_700, use only this version.
The source system already contains inconsistent IDoc segments or transfer structures. The process of generating transfer rules terminates with the following error messages:
EA 229, EA [...]

Symptom
SQL Server errors occur during BW processing like data loads, compression, or aggregate builds due to TEMPDB running out of space. The SQL Server specific errors are 1101 or 1105 and are found in the SAP System Log (transaction SM21) and the SQL Server Error Log.
SQL Error 1101 is:
Could not allocate [...]