SAP Knowledge Base Article - Public

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

Symptom

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

  • Cannot link two models

Environment

  • SAP Analytics Cloud (Enterprise) 2021.2

Reproducing the Issue


   - 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

Cause

This is currently being investigated by development

Resolution

This is currently being investigated by development

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

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 , Model, Story Design & Visualizations , Problem

Product

SAP Analytics Cloud 1.0