I have a problem when I drill down through a hierarchy...
imagine this hierarchy: year > half > quarter
I start the report only with the year column and click to drill... naturally OBIEE opens the half column and then I can press on the year column again to make another dill or I can press on the half column to drill, both this options open the desired column (quarter) but in different ways:
if I press the year column again the report shows:
year > quarter > half
and if I press the half column the report shows:
year > half > quarter
and this second behavior is what I need! Is there any way to get the second behavior when pressing the year column?
I don't think its possible too... but I have a client that has this requisite in a project so I'm trying to find a definitive answer whether that can be done or not. Thanks! If I find an answer I'll share it!