How To Fix UMC068 - No InfoCube found as data source

SAP Error Message - Details

• Message type: E = Error

• Message class: UMC - General Messages

• Message number: 068

• Message text: No InfoCube found as data source

What causes this issue?

No InfoCube was found as a possible data source.

System Response

BW queries are only supported as data sources if the 'release for OLE
DB for OLAP' flag was set. Therefore, the system only makes available
for selection those Info Cubes for which there is at least one BW query
with this flag.

How to fix this error?

Set the flag in the BW for the queries that you want to use as data
sources.

Procedure for System Administrators

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 UMC068 - No InfoCube found as data source ?

  The SAP error message UMC068 "No InfoCube found as data source" typically occurs in the context of SAP BW (Business Warehouse) or SAP BW/4HANA when a query or data extraction process is trying to access an InfoCube that does not exist or is not properly configured. Here are the potential causes, solutions, and related information for this error:
  Causes:
  
  Non-existent InfoCube: The specified InfoCube does not exist in the system.
  Incorrect Query Definition: The query may be referencing an InfoCube that has been deleted or renamed.
  Authorization Issues: The user may not have the necessary authorizations to access the InfoCube.
  Transport Issues: If the InfoCube was recently transported from another system, it may not have been properly activated or configured in the target system.
  Data Source Configuration: The data source may not be correctly configured in the InfoProvider settings.
  
  Solutions:
  
  
  Verify InfoCube Existence:
  
  Check in the SAP BW system to ensure that the InfoCube exists. You can do this by navigating to the InfoProvider list in the SAP BW modeling tools.
  
  
  
  Check Query Definition:
  
  Review the query definition in the BEx Query Designer to ensure that it is pointing to the correct InfoCube. If the InfoCube has been renamed or deleted, update the query accordingly.
  
  
  
  Authorization Check:
  
  Ensure that the user executing the query has the necessary authorizations to access the InfoCube. This can be checked in the user roles and authorizations.
  
  
  
  Transport Validation:
  
  If the InfoCube was transported, ensure that it has been activated in the target system. You may need to re-activate the InfoCube or check for any transport errors.
  
  
  
  Data Source Configuration:
  
  Go to the InfoProvider settings and verify that the data source is correctly configured. Ensure that the InfoCube is set as a data source for the query.
  
  
  
  Check for Data Loading Issues:
  
  If the InfoCube exists but has no data, ensure that the data loading process has been executed successfully. Check the data load logs for any errors.
  
  
  
  Related Information:
  
  Transaction Codes: You can use transaction codes like RSA1 (Data Warehousing Workbench) to manage InfoCubes and check their status.
  BEx Query Designer: Use the BEx Query Designer to modify and test queries.
  Authorization Objects: Check authorization objects related to InfoCubes, such as S_RS_COMP and S_RS_AUTH.
  SAP Notes: Search for relevant SAP Notes in the SAP Support Portal that may address specific issues related to this error message.
  
  By following these steps, you should be able to identify and resolve the issue causing the UMC068 error in your SAP BW environment.