Post Code Hierarchy???

[Former Member]

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

[Former Member]

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

[Former Member]

Thanks guys...I appreciate your help.

Regards

Milind

[Former Member]

Hi Milind,

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

Best regards,

Eugene

Message was edited by: Eugene Khusainov

[Former Member]

Hi Eugene,

I never tried Componding Attr, Could you please brief how Compounding attr is used in this case. An exampale would be a great help. I mean how perticular Post code will be linked to respective Sales Rep.

Regards

Milind

[Former Member]

Hi Milind,

Example:

Post code Rep Sales

10 AAAA 100

10 BBBB 200

20 AAAA 300

20 CCCC 400

30 CCCC 500

Compounding create a combined key for a combination post code and Sales rep:

Since rep AAAA may belong to different post codes (10 & 20), only a combination of post code and a rep properly identify his activity for this particular post code.

Compounded key in this example will be:

10AAAA

10BBBB

20AAAA

20CCCC

30CCCC

This allow to model situation with n:m relationships.

See more details here:

http://help.sap.com/bp_biv135/documentation/Multi-dimensional_modeling_EN.doc

Best regards,

Eugene