cancel
Showing results for 
Search instead for 
Did you mean: 

Unable to syndicate same Remote System with differnt value

Former Member
0 Kudos

Hi,

I am working on MDM 7.1 SP05 and I have the following issue with syndication:

I have a remote system table (Key Enabled) with System as Non-Qualifier and value as Qualifier and I have values in the MDM Datamanager as

MDM ID, Remotesystem (Multivalue Qualifier Table with Key Enabled)

111,((Qual1-Key,Val1),(Qual1-Key,Val2),(Qual1-Key,Val3))

When I syndicate I see only one value as 111, (Qual1,Val3)... But I want to have all the Qualifiers-Key with multiple values.. Where as in MDM 5.5 I can see all the Qualifiers with out any issues..Is this a restriction in MDM 7.1?

If I map System instead of Remote Key of Qualifier Table then I can see multiple times of same remote system with appropriate values.. But If I map remote key then I see the consolidated/the latest system-remote key wiht value... But I want system-remote key value appear multiple times...

Thanks alot

Rajeev

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hi Rajeev,

are you using flat file or XML file structure ?????

if XML just check Repeatetable XML Node in destination item tab is tick or not if not just mark tick and also make sure your parametric, name serach & free form serach if selected

Hope this will resolve your problem if not revert back

Thanks,

Jignesh Patel

Former Member
0 Kudos

HI,

Repeated note is checked for that node....

I can see multiple remote systems but I am unable to see the same remote system remote key again..

Suppose:

I have data :

MDM ID, RemoteSystem(System, Value)

111, ((Sys1,Val1),(Sys1,Val2),(Sys1,Val3),(Sys2,Val1))

Remote Keys for Sys1AAA and Sys2BBB

In the Syndication Manager I mapped as below: RemoteSystems RemoteKey and value are mapped to target...

RemoteSystem

--RemoteKey

System(DFNQ)

--Value(Qualifier)

I mapped RemoteKey and Value to the target fields.. Which is a XML output..

<REMOTE_SYSTEM>

- <Z_MDM_REMOTE_SYSTEM >

<Z_MDM_SYSTEM_NAME>AAA</Z_MDM_SYSTEM_NAME>

<Z_MDM_VALUE>Val3</Z_MDM_VALUE>

</Z_MDM_REMOTE_SYSTEM>

- <Z_MDM_REMOTE_SYSTEM >

<Z_MDM_SYSTEM_NAME>BBB</Z_MDM_SYSTEM_NAME>

<Z_MDM_VALUE>Val1</Z_MDM_VALUE>

</Z_MDM_REMOTE_SYSTEM>

</REMOTE_SYSTEM>

Where I need the following Output:

<REMOTE_SYSTEM>

- <Z_MDM_REMOTE_SYSTEM >

<Z_MDM_SYSTEM_NAME>AAA</Z_MDM_SYSTEM_NAME>

<Z_MDM_VALUE>Val1</Z_MDM_VALUE>

</Z_MDM_REMOTE_SYSTEM>

- <Z_MDM_REMOTE_SYSTEM >

<Z_MDM_SYSTEM_NAME>AAA</Z_MDM_SYSTEM_NAME>

<Z_MDM_VALUE>Val2</Z_MDM_VALUE>

</Z_MDM_REMOTE_SYSTEM>

- <Z_MDM_REMOTE_SYSTEM >

<Z_MDM_SYSTEM_NAME>AAA</Z_MDM_SYSTEM_NAME>

<Z_MDM_VALUE>Val3</Z_MDM_VALUE>

</Z_MDM_REMOTE_SYSTEM>

- <Z_MDM_REMOTE_SYSTEM >

<Z_MDM_SYSTEM_NAME>BBB</Z_MDM_SYSTEM_NAME>

<Z_MDM_VALUE>Val1</Z_MDM_VALUE>

</Z_MDM_REMOTE_SYSTEM>

</REMOTE_SYSTEM>

Any inputs.

Thanks

Rajeev

Former Member
0 Kudos

Hi Rajeev,

are you using standered XSD Schema or Customize ??

I have checked this senario at my end and it's working fine, if you customize XSD schema then i would suggest just check XSD node property Max Occurs is unbounded or not ideally it should be unbounded

for details refer MDM Syndicator Guide Page No 35

to change the property of XSD schema you can use altova spy software

i would suggest just recheck all map properties and your record should contain all non qualifier details e.g. Val1(Non Qualifier),Val2(Non Qualifier),Val3(Non Qualifier) for remote system AAA

