The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

Madesh's avatar
Madesh
New Contributor III
4 years ago

CubeView - Allow Sparse Row Suppression

Hi, We have created one Cube view with using "True (but determine sparse rows using other columns)" option under Allow Sparse Row Suppression in Column level and gave "True" under Allow Sparse Row s...
Cube View
OSAdmin's avatar
OSAdmin
Icon for OneStream Employee rankOneStream Employee
4 years ago

The issue is the formula.  You are using an account which is what the suppression keys off of.   The formula is not considered when rendering the data set.    You would have to show account 1.  Account 2 and account three. And then do the calculation.   You could hide the columns if you wanted.    

Madesh's avatar
Madesh
New Contributor III
4 years ago

We have tried to bring all the columns and did the suppression. But we got the same results, the suppression is being happened on all columns irrespective of Zero/Non-zero/Blank/Non-blank rows.
Are we missing something? can you help us to fix this issue.