Forum Discussion

WillVitale's avatar
WillVitale
Contributor II
2 years ago
Solved

Row Column Intersection in a Cubeview

Hello, I'm trying to sum up a calculated amount using Row Column Intersection and I cannot get it to work properly. I'm using Rows Override in order to sum up these calculated amounts (also using r...
Cube View
Reports
  • JackLacava's avatar
    JackLacava
    2 years ago
    WillVitale wrote:

    I don't want to make a new UD8, because I don't really know how to do that

    Investing in learning how to build DynamicCalc accounts/Flows/UDs will reap big dividends. It's not very hard either. Start from https://documentation.onestream.com/release_8.2/Content/Design%20and%20Reference/Cube%20Views/Create%20Dynamic%20Calculations.html and go forward for a couple of pages.

     

tuhler's avatar
tuhler
New Contributor III
2 years ago

You will want to build as much of the calculation logic as possible into the metadata. For example, you could have an account for each of your calculated reserves percentages that you use that would return inventory amounts * 0.1. From there, you could have those in a hierarchy that sums up to your LC parent.

You won't be able to have a CVR or CVC that references another calculated cell like you are trying to do.

Thanks,

Thomas