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).

ResmiKR's avatar
ResmiKR
New Contributor III
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
    2 years ago

    Thank you for that. But in this case we have three account members.

    • MarcR's avatar
      MarcR
      VIP
      2 years ago

      Never tried before but you could try: Account IN ('123', '456', '789') 

      Or you could try Account = '123' OR Account = '456' OR Account = '789'

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

        Hi,

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