Skip to main content
Employee - Sage
Dec 13, 2022 7:31 AM UTC

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

 

 

2 replies

Employee - Sage
Dec 13, 2022 7:31 AM UTC

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

 

 

graessdaAuthor
Member
Dec 13, 2022 9:21 AM UTC

Hi Jack,

Thank you. With this I´ve found the solution for this specific U8 member:


Dim result As New DrillDownFormulaResult

result.SourceDataCells.Add("U8#None")


Return Result