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
- 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
- 2851317 - Where can I find more information on SAP Analytics Cloud (SAC) for Planning features and documentation?
- 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 incident for SAP Analytics Cloud?
- 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.
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