Thanks,

Jignesh Patel

Former Member
0 Kudos

I am using customised...

Did you tried syndicating Remote key of that table or the field of the Qualifer table?

I am able to syndicate out with the system field and values.. But I want to syndicate out the multiple values wiht remote key of the table..

As mentioned Remote keys are AAA and BBB for System Sys1 and Sys2..

First I imported remote system table with Sys1 and Sys2 with remote Keys as AAA and BBB. then along wiht main table record I imported Sys1 and Sy2...

While Syndicating I want to syndicate AAA and BBB values along with Value field...

Suppose:

I have data :

MDM ID, RemoteSystem(System, Value)

111, ((Sys1,Val1),(Sys1,Val2),(Sys1,Val3),(Sys2,Val1))

Remote Keys for Sys1AAA and Sys2BBB

In the Syndication Manager I mapped as below: RemoteSystems RemoteKey and value are mapped to target...

RemoteSystem

--RemoteKey

System(DFNQ)

--Value(Qualifier)

I mapped RemoteKey and Value to the target fields.. Which is a XML output..

<REMOTE_SYSTEM>

- <Z_MDM_REMOTE_SYSTEM >

<Z_MDM_SYSTEM_NAME>AAA</Z_MDM_SYSTEM_NAME>

<Z_MDM_VALUE>Val3</Z_MDM_VALUE>

</Z_MDM_REMOTE_SYSTEM>

- <Z_MDM_REMOTE_SYSTEM >

<Z_MDM_SYSTEM_NAME>BBB</Z_MDM_SYSTEM_NAME>

<Z_MDM_VALUE>Val1</Z_MDM_VALUE>

</Z_MDM_REMOTE_SYSTEM>

</REMOTE_SYSTEM>

Where I need the following Output:

<REMOTE_SYSTEM>

- <Z_MDM_REMOTE_SYSTEM >

<Z_MDM_SYSTEM_NAME>AAA</Z_MDM_SYSTEM_NAME>

<Z_MDM_VALUE>Val1</Z_MDM_VALUE>

</Z_MDM_REMOTE_SYSTEM>

- <Z_MDM_REMOTE_SYSTEM >

<Z_MDM_SYSTEM_NAME>AAA</Z_MDM_SYSTEM_NAME>

<Z_MDM_VALUE>Val2</Z_MDM_VALUE>

</Z_MDM_REMOTE_SYSTEM>

- <Z_MDM_REMOTE_SYSTEM >

<Z_MDM_SYSTEM_NAME>AAA</Z_MDM_SYSTEM_NAME>

<Z_MDM_VALUE>Val3</Z_MDM_VALUE>

</Z_MDM_REMOTE_SYSTEM>

- <Z_MDM_REMOTE_SYSTEM >

<Z_MDM_SYSTEM_NAME>BBB</Z_MDM_SYSTEM_NAME>

<Z_MDM_VALUE>Val1</Z_MDM_VALUE>

</Z_MDM_REMOTE_SYSTEM>

</REMOTE_SYSTEM>

Any inputs.

Thanks

Rajeev

Former Member
0 Kudos

Hi Rajiv,

Yes I have created two remote system and remote system key as per your specification output requirement and i used SAP standered XSD file and i used qualified table

are you trying to syndicate Qualified table value (Qulifier) or Multilookup value ???

if your XSD is customize just refer syndicator reference guide page no 35 and mention point above

Thanks,

Jignesh Patel

Former Member
0 Kudos

Hi,

I used the same XSD which I used in MDM 5.5 and its generating the output as expected..

As I said I can see the multiple different remote Keys along wiht values (xsd as 0--unbound).. but I am unable to see the same remote system again... It only giving the updated remote key value... where as I want key mapping to appear again as in MDM I added multiple remote systems with key mapping AAA

If you go through about my xml outputs.. U can see that the output I need consits of multiple key mapping repeating wtih different values.. but I am getting only the updated one or latest one AAA(System as Sys1).. and I am unable to get same key mapping AAA again...

Any thing I need to configure or its a default one?

Regards,

Rajeev.

former_member205403
Active Contributor
0 Kudos

Hi Rajeev,

Where I need the following Output:

<REMOTE_SYSTEM>
- <Z_MDM_REMOTE_SYSTEM >
<Z_MDM_SYSTEM_NAME>AAA</Z_MDM_SYSTEM_NAME>
<Z_MDM_VALUE>Val1</Z_MDM_VALUE>
</Z_MDM_REMOTE_SYSTEM>

