Hi,
I've configured a hierarchy - info_data(gender,age,region) and expecting whenever someone is clicking on Gender it'll show age and after clicknig on age it should show region. It is working fine but sometimes it gets messed up. While going to info_data and clicking on gender it's showing up region directly and after clicking on region it's showing up age which isn't expected. I am not able to figure out the reason behind it. And to restore all the things I need to get the server restart. it again starts to work pretty fine. Can someone please help me with this as I am pretty new to OBIEE and still learning it.