3625425 - Planning Deployment not working

Symptom

You are using planning model in SAP Analytics Cloud (SAC) to write data into SAP Datasphere local table.
While the planning model can be exposed, the local table in the connected SAP Datasphere cannot be deployed.

The error message encountered during deployment is:
`Failed to Deploy "<table>" in "<space>". Execution of a database statement for artifact '<table>' failed with error: invalid column name: <column>: line 2 col 3 (at pos 81).`

Environment

SAP Datasphere
SAP Analytics Cloud

Reproducing the Issue

Create a planning model and public dimensions in SAP Analytics Cloud.
Use the connected SAP Datasphere as the storage location for the planning model and dimensions.
Deploy the local table in SAP Datasphere.

Cause

The issue arises due to the use of older SAP-provided content (over 8 years old) that includes public dimensions with outdated naming conventions. The column names in the CSN are incorrectly formatted, leading to deployment failures.

Resolution

Two options to resolve the issue:
1. Create new dimensions and models from scratch.
2. Wait for a fix scheduled for release on 19th July.

Keywords

KBA , DS-MD-TAB , Tables , LOD-ANA-ML-CM , Cube Management , Problem

Product

SAP Analytics Cloud all versions