Forum Discussion
sameburn
OneStream Employee
6 hours agoAlso please take care with the ParallelQueryCount variable. You have set yours to be 100,000!
This cannot exceed 128. I would recommend setting this at a safe level of something like 8
Similarly, you do not need to pass in the Dimension Token for Consolidation (C#USD becomes "USD" or "Local") and View (V#Periodic becomes "Periodic") Dimensions. We only need to pass the Dimension Token into dimensions that stipulate we can pass in a filter e.g. Entity (E#), Scenario (S#), Time (T#), etc (see example snippet below)
DataTable dt = BRApi.Import.Data.FdxExecuteDataUnit(si, cubeName, entityMemFilter, consName, scenarioTypeId, scenarioMemFilter, timeMemFilter, viewName, suppressNoData, filter, parallelQueryCount, logStatistics);
There are also some Tech Talks available on Navigator to better explain the Fast Data Extract (FDX) methods and a chapter in the OneStream Planning book
Hope this helps.
Related Content
- 2 years ago
- 2 years ago