The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

kbon's avatar
kbon
New Contributor
4 years ago
Solved

OrgByperiod/ Restructuration d'entités

hello team, new in OS , i need help if someone works on this tool. i am wondering if there is an equivalence of the hfm functionality "org by period" in OS ? is it possible in OS to manage the st...
Metadata
Methodology
Time
  • Krishna's avatar
    Krishna
    2 years ago

    TomABC - I think I found the solution. Here we go.

    1. If you have 2 Cube Summary and Base Cube.

    2. Set the Org By Period in the Summary Cube Settings.

    3. Add the Relationship in the Entity Dimension that is tagged to the summary Cube.

    4. Update the Consolidation% in the Entity Dimension that is tagged to the Summary Cube Relationship property.

    5. In the Base Cube Entity Dimension the relationship property can be 100% consol.

     

     

shikhak's avatar
shikhak
New Contributor
3 years ago

Hi LeeBown and TomABC,

The description you provided on Org by period was very helpful to me. 

I undertand that this is the basic functionality of OS when below options are selected in 'Consolidation Algorithm Type' 

We have a case that, we have to write some custom rules in OS specific to client. So we have to selet 'Custom' in the Consolidation Algorithm type. Now our problem is that Org by period is not working at all. We were able to eliminate the data rollup for inactive entities by setting Consolidation % and Ownership % to be '0'. But the interncompany data still gets eliminated at the parent where the entity is inactive. 

Have you had any similar experience. Do you have any idea how to handle this? 

Thanks!

Shikha