Hiding CV Row

There is an option to mark a row as not visible here:

But I think if you do that and that row is used in another row for CV math, you will get an error.

There are a couple work arounds:

1. Put all the rows that are needed for CV math at the bottom and use Text=Transparent to make them appear blank.

2. Create an account rollup in the account hierarchy for the sub-total for which want in your cube view and use that parent account instead

Here are some other options in these posts:

Hiding CV Row - OneStream Community (onestreamsoftware.com)

https://community.onestreamsoftware.com/t5/Implementation-Q-A-Archive/I-am-building-a-cube-view-I-have-a-row-that-is-a-calculated-row/ta-p/1204

Create two rows(row1 and row2)

First row with source members and second with formula. 

then hide first row which pull source members.

I recently had the same question but if you hide the row your calc won't pick it up.  I know that was the trick from the HFM reporting writing days, I used to do it all the time.  I ended up putting all of the info into my calc row, other option I was told was to create the rollup for what I needed.  I do like the idea above about setting text to transparent, will def be keeping that in mind!

Thank you, will try it.