I have face a strange behaviour while implementing hierarchical prompt in obiee11g. I am using 184.108.40.206 version.
I hav 6 levels in my hierarchical prompt, and while previewing the data for column.
Till 3rd level its dispalying all child values under that parent but at 4th level while clicking sign its displaying a single value and then 'more' which is fine. But clicking 'more' on single click is not fetching me the child values,I have to click 'more' atleast 3-4 times to get the child values ,sometimes that also wont work.
Note: This works fine in report but having above issue in Dashboard prompt.
Please help. Are there any settings to make it work?