Forum Discussion

Samwise's avatar
Samwise
Icon for OneStream Employee rankOneStream Employee
6 months ago
Solved

FDX filter not working

I am trying to extract cube data using FdxExecuteDataUnit however, the filter does not seem to be filtering any data. Any ideas what the issue could be? I am seeing multiple flow members in the data ...
Connectors
Extenders
  • Stefano's avatar
    Stefano
    5 months ago

    Hi Samwise​ 

    You should remove dimension prefixes in e.g. cons (just use "Local") and view (just use "YTD") as these fields are not "member filters".
    If you check the help you see which fields are MFs and which ones aren't. 
    Dim dt As DataTable = BRApi.Import.Data.FdxExecuteDataUnit(si, cubeName, entityMemFilter, consName, scenarioTypeId, scenarioMemFilter, timeMemFilter, viewName, suppressNoData, filter, parallelQueryCount, logStatistics)

    Regards
    Stefano

Stefano's avatar
Stefano
New Contributor II
5 months ago

Hi Samwise​ 

You should remove dimension prefixes in e.g. cons (just use "Local") and view (just use "YTD") as these fields are not "member filters".
If you check the help you see which fields are MFs and which ones aren't. 
Dim dt As DataTable = BRApi.Import.Data.FdxExecuteDataUnit(si, cubeName, entityMemFilter, consName, scenarioTypeId, scenarioMemFilter, timeMemFilter, viewName, suppressNoData, filter, parallelQueryCount, logStatistics)

Regards
Stefano