3601106 - Date dimension of the Analytic Model in Datasphere cannot be found in the SAC story

• Date dimension(Data Type is Date or String) of the Analytic Model in Datasphere cannot be found in the SAC story when trying to add it to the row or column of a table. However, when previewing the same Analytic Model in Datasphere, the dimension is shown. The dimension has the "Semantic Type" set to "Calendar - Day."

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental." 

• SAP Analytics Cloud
• SAP Datasphere

1. Open the story in SAC.
2. Try to add it to the row or column of a table. Date dimension of the Analytic Model cannot be found.
   

The behavior is expected and works as designed. 

Previously, there was an issue where semantic types were incorrectly mapped, which caused other complications. Now that the semantic type mapping has been corrected, this default SAC story behavior functions as intended. 

To display the dimension in your SAC story, select one of the solutions below that best fits your scenario. Apply the chosen solution only to entities where the Semantic Usage is set to Dimension, not to those marked as Fact or Analytical Dataset.

• Set the Semantic Type of the dimension to "Calendar - Day of Year".
  
  Note: To achieve functionality when the dimension is intended to function like the Datasphere-generated time dimension, set the Semantic Type to "Calendar - Day of Year" for all columns representing a date where "Calendar - Day" was previously applied.
  
  
  
  
  
  
• Set the Semantic Type of the dimension to "None". 
  
  • Then, deploy the Analytic Model again to reflect the change.

dimension is missing, dimension is not shown, Calendar Day  , KBA , DS-MD , Modeling (Data Builder) , DS-MD-AM , Analytic Model , LOD-ANA-DES , Story Design & Visualizations , Problem

SAP Analytics Cloud all versions ; SAP Datasphere all versions