Forum Discussion

L_OS's avatar
L_OS
New Contributor II
3 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
    3 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
      Valued Contributor
      3 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
        3 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