- <Z_MDM_REMOTE_SYSTEM >
<Z_MDM_SYSTEM_NAME>AAA</Z_MDM_SYSTEM_NAME>
<Z_MDM_VALUE>Val2</Z_MDM_VALUE>
</Z_MDM_REMOTE_SYSTEM>

- <Z_MDM_REMOTE_SYSTEM >
<Z_MDM_SYSTEM_NAME>AAA</Z_MDM_SYSTEM_NAME>
<Z_MDM_VALUE>Val3</Z_MDM_VALUE>
</Z_MDM_REMOTE_SYSTEM>

- <Z_MDM_REMOTE_SYSTEM >
<Z_MDM_SYSTEM_NAME>BBB</Z_MDM_SYSTEM_NAME>
<Z_MDM_VALUE>Val1</Z_MDM_VALUE>
</Z_MDM_REMOTE_SYSTEM>

</REMOTE_SYSTEM>

I feel, you may not be able to fulfill this requirement through Syndicator. As per MDM 7.1 Design, when there are multiple keys for the same remote system, Syndicator always syndicates DEFAULT KEY for the remote system... You can check in Data Manager and the values that you are getting as syndication output must be marked as default remote key for that remote system .

Please refer to MDM 7.1 Syndicator Reference Guide (*page no 162), which mentions the same thing. Link for Syndicator reference guide is below:

http://help.sap.com/saphelp_nwmdm71/helpdata/en/4b/711def8a722593e10000000a42189b/MDMSyndicator71.pd...

Hope this will help..

Former Member
0 Kudos

HI,

I have only one key mapping AAA for the system description Sys1 and it is by default key mapping and the same for Sys2 with BBB ....

A customer from system Sys1 imported with value 111 and the another customer with value 222 is imported from the same System.. so in that case I eneded up with two remote systems for the same record in MDM

MDM ID, RemoteSystem (Multi valued Qualifier Table)

1,((Sys1,111),(Sys1,222))

I need to syndicate out these two remote system with key mapping and values.. so its not possible to syndicate out of MDM as below:

<REMOTE_SYSTEM>

- <Z_MDM_REMOTE_SYSTEM >

<Z_MDM_SYSTEM_NAME>AAA</Z_MDM_SYSTEM_NAME>

<Z_MDM_VALUE>111</Z_MDM_VALUE>

</Z_MDM_REMOTE_SYSTEM>

- <Z_MDM_REMOTE_SYSTEM >

<Z_MDM_SYSTEM_NAME>AAA</Z_MDM_SYSTEM_NAME>

<Z_MDM_VALUE>222</Z_MDM_VALUE>

</Z_MDM_REMOTE_SYSTEM>

</REMOTE_SYSTEM>

In MDM 5.5 I am able to get the output as above but after switching to MDM 7.1 I am unabel to get the output.. Instaed it sends on the one value (which ever is the latest one)... Please advise..

Thanks

Rajeev

former_member205403
Active Contributor
0 Kudos

Hi Rajeev,

I got your requirement..I am not sure, but give a try to below steps:

1. Open syndicator and open your Map.

2. Go To Map Properties tab, and set the property "Remote Key Override" as "sys1"

3. Execute syndication. check and revert with the Result.

Best Regards,

Shiv

Former Member
0 Kudos

Hi Rajeev,

As per your requirement what i am able to figure it out you are maintaining duplicate non-qualifiers as you have 3 records with NQ field value AAA, since key is single for this NQ record "AAA" it is syndicating single record.

So there is problem with your duplicate qualified links. As you appending record with same qualified record, its result in 3 duplicate records. Can you please check is this the way you are maintaining data as i feel it is not an ideal way.

e.g. say if my main table record has non-Q AAA has value val1 at initial load.

some time later if i import same record with some different field values, it depends how you are updating your Qualified table data. Here ideally you should use qualified update data option which should check if your non-qualifier value AAA already exists then shall qualifier field value should be skip or updated.

If you use above options then you will have single qualified link AAA either with value "val1" or "val2 " or "val3", i mean you should have only one qualified link but as you are maintaining duplicates with 3 qualified links (using option append), you have

AAA with val1

AAA with val2

AAA with val3

and that's why only one record is getting syndicated with qualified link AAA which has single unique remote key.

So i feel either you should check is really Qualified append is required in your case, if it so then in this way it will not work, try testing it with without mapping remote key with target field. I mean unmap remote key and check are you able to syndicate all these three records or not. Kindly revert with your findings.

