altquark
Legendary Poster
I think we might have found a fundamental issue with OCM and conflicting Business Views. I know of this issue from in my distant past - but unsure about finding out more information. I tested this in Demo Jr as well as our Development system.
The issue is that if one places 3 or more tables in different datasources (using OCM to create the mappings of course) and then try to view those tables using a Business View - then an error appears.
If you place 2 tables in different datasources and apply a business view on the 2 tables - no error.
Since the Foundation makes many references to the ability of OneWorld to use Object Configuration Manager to place one table in one datasource - and another in a different datasource - then why is it that Business Views cannot translate the OCM information correctly ?
I think I know the answer why - and I am sure it does not affect too many people. From my initial research - out of almost 4,000 business views in Xe - there are only 100 or so business views that look at >=3 tables.
However, I am planning on performing more research - and publishing a list of table groups that should always remain in the same datasource.
Jon Steel
Xe Upgrade Specialist
erpSOURCING LLC
http://www.erpsourcing.com
ERP Sourcing
http://www.erpsourcing.com
[email protected]
The issue is that if one places 3 or more tables in different datasources (using OCM to create the mappings of course) and then try to view those tables using a Business View - then an error appears.
If you place 2 tables in different datasources and apply a business view on the 2 tables - no error.
Since the Foundation makes many references to the ability of OneWorld to use Object Configuration Manager to place one table in one datasource - and another in a different datasource - then why is it that Business Views cannot translate the OCM information correctly ?
I think I know the answer why - and I am sure it does not affect too many people. From my initial research - out of almost 4,000 business views in Xe - there are only 100 or so business views that look at >=3 tables.
However, I am planning on performing more research - and publishing a list of table groups that should always remain in the same datasource.
Jon Steel
Xe Upgrade Specialist
erpSOURCING LLC
http://www.erpsourcing.com
ERP Sourcing
http://www.erpsourcing.com
[email protected]