SAP Knowledge Base Article - Public

3200495 - When updating a BW Query to display reverse sign, the values in Table based on the BW Query does not change sign in SAP Analytics Cloud (SAC)

Symptom

  • Table not displaying the correct values.
  • Updating a BW Query to display "Reverse Sign", does not change the values of the Table widget on existing Story. 
  • When updating an SAP BW Query to display "Reverse Sign" for the Key Figure, the Table based on the BW Query in SAP Analytics Cloud, does not reverse the sign.

Environment

  • SAP Analytics Cloud

Reproducing the Issue

  1. In Bex Query Designer, create an SAP BW Query with 2 Structures.
  2. In SAP Analytics Cloud, create a BW Live connection to the SAP BW Query with 2 Structures.
  3. Create a Story, and add a Table, and a Chart on the SAP BW Query with 2 Structures.
  4. Save the Story.
  5. In Bex Query Designer, edit the SAP BW Query with 2 Structures, and set the Key Figure to display "Reverse Sign"
  6. In SAP Analytics Cloud, open the Story again, and notice the measure sign is not reverse on the Table, but it is reverse as expected on the Chart.

Cause

  • SAP Analytics Cloud stores some meta data of the SAP BW Query locally in the visualizations and in the Story. When changing the  SAP BW Query, the locally stored meta data cannot be updated, resulting in the change made in the BW Query not reflected in the Story.

Resolution

  • The Story needs to be re-created to pickup the change made in the SAP BW Query.
           
  • For reference, see SAP Note:
       
    2789695 - Considerations when changing backend data models used in SAP Analytics Cloud (SAC) 

See Also

Keywords

SAC , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0