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.

     

JackLacava's avatar
JackLacava
Icon for OneStream Employee rankOneStream Employee
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.

 

WillVitale's avatar
WillVitale
Contributor II
2 years ago

Hi Jack,

So I was able to get it to work after some tinkering, but now I cannot figure out how to roll up those amounts into the parent I created. I made it set to Is Consolidated and ran a force consolidate but that didn't end up working. I compared it to a flow dimension parent, which I thought was the closest example I could use and it pretty much mirrors it identically.

Thanks,

Will