SAP Knowledge Base Article - Public

3249170 - Model blending will result additional zeros for dimension values in SAP Analytics Cloud (SAC)


  • The dimension values will get additional zeros, when browser based blending is used in a SAC story table. 
  • When two live models are linked in a table, the representation of the members of a dimension is changing to the internal format: the members will get additional zeros (e.g. 00012345 instead of 12345).


  • SAP Analytics Cloud (Enterprise) 2022.15.08

Reproducing the Issue

  1. Login to SAC.
  2. Create a story and insert a table based on the live model e.g. [Model name1].
  3. Check the columns => values are showed without zeros e.g. 12345.
  4. Now go to Designer - Builder - Add linked models - Add model e.g. select another live model [Model name2] - link by dimension via ID.
  5. Add to table rows a dimension from the linked model [Model name2].
  6. Check the columns in the table => values are showed with additional zeros e.g. 0000012345.


The issue is caused by a defect in the product.


  • The issue is fixed in a future** version of SAP Analytics Cloud.
  • Please refer to maintenance document.

** in version 2023.03. for customers on a bi-weekly (fast track) release cycle.
** in 2023 QRC2 for customers on a Quarterly release cycle (QRC).

This Knowledge Base Article, SAP‘s strategy, and possible future developments are subject to change and may be changed by SAP at any time for any reason without notice.
This document is provided without a warranty of any kind, either express or implied, including but not limited to, the implied warranties of merchantability, fitness for a
particular purpose, or non-infringement.

See Also

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


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,, 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-DES , Story Design & Visualizations , LOD-ANA-LDC-BW , SAC Live Data Connection BW , Problem


SAP Analytics Cloud 1.0