We are using a hierarchy on 0cust_sales. Not all our customers are assigned to a hierarchy. This causes problems in the report when they do sorts. We were told that we could not do anything about this in the query, but that we could in the load of the hierarchy into BW by defaulting those customers that are unassigned to the root of the hierarchy.
Sounds good. But now they are looking to me to do this and I can't find where logic like this would be placed. Can any one point me in the right direction?