The OneStream Community is temporarily frozen until June 29th due to the ongoing maintenance. Please read the blog post here to learn more.

Forum Discussion

Samwise's avatar
Samwise
Icon for OneStream Employee rankOneStream Employee
8 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
    8 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

sameburn's avatar
sameburn
Icon for OneStream Employee rankOneStream Employee
8 months ago

Hi Samwise

The FDX filter filters the original FDX result. So that means it will only apply if the filter conditions are met e.g those values exist in the dataset returned from your original data unit FDX call.

If the filter criteria is not met. The filter does not apply. 

So I suspect there is something awry with your filter. Maybe run the original data set without filters. Check if these values you are filtering by exist and then slowly build your filter (where clause) e.g start with Flow on its own

The behaviour you are describing sounds like one of your filter conditions is not met.  Since your filter is using AND it implies that all of your filters need to be valid in order to invoke the filter

Hope this helps

Sam