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.

ChristianW's avatar
ChristianW
Icon for OneStream Employee rankOneStream Employee
4 years ago

Hi Oscar

If read only is sufficient, just encapsulate a row (or column) dimension's specification like this: GetDataCell(<Some POV> + 0)

Cheers

Christian