There will be different business requirements that to display a report in hierarchical manner and in the same way business need Spend reports with the Navigation hierarchies to display in the same tab page rather than opening in new tab.
For ex: We have created a navigation hierarchy using the Time dimension or we are using the standard “Time Dimension” hierarchy in any report. Once we drill down to different levels we are able to see the drilldown details in the same tab page.
In the above screen we are able to see a report in the Tab page “Trend by Time” and with time 2011 and 2012 which is a Year.
Now If we drilldown the report further on Year 2011 we are able to see further details in the same tab page.
However, suppose we create a custom navigation hierarchy using Company code and Plant. We will execute a report “Trend by Company code” as shown below. Now we are able to see the Time and Company code navigation hierarchy.
In the above we have seen the report opened or shown the details in the same tab page when we drilldown time hierarchy. Now We’ll drilldown further for Company code and we are not able to see the details in the same tab page “Trend by Company code” however it is opened in another tab, as shown below, rather than opening in the same tab page with the “Time, Company code (filtered one only) and Plant.
The reason for opening in new tab is the Company code and the Plant are not created as Grouping Dimension.The drilldown of Navigation hierarchy object will open the reports in the same tab page when we have created the hierarchical dimensions under group dimension. If there is no grouping of dimensions then the report will get opened in another tab page but will not display the report unless we click “Run Report” push button manually.