IBM Support

How to set multiple objects as the sources of crossover fields

Question & Answer


Question

During the creating of a crossover Domain, how do you set multiple objects as the sources of the crossover fields depending on a condition?

Answer


Here is an example showing how to achieve this:

Eg. You want to create a crossover so that:

In the Work Order Tracking application/ Plans tab/ Materials subtab, when you enter an Item number, you can copy the LOCATION column value from the ASSET table into the WPMATERIAL.WPM6 column if the entered item is a rotating item.
If the entered item is not a rotating item, then put the ORDERUNIT column value from the INVBALANCES table into WPMATERIAL WPM6 column.

1. Go to the Conditional Expression Manager application. Create a new condition.
Condition Name : NOTROT
Expression : ITEM.ROTATING = 0


2. Go to the Domains application and create a new crossover Domain ( TESTCORSSD1 )
In the CROSSOVER Domain table, enter as follows:
Object: ITEM
Validation Where Clause: itemnum=:itemnum


In the Crossover Fields table, enter two rows as follows:

1) The first line:


This line means that the data from INVBALANCES.LOCATION is copied into WPM6 when an item is not rotating.
INVBALANCES is the relationship name between ITEM(parent) object and INVBALANCES(child) object.


2) The second line:


This line means that the data from ASSET.LOCATION is copied into WPM6 when an item is rotating.
ASSET is the relationship name between ITEM (parent) object and ASSET(child) object.


3. Go to the Database Configuration application and find the WPMATERIAL object.
In the Attributes Tab then find the ITEMNUM attribute.
Enter the crossover Domain created in Step 1 into the Domain field.
Turn Admin Mode on and apply configuration changes.
Turn Admin Mode off.

4. Go to the Work Order Tracking application and try to put a rotating Item value into the Plans/Material Tab.
Location LATERM is grabbed from ASSET whose Itemnum is RTO18.


Try to put a not-rotating Item value into the Plans tab /Material subtab.
Location PKG is grabbed from INVBALANCES whose Itemnum is 560-00.


NB: This is just an example. It is not a suggested requirement because of cardinality problems ie. The cardinality between ITEM and ASSET or INVBALANCES is 1:N but it should be 1:1.

[{"Product":{"code":"SSLKT6","label":"IBM Maximo Asset Management"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"Domains","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.1;7.1.1;7.5","Edition":"","Line of Business":{"code":"LOB59","label":"Sustainability Software"}}]

Document Information

Modified date:
17 June 2018

UID

swg21567522