How To Fix R7B318 - Do not select template and "based on ..." at the same time

R7B318 - Overview

• Message type: E = Error

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

• Message number: 318

• Message text: Do not select template and "based on ..." at the same time

What causes this issue?

You have specified a template for the HybridProvider to be created. You
have also selected the option <LS>Based on DataStore</> or <LS>Based on
VirtualProvider</>.
This is not advisable because the HybridProvider structure can only be
derived from one single template InfoProvider.

System Response

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

How to fix this error?

Specify
either a template or
an existing InfoProvider (DataStore object, VirtualProvider) to be
integrated into the HybridProvider.

Procedure for System Administrators

Error message extract from SAP system. Copyright SAP SE.

Smart SAP Assistant

• What is the cause and solution for SAP error message R7B318 - Do not select template and "based on ..." at the same time ?

  The SAP error message R7B318, which states "Do not select template and 'based on ...' at the same time," typically occurs in the context of SAP BW (Business Warehouse) or SAP BI (Business Intelligence) when you are trying to create or modify a query or report. This error indicates that there is a conflict in the selection criteria you are using.
  
  Cause:
  The error arises when you attempt to use both a template and a "based on" option simultaneously in a query or report. In SAP BW, templates are predefined settings that can be applied to queries, while the "based on" option allows you to create a new query based on an existing one. The system does not allow both options to be selected at the same time because they serve different purposes and can lead to ambiguity in the query definition.
  
  Solution:
  To resolve this error, you need to ensure that you are