Skip to Content
May 04, 2016 at 09:35 AM

BW Hierarchy Issue - Nodes using External Char doesn't restrict the data


We are facing an issue with Hierarchy, DIV_FUNC_DEPT_HIER (Functional Hierarchy) on custom O ZC_DEPT This is a manually created Hierarchy. There are 2 external characteristics (ZC_DIVISN and ZC_FUNCTN) used in this hierarchy. There are few depts. that are common across few functions and this is causing data issue in the query output. Though the departments are under a particular function node the data in query output doesn’t get filtered for that specific function, rather data of all functions are displayed. This results in same values being repeated under each of the Function of sales and marketing division. Appreciate if the issue can be analysed and let us know the reason for such behaviour of the hierarchy. Please suggest how to fix the issue.