3033718 - Unable to link two models in SAP Analytics Cloud (SAC) & SAP Digital Boardroom

The following behavior occurs in SAP Analytics Cloud (SAC):

• Cannot link two models

• SAP Analytics Cloud (Enterprise) 2021.2

   - Create three XLSX files:   
     1.A   primary-main.xslx with fields:   STORE (D) , SALES REVENUE (M)
     1.B  secondary-no-measure.xslx with fields:     STORE (D) , ANOTHER COLUMN (D)
     1.C  secondary-with-measure.xslx with fields:     STORE (D) , ANOTHER COLUMN (D),  QUANTITY (M)

1. From main SAC menu select Create - Story
2. Select "Access and Explore Data"
3. Select above xlsx 1.B   (secondary-no-measure.xslx with fields:     COUNTRY (D), STORE (D), MANAGER (D), ANOTHER COLUMN (D)
4. Click on add another Model
5. Select above xlsx 1.A   (primary-main.xslx with fields:   STORE (D) , SALES REVENUE (M) )
6. Create a table
7. Click on Add linked model
8. Select the secondary model
9. Link the Dimensions  STORE-STORE
10. Add to the rows one or more Dimensions from secondary model:
    Country, Store Manager, rows come with (null) values

This is currently being investigated by development

This is currently being investigated by development

Workaround: add a column in the source file with a dummy measure

• 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 > 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.

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