I am currently working in a BW 3.5 environment.
I have built a hierarchy in BW for 0ACCOUNT. My hierarchy is activated, and I have run an attribute change run to make sure everything is up to date.
In Query Designer, I am building a selection on the hierarchy to restrict by a leaf (0account). To build the selection, i created a selection and chose the leaf node from the hierarchy. When I compile the query, i get the following error message in query designer:
"Node PROG0000410000 is not in hierarchy Z_OPS1 for InfoObject 0ACCOUNT"
I looked at hierarchy in bw and node PROG0000410000 exists (I even selected it from the hierarchy when building the restriction).
When I execute the query, i get no warnings or errors... the value for the selection I created is equal to an 'X'. Other selections I have built on the hierarchy work fine.
Has anyone encountered a similiar problem before?