Forum Discussion

Samwise's avatar
Samwise
Icon for OneStream Employee rankOneStream Employee
28 days ago

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
New Contributor II
26 days 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