SAP Knowledge Base Article - Public

2996773 - There's no value to select in Additional Dimensions of LINK formula in SAP Analytics Cloud (SAC) while linking models

Symptom

There's no value to select in Additional Dimensions of LINK formula in SAP Analytics Cloud (SAC) while linking models

Environment

SAP Analytics Cloud (Enterprise) 

Reproducing the Issue

  1. Logon to SAC tenant and open an existing model.
  2. Open Account > set Formula for one measure.
  3. Input LINK and select a model following guide:
    https://help.sap.com/viewer/00f68c2e08b941f081002fd3691d86a7/release/en-US/c921b1cb94d146e6abd996286d0e0bf7.html
  4. In the 3rd formula parameter(POV), click "Ctrl + Space" to open the suggestion list.
  5. Open Additional Dimensions and select one dimension.
  6. Find no values showing as selection.

Cause

The syntax of the member formula "Model Link" does not allow to have local dimensions with the same name in both linked models, because technically they are two different dimensions, but they cannot be distinguished by the formula.

Resolution

  • This problem can be solved either by renaming the dimension in one of the models or by replacing both with one public dimension.
  • Since dimensions in the SAP Analytics Cloud cannot be renamed or replaced in an existing model, it is necessary to recreate at least one of the models.

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 , KBA , LOD-ANA-DES , Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0