SAP Knowledge Base Article - Public

3667201 - Cannot deploy Analytic Model in Datasphere

Symptom

Try to deploy an Analytic Model in Datasphere.

The deployment fails with an error that starts similar to the following:

Failed to Deploy "<model_name>" in "<space_name>"

Deployed (or no changes) for 2 Objects. Review the following errors: "<model_name>" - Execution of a database statement for artifact '<model_name>' failed with error: column store error: fail to create scenario: [34011] Inconsistent calculation model;calculationNode (PROJECTION_0) -> inputs -> input (<view_name>) -> mappings -> mapping (<column_name>): Mapped source attribute <column_name> is missing in node <view_name>,Details (Errors): -
etc

Environment

  • SAP Datasphere

Reproducing the Issue

Try to deploy a new Analytic Model.

Cause

The character "/" is invalid for technical names in Datasphere. 

However if you create an artifact (view, table) in Datasphere by importing a CSN/JSON file, and some of the elements contain the character in their technical names, Datasphere will keep the invalid character in the names.

For example, if you create a View in Datasphere by importing a CSN file, and some of the columns contain "/n" in the name, Datasphere will keep the "/n" in the technical name, but not show it in the UI.

This will prevent the deployment of the Analytic Model that uses that View

The same applies to the combination "\n".

Resolution

From the Analytic Model, go to the underlying tables or views.

Use the functionality Export -> Export to CSN/JSON file.

Review the content of the CSN/JSON file. Look at the names of the columns, etc. Check if they contain the character combinations "/n" or "\n".
As explained, these character combinations are prohibited, but they are also invisible in the fields in the Datasphere UI, and can only be observed in the exported CSN/JSON file.

Proceed to rename those columns in the corresponding view/table and remove those character combinations. Then proceed to deploy the objects again.

Keywords

KBA , DS-MD-AM , Analytic Model , Problem

Product

SAP Datasphere all versions