Skip to Content
Former Member
Oct 19, 2005 at 08:06 PM

Best way to maintain the reverse (+/-) sign indicator on hierarchy nodes?


I would like some advice about maintaining the reverse (+/-) sign indicator on hierarchy nodes. I am working with 0ACCOUNT hierarchy. I have adjusted 0ACCOUNT infoobject hierarchy properties so that the reverse sign for nodes is checked true. I have built the appropriate replacement path variable and added it to my queries. When I set the reverse sign flag to true on specific nodes in the 0ACCOUNT hierarchy, the query variable picks it up and reverses the signs as expected. The challenge that I face is that I have several 0ACCOUNT hierarchies that need to be maintained, each of these with several nodes, sub nodes, and account numbers that need to be reversed. Also these will be changing on a regular basis. I do not want to manually maintain all of this in BW. Each of these hierarchies is extracted and loaded from R3 every night to pick up hierarchy changes, but the 0ACCOUNT hierarchy extractor does not have the reverse sign indicator. Ideally, users in R3 would mark specific hierarchy nodes and leaves with reverse indicators which then would be extracted and loaded to BW. Any ideas on how to best address this challenge?