Question:
Hi,
I have loaded GL hierarchies in my BW system. When I run a query either from RSRT or the browser, a lot of entries show under the 'not assigned' category. While I view the hiearchy from the hierarchy menu, it seems ok and there are no accounts showing under the not assigned category.Any ideas?
Cheers
Anand
Answer:
Hi Anand,
It is possible that the GL accounts in the results are accounts that are not defined in the hierarchy.
Drill down your report by GL account and check they exist in your hierarchy.
Regards,
David
Answer:
Thanks David.That was the case. I cried wolf too early I guess!!!
Cheers
Anand
Answer:
in the property of your Hierarchy, you tick the option to hide the non-assigned node, and it also improves performance in bw query.
Answer:
in the property of your Hierarchy, you tick the option to hide the non-assigned node, and it also improves performance in bw query.
Hi,
I couldn't see the hide option in the hierarcy properties.
please give me some tips
Thanks
Manjushri