Samwise
OneStream Employee
6 months agoFDX 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 table.
Is there also a way to do all base members for a dimension?
Dim dt As DataTable
Dim cbName As String = "FinConsol"
Dim ent As String = "E#124"
Dim cons As String = "C#Local"
Dim scen As String = "S#Actual"
Dim time As String = "T#2025M1"
Dim view As String = "V#YTD"
Dim filter As String = "Origin='Import' AND Flow='EndBalInp' AND Account = 'NetInc' AND UD7 = 'GL_Load'"
dt = BRApi.Import.Data.FdxExecuteDataUnit(si, cbName, ent, cons, ScenarioTypeId.Actual, scen, time, view, True, filter, 1, False)
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