Reg : demantra add level member for collections

Hi All,

There is requirement aggregate the sales_channel (location hirerchy) for a user in a worksheet, When I query the level members in location(levelmember) I could see the only say six sales channels ( but the flat file in which the user had given includes closed to 10 level member underneath the sales channel).

Action plan is how to add level member for the sales channel (location level)  - so that the user easily query the items in worksheet . user only enter the final forecast series and it is taken into collections - Please do suggest the work around (add level member to take it to collections??