Modeling Organisational Structures

[Former Member]

Hi all,

I want to model a treelike Organisational Structure in MDM. Therefore I have a field called Parent_ID refering to the superordinate node in the structure like showed below:

MDM_ID   Parent_ID   [Remote Key]
1        2           xyz
2        3           abc

Because the Client Systems have to work with there Remote Keys, the Export-Row for the Dataset with MDM_ID 1 should look like this:

ID    Parent_ID
xyz   abc

Any Ideas?

I tried several things:

- Lookup in the main table itself is not available.

- Calculate the Parent_ID in Syndicator does not work (Or I did not find the way it does? Custom Item?)

- Relationships are not (yet?) available in Syndicator

- Calculate the Parent_ID at Import needs several steps. Import Data, export it, import a a lookuptable which is a mapping between MDM_IDs and Remote Keys. Import the Parent node field as lookup. But quite complex and problems when merging Items.

- Calculated fields cannot access to the Remote Keys

Thanks for all further ideas.

Regards

Stefan

[Former Member · Accepted solution]

Stefan,

I have few comments regarding this.

1. As of SP3, "Curom Item" can not do any calculations apart from displaying "Field Name", "Value" and doing a concatenation of these or any other character you type in there.

2. Syndicator can not do "Pivoting" - the way you would like to do - Generating data in a column as a Row.

Regards,

Rajani