08-10-2023 08:43 AM
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
08-10-2023 09:15 AM
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)"