Maximo Open Forum

Is there a way to get related tables in a start center result set? In particular, for an Inventory result set, only the "Inventory Details" are available, no other tables (for inventory balances and item descriptions). The object structures have the correct relationships, but they don't show when designing the result set.

The "object structure" listed below the application can be opened in the Object Structures app. Make a copy and add the related MBOs, and they should appear in the Object List in a tree.

Is there a way to get related tables in a start center result set? In particular, for an Inventory result set, only the "Inventory Details" are available, no other tables (for inventory balances and item descriptions). The object structures have the correct relationships, but they don't show when designing the result set.

I thought that might be the case, but our object structure already has the relationships we're looking for.

The "object structure" listed below the application can be opened in the Object Structures app. Make a copy and add the related MBOs, and they should appear in the Object List in a tree.

Is there a way to get related tables in a start center result set? In particular, for an Inventory result set, only the "Inventory Details" are available, no other tables (for inventory balances and item descriptions). The object structures have the correct relationships, but they don't show when designing the result set.

Jason,

In Report Administration, does the User's Security Group have access to the "Inventory Details" Report Object Structure?  You might want to check there as well.

I thought that might be the case, but our object structure already has the relationships we're looking for.

The "object structure" listed below the application can be opened in the Object Structures app. Make a copy and add the related MBOs, and they should appear in the Object List in a tree.

Is there a way to get related tables in a start center result set? In particular, for an Inventory result set, only the "Inventory Details" are available, no other tables (for inventory balances and item descriptions). The object structures have the correct relationships, but they don't show when designing the result set.

Is there a way to get related tables in a start center result set? In particular, for an Inventory result set, only the "Inventory Details" are available, no other tables (for inventory balances and item descriptions). The object structures have the correct relationships, but they don't show when designing the result set.