SAP Knowledge Base Article - Public

3409359 - Scheduled publication ignores SAP Business Warehouse time variables in SAP Analytics Cloud

Symptom

  • Scheduling the story as PDF delivers the .pdf report with the last saved prompt version.
  • It should show the previous calendar week.
  • In the prompt, the option "Keep last saved values for dynamic variables" is not enabled. 

Environment

SAP Analytics Cloud (Entreprise) 2023.16.10 

 

Reproducing the Issue

  1. Log on to SAP Analytics Cloud tenant
  2. Open a story that uses BW time variables
    Note that it opens in the previous calendar week (e.g. week 48)
  3. Switch to Edit mode
  4. From the toolbar click More (...) and then "Edit Prompts"
  5. Click on the model to edit the prompt
  6. On the "Set Variables" window note that the "Calendar Year/Week (Previous week)" is set to previous week (e.g. 48.2023)
  7. Delete this value and enter 36.2023 as new member
  8. Click "Set"
    Observe that the story is updated with values from week 36
  9. Save the story
  10. Switch to View mode
    Note that it opens in the previous calendar week (week 48)
  11. Click "File" and then "Schedule Publication" 
  12. Fill in the required information to schedule the publication
  13. Click "Edit Prompts" and note that the Calendar Year/Week (Previous week) is still set to 48.2023
  14. Click "Create"
  15. Check the publication in your email box and open it
    Note that it will open with with values from week 36 (week 36.2023)

Cause

The issue is under investigation by development.

Resolution

The issue is under investigation by development.

See Also

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

Keywords

SAP Analytics Cloud, SAC, BW, Time Variables, Previous, Week, Prompt, New, Old, Value, Schedule Publication, Email, Delivered, Got, Received, Updated. , KBA , LOD-ANA-SCH , SAC Story Scheduling and Publication , Problem

Product

SAP Analytics Cloud 1.0