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
• SAP NETWEAVER BW 7.5 SP18

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.

• 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
• Have a question? Ask it here and let our amazing SAP community help! Or reply and share your knowledge!
• 2487011 - What information do I need to provide when opening an case for SAP Analytics Cloud?
• 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
• Search for SAP Analytics Cloud content using Google or Bing:
• https://www.google.ca/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
• https://www.bing.com/search?q=site%3Ahttps%3A%2F%2Fapps.support.sap.com+SAP+Analytics+Cloud
• Note: Add relevant text or warning/error messages to the text search field to filter results.
• SAP Analytics Cloud Connection Guide
• Getting Started with SAP Analytics Cloud Expert Community page
• SAP Analytics Cloud Get More Help and SAP Support
• Need More Help? Contact Support or visit the solution finder today!

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