Forum Discussion

mkalluri's avatar
mkalluri
New Contributor II
2 years ago
Solved

Data source Connector - Nested Drill back

Hi,         I am trying to build a Drill back functionality in one of data source connector business rules. I tried looking into One Stream reference guide on Data Source connector business rules...
Connectors
mkalluri's avatar
mkalluri
New Contributor II
2 years ago

I was able to find the solution and it is to have a column with name called "DrillTypeCode" in the first drill back result. When you drill back again the connector will be called with ActionType as GetDrillBackTypes and args.DrillCode will have the value from the column "DrillTypeCode" of the row you are performing drillback.

seangly's avatar
seangly
New Contributor III
2 years ago

Were you able to pull data from Drill Back Detail screen same as the one from Staging Area (sourceValues.Item(StageTableFields.StageSourceData.DimEntity)?

  • mkalluri's avatar
    mkalluri
    New Contributor II
    2 years ago

    Yes, precisely you can use below statement.

    args.GetSourceRowValue(StageTableFields.StageSourceData.DimEntity)  

    • seangly's avatar
      seangly
      New Contributor III
      2 years ago

      I mean from the Drill Back Detail as I need one field that is not in the Staging Area.

       

      • mkalluri's avatar
        mkalluri
        New Contributor II
        2 years ago

        If you are working on nested drill back functionality you can always get the value of the field in a row with args.GetSourceRowValue("[column name]")