Forum Discussion

AtharvaKabade's avatar
AtharvaKabade
New Contributor
3 days ago

How to looping Through Cube View Rows to Read Amount and Text Value Using Business Rule?

 

 

1 Reply

  • dsebenaler's avatar
    dsebenaler
    New Contributor III

    Hey Atharva. I think some of the key OneStream API functions/subs you could try using include:

    1. Api.Data.GetDataCell().CellAmount - can be used to get a cell's amount/decimal value 
    2. Api.Data.GetDataCellEx().DataCellAnnotation - can be used to get a cell's annotation/text value 

    For the loop itself I would recommend trying to use data buffers to grab slices of the data units that are represented in your cube view. You can use a "for each...next" loop to loop through the cells in each required data buffer and utilize (1) and (2) for each cell in the loop to drive additional logic within the finance business rule.