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

[former_member1235502]

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.

[swati_gawade]

Hi Venkata,

first of all reconcile your data with the infoprovider to confirm that these nodes will have diffrnt data under each node.

Refresh your hierarchy (try to delete these nodes and reload again if possible)

Refresh your query as well and check key figure definition and check the way data is being calculated.

Hope this helps.

-Swati.

[former_member1235502]

Hi Swati,

This is not a loaded hierarchy.

The hierarchy is manually created in BW system.

I checked that data with the cube and noticed that the values of the nodes which use external characteristic(Function), under which some departments are common for the nodes which use external characteristic.

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.