I am using Analysis for Office 2.1 SP2 , and while trying to slice and dice a HANA information view in AFO I am getting the error : ' 'Caught exception: exception 42733: The dependent element was not found: :'
Steps to recreate the issue are
I have a HANA calcualtion view with a calculated column which considers 'date field' in it for a calculation , the expression is correct and the data is showing up in HANA studio - Data preview .
How ever when I am using same calculation view in AO , in the first instance all the measures are coming up as expected. ( aggregated values)
When I drag any dimension into the report then the attached error comes up . I made sure all the fields considered in the calculated column are coming up with some value.
I cross checked if this is a data issue with Analysis for OLAP tool , surprisingly I am able to view the data slice and dice it with dimensions in the OLAP tool.
The wierd part is when I remove the calculated column which consumes the date field the AO for excell is working fine and allows me to slice and dice the data.
Any suggestions/ workarrounds how to overcome this error?