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

ResmiKR's avatar
ResmiKR
New Contributor III
2 years ago
Solved

Get multiple time period in FDX

Dear Community, How to get multiple time period data in FDX ?  We have data's in row manner. We need it in column wise. The data is imported into a table using FdxExecuteDataUnit function. 
Connectors
dashboards
Extenders
  • MarcR's avatar
    MarcR
    2 years ago
    Dim dt As DataTable = BRApi.Import.Data.FdxExecuteDataUnitTimePivot(si, "Corporate", "E#Frankfurt", "Local", ScenarioDimHelper.GetIdFromName(si, "Actual"), "S#Actual", "T#2018.base, T#2017.base", "YTD", False, False, Nothing, 8, True)

'Dim dt As DataTable = BRApi.Import.Data.FdxExecuteDataUnitTimePivot(si, cubeName, entityMemFilter, consName, scenarioTypeId, scenarioMemFilter, timeMemFilter, viewName, suppressNoData, useGenericTimeColNames, filter, parallelQueryCount, logStatistics)

    Try the TimePivot variant(s).

Sergey's avatar
Sergey
Icon for OneStream Employee rankOneStream Employee
2 years ago

Hello,

You might probably need FDXExecuteCubeView, where you can get as an output all the data in a specified cube view, whatever time periods you use 🙂

You can find a few examples in this community : 

https://community.onestreamsoftware.com/t5/Rules/FdxExecuteCubeView-Function/td-p/7394

https://community.onestreamsoftware.com/t5/Workflow-and-Data-Integration/FDX-methods-like-FdxExecuteCubeView-Why-are-they-faster/m-p/17437

or here (oddly) : https://dzone.com/articles/onestream-fast-data-extracts-apis

 

Regards,