I am trying to use EVPRO(evapp(),"Member","Partenth1") to get the Parent of any member. But it is returning #NODATA
Why is it failing? When I am trying to get "ID" or any other property value using EVPRO, it is sucessful. But for ParentH1 value, it returns #NODATA....
What's the solution...Or Is there any other method to get parent of any member.