Skip to Content

How to handle 2 semanticaly different characters with same master-data?

Hi specialists,

I've got a little moddeling problem - here's the szenario:

I've got a cube with a dimension "Customer".

This dimension shall have the following characteristics

- CustomerNumber (0Customer),

- Region_Cust (0Region (or reference of 0Region))

- Country_Cust (0Country (or reference of 0Country))

- Region_ShippedTo (ZRegion (=Reference of 0Region))

- Country_ShippedTo (ZRegion (=Reference of 0Region))

(The mentioned Info-Objects are just a proposal)

The regions need to be in the cube (for historical correctness) - (Display-)Attributes won't help.

The hatch: 0Region has a compound with 0Country. There seems to be no way to tell Region_ShippedTo to use ZRegion for the compound.

Let's say a customer has it's headquarter in Germany(Region: Berlin) - while the product is shipped to the brance in France(Region: Ile-de-France). Imho this is currently not modellable.

So how can one implement that (not that artificial) szenario without beeing forced to dublicate and keep synchronized the 0Country-InfoObject and all of its master-data? Master-Data should imho follow the idea of beeing centralized - it should be useable for the customer country/region as well as for the shipped-to country/region.

Could you please gimme a hint how to solute that problem?

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Mar 31, 2008 at 03:33 PM


    The requirement is not so clear to me .But i would think this way :

    Is it possible to define 0COUNTRY as Master data object with 0REGION as well ZREGION as its attributes?

    If so,this must give a way to solving your problem 😊


    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.