Forum Discussion

mvalerio24's avatar
mvalerio24
New Contributor III
2 years ago

Get list of accounts from Cubeview BR

I need to get a list of accounts based on what the cube view I created spits out. The cube view only has one row grabbing all the base children but has suppression on a column that will only show if there is a variance between 2 other columns. Each day the number of accounts with variances can differ and there is another column with a combo box for approve or deny. I need the list of accounts so I can provide the user with a mass approve or deny button

1 Reply

  • Steven's avatar
    Steven
    Contributor II

    mvalerio24,

    Try using the FdxExecuteCubeView function in a business rule:

     

    "Dim dt As DataTable = BRApi.Import.Data.FdxExecuteCubeView(si, cubeViewName, entityDimName, entityMemFilter, scenarioDimName, scenarioMemFilter, timeMemFilter, nvbParams, includeCellTextCols, useStandardFactTableFields, filter, parallelQueryCount, logStatistics)"