SAP Knowledge Base Article - Public

3481237 - Date format changes when blending 2 models using Live Direct Connection to BW/4HANA in SAP Analytics Cloud (SAC)

Symptom

In blended story data format is coming YYYY/MM/DD.

When the models are used individually, each one of them is showing as DD/MM/YYYY. 

Environment

 SAP Analytics Cloud (Enterprise) 2024.2.16

Reproducing the Issue

  1. Login into SAC;
  2. Go to the story with the blended models;
  3. See the data is YYYY/MM/DD;
  4. The expected date format is DD/MM/YYYY.

Cause

For Tables that blend using one or more BW models, the Table cells show the key for the Dimension. They should be showing the display key, as the non-blended equivalents do.

Resolution

The fix was deployed on patch 2024.8.20.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

Blend models, story, BW, data format, YYYY/MM/DD, DD/MM/YYYY.  , KBA , LOD-ANA-DES-BLEXDW , SAP Analytics Cloud Blending, Batch Export, Dynamic Images , Problem

Product

SAP Analytics Cloud 1.0