Skip to main content
Contributor
Apr 11, 2024 11:58 PM UTC
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 row override).

WillVitale_0-1712879655797.png

So the Input Inventory Amount, I put some dummy info in and the calculated reserves are taking those amounts and multiplying it by those percentages (name override as UD8#None). So the amount in LC column should be 265LC, but I cannot get it to populate. Below is my row override formula.

WillVitale_1-1712879797151.png

I've tried putting a row range but it comes up with an error message of Invalid calculation script.

WillVitale_2-1712879853181.png

I don't want to make a new UD8, because I don't really know how to do that, so if it can be done with a CVRC, or a different formula, that would be great!

Thanks,

Will

Employee - Sage
Apr 12, 2024 3:02 PM UTC

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.

 

6 replies

Contributor
Apr 12, 2024 2:09 PM UTC

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

Employee - Sage
Apr 12, 2024 3:02 PM UTC

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.

 

Contributor
Apr 15, 2024 9:27 PM UTC

Hi Jack,

So I followed that link and I tried creating a UD8 calc based off of something we already had but I'm not sure if this works or not.

WillVitale_0-1713216417175.png

I'm guessing it's a lot easier than I make it out to be, but any direction would be great.

Thanks,

Will