SAP Knowledge Base Article - Public

3314696 - Total Location is not properly displayed after QRC upgrade for UDH enabled dimension in BW

Symptom

Total Location is not properly displayed in an SAP Analytics Cloud Table after QRC upgrade for UDH (Universal Display Hierarchy) enabled dimension based on a Live Data Connection to SAP BW

"Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental."

Environment

  • SAP Analytics Cloud Wave 2023.02 (QRC1) and higher
  • Live Data Connection to SAP Business Warehouse (BW)

Reproducing the Issue

  1. In BW Modelling Tools, create a BW Query with Universal Display Hierarchy active, with the Result Location set to "Right"
  2. Prior to the QRC1 Upgrade, observe that in SAP Analytics Cloud, Create a Story / Table based on the BW Query and observe the Totals Column is shown to the left
  3. After the QRC1 Upgrade, observe that the Totals column is positioned towards the right

Cause

Prior to the 2023.02 upgrade although the UDH was enabled in the query and the LowerLevelNodeAlignment was set to ‘default’ it was never respected by the BW server as the capability was never sent.

Resolution

We acknowledge that this was an issue earlier and with 2023.02 upgrade this issue was fixed.

See Also

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

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics,Error, Issue, System, Data, User, Unable, Access, Connection, Sac, Connector, Live, Acquisition, Up, Set, setup, Model, BW, Connect, Story, Tenant, Import, Failed, Using, Working, SAML, SSO, sapanalyticscloud, sap analytical cloud, sap analytical cloud, SAC, sap analyst cloud, connected, failure, stopped, sap analyst cloud, https://hcs.cloud.sap, https://hanacloudservices.cloud.sap, https://cloudanalytics.accounts.ondemand.com, https://hanacloudservices-us.accounts.ondemand.com, https://www.sap.com, https://help.sap.com, predictive analytics (analysis), data analysis (analytics) tools, analytics tools, sap analytics cloud, data literacy, advanced analytics, data democratization, analytics software, real time analytics, self service analytics, advanced data analytics, analytics as a service, analytics cloud / cloud analytics, saas analytics, cloud bi, enterprise planning, cloud data analytics, cloud based analytics, analytics cloud platform, modern analytics, real time analysis, cloud analytics solution(s), what is sap analytics cloud, cloud analytics tools, analytics in the cloud, cloud analytics software , KBA , LOD-ANA-LDC-BW , SAC Live Data Connection BW , LOD-ANA-TAB , Table , Problem

Product

SAP Analytics Cloud 1.0