How To Fix R7B670 - InfoCube &1 is not SAP HANA-optimized, but only has an F-fact table

R7B670 - Overview

• Message type: E = Error

• Message class: R7B - BW Metadata (InfoCube, InfoObject, InfoObject catalog)

• Message number: 670

• Message text: InfoCube &1 is not SAP HANA-optimized, but only has an F-fact table

What causes this issue?

InfoCube &V1& is not a SAP HANA-optimized InfoCube according to its
metadata (cube subtype = ''), but only has F-fact table &V2& and a
P-dimension table.

System Response

The check on InfoCube &V1& returned an error. InfoCube &V1& cannot be
activated.

How to fix this error?

Try to identify the root cause of the changed cube subtype and adjust it
accordingly.

Procedure for System Administrators

Activating an InfoCube where its cube subtype is not '', but it is
actually SAP HANA-optimized (it does not have dimension tables or
compressed E-fact tables) results in data loss during DDIC activation of
the F-fact table. During DDIC activation, the ABAP Database Utility SE14
will run because the F-fact table contains data. As the data types of
the F-fact table columns will be changed, data loss occurs.

The system issues an error message and will not allow you to continue with this transaction until the error is resolved.

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message R7B670 - InfoCube &1 is not SAP HANA-optimized, but only has an F-fact table ?

  The SAP error message R7B670 indicates that the InfoCube you are trying to use is not optimized for SAP HANA and only contains a fact table of type "F" (which typically refers to a standard fact table in BW). This can occur when you are attempting to run queries or perform operations that require HANA-optimized structures, but the InfoCube does not meet those requirements.
  
  Cause:
  
  Non-Optimized InfoCube: The InfoCube is not designed to leverage the capabilities of SAP HANA. It may be an older InfoCube that has not been converted or optimized for HANA.
  Fact Table Type: The presence of only an F-fact table indicates that the InfoCube is not using the optimized data structures that are available in HANA, such as the use of "C" (characteristic) and "D" (data) tables in a HANA-optimized InfoCube.
  Query Execution: The error may arise when executing queries that expect HANA-optimized InfoCubes, which can lead to performance issues