SAP Knowledge Base Article - Public

3488081 - Specific dimension is not listed when trying to create a Link Dimensions feature in SAP Analyitcs Cloud (SAC)

Symptom

  • Specific dimension is not listed when trying to create a Link Dimensions feature in a SAC story based on live data connection to Datasphere.
  • This was working before.

Environment

  • SAP Analytics Cloud (Enterprise) 2024.8.16
  • SAP Datasphere 2024.11.1

Reproducing the Issue

  1. Login to SAC.
  2. Create a new ODE story based on live data connection to DS.
  3. Insert a chart/table.
  4. Try to create a Linked Dimensions between two DS datasets:
    • Tools - Linked Dimensions and select as models the datasets: DATASET1 and DATASET2
    • Search for the dimension [Test Dimension] => dimension is not present in the list.

Cause

The root cause of the issue is due to a logic flaw where a dimension has a hierarchy and an attribute/property which have the same id/name. In the case of the [Test Dimension] dimension there is an attribute named e.g. "TOTAL_HIER" as well as a level-based hierarchy named "TOTAL_HIER".

Resolution

  • Workaround: changing the id/name of either the attribute or hierarchy would enable the dimension to show-up in the "Link Dimensions" dialog. 
  • The issue is fixed in a future** version of SAP Analytics Cloud.
  • Please refer to maintenance document.

** in version 2024.08 (client side patch) for customers on a bi-weekly (fast track) release cycle.
** in Q3 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.

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.saphttps://hanacloudservices.cloud.saphttps://cloudanalytics.accounts.ondemand.comhttps://hanacloudservices-us.accounts.ondemand.comhttps://www.sap.comhttps://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 epm, business intelligence , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0