There is a data mismatch between BW Query and SAP Analytics Cloud (SAC).
You would like to have dimension members to be defaulted (e.g. current year and month) for the prompt, however the defaulted prompt values are overwritten with the last saved values in Story and/or bookmark level.
SAP Analytics Cloud 1.0.
BW Live Connection.
Reproducing the Issue
You are creating a new Story based on live BW connection and the BEx query has defaulted prompt values.
This is how a product is intended to work.
It is the default behavior of SAP Analytics Cloud to save the variable values, which were entered in the prompt, with the story. When later coming back to the same story, those values will be loaded and used.
The default values from the query are then ignored. An exception to this are "Exit" variables.
If you have an enhancement idea / feature request for an SAP Cloud Product that you would like to share with product management and/or other customer a feature request could be created. For more information please see KBA 2424376 - How do you create an enhancement request for SAP Analytics Cloud?
SAP KBA 2424376 - How do you create an enhancement request for SAP Analytics Cloud?
SAP KBA 3006315 - How to submit a Feature Requests / Enhancement ideas for SAP Cloud Products
Story tables, values is not match, overwrite, BW Live Connection, BEx query , KBA , LOD-ANA-LDC-BW , SAC Live Data Connection BW , Problem