Forum Discussion

ResmiKR's avatar
ResmiKR
New Contributor III
2 years ago

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
    Contributor III
    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,

  • MarcR's avatar
    MarcR
    VIP
    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).

    • ResmiKR's avatar
      ResmiKR
      New Contributor III
      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)

      In this filter if I need to include multiple account dimension members, How to include that. Is that possible?

      • MarcR's avatar
        MarcR
        VIP
        2 years ago

        Yes, in the filter option (the Nothing before the 8 parallel count) you can use 'SQL type filters' e.g. Account <> 'COGS_USENG'

        So not A#xxx.tree but it should get you there. However, if you set a filter that returns no values it will return all. It must be a filter that returns data.

  • ResmiKR's avatar
    ResmiKR
    New Contributor III
    11 months ago

    Dear Community, 

    On adding to this pivot time function, is there any way to get multiple time under which i should have account column as well.