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
SAP Knowledge Base Article - Public