Issues while building formulas and expressions

[Former Member]

Hi,

I have a couple of questions regarding the formulas and expressions in MDM. It would be a great help if someone could us on these:

<b>1</b>.While creating a Syndication map in MDM Syndicator, we need to do some calculation on some of the attributes/fields and need to store results in new Custom fields. The problem is when we create a new Custom Item and use Formula to create a formula like <MM Number:mm number> * 12, it is showing us result in Destination Preview as 100*12 rather than computing the value as 1200. The same is the case is for UOM conversion where we want to convert inches into feet. Can we do such such asthmatic calculations in syndicator? Is there any other way to get the same result?

<b>2</b> Calculated Filed Expression Builder screen for any table field in Console has Attribute List option always disabled. Only the Fields list is available on this screen. The same is the case for Validation and Assignment builders in Data Manager. Is it possible to select Attributes as well while creating “Calculated field Expressions” (Console) Validation and Assignment Expressions (Data Manager)?

We are using MDM 5,5 SP4 Patch01 on Windows XP Professional.

Thanks for your help.

Regards,

-Irfan

[Former Member]

Hi Irfan,

1) If you want to use formula like 100*12 and want to get result than syndicator is not for this.This kind of formula should be used in Data manager. Custom field in syndicator is not for this purpose. When you want to add and custom field in your output file which is not present in your current display than with the help of Custom field, you can see that field in Destination Preview.

Follow below link for more clarification

<a href="http://help.sap.com/saphelp_mdmgds55/helpdata/EN/28/52a8a6076d4979b08c27c7ca3aab8d/frameset.htm">Custom Fileld in Syndicator</a>

Hope this helps,

Regards,

Ron

Reward point for helpful answer

Message was edited by:

Ron