Forum Discussion

OSAdmin's avatar
OSAdmin
Valued Contributor
6 years ago

How to show Zero (instead of empty) in No Data cell

Originally posted by Hubert Gao Hello, In CubeView, is there any setting to show Zero for No Data cell instead of showing empty cell? Thank you!
Cube View
ryannelissa's avatar
ryannelissa
New Contributor III

This only applies to the PDF format, is there a way to do this in the Cube View or Excel Views as well?

graessda's avatar
graessda
New Contributor II
3 years ago

You can create a UD8 Member with a dynamic calc and select this member in CV´s POV. 

If api.Data.GetDataCell("E#" & Entity & ":P#" & Parent & ":C#" & Cons & ":S#" & Scenario & ":T#" & Time & ":V#" & View & ":A#" & Account & ":F#" & Flow & ":O#" & Origin & ":I#" & IC & ":U1#" & U1 & ":U2#" & U2 & ":U3#" & U3 & ":U4#" & U4 & ":U5#" & U5 & ":U6#" & U6 & ":U7#" & U7 &":U8#None").CellStatus.IsNoData Then
Return api.Data.CreateDataCellObject(0.0, False, False)
Else
Return api.Data.GetDataCell("E#" & Entity & ":P#" & Parent & ":C#" & Cons & ":S#" & Scenario & ":T#" & Time & ":V#" & View & ":A#" & Account & ":F#" & Flow & ":O#" & Origin & ":I#" & IC & ":U1#" & U1 & ":U2#" & U2 & ":U3#" & U3 & ":U4#" & U4 & ":U5#" & U5 & ":U6#" & U6 & ":U7#" & U7 & ":U8#None").CellAmount
End If

 

But drill down will not work anymore. 

  • graessda's avatar
    graessda
    New Contributor II
    3 years ago

    Forgot this before 

    Dim Entity As String = api.Pov.Entity.Name
    Dim Parent As String = api.Pov.Parent.Name
    Dim Cons As String = api.Pov.Cons.Name
    Dim Scenario As String = api.Pov.Scenario.Name
    Dim Time As String = api.Pov.Time.Name
    Dim View As String = api.Pov.View.Name
    Dim Account As String = api.Pov.Account.Name
    Dim Flow As String = api.Pov.Flow.Name
    Dim Origin As String = api.Pov.Origin.Name
    Dim IC As String = api.Pov.IC.Name
    Dim U1 As String = api.Pov.UD1.Name
    Dim U2 As String = api.Pov.UD2.Name
    Dim U3 As String = api.Pov.UD3.Name
    Dim U4 As String = api.Pov.UD4.Name
    Dim U5 As String = api.Pov.UD5.Name
    Dim U6 As String = api.Pov.UD6.Name
    Dim U7 As String = api.Pov.UD7.Name

     

    If api.Data.GetDataCell("E#" & Entity & ":P#" & Parent & ":C#" & Cons & ":S#" & Scenario & ":T#" & Time & ":V#" & View & ":A#" & Account & ":F#" & Flow & ":O#" & Origin & ":I#" & IC & ":U1#" & U1 & ":U2#" & U2 & ":U3#" & U3 & ":U4#" & U4 & ":U5#" & U5 & ":U6#" & U6 & ":U7#" & U7 &":U8#None").CellStatus.IsNoData Then
    Return api.Data.CreateDataCellObject(0.0, False, False)
    Else
    Return api.Data.GetDataCell("E#" & Entity & ":P#" & Parent & ":C#" & Cons & ":S#" & Scenario & ":T#" & Time & ":V#" & View & ":A#" & Account & ":F#" & Flow & ":O#" & Origin & ":I#" & IC & ":U1#" & U1 & ":U2#" & U2 & ":U3#" & U3 & ":U4#" & U4 & ":U5#" & U5 & ":U6#" & U6 & ":U7#" & U7 & ":U8#None").CellAmount
    End If