SAP Knowledge Base Article - Public

2868982 - Exception 42201 in SAP Analytics Cloud

Symptom

The following error message occurs in SAP Analytics Cloud (SAC):

  • Caught exception : exception 42201: Column not found : aSrcName=, ([Column D_CLIENT/!EMPTY (string)]) in view [MDView id: 351, description: Aggregation of measures groupId=0 (Aggregation of data source (measures, no currency/units)), columns: [D_ANALYTIQUE, D_ANALYTIQUE.ID, D_CLIENT.ID, D_COMPTE.ID, D_GENERIQUE.ID, D_INTERCO.ID, D_LIGNE_BUD.ID, D_ORGANISATION.ID, D_SOURCE.ID, SignedData, SignedData__\$\$MaxCellVersion\$\$, SignedData__\$\$MinCellVersion\$\$, TEMPS.CALMONTH, Version, [D_COMPTE]]]; columns(15)=[D_ANALYTIQUE, D_ANALYTIQUE.ID, D_CLIENT.ID, D_COMPTE.ID, D_GENERIQUE.ID, D_INTERCO.ID, D_LIGNE_BUD.ID, D_ORGANISATION.ID, D_SOURCE.ID, SignedData, SignedData__\$\$MaxCellVersion\$\$, SignedData__\$\$MinCellVersion\$\$, TEMPS.CALMONTH, Version, [D_COMPTE]]

This error message will appear when the users are using a restrict formula to lookup account members, then when they go to add in another dimension, they are facing the error message as shown above.

Environment

  • SAP Analytics Cloud 2019.22.2

Reproducing the Issue

  1. Log into SAP Analytics Cloud Platform
  2. Check your account members with a restrict formula. 
  3. See that the account hierarchy is working fine. 
  4. Go to add in another Dimension
  5. See that it's not added
  6. Observe that above error message is displayed. 

Cause

This issue is currently under investigation by Development.

Resolution

This issue is currently under investigation by Development.

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 , KBA , LOD-ANA-BI , Business Intelligence Functionality, Analytic Models , Problem

Product

SAP Analytics Cloud 1.0