Symptom
One of the following symptoms occur when using LargeString or LargeBinary attributes in a dimension of SAP Datasphere Analytic Model:
When deploying an Analytical Model in Datasphere an error message appears:
- The deploy fails:
"The deployment of AM was unsuccessful.
Error(s): Failed to execute a database statement for Artifact XX of type column store error: fail to create scenario: [34011] Inconsistent calculation model;calculationNode (finalNode) -> operation (SemanticQueryOp): semanticQuery doesn't support the lob datatype of attribute XX ,Details (Errors): - calculationNode (finalNode) -> operation (SemanticQueryOp): semanticQuery doesn't support the lob datatype of attribute XX [...]"; - A warning appears: "Attribute type from attribute " " in dimension source " " is not supported:
- In the preview the attributes are not present:
- Attributes are not visible as "Dimensions" in SAC while creation of SAC story.
Read more...
Environment
SAP Datasphere
Product
SAP Datasphere all versions
Keywords
LargeBinary, LargeString, LOB, attribute, preview, A SQL error happened. For details you could check on the SQL-Error-Code: 264 - invalid datatype, "cds.LargeBinary","cds.LargeString","hana.CLOB","cds.hana.CLOB", dwc , KBA , DS-MD-AM , Analytic Model , Problem
About this page
This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.
SAP Knowledge Base Article - Preview