Drill Down for "Show 0.0 in Cube View Data Cell instead of blank cell"

You'll have to specify a formula for drilldown, see the section "Formulas for Calculation Drill Down" in the Design and Reference Guide. The example below shows an option to determine what to look at (switching on storage type of the cell), you don't necessarily need to do it this way - what matters is that you call the result.SourceDataCells.Add() method to point the system in the direction of the intersections you want to list in the interface.

Dim result As New DrillDownFormulaResult()
If args.DrillDownArgs.RequestedDataCell.CellStatus.StorageType = _
         DataCellStorageType.Calculation Then
    ‘Use this to drill down to data that was copied using a Scenario Formula.
     result.Explanation = “Formula Definition: Actual = Budget”
     result.SourceDataCells.Add(“Cb#Houston:E#Houston:S#Actual”)
Else If args.DrillDownArgs.RequestedDataCell.CellStatus.StorageType = _ 
         DataCellStorageType.Input Then
     ‘Use this to drill down to data that was copied using Data Management.
     result.Explanation = “Data Management Defintion: Actual = Budget”
     result.SourceDataCells.Add(“Cb#Houston:E#Houston:S#Actual”)
End If
Return Result