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 ...
Forum Discussion
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