Skip to Content
author's profile photo Former Member
Former Member

Post Code Hierarchy???

Dear Colleagues,

I have a bit complex situation and not sure how to build that in BW. Client is having 6 Divisions and in total there are 400 Area Post Code (Area Pin Code) in UK. Now the client is maintaining that in flat file as... all 400 post codes --> their corresponding Divisions --> and then respective Sales Rep.

Post code is a key driver here because 1 post code can be served by one or many sales rep and vice-varsa. Now if want to replicate that in BW, what is best feasible way to do the same?

Even you small inputs always been helpful, please respond.

Regards

Milind

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • Posted on Nov 21, 2005 at 12:33 PM

    Hi Milind,

    I think you can make Post code a compounding attribute to sales reps.

    Best regards,

    Eugene

    Message was edited by: Eugene Khusainov

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Nov 21, 2005 at 01:34 PM

    Hi Milind,

    In your case you would be compounding Post code with Sales person or vice versa. To do the same you would need to go the the Infoobject for Post code/sales person in change mode

    and navigate to the Last tab i.e. Compounding.

    In this tab enter the Superior InfoObject

    Post code for Sales person <b>or</b>

    Sales person for Post Code

    What this means is that you can evaluate the data of Post code with reference to a Sales person only or vice versa and every combination of Postcode and salesperson is unique.

    Hope it helps. Let me know if you need more details.

    Cheers

    Anurag

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.