timallen
Well Known Member
(short version: what is the best strategy for putting two separate but associated companies in OneWorld?)
We have a client who has acquired another company (can't tell you anything about it: all very hush-hush). Their lines of business are very similar. The client has recently told me that they want to allow the second company to use OneWorld.
Originally they had told me that the two companies should have all the same programs, but that their data would be completely separate. So I thought I should make a copy of the original environment and change its OCM mappings for Business Data to new data sources for the new company.
But now they tell me that eventually the idea is to merge the two companies together in some foreseeable future. I started experiencing stabbing pains behind my left eye and developed a tic thinking about shoehorning the two sets of data sources back into one.
To complicate issues, it seems that due to a difference in the way accounts are named for the two companies, at least for now, the two companies won't be able to use the same reports and interactive apps (so that idea that they could use the same programs was, well, wrong). At this point my innards started making sounds like a Canadian moose charging a VW microvan.
I thought of some options, though maybe others exist. Should we:
1) Copy the original environment to a new environment using the P0094 Environment Master, create new data sources, and change the OCM mappings of the second environment to the new data sources? Will this be a problem when we have to re-integrate the two companies?
2) Put all the data in the same data sources and handle data separation with row-level security? Does this mess up reports that do aggregation? I reckon that this would at least make the problem of reintegrating the companies trivial.
3) Create a new environment from scratch and treat the second company as a completely separate company? This would address the problem of having programs that don't work for both companies, but make re-integration Really Hard.
4) Buy stock in both companies? (joke, joke)
5) Some other thing?
Thanks in advance.
We have a client who has acquired another company (can't tell you anything about it: all very hush-hush). Their lines of business are very similar. The client has recently told me that they want to allow the second company to use OneWorld.
Originally they had told me that the two companies should have all the same programs, but that their data would be completely separate. So I thought I should make a copy of the original environment and change its OCM mappings for Business Data to new data sources for the new company.
But now they tell me that eventually the idea is to merge the two companies together in some foreseeable future. I started experiencing stabbing pains behind my left eye and developed a tic thinking about shoehorning the two sets of data sources back into one.
To complicate issues, it seems that due to a difference in the way accounts are named for the two companies, at least for now, the two companies won't be able to use the same reports and interactive apps (so that idea that they could use the same programs was, well, wrong). At this point my innards started making sounds like a Canadian moose charging a VW microvan.
I thought of some options, though maybe others exist. Should we:
1) Copy the original environment to a new environment using the P0094 Environment Master, create new data sources, and change the OCM mappings of the second environment to the new data sources? Will this be a problem when we have to re-integrate the two companies?
2) Put all the data in the same data sources and handle data separation with row-level security? Does this mess up reports that do aggregation? I reckon that this would at least make the problem of reintegrating the companies trivial.
3) Create a new environment from scratch and treat the second company as a completely separate company? This would address the problem of having programs that don't work for both companies, but make re-integration Really Hard.
4) Buy stock in both companies? (joke, joke)
5) Some other thing?
Thanks in advance.