BEx Hierarchy issue in Webi
I have created an hierarchy on BI side,and I am making a P/L and Balance sheet report on top of BEx query in Webi, now i have an issue regarding suppressing the nodes.
I have given an input control for Year in both the reports.As soon as i select any year from the input control all the nodes of hierarchy gets opened up. My question is how can i suppress nodes or show only the top level in the hierarchy and other levels closed in the report? And also i have kept the hierarchy column in bold fonts, so can i format it in a way like only the highest member to be kept in bold and others in Regular fonts?