Skip to Content
0
Former Member
Jul 23, 2016 at 05:02 PM

Choosing a hierarchy structure based on a selected fiscal year in a Bex report

50 Views

Hello BW/Bex experts, I have a hierarchy master data with 2 hierarchies in the source system. One for the current year (myDimension_HIER_2016) and another for the previous year say myDimension_HIER_2015. I have loaded both hierarchies in BW under myDimension characteristic. The structures for the 2 hierarchies are different, but they are both linked to the same transaction table with data for both 2015 and 2016. In my Bex Report, I added a filter on the time dimension which allows the user to choose the fiscal year of analysis. The behavior I would like to see is the following : If a user selects fiscal year 2016 for analysis, the system should show the 2016 transaction data and show myDimension_HIER_2016 hierarchy structure from my myDimension. If a user selects fiscal year 2015 for analysis, the system should show the 2015 transaction data and show myDimension_HIER_2015 hierarchy structure from my myDimension. Thanks in advance for your inputs. JHN