Forum Discussion

Oscar's avatar
Oscar
Contributor
4 years ago
Solved

Show 0.0 in Cube View Data Cell instead of blank cell

I built a cube view which contains blank cells (this is expected) as there is no data in the intersection. How can I forcibly show 0.0 in these cells (intersections) instead of blank cells? Thanks!
Cube View
  • twn1's avatar
    twn1
    4 years ago

    Hi Oscar, 

    You can create a new U8# Dynamic Calc member with the following code:

    This should replace blank cell with 0 after you layout the CV report with the new UD8 member.

PFowler's avatar
PFowler
New Contributor II
4 years ago

Following up on this. I'm still learning the ropes with OneStream. How would I pass this in my member filter? Also, will this replace all NonData Cells with 0 in the Cube View? 

Oscar's avatar
Oscar
Contributor
4 years ago

We created a UD8 dimension member with Formula Type DynamicCalc. The code above is then placed in the Formula field. The newly created member would be referenced in the POV of the cube view where you want to show zeros instead of blanks in the report.