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
- Logon to SAC tenant and open an existing model.
- Open Account > set Formula for one measure.
- Input LINK and select a model following guide:
https://help.sap.com/viewer/00f68c2e08b941f081002fd3691d86a7/release/en-US/c921b1cb94d146e6abd996286d0e0bf7.html - In the 3rd formula parameter(POV), click "Ctrl + Space" to open the suggestion list.
- Open Additional Dimensions and select one dimension.
- 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
- 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?
- 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 > Learning > Data Connections
- SAP Analytics Cloud > Learning > Guided Playlists
- SAP Analytics Cloud > Learning > Guided Playlists > Getting Support
- Need More Help? Contact Support or visit the solution finder today!
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