cancel
Showing results for 
Search instead for 
Did you mean: 

Show 0.0 in Cube View Data Cell instead of blank cell

Oscar
New Contributor III

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!

1 ACCEPTED SOLUTION

kliau
New Contributor II

Hi Oscar, 

You can create a new U8# Dynamic Calc member with the following code:kliau_0-1642208321868.png

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

View solution in original post

3 REPLIES 3

ChristianW
OneStream Employee
OneStream Employee

Hi Oscar

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

Cheers

Christian

kliau
New Contributor II

Hi Oscar, 

You can create a new U8# Dynamic Calc member with the following code:kliau_0-1642208321868.png

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

Oscar
New Contributor III

Thank you! This is exactly what I needed ... in HFM this was as simple as applying the wanted format to the report, but it never occurred to me that this had to be coded in the U8 dimension (of all places) in OneStream ... Jeeeezz