What should I do, if … ? (SAP Library - SAP Open Information Warehouse)

What should I do, if … ?

This section advises you on what to do in certain unexpected situations.

OIW error message "Cannot create state tables" when loading the OIW Add-in

Some of the ActiveX Component required by the OIW Frontend for Excel are not correctly installed. Please check this after reading the section on Installation.

Once the OIW Add-in has been loaded, Microsoft Excel does not respond to double-clicks anymore.

When the OIW Frontend for Excel is loaded, it activates the SAP double-click mode and in this way disables the normal double-click mode of Microsoft Excel. You can return to the previous double-click mode by deactivating the SAP double-click mode manually. The switch to do this can be found in the OIW-specific part of the Data menu.

For more information on the SAP double-click mode, please refer to section Creating and Displaying Relationships in Queries.

OIW message "Query result did not fit into area …"

Please read the section on What Should I Do if the Result Area is too Small?.

Recalculating OIW queries delivers unexpected results or takes unusually long

The section on Recording a Trace File tells you how to gain a better understanding of the OIW Add-in’s activities. Also, you may analyze your worksheet using the Show relationships function (viz. Creating and Displaying Relationships in Queries).

Excel error message "This document contains links. Reestablish links?" when loading an Excel workbook containing OIW queries.

Answer "Yes" and see whether the next error message is "SAPWarehouseRead … not defined or too complex". If not, then the problem is probably not related to the OIW Frontend. Otherwise please check:

first, whether the OIW Add-in has been loaded at all, and
then, whether you can solve the problem by choosing Redirect links from the Data menu.

For a more detailed explanation please refer to the section Repairing Outdated Links.

OIW error message "Query is inconsistent: …" when trying to change an existing OIW query

The query’s structure is not valid with respect to the version of the OIW Catalog that is currently used by the OIW Frontend. When the query was defined, a different OIW Catalog must have been active. It might be possilbe to solve the problem by updating the local OIW Catalog from R/3 using the pushbutton Refresh Catalog.

Please note that the OIW Catalog can be filled quite differently in different R/3 Systems, and that a query can only be successfully run against a certain R/3 System if it is consistent with respect to this system’s OIW Catalog.