Regards,

Mandeep Saini

Former Member
0 Kudos

Hi,

but these AAA and BBB key mapping are at Qualifier Look up table level... Not on main record level..

I created a key mapping enabled Qualifier Look Up table [Multi valued] as RemoteSystem with system Name (Non-Qual) and Value (Qualifier)...

I imported the Qualifer Table System Name Sys1 with remote Key AAA

Now I imported the map table using the above table and I see in MDM as below

MDM ID,RemoteSystem

1,((Sys1,111),(Sys1,222))

So now I want to syndicate this.. I tried wiht the option you said but I dont see such remote system .. I have about 100 such values stored in that Qualifeir Table.. so which i need to forwrad the keymapping code with value..

Any suggestions to syndicate out above Qualifer table key mapping values as said in above output format.

Hi,

I am using value field to update the remoteSystem Qualifer Table.. So

Say I have

MDM ID,RemoteSystem

1,((Sys1,111),(Sys1,222))

I use to update the table with value.. Basically I have other fields too in the table which gets updated.. Table doesnt hold any record which has same remotesystem and value... Thats the condition...

Yes If I unmap kepmapping and map to SystemName then i am able to see the output as expected BUT I need to syndicate out the code of that Systemname...

Thanks

Rajeev

Edited by: rajeev raj on Sep 1, 2010 6:44 PM

former_member205403
Active Contributor
0 Kudos

Hey Rajeev,

Kindly ignore solution suggested my Me. I assumed you are looking for remote key values from Main table. But this is not the case...

Best Regards,

Shiv

Former Member
0 Kudos

Hi Rajeev,

Are you using old map of MDM5.5 version to 7.1 if Yes then i would suggest create new mapping and save it because MDM5.5 mapping sometimes not working in MDM7.1 version

or

if you have upgrade your repository from 5.5 to 7.1 just repair repository atleast once and recheck your senario

also could you provide me the details of remote key information that is in following format with non qualifier details

Default Name Remote System Key

Thanks,

Jignesh Patel

Former Member
0 Kudos

Hi,

i imported the new XSD in to MDM Syndicator and mapped the remotekey of Qualifier Table to the SystemName, AND value to Value...Still I am unable to get the same Remotekey twice...

Yes I checked and loaded wiht update indices while loading MDM repository....

Remote Key informatiion on Qualifier table is as below:

Default,SystemName,RemoteSystem,Key

Checked,Sys1,Remote,AAA

It was working fine in MDM 5.5 but unable to get the same output in MD 7.1 .. Any suggestions?? Does MDM 7.1 doesnt support this?

Thanks

Rajeev

Former Member
0 Kudos

Hi Rajeev,

at my end its working fine

as per my understaning there is nothing to do with your XSD it look good, i think problem with maintaining records in MDM data manager as per my understading

follow this step it may help you

1. select Qualified Table in MDM Data Manager

2. then right click on records select edit key mapping assign remote system(for e.g Sys1, Sys2) and remote key value(Value1,Value2)

3. then open syndication map and map remotekey field under qualified table to destination side

4. also make sure Remote Key Override property under map properties tab should select both system

Note : Qualified table remote key value will display at destination side

Thanks,

Jignesh Patel

Former Member
0 Kudos

HI,

I am unable to get the output what I am expecting.. Are you able to get the same code more than once if the Data Manager has more than once systems?

Suppose in MDM DataManager I have two remote Systems Sy1 with value 111 and Sys1 with value 222 but I see only one in the output: that is AAA with value 222...

As this remote key is under qualifier table so I am unable to see the Sys1 and Sys2 in the remote Key Override of Map Properties.

Please do let me know If I am missing some thing.. I reimported the qualifier table with keymapping values.. But still I ma unable to get same key mapping more than once.

Regards,

Rajeev

Former Member
0 Kudos

Hi Rajeev,

have you selected both remote system i.e. Sys1 and Sys2 in Remote Key Override under Map Properties option

also i would like mention output will not reflect in destination preview it will display only current remote system map

which you open

you require to syndicate manually or set automize process

if syndicate file manual and save to local desktop automatically it will create two file for remote system Sys1, Sys2

or if syndication automize process it will automatically genrate file in define outbound port path for system Sys1, Sys2

Hope this will resolved your problem if not revert back

Thanks,

Jignesh Patel

Former Member
0 Kudos

HI All,

Thanks alot for your valuable time and answers.. .. Points are awarded.