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

L_OS's avatar
L_OS
New Contributor II
4 years ago

Thank you Peter.

I have followed your approach and it works if I use an empty UD dimension.

If I use the same UD dimension where I have my members, then I get invalid cells:

 

Same UD dimension:

    

 

Using UD7 empty dimension:

 

 

Any thoughts around that?

 

 

PeterFu's avatar
PeterFu
Contributor II
4 years ago

Hi,

 

Yes, you have to use another user-defined dimension. I think the system is only regrouping your transactions in the other UD-dimension based on your formula. The good thing is that this is done on-the-fly, no consolidation is needed if I remember correctly.

 

Peter 

  • ChristianW's avatar
    ChristianW
    Icon for OneStream Employee rankOneStream Employee
    4 years ago

    Hi Peter

    How are you doing?

    Consolidation is only needed, if you like to use the attributes with entity.

    Cheers

    Christian

    • PeterFu's avatar
      PeterFu
      Contributor II
      4 years ago

      Hi Christian,

       

      I am fine thank you. Really busy with a lot of OneStream work! 🙂 How are you doing?

       

      Thanks a lot for the info!

       

      Peter