How do you handle a sale of a division in your company to other corporations?

Question

Happy inflation and recession (aka layoffs) everyone &lt;silly grin&gt;
How do you handle a sale of a division in your company to other corporations?
For example:
&nbsp;We have a Division1 selling widgets. It is under a consolidation roll-up for external reporting purposes. After we sold it, we want to stop tracking its history of transactions, so we create another member in Entity dimension called Division1_sold, put it under a different 2nd roll-up in Entity dimension.&nbsp; We need it to track and wrap up any costs/ revenue pertaining to Division1 that is no longer ours, and so we don't want to report nor consolidate it under the first roll-up.Is there a more elegant way to solve this problem?&nbsp; I see that OneStream allows us to set up for each member (such as Division1) that has&nbsp; a date when 100% consolidation begins and ends.Thank you for your advice. I'm in SLO California. If anyone lives near me, let's meet up for lunch - my treat!!

Davy · Answer

&nbsp;All consolidating entities&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |__&nbsp;&nbsp; Division 1 (has data from 1/2022 to 5/2022)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;|__&nbsp;&nbsp; Division 2&nbsp;&nbsp;&nbsp;Division 1 is sold in June, so we create a new Division 1_sold&nbsp;All consolidating entities&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |__&nbsp;&nbsp; Division 1 (has data from 1/2022 to 5/2022)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;|__&nbsp;&nbsp; Division 2&nbsp;All sold entities&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |__&nbsp;&nbsp; Division 1_sold (has data from 6/2022 and beyond )&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;|__&nbsp;&nbsp; Division xxx&nbsp;&nbsp;&nbsp;&nbsp;Is there a better more elegant way – e.g. no need to create a Division 1_sold ?&nbsp;&nbsp;All consolidating entities&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |__&nbsp;&nbsp; Division 1 (has data from 1/2022 to 5/2022)&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;|__&nbsp;&nbsp; Division 2&nbsp;All sold entities&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; |__&nbsp;&nbsp; Division 1 (has data from 6/2022 and beyond )&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; &nbsp;|__&nbsp;&nbsp; Division xxx&nbsp;&nbsp;&nbsp;&nbsp;

Davy · Answer

Maybe the trick is to use its settings of "Time" for Consolidation:Time is set as (Default Time) :&nbsp;&nbsp;

Davy · Answer

When Time is set as a month such as 2022M5, what does it mean?&nbsp; Does it mean that starting in Month 5 of 2022, the consolidation will be 100% ?&nbsp;

ChristianW · Answer

If the default has no input, then it is 100%. If you need to start with 0% and then increase to 100% in May 2022, then you have to set the default to 0%, and then 2022M5 to 100%. The 100% rolls forward till the next change takes place.&nbsp;

Forum Discussion

How do you handle a sale of a division in your company to other corporations?

4 Replies

Related Content

Company Logo

Row Division Formula

Cube View Cell Formatting / Division to 1000

Managing Group Company Exits in the User Workflow View

Division by 1000 works only for the first column of the cube view