Skip to Content
Former Member
Oct 13, 2015 at 03:02 PM

AO 2.1 SP2 Error - 'Caught exception: exception 42733: The dependent element was not found: :'


Dear All,

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?

Error Screenshot:


Sindhoora Leburi


Untitled.png (8.5 kB)