Forum Discussion

AtharvaKabade's avatar
AtharvaKabade
New Contributor
5 months ago
Solved

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

   
  • sameburn's avatar
    5 months ago

    Hi AtharvaKabade​ 

    If you want to replicate that CubeView data set in its entirety, you may want to consider using the FDX CubeView BRApi

    There is an example here

    This method uses your CubeView to derive the data set and returns the output as a DataTable.

    You can then interact with this DataTable to retrieve the values you want e.g. loop through DataRows or use .Select, etc

    So less overhead for development since you can read your variables directly from the CubeView itself (including Commentary and / or Dynamic Calcs)

    Hope this helps

    Sam