Newcomer

Hiding CV Row

5 replies
38 views

Hi Community,

I have a Cube View which has multiple source rows and a total row at the very end which is using GetDataCell(CVR()) to obtain the Total.
Is there any way in which I can hide the source rows and just display only the Total row.

Thanks,

T_Kress

Contributor

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

P

pranav46

Member

Create two rows(row1 and row2)

First row with source members and second with formula.

then hide first row which pull source members.

J

jbrem

Contributor

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!