Symptom
The error below occurs in SAC Add-in for Office when trying to consume an Analytic Model with Hierarchy as Directory, directly connected to Datasphere:
---------------------------------------------------------
Error: Error [Server]: (#42350) Can not read view due to missing required capabilities : The view XYZ requires following capabilities: InAModelExternalDimension, MetadataHasExternalHierarchies
Error [Server]: (#42208) Can't read the view : XYZ::[INAMODEL], reason: : Missing required capabilties!
---------------------------------------------------------
Environment
SAP Analytics Cloud, add-in for Microsoft Office
Reproducing the Issue
Cause
This is a known error and the root cause was already identified.
Resolution
The fix is planned to be available in Calendar Week 50.
Until then, the users should not open a view with external hierarchy (i.e. hierarchy with directory) in SAC Add-in for Office.
See Also
Keywords
42350, 42208, Missing required capabilties , KBA , LOD-ANA-OF , SAP Analytics Cloud, add-in for Microsoft Office , Problem