01-07-2022 11:43 AM - last edited on 02-10-2022 10:43 AM by OSAdmin
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!
Solved! Go to Solution.
01-14-2022 08:03 PM
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.
01-10-2022 09:40 AM
Hi Oscar
If read only is sufficient, just encapsulate a row (or column) dimension's specification like this: GetDataCell(<Some POV> + 0)
Cheers
Christian
01-14-2022 08:03 PM
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.
01-18-2022 08:40 AM
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
09-27-2022 11:39 AM
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?
09-27-2022 03:53 PM
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.
09-27-2022 04:04 PM
Did you do this without creating a business rule? Would you be able to show screenshots of the formula so I can visualize it?
09-27-2022 04:13 PM
The code is shown above. You have to paste it in a UD8 dimension member:
Then in the cub view:
10-03-2022 04:54 PM
Thank you very much