SAP Knowledge Base Article - Public

3039720 - Error "Caught exception : exception 42556: Extended dimension processing error : Can't read view" occurs in SAP Analytics Cloud (SAC)

Symptom

The following error occurs in SAP Analytics Cloud: "Caught exception : exception 42556: Extended dimension processing error : Can't read view".

Environment

  • SAP Analytics Cloud (Enterprise)
  • HANA Live Connection

Reproducing the Issue

  1.  Open Story based on Live Data Connection.
  2.  Create a chart with calculations.
  3.  Observe the Error Message.

Cause

This issue is currently under investigation by development.

Resolution

This issue is currently under investigation by development.

Workaround (must be applied on the system level):

ALTER SYSTEM ALTER CONFIGURATION('indexserver.ini', 'SYSTEM') set ('mds', 'prequery_keep_internal_table') = 'false' with reconfigure;

 

Some information about the workaround: this parameter switches off an optimization applied on calculated dimension processing (MDS-side pre-caching),

which can lead to potential performance degradation for stories with "heavy" calculated dimensions - where same calculated dimensions are used across multiple charts / tables.

See Also

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

Keywords

Live, HANA, Calculations, render, chart, table, dimension, Caught exception : exception 42556: Extended dimension processing error : Can't read view, exception, 42556,  exception 42556, Extended dimension processing error , KBA , LOD-ANA-DES , Story Design & Visualizations , LOD-ANA-DES-CAL , SAC Story Calculations , LOD-ANA-LDC-HAN , SAC Live Data Connection HANA , Problem

Product

SAP Analytics Cloud 1.0