SAP Knowledge Base Article - Public

3050667 - How to change the date format of a Model variable based on a live BW connection in Dynamic Text in SAP Analytics Cloud?

Symptom

The date format of a model variable based on a live BW connection in Dynamic Text is "MM DD, YYYY".

Environment

SAP Analytics Cloud

Reproducing the Issue

  1. Create a Model include date format variable based on BW live connection.
  2. Create a story and add Text to the story canvas.
  3. Click Input Control, add the Model which is created in the first step.
  4. Click Text->。。。> Add->Dynamic Text.
  5. Click Model Variables.
  6. Select a date variable.
  7. Create.
    >>Notice that the date format is "MM DD, YYYY".

Cause

This is a by design behavior.

Resolution

  1. Navigate to Profile -> Profile settings.
  2. Click on "Edit".
  3. Change Date Formatting to the desired format.
  4. Click on Save and close the button .
  5. Open the story and check date format again.
    >>The date format will be changed as desired.

Keywords

KBA , LOD-ANA-DES , Story Design & Visualizations , How To

Product

SAP Analytics Cloud 1.0