SAP Knowledge Base Article - Public

3342102 - Error Caught exception : exception 42201: Column not found - SAP Analytics cloud

Symptom

After the QRC2 upgrade, calculated measure fails with the below error:

Calculation Preview is not available due to the following reasons:
Error [Server]: (#42014) Caught exception : exception 42201: Column not found

Environment

  • SAP Analytics Cloud (SAC)

Reproducing the Issue

This is identified as a product defect.

Resolution

A fix will be released soon for this issue.

Workaround:

- Instead of using Average Exception Aggregation, use AverageNull.

Or

- Add the filter column to drill.

See Also

Your feedback is important to help us improve our knowledge base.

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics, currency conversion, restricted measure, CC, unit, EA, last, first, AVG, Cur, EUR, USD , KBA , LOD-ANA-CC , SAC Currency conversion , Known Error

Product

SAP Analytics Cloud 1.0