Error in Measure columns – Hierarchy field
We have faced one issue in OLAP Report. Just thought of sharing the details with you all.
Report : OLAP Report
Backend : HANA
I was getting an error in Measure columns when i pulled the Hierarchy field in to the Report column. For other normal fields, the measure values were displaying properly. Only when we pull the hierarchy field, we got this error.
The above issue is because of the Calculated Key figures in HANA View.
Solution: We need to move the Calculated Key figures in to Projection level in HANA view.